SAP ABAP View V_ACEPSOI2 (Join ACEOBJ + ACEPSOH + ACEPSOI)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_ACEPSOI2
Short Description	Join ACEOBJ + ACEPSOH + ACEPSOI
Root table	ACEOBJ	Accrual Objects

Table

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

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	ACEPSOI	MANDT	JL	EQ				0	0
10	ACEPSOH	MANDT	JR	EQ			AND	0	0
11	ACEPSOI	COMP	JL	EQ				0	0
12	ACEPSOH	COMP	JR	EQ			AND	0	0
13	ACEPSOI	BUKRS	JL	EQ				0	0
14	ACEPSOH	BUKRS	JR	EQ			AND	0	0
15	ACEPSOI	OBJID	JL	EQ				0	0
16	ACEPSOH	OBJID	JR	EQ			AND	0	0
17	ACEPSOI	SUBID	JL	EQ				0	0
18	ACEPSOH	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	*	ACEPSOI	*		☐		☐
6	-	ACEPSOI	MANDT		☐	MANDT	☐	Client
7	-	ACEPSOI	COMP		☐	ACE_COMP	☐	Accrual Engine Application Component
8	-	ACEPSOI	BUKRS		☐	ACE_BUKRS	☐	Company Code
9	GJAHR	ACEPSOI	GJAHR		☐	ACEPS_GJAHR	☐	Fiscal Year in Accrual Engine
10	-	ACEPSOI	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)
11	SUBID	ACEPSOI	SUBID		☐	ACE_SUBID	☐	Accrual Subobject (Internal Display, Sequence Number)
12	ACRTYPE	ACEPSOI	ACRTYPE		☐	ACE_ACRTYPE	☐	Accrual Type
13	ACCRULE	ACEPSOI	ACCRULE		☐	ACCOUNTING_PRINCIPLE	☐	Accounting Principle
14	CUMVALCAP	ACEPSOI	CUMVALCAP		☐	ACE_CUM_AMOUNT_CAPITALIZED	☐	Cumulative Asset Balance Sheet Value Posted in Previous Yrs
15	CUMVALACCR	ACEPSOI	CUMVALACCR		☐	ACE_CUM_AMOUNT_ACCRUED	☐	Cumulative Recognition Posted in Previous Years
16	VALCAP	ACEPSOI	VALCAP		☐	ACE_AMOUNT_CAPITALIZED	☐	Posted Asset Balance Sheet Value (by Year)
17	VALACCR	ACEPSOI	VALACCR		☐	ACE_AMOUNT_ACCRUED	☐	Recognition Postings Made (Year-Based)
18	VALRETIRE	ACEPSOI	VALRETIRE		☐	ACE_AMOUNT_RETIRED	☐	Posted Retirement Amount
19	LASTEFFDATE	ACEPSOI	LASTEFFDATE		☐	ACE_LASTEFFDATE	☐	Last Periodic Posting
20	CURRENCY	ACEPSOI	CURRENCY		☐	ACEDS_VALCURRENCY	☐	Currency Calculated/Posted in the Accrual Amounts
21	REF_KEY	ACEOBJ	REF_KEY		☐	ACE_REF_KEY	☐	Unique External Reference for Accrual Object
22	REF_SUBKEY	ACEPSOH	REF_SUBKEY		☐	ACE_REF_SUBKEY	☐	Unique Reference for an Accrual Subobject
23	OBJSTATUS	ACEOBJ	OBJSTATUS		☐	ACE_OBJECT_STATUS	☐	Processing Status of an Accrual Object

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	20110901
SAP Release Created in	500