SAP ABAP View V_ACEPSOIT_OBJ2 (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_OBJ2 | |
Short Description | Join: ACEOBJ + ACEPSOH + ACEPSOIT | |
Root table | ACEOBJ | Accrual Objects |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ACEOBJ | ACEOBJ | ||
2 | ACEPSOH | |||
3 | ACEPSOIT |
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 | ACEPSOIT | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | ACEPSOH | COMP | JL | EQ | 0 | 0 | ||||
12 | ACEPSOIT | COMP | JR | EQ | AND | 0 | 0 | |||
13 | ACEPSOH | BUKRS | JL | EQ | 0 | 0 | ||||
14 | ACEPSOIT | BUKRS | JR | EQ | AND | 0 | 0 | |||
15 | ACEPSOH | OBJID | JL | EQ | 0 | 0 | ||||
16 | ACEPSOIT | 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 | OBJID | ACEOBJ | OBJID | ACE_GUID | Accrual Object (Internal Display in Form of a GUID) | |||
5 | * | ACEPSOIT | * | |||||
6 | - | ACEPSOIT | MANDT | MANDT | Client | |||
7 | - | ACEPSOIT | COMP | ACE_COMP | Accrual Engine Application Component | |||
8 | - | ACEPSOIT | BUKRS | ACE_BUKRS | Company Code | |||
9 | GJAHR | ACEPSOIT | GJAHR | ACEPS_GJAHR | Fiscal Year in Accrual Engine | |||
10 | - | ACEPSOIT | OBJID | ACE_GUID | Accrual Object (Internal Display in Form of a GUID) | |||
11 | SUBID | ACEPSOIT | SUBID | ACE_SUBID | Accrual Subobject (Internal Display, Sequence Number) | |||
12 | ACRTYPE | ACEPSOIT | ACRTYPE | ACE_ACRTYPE | Accrual Type | |||
13 | ACCRULE | ACEPSOIT | ACCRULE | ACCOUNTING_PRINCIPLE | Accounting Principle | |||
14 | DOCNR | ACEPSOIT | DOCNR | ACEPS_DOCNR | Document Number of an Accrual Engine Document | |||
15 | VALCUM | ACEPSOIT | VALCUM | ACE_AMOUNT_CUMULATED | Cumulative Value (Previously Accrued) | |||
16 | VALTBP | ACEPSOIT | VALTBP | ACE_AMOUNT_TBP | Amount Currently Posted | |||
17 | CURRENCY | ACEPSOIT | CURRENCY | ACEDS_VALCURRENCY | Currency Calculated/Posted in the Accrual Amounts | |||
18 | TRANSTYPE | ACEPSOIT | TRANSTYPE | ACE_TRANSTYPE | Transaction in Accrual Engine | |||
19 | EFFDATE | ACEPSOIT | EFFDATE | ACE_EFFDATE | Key Date/Posting Date for Accruals | |||
20 | PODATE | ACEPSOIT | PODATE | ACE_PODATE | Posting Date | |||
21 | POPER | ACEPSOIT | POPER | ACE_POPER | Posting Period in Financial Accounting | |||
22 | POYEAR | ACEPSOIT | POYEAR | ACE_POYEAR | Fiscal Year in Financial Accounting | |||
23 | RUNID | ACEPSOIT | RUNID | ACEPS_RUNID | Number (Run ID) of a Periodic Accrual Run in the Accl Engine | |||
24 | AWTYP | ACEPSOIT | AWTYP | AWTYP | Reference procedure | |||
25 | AWKEY | ACEPSOIT | AWKEY | ACE_AWKEY | Reference Key for Accounting Document | |||
26 | AWSYS | ACEPSOIT | AWSYS | AWSYS | Logical system of source document | |||
27 | TIMESTMP | ACEPSOIT | TIMESTMP | ACE_HZSTMP | Time Added (Greenwich Meantime) | |||
28 | REVERSAL_DOC | ACEPSOIT | REVERSAL_DOC | ACEPS_FLAG_REVERSAL_DOC | Indicator: Document Is a Reversal Document | |||
29 | REVERSED_DOC | ACEPSOIT | REVERSED_DOC | ACEPS_DOCNR_REVERSED | Number of the Reversed Accrual Engine Document | |||
30 | REF_KEY | ACEOBJ | REF_KEY | ACE_REF_KEY | Unique External Reference for Accrual Object | |||
31 | REF_SUBKEY | ACEPSOH | REF_SUBKEY | ACE_REF_SUBKEY | Unique Reference for an Accrual Subobject | |||
32 | 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 | 500 |