SAP ABAP View TRLV_TRANS_POS (TRL: Positions, Transactions, Flows)

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_TRANS_POS
Short Description	TRL: Positions, Transactions, Flows
Root table	DIFT_POS_IDENT	Persistent Flow Selectors

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DIFT_POS_IDENT	DIFT_POS_IDENT
2	TRLT_POSITION
3	TRLT_FLOW
4	TRLT_TRANSACTION

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
2	TRLT_POSITION	MANDT	JR	EQ			AND	0	0
3	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
4	TRLT_POSITION	IDENTIFIER_OID	JR	EQ			AND	0	0
5	TRLT_POSITION	MANDT	JL	EQ				0	0
6	TRLT_FLOW	MANDT	JR	EQ			AND	0	0
7	TRLT_POSITION	OS_GUID	JL	EQ				0	0
8	TRLT_FLOW	POSITION_OID	JR	EQ			AND	0	0
9	TRLT_TRANSACTION	MANDT	JL	EQ				0	0
10	TRLT_FLOW	MANDT	JR	EQ			AND	0	0
11	TRLT_TRANSACTION	OS_GUID	JL	EQ				0	0
12	TRLT_FLOW	TRANSACTION_OID	JR	EQ			AND	0	0
13	DIFT_POS_IDENT	CONTEXT		EQ	'TRL'			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	CREATE_DATE	TRLT_TRANSACTION	CREATE_DATE		☐	TPM_BT_CREATE_DATE	☐	Creation Date of the Operative Business Transaction
7	CREATE_TIME	TRLT_TRANSACTION	CREATE_TIME		☐	TPM_BT_CREATE_TIME	☐	Creation Time of the Operative Business Transaction
8	BUSTRANSSTATE	TRLT_TRANSACTION	BUSTRANSSTATE		☐	TPM_TRLTRANSTATE	☐	Status of Treasury Ledger Business Transaction
9	BOOKING_STATE	TRLT_TRANSACTION	BOOKING_STATE		☐	TPM_TRL_BOOKINGSTATE	☐	Posting Status Treasury Ledger Business Transaction
10	REFBUSTRANSID	TRLT_TRANSACTION	REFBUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
11	FI_POST_DATE	TRLT_TRANSACTION	FI_POST_DATE		☐	TPM_FI_POSTING_DATE	☐	Different FI Posting Date
12	FI_POST_PERIOD	TRLT_TRANSACTION	FI_POST_PERIOD		☐	TPM_FI_POSTING_PERIOD	☐	Different FI Posting Period
13	USER_DATA_OID	TRLT_TRANSACTION	USER_DATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
14	USER_DATA_CLS	TRLT_TRANSACTION	USER_DATA_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	TRLFLOWNUMBER	TRLT_FLOW	TRLFLOWNUMBER		☐	TPM_TRLFLOWNR	☐	Number of TRL Flow
16	FLOWNUMBER	TRLT_FLOW	FLOWNUMBER		☐	TPM_TRDFLOWNR	☐	Number of a Distributor Flow
17	SOURCETARGET_FLG	TRLT_FLOW	SOURCETARGET_FLG		☐	TPM_SOURCE_TARGET_FLG	☐	Indicator: Source or Target of a Flow
18	TRANSFER_GROUP	TRLT_FLOW	TRANSFER_GROUP		☐	TPM_TRANSFER_GROUP	☐	Group of Flows from a Source or Target
19	FLOWTYPE	TRLT_FLOW	FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
20	AMOUNT_FACTOR	TRLT_FLOW	AMOUNT_FACTOR		☐	TPM_AMOUNT_FACTOR	☐	Value Coefficient
21	QUANT_CAT	TRLT_FLOW	QUANT_CAT		☐	TPM_QTY_PM_CAT	☐	Position Change Category: Quantity
22	AMOUNT_CAT	TRLT_FLOW	AMOUNT_CAT		☐	TPM_AMT_PM_CAT	☐	Position Change Category
23	UNITS	TRLT_FLOW	UNITS		☐	TPM_UNITS	☐	Units
24	NOMINAL_AMT	TRLT_FLOW	NOMINAL_AMT		☐	TPM_NOMINAL_AMT	☐	Nominal Amount
25	NOMINAL_CURR	TRLT_FLOW	NOMINAL_CURR		☐	TPM_NOMINAL_CURR	☐	Nominal Currency
26	POSAMT_IDX_CLEAN	TRLT_FLOW	POSAMT_IDX_CLEAN		☐	TPM_POSITION_AMT_IDX_CLEAN	☐	Amount in Position Currency Index-Clean
27	POSITION_AMT	TRLT_FLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
28	POSITION_CURR	TRLT_FLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
29	VALUATION_AMT	TRLT_FLOW	VALUATION_AMT		☐	TPM_VALUATION_AMT	☐	Amount in Valuation Currency
30	VALUATION_CURR	TRLT_FLOW	VALUATION_CURR		☐	TPM_VALUATION_CURR	☐	Valuation Currency
31	POS_MAN_PROC	TRLT_POSITION	POS_MAN_PROC		☐	TPM_POS_MAN_PROC	☐	Position Management Procedure
32	ACTIVE_PASSIVE	TRLT_POSITION	ACTIVE_PASSIVE		☐	TPM_ACTIVE_PASSIVE	☐	Indicator: Assets/Liabilities Position
33	SBILK	TRLT_POSITION	SBILK		☐	SBILK	☐	Balance Sheet Indicator
34	SKWG14NEU	TRLT_POSITION	SKWG14NEU		☐	VVSKWG14	☐	Position grouping acc. Para 14 GBA (Sec. and loans)
35	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
36	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
37	VALUATION_CLASS	DIFT_POS_IDENT	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
38	ACCOUNTING_CODE	DIFT_POS_IDENT	ACCOUNTING_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
39	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
40	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
41	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
42	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
43	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
44	TRADER	DIFT_POS_IDENT	TRADER		☐	RDEALER	☐	Trader
45	ACCOUNT_GROUP	DIFT_POS_IDENT	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
46	LOANS_CONTRACT	DIFT_POS_IDENT	LOANS_CONTRACT		☐	RANL	☐	Contract Number
47	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
48	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
49	LOT_ID	DIFT_POS_IDENT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
50	DEAL_NUMBER	DIFT_POS_IDENT	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction
51	NOMINAL_ORG_AMT	TRLT_FLOW	NOMINAL_ORG_AMT		☐	TPM_NOMINAL_ORG_AMT	☐	Original Nominal Amount in Position Currency
52	CALCULATION_DATE	TRLT_FLOW	CALCULATION_DATE		☐	DVALUT	☐	Calculation Date
53	CALC_DATE_INCL	TRLT_FLOW	CALC_DATE_INCL		☐	VVSINCL	☐	Inclusive indicator for beginning and end of a period
54	DUE_DATE	TRLT_FLOW	DUE_DATE		☐	TPM_DUE_DATE	☐	Due Date
55	CALC_BEGIN	TRLT_FLOW	CALC_BEGIN		☐	DBERVON	☐	Start of Calculation Period
56	CALC_END	TRLT_FLOW	CALC_END		☐	DBERBIS	☐	End of Calculation Period
57	EFF_INT_RATE_U	TRLT_FLOW	EFF_INT_RATE_U		☐	TPM_TRL_EFF_INT_RATE_USED	☐	For Calculation of Amortization Amts (SAC) for Used EffInR
58	EFF_INT_RATE_N	TRLT_FLOW	EFF_INT_RATE_N		☐	TPM_TRL_EFF_INT_RATE_NEW	☐	Valid Effective Interest Rate for the Next Amortization
59	IDENTIFIER_OID	TRLT_POSITION	IDENTIFIER_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format

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