SAP ABAP Table SLDV_TRANS_FLOW (Generated Table for View)

Basic Data

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

Foreign Keys

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

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