SAP ABAP Table TRLV_DERIV_QUERY (Generated Table for View TRLV_DERIV_QUERY)

Basic Data

Table Category	VIEW	General view structure
General view structure	TRLV_DERIV_QUERY	Table Relationship Diagram
Short Description	Generated Table for View TRLV_DERIV_QUERY

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	USER_DATA_CLS	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
4	USER_DATA_OID	☑	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
5	DERIVTRANSSTAT	☑	TPM_DERIVTRANSSTAT	TPM_DERIVTRANSSTAT	CHAR	1	0	Status of a Business Transaction of Category: 'Derived BT'
6	DIST_TRANS_ID	☑	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
7	RF_DIST_TRANS_ID	☑	TPM_REFBUSTRANSID	SYSUUID	RAW	16	0	Business Transaction ID of Reference Business Transaction
8	POSITION_DATE	☑	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
9	TR_ACC_CODE	☑	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code
10	VALUATION_AREA	☑	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area
11	CREATE_DATE	☑	TPM_BT_CREATE_DATE	DATUM	DATS	8	0	Creation Date of the Operative Business Transaction
12	CREATE_TIME	☑	TPM_BT_CREATE_TIME	UZEIT	TIMS	6	0	Creation Time of the Operative Business Transaction
13	DERIV_FLOWNUMBER	☑	TPM_TRLDERIVFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
14	POSITION_OID	☐	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRLT_POSITION
15	DIST_FLOW_NUMBER	☐	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
16	POS_MAN_PROC	☐	TPM_POS_MAN_PROC	TPM_POS_MAN_PROC	CHAR	4	0	Position Management Procedure
17	DERIV_METHOD	☐	TPM_DERIV_METHOD	FUNCNAME	CHAR	30	0	Derivation Method
18	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
19	POSITION_AMT	☐	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
20	POSAMT_IDX_CLEAN	☐	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
21	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
22	VALUATION_AMT	☐	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
23	AMT_PM_CAT	☐	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category
24	DIST_FLOWTYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type
25	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
26	TRANSFER_GROUP	☐	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
27	EFF_INT_RATE_U	☐	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
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_EFF_RATE	☐	RDPT_SCHEDULE_KEY_EFF_RATE		INT4	10	0	Key for Redemption Schedule that Explains Effect. Int. Rate
30	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_DERIV_QUERY	POSITION_OID	TRLT_POSITION	OS_GUID	REF	1	CN
2	TRLV_DERIV_QUERY	USER_DATA_CLS	TRGT_USER_DATA	OS_GUID	REF	1	CN
3	TRLV_DERIV_QUERY	USER_DATA_OID	TRGT_USER_DATA	OS_GUID	REF	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in