SAP ACESOBJ_ITEM_PER Period data of Accrual Item Table
Overview
ACESOBJ_ITEM_PER is a standard SAP S/4HANA table that stores Period data of Accrual Item data. There are total 66 fields in the ACESOBJ_ITEM_PER table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACESOBJ_ITEM_PER belongs to Accrual Engine (FI-GL-GL-ACE) module and is located in the package Accrual Engine Adopted for S/4HANA (ACE_S4).
In addition, following links provide an overview of foreign key relationships, if any, that link ACESOBJ_ITEM_PER to other SAP tables and standard CDS views available based on ACESOBJ_ITEM_PER table in S/4HANA 2020.
Techincal Settings of ACESOBJ_ITEM_PER
Below are technical details of the table ACESOBJ_ITEM_PER
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACESOBJ_ITEM_PER Fields
The following table gives you an overview of the fields available in ACESOBJ_ITEM_PER
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| COMP | Accrual Engine Application Component | ACE_COMP | TACECOMP | CHAR | 4 |
| LOGSYS | Logical System of Accrual Object | ACE_LOGSYS | CHAR | 10 | |
| BUKRS | Company Code | ACE_BUKRS | CHAR | 4 | |
| REF_KEY | Identifier of the Accrual Object | ACE_OBJ_ID | CHAR | 32 | |
| REF_SUBKEY | Identifier of the Accrual Subobject | ACE_SUBOBJ_ID | CHAR | 32 | |
| ITEMTYPE | Accrual Item Type | ACE_ITEMTYPE | CHAR | 11 | |
| RLDNR | Ledger in General Ledger Accounting | FINS_LEDGER | CHAR | 2 | |
| PERIOD_END_DATE | Last day of period in Accrual Engine | ACE_PERIOD_END_DATE | DATS | 8 | |
| PERIOD_START_DATE | First day of period in Accrual Engine | ACE_PERIOD_START_DATE | DATS | 8 | |
| PERIOD_AMNT_SOURCE | Source of Period Amount | ACE_PERIOD_AMNT_SOURCE | CHAR | 1 | |
| PERIOD_AMNT_CHANGED_BY | Name of the user who has last changed the period amount | ACE_PER_AMNT_CHANGED_BY_UNAME | CHAR | 12 | |
| PERIOD_AMNT_CHANGED_ON | Day on which the period amount was last changed | ACE_PER_AMNT_CHANGED_ON_DATE | DATS | 8 | |
| PERIOD_AMNT_CHANGED_AT | Time at which the period amount was last changed | ACE_PER_AMNT_CHANGED_AT_TIME | TIMS | 6 | |
| PERIOD_AMNT_WSL | Period Amount in Transaction Currency | ACE_PERIOD_AMNT_WCURR | CURR | 23 | |
| PERIOD_AMNT_HSL | Period Amount in Company Code Currency | ACE_PERIOD_AMNT_HCURR | CURR | 23 | |
| PERIOD_AMNT_KSL | Period Amount in Global Currency | ACE_PERIOD_AMNT_KCURR | CURR | 23 | |
| PERIOD_AMNT_OSL | Period Amount in Freely Defined Currency 1 | ACE_PERIOD_AMNT_OCURR | CURR | 23 | |
| PERIOD_AMNT_VSL | Period Amount in Freely Defined Currency 2 | ACE_PERIOD_AMNT_VCURR | CURR | 23 | |
| PERIOD_AMNT_BSL | Period Amount in Freely Defined Currency 3 | ACE_PERIOD_AMNT_BCURR | CURR | 23 | |
| PERIOD_AMNT_CSL | Period Amount in Freely Defined Currency 4 | ACE_PERIOD_AMNT_CCURR | CURR | 23 | |
| PERIOD_AMNT_DSL | Period Amount in Freely Defined Currency 5 | ACE_PERIOD_AMNT_DCURR | CURR | 23 | |
| PERIOD_AMNT_ESL | Period Amount in Freely Defined Currency 6 | ACE_PERIOD_AMNT_ECURR | CURR | 23 | |
| PERIOD_AMNT_FSL | Period Amount in Freely Defined Currency 7 | ACE_PERIOD_AMNT_FCURR | CURR | 23 | |
| PERIOD_AMNT_GSL | Period Amount in Freely Defined Currency 8 | ACE_PERIOD_AMNT_GCURR | CURR | 23 | |
| RWCURPER | Transaction Currency | FINS_CURRW | TCURC | CUKY | 5 |
| RHCURPER | Company Code Currency | FINS_CURRH | TCURC | CUKY | 5 |
| RKCURPER | Global Currency | FINS_CURRK | TCURC | CUKY | 5 |
| ROCURPER | Freely Defined Currency 1 | FINS_CURR1 | TCURC | CUKY | 5 |
| RVCURPER | Freely Defined Currency 2 | FINS_CURR2 | TCURC | CUKY | 5 |
| RBCURPER | Freely Defined Currency 3 | FINS_CURR3 | TCURC | CUKY | 5 |
| RCCURPER | Freely Defined Currency 4 | FINS_CURR4 | TCURC | CUKY | 5 |
| RDCURPER | Freely Defined Currency 5 | FINS_CURR5 | TCURC | CUKY | 5 |
| RECURPER | Freely Defined Currency 6 | FINS_CURR6 | TCURC | CUKY | 5 |
| RFCURPER | Freely Defined Currency 7 | FINS_CURR7 | TCURC | CUKY | 5 |
| RGCURPER | Freely Defined Currency 8 | FINS_CURR8 | TCURC | CUKY | 5 |
| PERIOD_MSL | Period Quantity | ACE_PERIOD_MSL | QUAN | 15 | |
| PERIOD_UNIT | Base Unit of Measure | MEINS | * | UNIT | 3 |
| ADJUSTED_PER_AMNT_WSL | Adjusted Period Amount in Transaction Currency | ACE_ADJUSTED_PER_AMNT_WCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_HSL | Adjusted Period Amount in Company Code Currency | ACE_ADJUSTED_PER_AMNT_HCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_KSL | Adjusted Period Amount in Global Currency | ACE_ADJUSTED_PER_AMNT_KCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_OSL | Adjusted Period Amount in Freely Defined Currency 1 | ACE_ADJUSTED_PER_AMNT_OCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_VSL | Adjusted Period Amount in Freely Defined Currency 2 | ACE_ADJUSTED_PER_AMNT_VCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_BSL | Adjusted Period Amount in Freely Defined Currency 3 | ACE_ADJUSTED_PER_AMNT_BCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_CSL | Adjusted Period Amount in Freely Defined Currency 4 | ACE_ADJUSTED_PER_AMNT_CCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_DSL | Adjusted Period Amount in Freely Defined Currency 5 | ACE_ADJUSTED_PER_AMNT_DCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_ESL | Adjusted Period Amount in Freely Defined Currency 6 | ACE_ADJUSTED_PER_AMNT_ECURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_FSL | Adjusted Period Amount in Freely Defined Currency 7 | ACE_ADJUSTED_PER_AMNT_FCURR | CURR | 23 | |
| ADJUSTED_PER_AMNT_GSL | Adjusted Period Amount in Freely Defined Currency 8 | ACE_ADJUSTED_PER_AMNT_GCURR | CURR | 23 | |
| ADJUSTED_PER_MSL | Revised Quantity | ACE_ACCR_AMNT_MSL_ADJSTD | QUAN | 15 | |
| ADJSTMNT_REASON | Reason Code | ACE_DS_ADJSTMNT_REASON_CODE | * | CHAR | 2 |
| ADJSTMNT_COMMENT | Comment | ACE_DS_ADJSTMNT_COMMENT | CHAR | 100 | |
| ADJUSTED_BY | Name of the user who has adjusted the period amount | ACE_DS_PACCR_ADJUSTEDBY_UNAME | CHAR | 12 | |
| ADJUSTED_ON | Day on which the period amount was adjusted | ACE_DS_ADJUSTED_ON_DATE | DATS | 8 | |
| ADJUSTED_AT | Time at which the period amount was adjusted | ACE_DS_ADJUSTED_AT_TIME | TIMS | 6 | |
| REVIEW_STATUS | Review Status | ACEDS_RVW_STATUS | CHAR | 1 | |
| REVIEW_TYPE | Review Type | ACE_DS_REVIEW_TYPE | CHAR | 1 | |
| REVIEWED_BY | Name of the user who has reviewed the period amount | ACE_DS_PACCR_REVIEWER_UNAME | CHAR | 12 | |
| REVIEWED_ON | Day on which the period amount was reviewed | ACE_DS_REVIEWED_ON_DATE | DATS | 8 | |
| REVIEWED_AT | Time at which the period amount was reviewed | ACE_DS_REVIEWED_AT_TIME | TIMS | 6 | |
| APPROVAL_STATUS | Approval Status | ACEDS_APRVL_STATUS | CHAR | 1 | |
| APPROVAL_TYPE | Approval Type | ACE_DS_APPROVAL_TYPE | CHAR | 1 | |
| APPROVED_BY | Name of the user who has approved the accrual amount | ACE_DS_PACCR_APPROVER_UNAME | CHAR | 12 | |
| APPROVED_ON | Day on which the period amount was approved | ACE_DS_APPROVED_ON_DATE | DATS | 8 | |
| APPROVED_AT | Time at which the period amount was approved | ACE_DS_APPROVED_AT_TIME | TIMS | 6 | |
| XASSISTED_BY_ML | Indicator: Assisted by Machine Learning | ACE_XASSISTED_BY_ML | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACESOBJ_ITEM_PER
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ACESOBJ_ITEM_PER | COMP | : | TACECOMP |
| ACESOBJ_ITEM_PER | RBCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RCCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RDCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RECURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RFCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RGCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RHCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RKCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | ROCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RVCURPER | C: CN | TCURC |
| ACESOBJ_ITEM_PER | RWCURPER | C: CN | TCURC |