SAP Table TRDT_FLOW

Persistent distributor flows

The table TRDT_FLOW (Persistent distributor flows) is a standard table in SAP ERP. It belongs to the package FTR_DISTRIBUTOR.

Technical Information

Table	TRDT_FLOW
Short Text	Persistent distributor flows
Package	FTR_DISTRIBUTOR
Table Type	Transparent Table

Fields for Table TRDT_FLOW

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
BUSTRANS_OS_GUID	✔	Object Identity in Database Format	TPM_DB_OS_GUID	CHAR	32	TRDT_TRDBUSTRANS
FLOW_NUMBER	✔	Number of a Distributor Flow	TPM_TRDFLOWNR	INT4	10
DIS_FLOWTYPE		Update Type	TPM_DIS_FLOWTYPE	CHAR	8	TRDC_DFLOWTYPE
ALLOC_NMBR		Assignment Number	DZUONR	CHAR	18
COMPANY_CODE		Company Code	BUKRS	CHAR	4	T001
VALUATION_AREA		Valuation Area	TPM_VAL_AREA	CHAR	3	*
PRODUCT_TYPE		Product Type	VVSART	CHAR	3	TZPA
TRANSACTION_TYPE		Financial Transaction Type	TB_SFHAART	CHAR	3	AT10
COM_VAL_CLASS		General Valuation Class	TPM_COM_VAL_CLASS	NUMC	4	TRGC_COM_VALCL
VALUATION_CLASS		Valuation Class	TPM_VAL_CLASS	NUMC	4	TRGC_VAL_CLASS
SECURITY_ID		Security ID Number	VVRANLW	CHAR	13	VWPANLA
SECURITY_ACCOUNT		Securities Account	RLDEPO	CHAR	10	TWD01
ACCOUNT_GROUP		Securities Account Group	TPM_SEC_ACCT_GRP	CHAR	10	TRGT_SECACCGRP
PORTFOLIO		Portfolio	RPORTB	CHAR	10	TWPOB
TRADER		Trader	RDEALER	CHAR	12	TZDEA
LOANS_CONTRACT		Contract Number	RANL	CHAR	13	VDARL
DEAL_NUMBER		Financial Transaction	TB_RFHA	CHAR	13	VTBFHA
POSITION_ACCOUNT		Futures Account for Listed Options and Futures	TPM_POS_ACCOUNT_FUT	CHAR	10	*
LOT_ID		Identifier of the Lot	TPM_LOT_ID	RAW	16
FLAG_LONG_SHORT		Indicator: Long or Short Position	TPM_FLAG_LONG_SHORT	CHAR	1
FUND		Fund	FM_FUND	CHAR	10	*
GRANT_NBR		Grant	GM_GRANT_NBR	CHAR	20
EXTERNAL_ACCOUNT		External Account	TPM_EXT_ACCOUNT	CHAR	10
DIFF_CURRENCY		Currency as Differentiation Term	TPM_DIFF_CURRENCY	CUKY	5	*
UNITS		Units	TPM_UNITS	DEC	22
NOMINAL_CURR		Nominal Currency	TPM_NOMINAL_CURR	CUKY	5	*
NOMINAL_AMT		Nominal Amount	TPM_NOMINAL_AMT	CURR	21
NOMINAL_ORG_AMT		Original Nominal Amount in Position Currency	TPM_NOMINAL_ORG_AMT	CURR	21
POSITION_CURR		Position Currency	TPM_POSITION_CURR	CUKY	5	*
POSITION_AMT		Amount (Position Currency)	TPM_POSITION_AMT	CURR	21
POSAMT_IDX_CLEAN		Amount in Position Currency Index-Clean	TPM_POSITION_AMT_IDX_CLEAN	CURR	21
QUANT_CAT		Position Change Category: Quantity	TPM_QTY_PM_CAT	CHAR	4
ACTIVE_PASSIVE		Indicator: Assets/Liabilities Position	TPM_ACTIVE_PASSIVE	CHAR	1
LOCAL_CURR		Local Currency	TPM_LOCAL_CURR	CUKY	5	*
LOCAL_AMT		Amount (Local Currency)	TPM_LOCAL_AMT	CURR	21
VALUATION_CURR		Valuation Currency	TPM_VALUATION_CURR	CUKY	5	*
VALUATION_AMT		Amount in Valuation Currency	TPM_VALUATION_AMT	CURR	21
TRL_POS_MAN_CAT		Position Change Category	TPM_AMT_PM_CAT	CHAR	4	*
FIXED_AA_REF		Account Assignment Reference of Position Management	TPM_AA_REF	CHAR	12	TRACC_AA_REF
SOURCETARGET_FLG		Indicator: Source or Target of a Flow	TPM_SOURCE_TARGET_FLG	CHAR	1
TRANSFER_GROUP		Group of Flows from a Source or Target	TPM_TRANSFER_GROUP	NUMC	4
LOT_CREATION		Lot Creation Category	TPM_LOT_CREATION	NUMC	1
AMOUNT_FACTOR		Value Coefficient	TPM_AMOUNT_FACTOR	FLTP	16
PAYMENT_CURR		Payment Currency	TPM_PAYMENT_CURR	CUKY	5	*
PAYMENT_AMT		Payment Amount	TPM_PAYMENT_AMT	CURR	21
SIGN		Direction of flow	TB_SSIGN	CHAR	1
HOUSE_BANK		Short key for own house bank	TB_RHABKI	CHAR	5	*
HOUSE_BANK_ACC		Short key for house bank account	TB_RHKTID	CHAR	5	*
PAYMENT_DATE		Payment Date	TPM_PAYMENT_DATE	DATS	8
DUE_DATE		Due Date	TPM_DUE_DATE	DATS	8
RPBANK		Partner bank details	TB_RPBANK	CHAR	4
RPZAHL		Payer/payee	TB_RPZAHL_NEW	CHAR	10	BUT000
SZART		Payment transaction	TB_SZART	CHAR	1
ZLSCH		Payment Method	DZLSCH	CHAR	1	*
UZAWE		Payment Method Supplement	UZAWE	CHAR	2	T042F
SPAYRQ		Payment request allowed	TB_SPAYRQ	CHAR	1
SPRSNG		Individual payment required	TB_SPRSNG	CHAR	1
SPRGRD		Determine grouping definition	TB_SPRGRD	CHAR	1
SCSPAY		Same direction necessary for joint payment?	TB_SCSPAY	CHAR	1
ZWELS		List of the Payment Methods to be Considered	DZWELS	CHAR	10
PAYGR		Grouping Field for Automatic Payments	PAYGR	CHAR	20
CALCULATION_DATE		Calculation Date	DVALUT	DATS	8
CALC_DATE_INCL		Inclusive indicator for beginning and end of a period	VVSINCL	NUMC	1
COUPON_DATE		Date of the Next Coupon	TPM_COUPON_DATE	DATS	8
COUPON_SIGN		Coupon ID for Interest and Accrued Interest Calculation	TPM_COUPON_SIGN	CHAR	1
CALC_BEGIN		Start of Calculation Period	DBERVON	DATS	8
CALC_END		End of Calculation Period	DBERBIS	DATS	8
EFF_INT_RATE_U		For Calculation of Amortization Amts (SAC) for Used EffInR	TPM_TRL_EFF_INT_RATE_USED	DEC	10
SCHED_EFF_RATE		Key for Redemption Schedule that Explains Effect. Int. Rate	RDPT_SCHEDULE_KEY_EFF_RATE	INT4	10
EFF_INT_RATE_N		Valid Effective Interest Rate for the Next Amortization	TPM_TRL_EFF_INT_RATE_NEW	DEC	10
SCHED_FIX		Key for Fixed Redemption Schedule	RDPT_SCHEDULE_KEY_FIX	INT4	10
LANDL		Supplying Country	LANDL	CHAR	3	*
LZBKZ		State Central Bank Indicator	LZBKZ	CHAR	3	*
RPCODE		Repetitive Code	RPCODE	CHAR	20	*
RP_TEXT		Reference Text for Repetitive Code	RPCODE_TEXT	CHAR	50
RFHAZU		Transaction activity	TB_RFHAZU	NUMC	5
NORDEXT		External Reference	TB_NORDEXT	CHAR	16
SFGZUSTT		Transaction Activity Category	TB_SFGZUTY	NUMC	2	*
SKHWFIX		Indicator for translation into local currency	TB_SKHWFIX	CHAR	1
TRANSL_DATE		Translation Date	WWERT_D	DATS	8
RKONDGR		Direction of Transaction	TB_RKONDGR	NUMC	1
COUNTERPARTY		Business Partner Number	TB_KUNNR_NEW	CHAR	10	*
SNOTDELIVERED		Security not delivered	FTR_NOT_DEL_FLG	CHAR	1
CLEARING_STATUS		Clearing Status (TREA)	TPM_TREA_CLEARING_STATUS	NUMC	1
CLEARING_DATE		Actual Clearing Date	TPM_TREA_CLEARING_DATE_ACT	DATS	8
MNDID		Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35