ACESOBJ_ITEM_PER is a standard SAP table in SAP ECC (or) S/4HANA which stores Period data of Accrual Item data. There are total 66 fields in ACESOBJ_ITEM_PER table.This blog post provides key technical details of SAP table ACESOBJ_ITEM_PER, including its availability across SAP S/4HANA versions and the list of CDS views for ACESOBJ_ITEM_PER table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Accrual Engine Adopted for S/4HANA (ACE_S4) |
| Technical Component | Accrual Engine (FI-GL-GL-ACE) |
SAP ACESOBJ_ITEM_PER Table Fields
The following is the list of fields that are available in SAP ACESOBJ_ITEM_PER table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| COMP | Accrual Engine Application Component | ACE_COMP | ACE_COMP | TACECOMP | CHAR (4) |
| LOGSYS | Logical System of Accrual Object | ACE_LOGSYS | LOGSYS | CHAR (10) | |
| BUKRS | Company Code | ACE_BUKRS | BUKRS | CHAR (4) | |
| REF_KEY | Identifier of the Accrual Object | ACE_OBJ_ID | ACE_OBJ_ID | CHAR (32) | |
| REF_SUBKEY | Identifier of the Accrual Subobject | ACE_SUBOBJ_ID | ACE_SUBOBJ_ID | CHAR (32) | |
| ITEMTYPE | Accrual Item Type | ACE_ITEMTYPE | ACE_ITEMTYPE | CHAR (11) | |
| RLDNR | Ledger in General Ledger Accounting | FINS_LEDGER | FINS_LEDGER | CHAR (2) | |
| PERIOD_END_DATE | Last day of period in Accrual Engine | ACE_PERIOD_END_DATE | DATS | DATS (8) | |
| PERIOD_START_DATE | First day of period in Accrual Engine | ACE_PERIOD_START_DATE | DATE | DATS (8) | |
| PERIOD_AMNT_SOURCE | Source of Period Amount | ACE_PERIOD_AMNT_SOURCE | 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 | UNAME | CHAR (12) | |
| PERIOD_AMNT_CHANGED_ON | Day on which the period amount was last changed | ACE_PER_AMNT_CHANGED_ON_DATE | DATUM | DATS (8) | |
| PERIOD_AMNT_CHANGED_AT | Time at which the period amount was last changed | ACE_PER_AMNT_CHANGED_AT_TIME | UZEIT | TIMS (6) | |
| PERIOD_AMNT_WSL | Period Amount in Transaction Currency | ACE_PERIOD_AMNT_WCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_HSL | Period Amount in Company Code Currency | ACE_PERIOD_AMNT_HCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_KSL | Period Amount in Global Currency | ACE_PERIOD_AMNT_KCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_OSL | Period Amount in Freely Defined Currency 1 | ACE_PERIOD_AMNT_OCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_VSL | Period Amount in Freely Defined Currency 2 | ACE_PERIOD_AMNT_VCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_BSL | Period Amount in Freely Defined Currency 3 | ACE_PERIOD_AMNT_BCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_CSL | Period Amount in Freely Defined Currency 4 | ACE_PERIOD_AMNT_CCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_DSL | Period Amount in Freely Defined Currency 5 | ACE_PERIOD_AMNT_DCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_ESL | Period Amount in Freely Defined Currency 6 | ACE_PERIOD_AMNT_ECURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_FSL | Period Amount in Freely Defined Currency 7 | ACE_PERIOD_AMNT_FCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PERIOD_AMNT_GSL | Period Amount in Freely Defined Currency 8 | ACE_PERIOD_AMNT_GCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| RWCURPER | Transaction Currency | FINS_CURRW | WAERS | TCURC | CUKY (5) |
| RHCURPER | Company Code Currency | FINS_CURRH | WAERS | TCURC | CUKY (5) |
| RKCURPER | Global Currency | FINS_CURRK | WAERS | TCURC | CUKY (5) |
| ROCURPER | Freely Defined Currency 1 | FINS_CURR1 | WAERS | TCURC | CUKY (5) |
| RVCURPER | Freely Defined Currency 2 | FINS_CURR2 | WAERS | TCURC | CUKY (5) |
| RBCURPER | Freely Defined Currency 3 | FINS_CURR3 | WAERS | TCURC | CUKY (5) |
| RCCURPER | Freely Defined Currency 4 | FINS_CURR4 | WAERS | TCURC | CUKY (5) |
| RDCURPER | Freely Defined Currency 5 | FINS_CURR5 | WAERS | TCURC | CUKY (5) |
| RECURPER | Freely Defined Currency 6 | FINS_CURR6 | WAERS | TCURC | CUKY (5) |
| RFCURPER | Freely Defined Currency 7 | FINS_CURR7 | WAERS | TCURC | CUKY (5) |
| RGCURPER | Freely Defined Currency 8 | FINS_CURR8 | WAERS | TCURC | CUKY (5) |
| PERIOD_MSL | Period Quantity | ACE_PERIOD_MSL | MENGV8 | QUAN (15) | |
| PERIOD_UNIT | Base Unit of Measure | MEINS | MEINS | * | UNIT (3) |
| ADJUSTED_PER_AMNT_WSL | Adjusted Period Amount in Transaction Currency | ACE_ADJUSTED_PER_AMNT_WCURR | AFLE15D2O20N_TO_23D2O30N | CURR (23) | |
| ADJUSTED_PER_AMNT_HSL | Adjusted Period Amount in Company Code Currency | ACE_ADJUSTED_PER_AMNT_HCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_KSL | Adjusted Period Amount in Global Currency | ACE_ADJUSTED_PER_AMNT_KCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_OSL | Adjusted Period Amount in Freely Defined Currency 1 | ACE_ADJUSTED_PER_AMNT_OCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_VSL | Adjusted Period Amount in Freely Defined Currency 2 | ACE_ADJUSTED_PER_AMNT_VCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_BSL | Adjusted Period Amount in Freely Defined Currency 3 | ACE_ADJUSTED_PER_AMNT_BCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_CSL | Adjusted Period Amount in Freely Defined Currency 4 | ACE_ADJUSTED_PER_AMNT_CCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_DSL | Adjusted Period Amount in Freely Defined Currency 5 | ACE_ADJUSTED_PER_AMNT_DCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_ESL | Adjusted Period Amount in Freely Defined Currency 6 | ACE_ADJUSTED_PER_AMNT_ECURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_FSL | Adjusted Period Amount in Freely Defined Currency 7 | ACE_ADJUSTED_PER_AMNT_FCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_AMNT_GSL | Adjusted Period Amount in Freely Defined Currency 8 | ACE_ADJUSTED_PER_AMNT_GCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ADJUSTED_PER_MSL | Revised Quantity | ACE_ACCR_AMNT_MSL_ADJSTD | MENGV8 | QUAN (15) | |
| ADJSTMNT_REASON | Reason Code | ACE_DS_ADJSTMNT_REASON_CODE | ACE_DS_ADJSTMNT_REASON_CODE | * | CHAR (2) |
| ADJSTMNT_COMMENT | Comment | ACE_DS_ADJSTMNT_COMMENT | TEXT100 | CHAR (100) | |
| ADJUSTED_BY | Name of the user who has adjusted the period amount | ACE_DS_PACCR_ADJUSTEDBY_UNAME | UNAME | CHAR (12) | |
| ADJUSTED_ON | Day on which the period amount was adjusted | ACE_DS_ADJUSTED_ON_DATE | DATUM | DATS (8) | |
| ADJUSTED_AT | Time at which the period amount was adjusted | ACE_DS_ADJUSTED_AT_TIME | UZEIT | TIMS (6) | |
| REVIEW_STATUS | Review Status | ACEDS_RVW_STATUS | ACEDS_RVW_STATUS | CHAR (1) | |
| REVIEW_TYPE | Review Type | ACE_DS_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 | UNAME | CHAR (12) | |
| REVIEWED_ON | Day on which the period amount was reviewed | ACE_DS_REVIEWED_ON_DATE | DATUM | DATS (8) | |
| REVIEWED_AT | Time at which the period amount was reviewed | ACE_DS_REVIEWED_AT_TIME | UZEIT | TIMS (6) | |
| APPROVAL_STATUS | Approval Status | ACEDS_APRVL_STATUS | ACEDS_APRVL_STATUS | CHAR (1) | |
| APPROVAL_TYPE | Approval Type | ACE_DS_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 | UNAME | CHAR (12) | |
| APPROVED_ON | Day on which the period amount was approved | ACE_DS_APPROVED_ON_DATE | DATUM | DATS (8) | |
| APPROVED_AT | Time at which the period amount was approved | ACE_DS_APPROVED_AT_TIME | UZEIT | TIMS (6) | |
| XASSISTED_BY_ML | Indicator: Assisted by Machine Learning | ACE_XASSISTED_BY_ML | XFELD | CHAR (1) |
Availability
The SAP table ACESOBJ_ITEM_PER is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ACESOBJ_ITEM_PER table
The following is the list of ACESOBJ_ITEM_PER CDS views, which can also be used instead of ACESOBJ_ITEM_PER table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_ACCRENGINEACCRPERDCAMOUNTS | BASIC | Accrual Periodic Amounts |
| I_ACCRENGINEACTLPERDCAMOUNTS | BASIC | Accrual Engine:Actual Periodic Amounts |
| I_ACCRENGINEBASICPERDCAMOUNTS | BASIC | Accrual Engine:Periodic Amounts |
| I_ACCRENGINEPLANPERDCAMOUNTS | BASIC | Accrual Engine:Planned Periodic Amounts |
| I_ACCRSUBOBJITEMPOSTEDAMT | BASIC | Accrual Sub-Object Item Posted Amount |
| I_MANUALACCRUAL | BASIC | Manual Accrual Object View |
| I_PERIODACCRUAL | BASIC | Periodic Data of Accrual Subobject View |
| I_PURCHASEORDERACCRUAL | BASIC | Purchase Order Accrual Object View |
| P_ACCRUALOBJECTPERIOD_ADMIN | BASIC | Get admin information for reviewed item type |
| P_ACCRUALOBJECTPERIOD_DERIVE | BASIC | Derive actual and planned item type information |
| P_ACCRUALOBJECTPERIOD_TS | BASIC | Calculate timestamp for period entries |
| I_ACCRENGINEPERIODICAMOUNTS | COMPOSITE | Accrual Engine:Cnsldtd Periodic Amounts |
| I_ACCRSUBOBJITMWTHPERDCAMOUNTS | COMPOSITE | Accrual Subobject Item with Periodic Amounts |
| P_PURCHASEORDACCRFORINFERENCE | COMPOSITE | Accrual Objects for Machine Learning Inference |
| P_PURCHASEORDACCRFORTRAINING | COMPOSITE | Accrual Objects for Machine Learning Training |
| P_PURORDACCRTRAININGDATACLASS | COMPOSITE | Accrual Objects for Machine Learning Training |
| C_ACCRENGINEACCRPERDCAMOUNTS | CONSUMPTION | Accrual Periodic Amounts |
| C_ACCRPERDCAMTADJUSTEDBYUSERVH | CONSUMPTION | Accrual Periodic Amount Proposed By User VH |
| C_ACCRPERDCAMTAPPROVEDBYUSERVH | CONSUMPTION | Accrual Periodic Amount Proposed By User VH |
| C_ACCRPERDCAMTPROPOSEDBYUSERVH | CONSUMPTION | Accrual Periodic Amount Proposed By User VH |
| C_ACCRPERDCAMTREVIEWEDBYUSERVH | CONSUMPTION | Accrual Periodic Amount Proposed By User VH |
| C_ACCRSUBOBJITMWTHPERDCAMOUNTS | CONSUMPTION | Accrual Subobject Item with Periodic Amounts |
| C_MANUALACCRUAL | CONSUMPTION | Manual Accrual Object Consumption View |
| C_PURCHASEORDERACCRUAL | CONSUMPTION | Purchase Order Accrual Object View |
| C_PURORDACCRUALFORREVIEW | CONSUMPTION | Purchase Order Accrual Object for Review |
| C_PURORDERTOTALACCRAMOUNT | CONSUMPTION | Total Accrual Amount of Purchase Order |
