SAP ABAP View V_ACEPSOIT (Join ACEOBJ + ACEPSOH + ACEPSOIT)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ FI-GL-GL-ACE (Application Component) Accrual Engine
⤷ ACE-PS (Package) Accrual Engine: Posting Server Basis
⤷ 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_ACEPSOIT | |
Short Description | Join ACEOBJ + ACEPSOH + ACEPSOIT | |
Root table | ACEOBJ | Accrual Objects |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ACEOBJ | ACEOBJ | ||
2 | ACEPSOIT | |||
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 | ACEPSOIT | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ACEOBJ | COMP | JL | EQ | 0 | 0 | ||||
4 | ACEPSOIT | COMP | JR | EQ | AND | 0 | 0 | |||
5 | ACEOBJ | BUKRS | JL | EQ | 0 | 0 | ||||
6 | ACEPSOIT | BUKRS | JR | EQ | AND | 0 | 0 | |||
7 | ACEOBJ | OBJID | JL | EQ | 0 | 0 | ||||
8 | ACEPSOIT | 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 | ACEPSOIT | 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 | * | ACEPSOIT | * | |||||
5 | - | ACEPSOIT | MANDT | MANDT | Client | |||
6 | - | ACEPSOIT | COMP | ACE_COMP | Accrual Engine Application Component | |||
7 | - | ACEPSOIT | BUKRS | ACE_BUKRS | Company Code | |||
8 | GJAHR | ACEPSOIT | GJAHR | ACEPS_GJAHR | Fiscal Year in Accrual Engine | |||
9 | - | ACEPSOIT | OBJID | ACE_GUID | Accrual Object (Internal Display in Form of a GUID) | |||
10 | - | ACEPSOIT | SUBID | ACE_SUBID | Accrual Subobject (Internal Display, Sequence Number) | |||
11 | ACRTYPE | ACEPSOIT | ACRTYPE | ACE_ACRTYPE | Accrual Type | |||
12 | ACCRULE | ACEPSOIT | ACCRULE | ACCOUNTING_PRINCIPLE | Accounting Principle | |||
13 | DOCNR | ACEPSOIT | DOCNR | ACEPS_DOCNR | Document Number of an Accrual Engine Document | |||
14 | VALCUM | ACEPSOIT | VALCUM | ACE_AMOUNT_CUMULATED | Cumulative Value (Previously Accrued) | |||
15 | VALTBP | ACEPSOIT | VALTBP | ACE_AMOUNT_TBP | Amount Currently Posted | |||
16 | CURRENCY | ACEPSOIT | CURRENCY | ACEDS_VALCURRENCY | Currency Calculated/Posted in the Accrual Amounts | |||
17 | TRANSTYPE | ACEPSOIT | TRANSTYPE | ACE_TRANSTYPE | Transaction in Accrual Engine | |||
18 | EFFDATE | ACEPSOIT | EFFDATE | ACE_EFFDATE | Key Date/Posting Date for Accruals | |||
19 | PODATE | ACEPSOIT | PODATE | ACE_PODATE | Posting Date | |||
20 | POPER | ACEPSOIT | POPER | ACE_POPER | Posting Period in Financial Accounting | |||
21 | POYEAR | ACEPSOIT | POYEAR | ACE_POYEAR | Fiscal Year in Financial Accounting | |||
22 | RUNID | ACEPSOIT | RUNID | ACEPS_RUNID | Number (Run ID) of a Periodic Accrual Run in the Accl Engine | |||
23 | AWTYP | ACEPSOIT | AWTYP | AWTYP | Reference procedure | |||
24 | AWKEY | ACEPSOIT | AWKEY | ACE_AWKEY | Reference Key for Accounting Document | |||
25 | AWSYS | ACEPSOIT | AWSYS | AWSYS | Logical system of source document | |||
26 | TIMESTMP | ACEPSOIT | TIMESTMP | ACE_HZSTMP | Time Added (Greenwich Meantime) | |||
27 | REVERSAL_DOC | ACEPSOIT | REVERSAL_DOC | ACEPS_FLAG_REVERSAL_DOC | Indicator: Document Is a Reversal Document | |||
28 | REVERSED_DOC | ACEPSOIT | REVERSED_DOC | ACEPS_DOCNR_REVERSED | Number of the Reversed Accrual Engine Document | |||
29 | * | ACEPSOH | * | |||||
30 | - | ACEPSOH | MANDT | MANDT | Client | |||
31 | - | ACEPSOH | COMP | ACE_COMP | Accrual Engine Application Component | |||
32 | - | ACEPSOH | BUKRS | ACE_BUKRS | Company Code | |||
33 | - | ACEPSOH | OBJID | ACE_GUID | Accrual Object (Internal Display in Form of a GUID) | |||
34 | SUBID | ACEPSOH | SUBID | ACE_SUBID | Accrual Subobject (Internal Display, Sequence Number) | |||
35 | UNAME | ACEPSOH | UNAME | ACE_UNAME | User Name | |||
36 | CPUDT | ACEPSOH | CPUDT | ACE_CREATEDATE | Date on which the accrual subobject was added/changed | |||
37 | CPUTM | ACEPSOH | CPUTM | ACE_CREATETIME | Time at which the accrual subobject was added/changed | |||
38 | DEACTDATE | ACEPSOH | DEACTDATE | ACE_DEACTDATE | Deactivation Date | |||
39 | STATUS | ACEPSOH | STATUS | ACEPS_HEADER_STATUS | Processing Status of Posting Data of an Accrual Subobject | |||
40 | FIRSTYEAR | ACEPSOH | FIRSTYEAR | ACE_FIRSTYEAR | First Fiscal Year | |||
41 | LASTYEAR | ACEPSOH | LASTYEAR | ACE_LASTYEAR | Last Fiscal Year | |||
42 | * | ACEOBJ | * | |||||
43 | OBJID | ACEOBJ | OBJID | ACE_GUID | Accrual Object (Internal Display in Form of a GUID) | |||
44 | REF_KEY | ACEOBJ | REF_KEY | ACE_REF_KEY | Unique External Reference for Accrual Object | |||
45 | REF_SUBKEY | ACEPSOH | REF_SUBKEY | ACE_REF_SUBKEY | Unique Reference for an Accrual Subobject | |||
46 | OBJSTATUS | ACEOBJ | OBJSTATUS | ACE_OBJECT_STATUS | Processing Status of an Accrual Object | |||
Maintenance Status
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 | 46C |