SAP ABAP Table TRLT_FLOW (Treasury Ledger Flows)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_TREASURY_LEDGER (Package) Treasury Ledger

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TRLT_FLOW	Table Relationship Diagram
Short Description	Treasury Ledger Flows

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	TRANSACTION_OID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRLT_TRANSACTION
3	TRLFLOWNUMBER	☑	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
4	.INCLUDE	☐				0	0	Include Structure Treasury Ledger Flows
5	FLOWNUMBER	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
6	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
7	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
8	FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	*
9	AMOUNT_FACTOR	☐	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
10	QUANT_CAT	☐	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
11	AMOUNT_CAT	☐	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category	*
12	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
13	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
14	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
15	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency	*
16	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
17	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
18	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency	*
19	VALUATION_AMT	☐	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
20	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
21	CALCULATION_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
22	CALC_DATE_INCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
23	DUE_DATE	☐	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
24	CALC_BEGIN	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
25	CALC_END	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
26	EFF_INT_RATE_U	☐	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
27	SCHED_EFF_RATE	☐	RDPT_SCHEDULE_KEY_EFF_RATE		INT4	10	0	Key for Redemption Schedule that Explains Effect. Int. Rate
28	EFF_INT_RATE_N	☐	TPM_TRL_EFF_INT_RATE_NEW	DEC3_7	DEC	10	7	Valid Effective Interest Rate for the Next Amortization
29	SCHED_FIX	☐	RDPT_SCHEDULE_KEY_FIX		INT4	10	0	Key for Fixed Redemption Schedule
30	.INCLUDE	☐				0	0	Include Structure TRL Documents
31	DOCUMENTID	☐	TPM_TRDDOCID	SYSUUID	RAW	16	0	Distributor Document ID
32	BOOKING_STATE	☐	TPM_TRL_BOOKINGSTATE	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Posting Status Treasury Ledger Business Transaction
33	USER_DATA_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
34	POSITION_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRLT_POSITION
35	TRLDATE	☐	TPM_TRLDATE	DATUM	DATS	8	0	Treasury Ledger Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRLT_FLOW	POSITION_OID	TRLT_POSITION	OS_GUID
2	TRLT_FLOW	TRANSACTION_OID	TRLT_TRANSACTION	OS_GUID
3	TRLT_FLOW	USER_DATA_OID	TRGT_USER_DATA	OS_GUID

History

Last changed by/on	SAP	20110901
SAP Release Created in