SAP ABAP Table TRATV_TRANS (Generated Table for View TRATV_TRANS)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRATV_TRANS	Table Relationship Diagram
Short Description	Generated Table for View TRATV_TRANS

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	OS_GUID_TRANS	☑	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
3	OS_GUID_PC	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
4	OS_GUID_UD	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
5	OS_GUID_PI	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
6	POSTING_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
7	OLD_AA_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management
8	NEW_AA_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management
9	TRANS_STATE	☐	TPM_BUSTRANS_STATE	TPM_BUSTRANS_STATE	CHAR	1	0	Status of Distributor Business Transaction
10	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
11	CONTXTSTATE	☐	TPM_POS_CNTXT_STATE	TPM_POS_CNTXT_STATE	INT1	3	0	Obsolete: Status of Position Context
12	AA_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
13	CREATE_NAME	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
14	CREATE_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
15	CREATE_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
16	CREATE_TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
17	CHANGE_NAME	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
18	CHANGE_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
19	CHANGE_TIME	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
20	CHANGE_TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
21	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
22	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
23	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
24	ACCOUNTING_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
25	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
26	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
27	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
28	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
29	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
30	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
31	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
32	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
33	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
34	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
35	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
36	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRATV_TRANS	AA_REF	TRACC_AA_REF	AA_REF	KEY	1	CN
2	TRATV_TRANS	ACCOUNTING_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
3	TRATV_TRANS	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
4	TRATV_TRANS	COMPANY_CODE	T001	BUKRS
5	TRATV_TRANS	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
6	TRATV_TRANS	DEAL_NUMBER	VTBFHA	RFHA	KEY	1	CN
7	TRATV_TRANS	LOANS_CONTRACT	VDARL	RANL
8	TRATV_TRANS	PORTFOLIO	TWPOB	RPORTB
9	TRATV_TRANS	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT	KEY	1	CN
10	TRATV_TRANS	PRODUCT_TYPE	TZPA	GSART
11	TRATV_TRANS	SECURITY_ACCOUNT	TWD01	RLDEPO
12	TRATV_TRANS	SECURITY_ID	VWPANLA	RANL
13	TRATV_TRANS	TRADER	TZDEA	RDEALER
14	TRATV_TRANS	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
15	TRATV_TRANS	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS

History

Last changed by/on	SAP	20080505
SAP Release Created in