SAP ABAP View TRLV_DERIV_QUERY (Query for Database Accesses of Derived 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

View Type	D	Database View
Database View	TRLV_DERIV_QUERY
Short Description	Query for Database Accesses of Derived Business Transaction
Root table	TRLT_DERIVFLOWS	Treasury: Flows for Derived Business Transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRLT_DERIVFLOWS	TRLT_DERIVFLOWS
2	TRLT_DERIVTRANS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRLT_DERIVTRANS	MANDT	JL	EQ				0	0
2	TRLT_DERIVFLOWS	MANDT	JR	EQ			AND	0	0
3	TRLT_DERIVTRANS	OS_GUID	JL	EQ				0	0
4	TRLT_DERIVFLOWS	DERIV_TRANS_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRLT_DERIVTRANS	MANDT		☐	MANDT	☐	Client
2	OS_GUID	TRLT_DERIVTRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	USER_DATA_CLS	TRLT_DERIVTRANS	USER_DATA_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
4	USER_DATA_OID	TRLT_DERIVTRANS	USER_DATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	DERIVTRANSSTAT	TRLT_DERIVTRANS	DERIVTRANSSTAT		☐	TPM_DERIVTRANSSTAT	☐	Status of a Business Transaction of Category: 'Derived BT'
6	DIST_TRANS_ID	TRLT_DERIVTRANS	DIST_TRANS_ID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
7	RF_DIST_TRANS_ID	TRLT_DERIVTRANS	RF_DIST_TRANS_ID		☐	TPM_REFBUSTRANSID	☐	Business Transaction ID of Reference Business Transaction
8	POSITION_DATE	TRLT_DERIVTRANS	POSITION_DATE		☐	TPM_POSITION_DATE	☐	Position Value Date
9	TR_ACC_CODE	TRLT_DERIVTRANS	TR_ACC_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
10	VALUATION_AREA	TRLT_DERIVTRANS	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
11	CREATE_DATE	TRLT_DERIVTRANS	CREATE_DATE		☐	TPM_BT_CREATE_DATE	☐	Creation Date of the Operative Business Transaction
12	CREATE_TIME	TRLT_DERIVTRANS	CREATE_TIME		☐	TPM_BT_CREATE_TIME	☐	Creation Time of the Operative Business Transaction
13	DERIV_FLOWNUMBER	TRLT_DERIVFLOWS	DERIV_FLOWNUMBER		☐	TPM_TRLDERIVFLOWNR	☐	Number of TRL Flow
14	POSITION_OID	TRLT_DERIVFLOWS	POSITION_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	DIST_FLOW_NUMBER	TRLT_DERIVFLOWS	DIST_FLOW_NUMBER		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
16	POS_MAN_PROC	TRLT_DERIVFLOWS	POS_MAN_PROC		☐	TPM_POS_MAN_PROC	☐	Position Management Procedure
17	DERIV_METHOD	TRLT_DERIVFLOWS	DERIV_METHOD		☐	TPM_DERIV_METHOD	☐	Derivation Method
18	POSITION_CURR	TRLT_DERIVFLOWS	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
19	POSITION_AMT	TRLT_DERIVFLOWS	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
20	POSAMT_IDX_CLEAN	TRLT_DERIVFLOWS	POSAMT_IDX_CLEAN		☐	TPM_POSITION_AMT_IDX_CLEAN	☐	Amount in Position Currency Index-Clean
21	VALUATION_CURR	TRLT_DERIVFLOWS	VALUATION_CURR		☐	TPM_VALUATION_CURR	☐	Valuation Currency
22	VALUATION_AMT	TRLT_DERIVFLOWS	VALUATION_AMT		☐	TPM_VALUATION_AMT	☐	Amount in Valuation Currency
23	AMT_PM_CAT	TRLT_DERIVFLOWS	AMT_PM_CAT		☐	TPM_AMT_PM_CAT	☐	Position Change Category
24	DIST_FLOWTYPE	TRLT_DERIVFLOWS	DIST_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
25	SOURCETARGET_FLG	TRLT_DERIVFLOWS	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
26	TRANSFER_GROUP	TRLT_DERIVFLOWS	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
27	EFF_INT_RATE_U	TRLT_DERIVFLOWS	EFF_INT_RATE_U		☐	TPM_TRL_EFF_INT_RATE_USED	☐	For Calculation of Amortization Amts (SAC) for Used EffInR
28	EFF_INT_RATE_N	TRLT_DERIVFLOWS	EFF_INT_RATE_N		☐	TPM_TRL_EFF_INT_RATE_NEW	☐	Valid Effective Interest Rate for the Next Amortization
29	SCHED_EFF_RATE	TRLT_DERIVFLOWS	SCHED_EFF_RATE		☐	RDPT_SCHEDULE_KEY_EFF_RATE	☐	Key for Redemption Schedule that Explains Effect. Int. Rate
30	SCHED_FIX	TRLT_DERIVFLOWS	SCHED_FIX		☐	RDPT_SCHEDULE_KEY_FIX	☐	Key for Fixed Redemption Schedule

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20050411
SAP Release Created in	462_10