SAP ABAP View V_ACEDSOI2 (Join of ACEOBJ + ACEPSOH + ACEDSOI)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-GL-GL-ACE (Application Component) Accrual Engine
     ⤷ ACE-DS (Package) Accrual Engine: Distribution Server Basis

Basic Data

View Type	D	Database View
Database View	V_ACEDSOI2
Short Description	Join of ACEOBJ + ACEPSOH + ACEDSOI
Root table	ACEOBJ	Accrual Objects

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ACEOBJ	ACEOBJ
2	ACEPSOH
3	ACEDSOI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ACEOBJ	MANDT	JL	EQ				0	0
2	ACEPSOH	MANDT	JR	EQ			AND	0	0
3	ACEOBJ	COMP	JL	EQ				0	0
4	ACEPSOH	COMP	JR	EQ			AND	0	0
5	ACEOBJ	BUKRS	JL	EQ				0	0
6	ACEPSOH	BUKRS	JR	EQ			AND	0	0
7	ACEOBJ	OBJID	JL	EQ				0	0
8	ACEPSOH	OBJID	JR	EQ			AND	0	0
9	ACEPSOH	MANDT	JL	EQ				0	0
10	ACEDSOI	MANDT	JR	EQ			AND	0	0
11	ACEPSOH	COMP	JL	EQ				0	0
12	ACEDSOI	COMP	JR	EQ			AND	0	0
13	ACEPSOH	BUKRS	JL	EQ				0	0
14	ACEDSOI	BUKRS	JR	EQ			AND	0	0
15	ACEPSOH	OBJID	JL	EQ				0	0
16	ACEDSOI	OBJID	JR	EQ			AND	0	0
17	ACEPSOH	SUBID	JL	EQ				0	0
18	ACEDSOI	SUBID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ACEOBJ	MANDT		☐	MANDT	☐	Client
2	COMP	ACEOBJ	COMP		☐	ACE_COMP	☐	Accrual Engine Application Component
3	BUKRS	ACEOBJ	BUKRS		☐	ACE_BUKRS	☐	Company Code
4	OBJID	ACEOBJ	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)
5	REF_KEY	ACEOBJ	REF_KEY		☐	ACE_REF_KEY	☐	Unique External Reference for Accrual Object
6	REF_SUBKEY	ACEPSOH	REF_SUBKEY		☐	ACE_REF_SUBKEY	☐	Unique Reference for an Accrual Subobject
7	OBJSTATUS	ACEOBJ	OBJSTATUS		☐	ACE_OBJECT_STATUS	☐	Processing Status of an Accrual Object
8	*	ACEDSOI	*		☐		☐
9	-	ACEDSOI	MANDT		☐	MANDT	☐	Client
10	-	ACEDSOI	COMP		☐	ACE_COMP	☐	Accrual Engine Application Component
11	-	ACEDSOI	BUKRS		☐	ACE_BUKRS	☐	Company Code
12	-	ACEDSOI	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)
13	SUBID	ACEDSOI	SUBID		☐	ACE_SUBID	☐	Accrual Subobject (Internal Display, Sequence Number)
14	ACRTYPE	ACEDSOI	ACRTYPE		☐	ACE_ACRTYPE	☐	Accrual Type
15	ACCRULE	ACEDSOI	ACCRULE		☐	ACCOUNTING_PRINCIPLE	☐	Accounting Principle
16	DATE_TO	ACEDSOI	DATE_TO		☐	ACE_DATETO	☐	To Date of Accrual Item
17	DATE_FROM	ACEDSOI	DATE_FROM		☐	ACE_DATEFROM	☐	From Date of an Entry
18	TIMESTMP	ACEDSOI	TIMESTMP		☐	ACE_HZSTMP	☐	Time Added (Greenwich Meantime)
19	AMOUNT	ACEDSOI	AMOUNT		☐	ACE_TOTAL_AMOUNT	☐	Total Amount To Be Accrued
20	CURRENCY	ACEDSOI	CURRENCY		☐	ACE_DS_CURRENCY	☐	Currency of Accrual Item
21	QUANTITY	ACEDSOI	QUANTITY		☐	ACE_TOTAL_QUANTITY	☐	Total Quantity To Be Accrued
22	UNIT	ACEDSOI	UNIT		☐	ACE_UNIT	☐	Unit of Measure for Accrual Items
23	ACRMETHOD	ACEDSOI	ACRMETHOD		☐	ACEDS_ACRMETHOD	☐	Accrual/Deferral Method
24	SVALITY_FROM	ACEDSOI	SVALITY_FROM		☐	ACE_SVALDATE_FROM	☐	Runtime Start of Accrual Type
25	SVALITY_TO	ACEDSOI	SVALITY_TO		☐	ACE_SVALDATE_TO	☐	Runtime End of Accrual Type
26	-	ACEPSOH	BUKRS		☐	ACE_BUKRS	☐	Company Code
27	-	ACEPSOH	COMP		☐	ACE_COMP	☐	Accrual Engine Application Component
28	-	ACEPSOH	MANDT		☐	MANDT	☐	Client
29	-	ACEPSOH	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)

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	500