SAP ABAP Table TRLS_FLOW_AND_TRANS1 (Treasury Ledger Flows Including Business Transaction)

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	INTTAB	Structure
Structure	TRLS_FLOW_AND_TRANS1	Table Relationship Diagram
Short Description	Treasury Ledger Flows Including Business Transaction

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	Mapping Structure Treasury Ledger Business Transactions
2	OS_GUID	☐	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
3	.INCLUDE	☐				0	0	Include Structure Treasury Ledger Business Transactions
4	PRODUCT_GROUP	☐	TPM_PRODUCT_GROUP	TPM_PRODUCT_GROUP	NUMC	3	0	Product Group
5	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
6	TRLDATE	☐	TPM_TRLDATE	DATUM	DATS	8	0	Treasury Ledger Date
7	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
8	CREATE_DATE	☐	TPM_BT_CREATE_DATE	DATUM	DATS	8	0	Creation Date of the Operative Business Transaction
9	CREATE_TIME	☐	TPM_BT_CREATE_TIME	UZEIT	TIMS	6	0	Creation Time of the Operative Business Transaction
10	BUSTRANSSTATE	☐	TPM_TRLTRANSTATE	TPM_TRANSACTION_STATE	CHAR	1	0	Status of Treasury Ledger Business Transaction
11	BOOKING_STATE	☐	TPM_TRL_BOOKINGSTATE	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Posting Status Treasury Ledger Business Transaction
12	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
13	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	*
14	REFBUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
15	FI_POST_DATE	☐	TPM_FI_POSTING_DATE	DATUM	DATS	8	0	Different FI Posting Date
16	FI_POST_PERIOD	☐	TPM_FI_POSTING_PERIOD	MONAT	NUMC	2	0	Different FI Posting Period
17	FI_REV_DATE	☐	TPM_FI_REVERSAL_DATE	DATUM	DATS	8	0	Different FI Reversal Date
18	FI_REV_PERIOD	☐	TPM_FI_REVERSAL_PERIOD	MONAT	NUMC	2	0	Alternative FI Reversal Period
19	MIGR_INIT_FLG	☐	TPM_FLG_MIGR_INIT	TPM_FLG_MIGR_INIT	CHAR	1	0	Bus. Transaction Originated from Migration/Initialization
20	USER_DATA_OID	☐	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
21	USER_DATA_CLS	☐	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
22	TAB_FLOW_PERS	☐	TRLY_FLOW_PERS		TTYP	0	0
23	.INCLUDE	☐				0	0	Treasury Ledger Flows
24	POSITION	☐	CL_POSITION_TRL		REF	0	0
25	TRLFLOWNUMBER	☐	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
26	.INCLUDE	☐				0	0	Include Structure Treasury Ledger Flows
27	FLOWNUMBER	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
28	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
29	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
30	FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	*
31	AMOUNT_FACTOR	☐	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
32	QUANT_CAT	☐	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
33	AMOUNT_CAT	☐	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category	*
34	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
35	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
36	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
37	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency	*
38	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
39	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
40	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency	*
41	VALUATION_AMT	☐	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
42	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	*
43	CALCULATION_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
44	CALC_DATE_INCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
45	DUE_DATE	☐	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
46	CALC_BEGIN	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
47	CALC_END	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
48	EFF_INT_RATE_U	☐	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
49	SCHED_EFF_RATE	☐	RDPT_SCHEDULE_KEY_EFF_RATE		INT4	10	0	Key for Redemption Schedule that Explains Effect. Int. Rate
50	EFF_INT_RATE_N	☐	TPM_TRL_EFF_INT_RATE_NEW	DEC3_7	DEC	10	7	Valid Effective Interest Rate for the Next Amortization
51	SCHED_FIX	☐	RDPT_SCHEDULE_KEY_FIX		INT4	10	0	Key for Fixed Redemption Schedule
52	ACTIVE_PASSIVE	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
53	TRANSACTION_TYPE	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
54	POSTING_DATE	☐	TPM_POSTING_DATE	DATUM	DATS	8	0	Posting Date for the Subledger
55	POSTING_STATE	☐	FTR_LEDGER_POSTING_STATE	FTR_LEDGER_POSTING_STATE	CHAR	1	0	Ledger Posting Status
56	HEDGE_ID	☐	THM_HEDGE_ID	THM_HEDGE_ID	NUMC	10	0	Hedge Item Identification Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRLS_FLOW_AND_TRANS1	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT

History

Last changed by/on	SAP	20110901
SAP Release Created in	110