SAP ABAP View TRILV_DFLOW_TRL (Flows with Bus. Transaction Data and Information from TRL)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_INCOME_LEDGER (Package) Treasury: Income Ledger

Basic Data

View Type	D	Database View
Database View	TRILV_DFLOW_TRL
Short Description	Flows with Bus. Transaction Data and Information from TRL
Root table	TRILT_DFLOW	Derived Flows in the Income Ledger

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRILT_DFLOW	TRILT_DFLOW
2	TRILT_DTRANS
3	TRLT_TRANSACTION

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRILT_DTRANS	MANDT	JL	EQ				0	0
2	TRILT_DFLOW	MANDT	JR	EQ			AND	0	0
3	TRILT_DTRANS	OS_GUID	JL	EQ				0	0
4	TRILT_DFLOW	TRIL_DTRANS	JR	EQ			AND	0	0
5	TRILT_DTRANS	MANDT	JL	EQ				0	0
6	TRLT_TRANSACTION	MANDT	JR	EQ			AND	0	0
7	TRILT_DTRANS	TRIL_BUSTRANSID	JL	EQ				0	0
8	TRLT_TRANSACTION	BUSTRANSID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRILT_DTRANS	MANDT		☐	MANDT	☐	Client
2	OS_GUID	TRILT_DTRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	OS_GUID_TRL	TRLT_TRANSACTION	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
4	FLOW_NUMBER	TRILT_DFLOW	FLOW_NUMBER		☐	TPM_TRIL_FLOW_NR	☐	Flow Number in the Income Ledger
5	VALUATION_AREA	TRILT_DTRANS	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
6	TR_ACC_CODE	TRILT_DTRANS	TR_ACC_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
7	COMPANY_CODE	TRILT_DTRANS	COMPANY_CODE		☐	BUKRS	☐	Company Code
8	RFHA	TRILT_DTRANS	RFHA		☐	TB_RFHA	☐	Financial Transaction
9	PRODUCT_CAT	TRILT_DTRANS	PRODUCT_CAT		☐	SANLF	☐	Product Category
10	KEY_DATE	TRILT_DTRANS	KEY_DATE		☐	TPM_TRIL_DATE	☐	Date of a Business Transaction in the Income Ledger
11	BUSTRANSCAT	TRILT_DTRANS	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
12	TRIL_STATE	TRILT_DTRANS	TRIL_STATE		☐	TPM_TRIL_STATE	☐	Status of a Business Transaction in the Income Ledger
13	TRIL_BUSTRANSID	TRILT_DTRANS	TRIL_BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
14	VAL_BUSTRANSID	TRILT_DTRANS	VAL_BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
15	RECLASS_ORIGIN	TRILT_DTRANS	RECLASS_ORIGIN		☐	TPM_TRIL_RECLASS_ORIGIN	☐	Reason for Equity Capital Reclassification
16	USER_DATA_OID	TRILT_DTRANS	USER_DATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
17	BOOKING_STATE	TRLT_TRANSACTION	BOOKING_STATE		☐	TPM_TRL_BOOKINGSTATE	☐	Posting Status Treasury Ledger Business Transaction
18	FI_POST_DATE	TRLT_TRANSACTION	FI_POST_DATE		☐	TPM_FI_POSTING_DATE	☐	Different FI Posting Date
19	FI_POST_PERIOD	TRLT_TRANSACTION	FI_POST_PERIOD		☐	TPM_FI_POSTING_PERIOD	☐	Different FI Posting Period
20	FI_REV_DATE	TRLT_TRANSACTION	FI_REV_DATE		☐	TPM_FI_REVERSAL_DATE	☐	Different FI Reversal Date
21	FI_REV_PERIOD	TRLT_TRANSACTION	FI_REV_PERIOD		☐	TPM_FI_REVERSAL_PERIOD	☐	Alternative FI Reversal Period
22	DIS_FLOWTYPE	TRILT_DFLOW	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
23	TRIL_FLOW_CAT	TRILT_DFLOW	TRIL_FLOW_CAT		☐	TPM_TRIL_FLOW_CAT	☐	Flow Category in Income Ledger
24	HEDGE_ID	TRILT_DFLOW	HEDGE_ID		☐	TPM_HEDGE_ID	☐	Identification for Hedging Relationship
25	POSITION_CURR	TRILT_DFLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
26	POSITION_AMT	TRILT_DFLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
27	VALUATION_CURR	TRILT_DFLOW	VALUATION_CURR		☐	TPM_VALUATION_CURR	☐	Valuation Currency
28	VALUATION_AMT	TRILT_DFLOW	VALUATION_AMT		☐	TPM_VALUATION_AMT	☐	Amount in Valuation Currency

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	20060711
SAP Release Created in