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

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_ACEPSOI
Short Description	Join ACEOBJ + ACEPSOI + ACEPSOH
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	ACEPSOI	MANDT	JR	EQ			AND	0	0
3	ACEOBJ	COMP	JL	EQ				0	0
4	ACEPSOI	COMP	JR	EQ			AND	0	0
5	ACEOBJ	BUKRS	JL	EQ				0	0
6	ACEPSOI	BUKRS	JR	EQ			AND	0	0
7	ACEOBJ	OBJID	JL	EQ				0	0
8	ACEPSOI	OBJID	JR	EQ			AND	0	0
9	ACEOBJ	MANDT	JL	EQ				0	0
10	ACEPSOH	MANDT	JR	EQ			AND	0	0
11	ACEOBJ	COMP	JL	EQ				0	0
12	ACEPSOH	COMP	JR	EQ			AND	0	0
13	ACEOBJ	BUKRS	JL	EQ				0	0
14	ACEPSOH	BUKRS	JR	EQ			AND	0	0
15	ACEOBJ	OBJID	JL	EQ				0	0
16	ACEPSOH	OBJID	JR	EQ			AND	0	0
17	ACEPSOH	SUBID	JL	EQ				0	0
18	ACEPSOI	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	REF_KEY	ACEOBJ	REF_KEY		☐	ACE_REF_KEY	☐	Unique External Reference for Accrual Object
5	REF_SUBKEY	ACEPSOH	REF_SUBKEY		☐	ACE_REF_SUBKEY	☐	Unique Reference for an Accrual Subobject
6	GJAHR	ACEPSOI	GJAHR		☐	ACEPS_GJAHR	☐	Fiscal Year in Accrual Engine
7	ACRTYPE	ACEPSOI	ACRTYPE		☐	ACE_ACRTYPE	☐	Accrual Type
8	ACCRULE	ACEPSOI	ACCRULE		☐	ACCOUNTING_PRINCIPLE	☐	Accounting Principle
9	*	ACEPSOI	*		☐		☐
10	-	ACEPSOI	MANDT		☐	MANDT	☐	Client
11	-	ACEPSOI	COMP		☐	ACE_COMP	☐	Accrual Engine Application Component
12	-	ACEPSOI	BUKRS		☐	ACE_BUKRS	☐	Company Code
13	-	ACEPSOI	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)
14	-	ACEPSOI	SUBID		☐	ACE_SUBID	☐	Accrual Subobject (Internal Display, Sequence Number)
15	CUMVALCAP	ACEPSOI	CUMVALCAP		☐	ACE_CUM_AMOUNT_CAPITALIZED	☐	Cumulative Asset Balance Sheet Value Posted in Previous Yrs
16	CUMVALACCR	ACEPSOI	CUMVALACCR		☐	ACE_CUM_AMOUNT_ACCRUED	☐	Cumulative Recognition Posted in Previous Years
17	VALCAP	ACEPSOI	VALCAP		☐	ACE_AMOUNT_CAPITALIZED	☐	Posted Asset Balance Sheet Value (by Year)
18	VALACCR	ACEPSOI	VALACCR		☐	ACE_AMOUNT_ACCRUED	☐	Recognition Postings Made (Year-Based)
19	VALRETIRE	ACEPSOI	VALRETIRE		☐	ACE_AMOUNT_RETIRED	☐	Posted Retirement Amount
20	LASTEFFDATE	ACEPSOI	LASTEFFDATE		☐	ACE_LASTEFFDATE	☐	Last Periodic Posting
21	CURRENCY	ACEPSOI	CURRENCY		☐	ACEDS_VALCURRENCY	☐	Currency Calculated/Posted in the Accrual Amounts
22	*	ACEPSOH	*		☐		☐
23	-	ACEPSOH	MANDT		☐	MANDT	☐	Client
24	-	ACEPSOH	COMP		☐	ACE_COMP	☐	Accrual Engine Application Component
25	-	ACEPSOH	BUKRS		☐	ACE_BUKRS	☐	Company Code
26	-	ACEPSOH	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)
27	SUBID	ACEPSOH	SUBID		☐	ACE_SUBID	☐	Accrual Subobject (Internal Display, Sequence Number)
28	UNAME	ACEPSOH	UNAME		☐	ACE_UNAME	☐	User Name
29	CPUDT	ACEPSOH	CPUDT		☐	ACE_CREATEDATE	☐	Date on which the accrual subobject was added/changed
30	CPUTM	ACEPSOH	CPUTM		☐	ACE_CREATETIME	☐	Time at which the accrual subobject was added/changed
31	DEACTDATE	ACEPSOH	DEACTDATE		☐	ACE_DEACTDATE	☐	Deactivation Date
32	STATUS	ACEPSOH	STATUS		☐	ACEPS_HEADER_STATUS	☐	Processing Status of Posting Data of an Accrual Subobject
33	FIRSTYEAR	ACEPSOH	FIRSTYEAR		☐	ACE_FIRSTYEAR	☐	First Fiscal Year
34	LASTYEAR	ACEPSOH	LASTYEAR		☐	ACE_LASTYEAR	☐	Last Fiscal Year
35	*	ACEOBJ	*		☐		☐
36	OBJID	ACEOBJ	OBJID		☐	ACE_GUID	☐	Accrual Object (Internal Display in Form of a GUID)
37	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	46C