SAP ABAP View TRATV_TRANSFLOW (View of Acct Assnmnt Transfers via BusTrans and Flows)

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_TRANSFLOW
Short Description	View of Acct Assnmnt Transfers via BusTrans and Flows
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	TRATT_FLOW
3	TRGT_USER_DATA
4	TRACT_POSCONTEXT
5	DIFT_POS_IDENT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TRATT_TRANS	MANDT	JL	EQ				0	0
2	TRATT_FLOW	MANDT	JR	EQ			AND	0	0
3	TRATT_TRANS	OS_GUID	JL	EQ				0	0
4	TRATT_FLOW	TRANSACTION_ID	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	TRACT_POSCONTEXT	MANDT	JL	EQ				0	0
10	TRATT_TRANS	MANDT	JR	EQ			AND	0	0
11	TRACT_POSCONTEXT	OS_GUID	JL	EQ				0	0
12	TRATT_TRANS	POS_CONTEXT_OID	JR	EQ			AND	0	0
13	DIFT_POS_IDENT	MANDT	JL	EQ				0	0
14	TRACT_POSCONTEXT	MANDT	JR	EQ			AND	0	0
15	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
16	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	TRANSACTION_ID	TRATT_FLOW	TRANSACTION_ID		☐	OS_GUID	☐	Globally Unique Identifier
4	OS_GUID_UD	TRGT_USER_DATA	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	OS_GUID_PC	TRACT_POSCONTEXT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
6	OS_GUID_PI	DIFT_POS_IDENT	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
7	FLOW_NUMBER	TRATT_FLOW	FLOW_NUMBER		☐	TPM_TRATFLOWNR	☐	Flow Number for Account Assigment Reference Transfers
8	POSTING_DATE	TRATT_TRANS	POSTING_DATE		☐	BUDAT	☐	Posting Date in the Document
9	OLD_AA_REF	TRATT_TRANS	OLD_AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
10	NEW_AA_REF	TRATT_TRANS	NEW_AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
11	TRANS_STATE	TRATT_TRANS	TRANS_STATE		☐	TPM_BUSTRANS_STATE	☐	Status of Distributor Business Transaction
12	BUSTRANSID	TRATT_TRANS	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
13	DIS_FLOWTYPE	TRATT_FLOW	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
14	IN_OUT_FLAG	TRATT_FLOW	IN_OUT_FLAG		☐	TPM_AAR_TRANSFER_IN_OUT_FLAG	☐	Posting/Clearing Flag
15	ACCOUNT_SYMBOL	TRATT_FLOW	ACCOUNT_SYMBOL		☐	TPM_ACC_SYMBOL	☐	Account Symbol for Account Assignment Reference
16	FOREIGN_AMT	TRATT_FLOW	FOREIGN_AMT		☐	TPM_FOREIGN_AMT	☐	Amount in Transaction Currency
17	FOREIGN_CURR	TRATT_FLOW	FOREIGN_CURR		☐	TPM_FOREIGN_CURR	☐	Transaction Currency
18	LOCAL_AMT	TRATT_FLOW	LOCAL_AMT		☐	TPM_LOCAL_AMT	☐	Amount in Local Currency
19	LOCAL_CURR	TRATT_FLOW	LOCAL_CURR		☐	TPM_LOCAL_CURR	☐	Local Currency
20	CREATE_NAME	TRGT_USER_DATA	CREATE_NAME		☐	RERF	☐	Entered by
21	CREATE_DATE	TRGT_USER_DATA	CREATE_DATE		☐	DERF	☐	First Entered on
22	CREATE_TIME	TRGT_USER_DATA	CREATE_TIME		☐	TERF	☐	Time of Initial Entry
23	CREATE_TCODE	TRGT_USER_DATA	CREATE_TCODE		☐	TCODE	☐	Transaction Code
24	CHANGE_NAME	TRGT_USER_DATA	CHANGE_NAME		☐	RBEAR	☐	Employee ID
25	CHANGE_DATE	TRGT_USER_DATA	CHANGE_DATE		☐	DBEAR	☐	Last Edited on
26	CHANGE_TIME	TRGT_USER_DATA	CHANGE_TIME		☐	TBEAR	☐	Last Edited at
27	CHANGE_TCODE	TRGT_USER_DATA	CHANGE_TCODE		☐	TCODE	☐	Transaction Code
28	CONTXTSTATE	TRACT_POSCONTEXT	CONTXTSTATE		☐	TPM_POS_CNTXT_STATE	☐	Obsolete: Status of Position Context
29	AA_REF	TRACT_POSCONTEXT	AA_REF		☐	TPM_AA_REF	☐	Account Assignment Reference of Position Management
30	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
31	VALUATION_CLASS	DIFT_POS_IDENT	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
32	ACCOUNTING_CODE	DIFT_POS_IDENT	ACCOUNTING_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
33	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
34	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
35	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
36	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
37	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
38	ACCOUNT_GROUP	DIFT_POS_IDENT	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
39	LOANS_CONTRACT	DIFT_POS_IDENT	LOANS_CONTRACT		☐	RANL	☐	Contract Number
40	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
41	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
42	LOT_ID	DIFT_POS_IDENT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
43	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