SAP ABAP Table TRDV_TRANS_FLOW (Generated Table for View)

Basic Data

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

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	OS_GUID	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
3	VERSION	TPM_TRDVERSION	TPM_TRDVERSION	CHAR	6	0	Distributor Version in Generation of Data
4	OWNER	TPM_BUSTRANS_OWNER	TPM_BUSTRANS_OWNER	INT1	3	0	Origin of a Distributor Business Transaction
5	COMPANY_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	VALUATION_AREA	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
7	BUSTRANSID	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
8	EXTBUSTRANSID	TPM_EXTBUSTRANSID	TPM_EXTBUSTRANSID	CHAR	60	0	Default ID from Creator for Distributor Business Transaction
9	BUSTRANSCAT	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
10	BUSTRANS_STATE	TPM_BUSTRANS_STATE	TPM_BUSTRANS_STATE	CHAR	1	0	Status of Distributor Business Transaction
11	POSITION_DATE	TPM_POSTING_DATE	DATUM	DATS	8	0	Posting Date for the Subledger
12	USER_CREATE_DATE	TPM_BT_CREATE_DATE	DATUM	DATS	8	0	Creation Date of the Operative Business Transaction
13	USER_CREATE_TIME	TPM_BT_CREATE_TIME	UZEIT	TIMS	6	0	Creation Time of the Operative Business Transaction
14	REF_BUSTRANSID	TPM_REFBUSTRANSID	SYSUUID	RAW	16	0	Business Transaction ID of Reference Business Transaction
15	TR_REV_REASON	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
16	DOCUMENT_DATE	BLDAT	DATUM	DATS	8	0	Document Date in Document
17	PRODUCT_CATEGORY	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
18	CREATE_NAME	RERF	SYCHAR12	CHAR	12	0	Entered by
19	CREATE_DATE	DERF	DATUM	DATS	8	0	First Entered on
20	CREATE_TIME	TERF	TIMES	TIMS	6	0	Time of Initial Entry
21	CREATE_TCODE	TCODE	TCODE	CHAR	20	0	Transaction Code
22	CHANGE_NAME	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
23	CHANGE_DATE	DBEAR	DATUM	DATS	8	0	Last Edited on
24	CHANGE_TIME	TBEAR	TIMES	TIMS	6	0	Last Edited at
25	CHANGE_TCODE	TCODE	TCODE	CHAR	20	0	Transaction Code
26	FLOW_NUMBER	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
27	DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
28	ALLOC_NMBR	DZUONR	ZUONR	CHAR	18	0	Assignment number
29	PRODUCT_TYPE	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
30	COM_VAL_CLASS	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
31	VALUATION_CLASS	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class
32	SECURITY_ID	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
33	SECURITY_ACCOUNT	RLDEPO	RLDEPO	CHAR	10	0	Securities Account
34	ACCOUNT_GROUP	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group
35	PORTFOLIO	RPORTB	RPORTB	CHAR	10	0	Portfolio
36	TRADER	RDEALER	RDEALER	CHAR	12	0	Trader
37	LOANS_CONTRACT	RANL	RANL	CHAR	13	0	Contract Number
38	POSITION_ACCOUNT	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures
39	FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
40	UNITS	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
41	NOMINAL_CURR	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
42	NOMINAL_AMT	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
43	POSITION_CURR	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
44	POSITION_AMT	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
45	POSAMT_IDX_CLEAN	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
46	LOCAL_CURR	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency
47	LOCAL_AMT	TPM_LOCAL_AMT	TPM_AMOUNT	CURR	21	2	Amount in Local Currency
48	VALUATION_CURR	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
49	VALUATION_AMT	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
50	TRL_POS_MAN_CAT	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category
51	SOURCETARGET_FLG	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
52	TRANSFER_GROUP	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
53	LOT_CREATION	TPM_LOT_CREATION	TPM_LOT_CREATION	NUMC	1	0	Lot Creation Category
54	PAYMENT_CURR	TPM_PAYMENT_CURR	WAERS	CUKY	5	0	Payment Currency
55	PAYMENT_AMT	TPM_PAYMENT_AMT	TPM_AMOUNT	CURR	21	2	Amount in Payment Currency
56	SIGN	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
57	HOUSE_BANK	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank
58	HOUSE_BANK_ACC	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account
59	PAYMENT_DATE	TPM_PAYMENT_DATE	TPM_POSITION_DATE	DATS	8	0	Payment Date
60	CALCULATION_DATE	DVALUT	DATUM	DATS	8	0	Calculation Date
61	CALC_DATE_INCL	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
62	COUPON_DATE	TPM_COUPON_DATE	DATUM	DATS	8	0	Date of the Next Coupon
63	COUPON_SIGN	TPM_COUPON_SIGN	VVSCOUPON	CHAR	1	0	Coupon ID for Interest and Accrued Interest Calculation
64	CALC_BEGIN	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
65	CALC_END	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
66	TRANSACTION_TYPE	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
67	LOT_ID	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
68	QUANT_CAT	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
69	AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
70	FIXED_AA_REF	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
71	DUE_DATE	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
72	RPBANK	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
73	RPZAHL	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
74	SZART	TB_SZART	XFELD	CHAR	1	0	Payment transaction
75	ZLSCH	DZLSCH	ZLSCH	CHAR	1	0	Payment method
76	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
77	SPAYRQ	TB_SPAYRQ	T_SPAYRQ	CHAR	1	0	Payment request allowed
78	SPRSNG	TB_SPRSNG	T_SPAYRQ	CHAR	1	0	Individual payment required
79	SPRGRD	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
80	SCSPAY	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
81	ZWELS	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
82	PAYGR	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
83	PLANNED_ACTION	TPM_PLANNED_ACTION	TPM_PLANNED_ACTION	INT1	3	0	Planned Action in a Business Transaction
84	FI_POST_DATE	TPM_FI_POSTING_DATE	DATUM	DATS	8	0	Different FI Posting Date
85	FI_POST_PERIOD	TPM_FI_POSTING_PERIOD	MONAT	NUMC	2	0	Different FI Posting Period
86	DEAL_NUMBER	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction
87	PRODUCT_GROUP	TPM_PRODUCT_GROUP	TPM_PRODUCT_GROUP	NUMC	3	0	Product Group
88	FI_REV_DATE	TPM_FI_REVERSAL_DATE	DATUM	DATS	8	0	Different FI Reversal Date
89	FI_REV_PERIOD	TPM_FI_REVERSAL_PERIOD	MONAT	NUMC	2	0	Alternative FI Reversal Period
90	NOMINAL_ORG_AMT	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
91	ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
92	EFF_INT_RATE_U	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
93	EFF_INT_RATE_N	TPM_TRL_EFF_INT_RATE_NEW	DEC3_7	DEC	10	7	Valid Effective Interest Rate for the Next Amortization
94	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country
95	LZBKZ	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator
96	RPCODE	RPCODE	RPCODE	CHAR	20	0	Repetitive Code
97	RP_TEXT	RPCODE_TEXT	XTEXT50	CHAR	50	0	Reference Text for Repetitive Code
98	RFHAZU	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
99	NORDEXT	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
100	SFGZUSTT	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	TRDV_TRANS_FLOW	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	KEY	1	CN
2	TRDV_TRANS_FLOW	COMPANY_CODE	T001	BUKRS	KEY	1	CN
3	TRDV_TRANS_FLOW	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
4	TRDV_TRANS_FLOW	DIS_FLOWTYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE	KEY	1	CN
5	TRDV_TRANS_FLOW	FIXED_AA_REF	TRACC_AA_REF	AA_REF	KEY	1	CN
6	TRDV_TRANS_FLOW	MANDT	T000	MANDT	KEY	1	CN
7	TRDV_TRANS_FLOW	PRODUCT_CATEGORY	TZAF	SANLF	KEY	1	CN
8	TRDV_TRANS_FLOW	PRODUCT_TYPE	TZPA	GSART	KEY	1	CN
9	TRDV_TRANS_FLOW	RPZAHL	BUT000	PARTNER	KEY	1	CN
10	TRDV_TRANS_FLOW	SECURITY_ID	VWPANLA	RANL	KEY	C	CN
11	TRDV_TRANS_FLOW	TRANSACTION_TYPE	AT10	SFHAART	KEY	1	CN
12	TRDV_TRANS_FLOW	TR_REV_REASON	TZST	SSTOGRD	KEY	1	CN
13	TRDV_TRANS_FLOW	UZAWE	T042F	UZAWE	KEY	1	CN
14	TRDV_TRANS_FLOW	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA	KEY	1	CN