SAP ABAP View TRLV_TRANS2 (View of TR Ledger Business Transactions and User)

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_TRANS2
Short Description	View of TR Ledger Business Transactions and User
Root table	TRGT_USER_DATA	TR Position Management - User Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRGT_USER_DATA	TRGT_USER_DATA
2	TRLT_TRANSACTION

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRLT_TRANSACTION	MANDT		☐	MANDT	☐	Client
2	OS_GUID	TRLT_TRANSACTION	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	BUSTRANSCAT	TRLT_TRANSACTION	BUSTRANSCAT		☐	TPM_BUSTRANSCAT	☐	Business Transaction Category
4	TRLDATE	TRLT_TRANSACTION	TRLDATE		☐	TPM_TRLDATE	☐	Treasury Ledger Date
5	BUSTRANSID	TRLT_TRANSACTION	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
6	BUSTRANSSTATE	TRLT_TRANSACTION	BUSTRANSSTATE		☐	TPM_TRLTRANSTATE	☐	Status of Treasury Ledger Business Transaction
7	BOOKING_STATE	TRLT_TRANSACTION	BOOKING_STATE		☐	TPM_TRL_BOOKINGSTATE	☐	Posting Status Treasury Ledger Business Transaction
8	VALUATION_AREA	TRLT_TRANSACTION	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
9	TR_ACC_CODE	TRLT_TRANSACTION	TR_ACC_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
10	REFBUSTRANSID	TRLT_TRANSACTION	REFBUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
11	USER_DATA_OID	TRLT_TRANSACTION	USER_DATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
12	USER_DATA_CLS	TRLT_TRANSACTION	USER_DATA_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
13	CREATE_NAME	TRGT_USER_DATA	CREATE_NAME		☐	RERF	☐	Entered by
14	CREATE_DATE	TRGT_USER_DATA	CREATE_DATE		☐	DERF	☐	First Entered on
15	CREATE_TIME	TRGT_USER_DATA	CREATE_TIME		☐	TERF	☐	Time of Initial Entry
16	CREATE_TCODE	TRGT_USER_DATA	CREATE_TCODE		☐	TCODE	☐	Transaction Code
17	CHANGE_NAME	TRGT_USER_DATA	CHANGE_NAME		☐	RBEAR	☐	Employee ID
18	CHANGE_DATE	TRGT_USER_DATA	CHANGE_DATE		☐	DBEAR	☐	Last Edited on
19	CHANGE_TIME	TRGT_USER_DATA	CHANGE_TIME		☐	TBEAR	☐	Last Edited at
20	CHANGE_TCODE	TRGT_USER_DATA	CHANGE_TCODE		☐	TCODE	☐	Transaction Code
21	PRODUCT_GROUP	TRLT_TRANSACTION	PRODUCT_GROUP		☐	TPM_PRODUCT_GROUP	☐	Product Group
22	FI_POST_DATE	TRLT_TRANSACTION	FI_POST_DATE		☐	TPM_FI_POSTING_DATE	☐	Different FI Posting Date
23	FI_POST_PERIOD	TRLT_TRANSACTION	FI_POST_PERIOD		☐	TPM_FI_POSTING_PERIOD	☐	Different FI Posting Period
24	FI_REV_DATE	TRLT_TRANSACTION	FI_REV_DATE		☐	TPM_FI_REVERSAL_DATE	☐	Different FI Reversal Date
25	FI_REV_PERIOD	TRLT_TRANSACTION	FI_REV_PERIOD		☐	TPM_FI_REVERSAL_PERIOD	☐	Alternative FI Reversal Period
26	MIGR_INIT_FLG	TRLT_TRANSACTION	MIGR_INIT_FLG		☐	TPM_FLG_MIGR_INIT	☐	Bus. Transaction Originated from Migration/Initialization

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	20031111
SAP Release Created in	462_10