SAP ABAP View ADJV_TRANS_DIF (Reconciliation Business Trans.for Differentiation Values)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_ADJUSTMENT (Package) Treasury: Reconciliation Business Transactions

Basic Data

View Type	D	Database View
Database View	ADJV_TRANS_DIF
Short Description	Reconciliation Business Trans.for Differentiation Values
Root table	ADJT_TRANSACTION	Treasury: Reconciliation business transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ADJT_TRANSACTION	ADJT_TRANSACTION
2	DIFT_POS_IDENT

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	ADJT_TRANSACTION	MANDT	JR	EQ			AND	0	0
3	DIFT_POS_IDENT	OS_GUID	JL	EQ				0	0
4	ADJT_TRANSACTION	IDENTIFIER_OID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ADJT_TRANSACTION	MANDT		☐	MANDT	☐	Client
2	OS_GUID	ADJT_TRANSACTION	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	USER_DATA_CLS	ADJT_TRANSACTION	USER_DATA_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
4	USER_DATA_OID	ADJT_TRANSACTION	USER_DATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
5	IDENTIFIER_CLS	ADJT_TRANSACTION	IDENTIFIER_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
6	IDENTIFIER_OID	ADJT_TRANSACTION	IDENTIFIER_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
7	ADJUSTMENT_CAT	ADJT_TRANSACTION	ADJUSTMENT_CAT		☐	TPM_ADJUSTMENT_CAT	☐	Treasury: Reconciliation Category
8	BUSTRANSID	ADJT_TRANSACTION	BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
9	POSTING_STATE	ADJT_TRANSACTION	POSTING_STATE		☐	TPM_ADJTRANSTATE	☐	Update Status of a Reconciliation Business Transaction
10	ADJUSTMENT_DATE	ADJT_TRANSACTION	ADJUSTMENT_DATE		☐	TPM_ADJUSTMENT_DATE	☐	Reconciliation Key Date
11	DIST_FLOWTYPE	ADJT_TRANSACTION	DIST_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
12	CONTEXT	DIFT_POS_IDENT	CONTEXT		☐	DIF_IDENT_CONTEXT	☐	Context for Identifier
13	IDENTIFIED_OID	DIFT_POS_IDENT	IDENTIFIED_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
14	IDENTIFIED_CLS	DIFT_POS_IDENT	IDENTIFIED_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	VALUATION_AREA	DIFT_POS_IDENT	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
16	COM_VAL_CLASS	DIFT_POS_IDENT	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
17	VALUATION_CLASS	DIFT_POS_IDENT	VALUATION_CLASS		☐	TPM_VAL_CLASS	☐	Valuation Class
18	ACCOUNTING_CODE	DIFT_POS_IDENT	ACCOUNTING_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
19	COMPANY_CODE	DIFT_POS_IDENT	COMPANY_CODE		☐	BUKRS	☐	Company Code
20	PRODUCT_TYPE	DIFT_POS_IDENT	PRODUCT_TYPE		☐	VVSART	☐	Product Type
21	SECURITY_ACCOUNT	DIFT_POS_IDENT	SECURITY_ACCOUNT		☐	RLDEPO	☐	Securities Account
22	SECURITY_ID	DIFT_POS_IDENT	SECURITY_ID		☐	VVRANLW	☐	Security ID Number
23	PORTFOLIO	DIFT_POS_IDENT	PORTFOLIO		☐	TPM_PORTFOLIO_DIFF	☐	Portfolio as Differentiation Characteristic
24	TRADER	DIFT_POS_IDENT	TRADER		☐	RDEALER	☐	Trader
25	ACCOUNT_GROUP	DIFT_POS_IDENT	ACCOUNT_GROUP		☐	TPM_SEC_ACCT_GRP	☐	Securities Account Group
26	LOANS_CONTRACT	DIFT_POS_IDENT	LOANS_CONTRACT		☐	RANL	☐	Contract Number
27	POSITION_ACCOUNT	DIFT_POS_IDENT	POSITION_ACCOUNT		☐	TPM_POS_ACCOUNT_FUT	☐	Futures Account for Listed Options and Futures
28	FLAG_LONG_SHORT	DIFT_POS_IDENT	FLAG_LONG_SHORT		☐	TPM_FLAG_LONG_SHORT	☐	Indicator: Long or Short Position
29	LOT_ID	DIFT_POS_IDENT	LOT_ID		☐	TPM_LOT_ID	☐	Identifier of the Lot
30	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	462_10