SAP ABAP Table TRLV_QUERY (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRLV_QUERY	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	FI_POST_DATE	☑	TPM_FI_POSTING_DATE	DATUM	DATS	8	0	Different FI Posting Date
14	FI_POST_PERIOD	☑	TPM_FI_POSTING_PERIOD	MONAT	NUMC	2	0	Different FI Posting Period
15	FI_REV_DATE	☑	TPM_FI_REVERSAL_DATE	DATUM	DATS	8	0	Different FI Reversal Date
16	FI_REV_PERIOD	☑	TPM_FI_REVERSAL_PERIOD	MONAT	NUMC	2	0	Alternative FI Reversal Period
17	TRANSACTION_OID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRLT_TRANSACTION
18	TRLFLOWNUMBER	☑	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
19	FLOWNUMBER	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
20	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
21	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
22	FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type
23	QUANT_CAT	☐	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
24	AMOUNT_CAT	☐	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category
25	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
26	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
27	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
28	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
29	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
30	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
31	VALUATION_AMT	☐	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
32	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
33	POSITION_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRLT_POSITION
34	USER_DATA_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
35	USER_DATA_CLS	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
36	AMOUNT_FACTOR	☐	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
37	CALCULATION_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
38	CALC_DATE_INCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
39	DUE_DATE	☐	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
40	CALC_BEGIN	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
41	CALC_END	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
42	PRODUCT_GROUP	☐	TPM_PRODUCT_GROUP	TPM_PRODUCT_GROUP	NUMC	3	0	Product Group
43	MIGR_INIT_FLG	☐	TPM_FLG_MIGR_INIT	TPM_FLG_MIGR_INIT	CHAR	1	0	Bus. Transaction Originated from Migration/Initialization
44	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
45	EFF_INT_RATE_U	☐	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
46	EFF_INT_RATE_N	☐	TPM_TRL_EFF_INT_RATE_NEW	DEC3_7	DEC	10	7	Valid Effective Interest Rate for the Next Amortization
47	SCHED_EFF_RATE	☐	RDPT_SCHEDULE_KEY_EFF_RATE		INT4	10	0	Key for Redemption Schedule that Explains Effect. Int. Rate
48	SCHED_FIX	☐	RDPT_SCHEDULE_KEY_FIX		INT4	10	0	Key for Fixed Redemption Schedule

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRLV_QUERY	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
2	TRLV_QUERY	POSITION_OID	TRLT_POSITION	OS_GUID
3	TRLV_QUERY	TRANSACTION_OID	TRLT_TRANSACTION	OS_GUID
4	TRLV_QUERY	USER_DATA_OID	TRGT_USER_DATA	OS_GUID

History

Last changed by/on	SAP	20110901
SAP Release Created in