SAP ABAP Table TXI_TRDT_FLOW (Treasury: Persistent distributor flows)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_ILM (Package) Support Information Lifecycle management (ILM)

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_TRDT_FLOW	Table Relationship Diagram
Short Description	Treasury: Persistent distributor flows

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	.INCLUDE	☐				0	0	Persistent distributor flows
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUSTRANS_OS_GUID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRDT_TRDBUSTRANS
4	FLOW_NUMBER	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
5	DIS_FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
6	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
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	PRODUCT_TYPE	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
11	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
12	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
13	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
14	SECURITY_ACCOUNT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
15	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
16	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
17	TRADER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
18	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
19	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
20	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	*
21	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
22	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
23	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
24	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency	*
25	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
26	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
27	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency	*
28	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
29	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
30	QUANT_CAT	☐	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
31	ACTIVE_PASSIVE	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
32	LOCAL_CURR	☐	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency	*
33	LOCAL_AMT	☐	TPM_LOCAL_AMT	TPM_AMOUNT	CURR	21	2	Amount in Local Currency
34	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
35	VALUATION_AMT	☐	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
36	TRL_POS_MAN_CAT	☐	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category	*
37	FIXED_AA_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
38	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
39	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
40	LOT_CREATION	☐	TPM_LOT_CREATION	TPM_LOT_CREATION	NUMC	1	0	Lot Creation Category
41	AMOUNT_FACTOR	☐	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
42	PAYMENT_CURR	☐	TPM_PAYMENT_CURR	WAERS	CUKY	5	0	Payment Currency	*
43	PAYMENT_AMT	☐	TPM_PAYMENT_AMT	TPM_AMOUNT	CURR	21	2	Amount in Payment Currency
44	SIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
45	HOUSE_BANK	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
46	HOUSE_BANK_ACC	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
47	PAYMENT_DATE	☐	TPM_PAYMENT_DATE	TPM_POSITION_DATE	DATS	8	0	Payment Date
48	DUE_DATE	☐	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
49	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
50	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
51	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
52	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
53	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
54	SPAYRQ	☐	TB_SPAYRQ	T_SPAYRQ	CHAR	1	0	Payment request allowed
55	SPRSNG	☐	TB_SPRSNG	T_SPAYRQ	CHAR	1	0	Individual payment required
56	SPRGRD	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
57	SCSPAY	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
58	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
59	PAYGR	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
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	EFF_INT_RATE_U	☐	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
67	SCHED_EFF_RATE	☐	RDPT_SCHEDULE_KEY_EFF_RATE		INT4	10	0	Key for Redemption Schedule that Explains Effect. Int. Rate
68	EFF_INT_RATE_N	☐	TPM_TRL_EFF_INT_RATE_NEW	DEC3_7	DEC	10	7	Valid Effective Interest Rate for the Next Amortization
69	SCHED_FIX	☐	RDPT_SCHEDULE_KEY_FIX		INT4	10	0	Key for Fixed Redemption Schedule
70	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
71	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
72	RPCODE	☐	RPCODE	RPCODE	CHAR	20	0	Repetitive Code	*
73	RP_TEXT	☐	RPCODE_TEXT	XTEXT50	CHAR	50	0	Reference Text for Repetitive Code
74	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
75	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
76	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	TXI_TRDT_FLOW	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP	KEY	C	CN
2	TXI_TRDT_FLOW	BUSTRANS_OS_GUID	TRDT_TRDBUSTRANS	OS_GUID	KEY	1	CN
3	TXI_TRDT_FLOW	COMPANY_CODE	T001	BUKRS	KEY	1	CN
4	TXI_TRDT_FLOW	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
5	TXI_TRDT_FLOW	DEAL_NUMBER	VTBFHA	RFHA	KEY	1	CN
6	TXI_TRDT_FLOW	DIS_FLOWTYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE	KEY	1	CN
7	TXI_TRDT_FLOW	FIXED_AA_REF	TRACC_AA_REF	AA_REF	KEY	1	CN
8	TXI_TRDT_FLOW	LOANS_CONTRACT	VDARL	RANL	KEY	C	CN
9	TXI_TRDT_FLOW	MANDT	T000	MANDT	KEY	1	CN
10	TXI_TRDT_FLOW	PORTFOLIO	TWPOB	RPORTB	KEY	C	CN
11	TXI_TRDT_FLOW	PRODUCT_TYPE	TZPA	GSART	KEY	1	CN
12	TXI_TRDT_FLOW	RPZAHL	BUT000	PARTNER	KEY	1	CN
13	TXI_TRDT_FLOW	SECURITY_ACCOUNT	TWD01	RLDEPO	KEY	C	CN
14	TXI_TRDT_FLOW	SECURITY_ID	VWPANLA	RANL	KEY	C	CN
15	TXI_TRDT_FLOW	TRADER	TZDEA	RDEALER	KEY	C	CN
16	TXI_TRDT_FLOW	TRANSACTION_TYPE	AT10	SFHAART	KEY	1	CN
17	TXI_TRDT_FLOW	UZAWE	T042F	UZAWE	KEY	1	CN
18	TXI_TRDT_FLOW	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA	KEY	1	CN
19	TXI_TRDT_FLOW	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS	KEY	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	604