SAP ABAP Table TRLV_TRANS1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRLV_TRANS1	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	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	OS_GUID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
3	BUSTRANSCAT	☑	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
4	TRLDATE	☑	TPM_TRLDATE	DATUM	DATS	8	0	Treasury Ledger Date
5	BUSTRANSID	☑	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
6	CREATE_DATE	☑	TPM_BT_CREATE_DATE	DATUM	DATS	8	0	Creation Date of the Operative Business Transaction
7	CREATE_TIME	☑	TPM_BT_CREATE_TIME	UZEIT	TIMS	6	0	Creation Time of the Operative Business Transaction
8	BUSTRANSSTATE	☑	TPM_TRLTRANSTATE	TPM_TRANSACTION_STATE	CHAR	1	0	Status of Treasury Ledger Business Transaction
9	BOOKING_STATE	☑	TPM_TRL_BOOKINGSTATE	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Posting Status Treasury Ledger Business Transaction
10	VALUATION_AREA	☑	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area
11	TR_ACC_CODE	☑	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code
12	REFBUSTRANSID	☑	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
13	USER_DATA_OID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
14	USER_DATA_CLS	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
15	TRLFLOWNUMBER	☑	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
16	FLOWNUMBER	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
17	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
18	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
19	FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type
20	AMOUNT_FACTOR	☐	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
21	QUANT_CAT	☐	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
22	AMOUNT_CAT	☐	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category
23	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
24	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
25	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
26	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
27	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
28	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
29	VALUATION_AMT	☐	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
30	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
31	POSITION_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRLT_POSITION
32	PRODUCT_GROUP	☐	TPM_PRODUCT_GROUP	TPM_PRODUCT_GROUP	NUMC	3	0	Product Group
33	FI_POST_DATE	☐	TPM_FI_POSTING_DATE	DATUM	DATS	8	0	Different FI Posting Date
34	FI_POST_PERIOD	☐	TPM_FI_POSTING_PERIOD	MONAT	NUMC	2	0	Different FI Posting Period
35	FI_REV_DATE	☐	TPM_FI_REVERSAL_DATE	DATUM	DATS	8	0	Different FI Reversal Date
36	FI_REV_PERIOD	☐	TPM_FI_REVERSAL_PERIOD	MONAT	NUMC	2	0	Alternative FI Reversal Period
37	MIGR_INIT_FLG	☐	TPM_FLG_MIGR_INIT	TPM_FLG_MIGR_INIT	CHAR	1	0	Bus. Transaction Originated from Migration/Initialization
38	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
39	CALCULATION_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
40	CALC_DATE_INCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
41	DUE_DATE	☐	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
42	CALC_BEGIN	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
43	CALC_END	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
44	EFF_INT_RATE_U	☐	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
45	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	TRLV_TRANS1	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
2	TRLV_TRANS1	POSITION_OID	TRLT_POSITION	OS_GUID
3	TRLV_TRANS1	USER_DATA_OID	TRGT_USER_DATA	OS_GUID

History

Last changed by/on	SAP	20110901
SAP Release Created in