SAP ABAP View TRATV_TRANS (View of Account Assignment Reference Transfers via BusTrans)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_AA_REF_TRANSFER (Package) CFM TM: Acccount Assignment Reference - Transfer

Basic Data

View Type	D	Database View
Database View	TRATV_TRANS
Short Description	View of Account Assignment Reference Transfers via BusTrans
Root table	TRATT_TRANS	Account Assignment Reference Transfer Business Transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TRATT_TRANS	TRATT_TRANS
2	TRACT_POSCONTEXT
3	TRGT_USER_DATA
4	DIFT_POS_IDENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRACT_POSCONTEXT	MANDT	JL	EQ				0	0
2	TRATT_TRANS	MANDT	JR	EQ			AND	0	0
3	TRACT_POSCONTEXT	OS_GUID	JL	EQ				0	0
4	TRATT_TRANS	POS_CONTEXT_OID	JR	EQ			AND	0	0
5	TRGT_USER_DATA	MANDT	JL	EQ				0	0
6	TRATT_TRANS	MANDT	JR	EQ			AND	0	0
7	TRGT_USER_DATA	OS_GUID	JL	EQ				0	0
8	TRATT_TRANS	USER_DATA_OID	JR	EQ			AND	0	0
9	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
10	TRACT_POSCONTEXT	MANDT	JR	EQ			AND	0	0
11	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
12	TRACT_POSCONTEXT	POS_IDENTIF_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TRATT_TRANS	MANDT		☐	MANDT	☐	Client
2	OS_GUID_TRANS	TRATT_TRANS	OS_GUID		☐	OS_GUID	☐	Globally Unique Identifier
3	OS_GUID_PC	TRACT_POSCONTEXT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
4	OS_GUID_UD	TRGT_USER_DATA	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	OS_GUID_PI	DIFT_POS_IDENT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
6	POSTING_DATE	TRATT_TRANS	POSTING_DATE		☐	BUDAT	☐	Posting Date in the Document
7	OLD_AA_REF	TRATT_TRANS	OLD_AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
8	NEW_AA_REF	TRATT_TRANS	NEW_AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
9	TRANS_STATE	TRATT_TRANS	TRANS_STATE		☐	TPM_BUSTRANS_STATE	☐	Status of Distributor Business Transaction
10	BUSTRANSID	TRATT_TRANS	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
11	CONTXTSTATE	TRACT_POSCONTEXT	CONTXTSTATE		☐	TPM_POS_CNTXT_STATE	☐	Obsolete: Status of Position Context
12	AA_REF	TRACT_POSCONTEXT	AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
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	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
22	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
23	VALUATION_CLASS	DIFT_POS_IDENT	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
24	ACCOUNTING_CODE	DIFT_POS_IDENT	ACCOUNTING_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
25	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
26	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
27	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
28	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
29	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
30	TRADER	DIFT_POS_IDENT	TRADER		☐	RDEALER	☐	Trader
31	ACCOUNT_GROUP	DIFT_POS_IDENT	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
32	LOANS_CONTRACT	DIFT_POS_IDENT	LOANS_CONTRACT		☐	RANL	☐	Contract Number
33	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
34	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
35	LOT_ID	DIFT_POS_IDENT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
36	DEAL_NUMBER	DIFT_POS_IDENT	DEAL_NUMBER		☐	TB_RFHA	☐	Financial Transaction

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