ACESOBJ_ITEM is a standard SAP table in SAP ECC (or) S/4HANA which stores Item Data for Accrual Subobject data. There are total 46 fields in ACESOBJ_ITEM table.This blog post provides key technical details of SAP table ACESOBJ_ITEM, including its availability across SAP S/4HANA versions and the list of CDS views for ACESOBJ_ITEM 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 Table Fields
The following is the list of fields that are available in SAP ACESOBJ_ITEM 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) | |
| DATE_TO | To Date of Accrual Item | ACE_DATETO | DATS | DATS (8) | |
| DATE_FROM | From Date of an Entry | ACE_DATEFROM | DATS | DATS (8) | |
| QUANTITY | Total Quantity to Accrue | ACE_TOTAL_QUANTITY | MENGV8 | QUAN (15) | |
| UNIT | Unit of Measure for Accrual Items | ACE_UNIT | MEINS | T006 | UNIT (3) |
| ACRMETHOD | Accrual/Deferral Method | ACEDS_ACRMETHOD | ACE_ACCMETHOD | TACE_ACCMETHODS | CHAR (10) |
| XOBSOLETE | Accrual Item is Obsolete | ACEDS_XOBSOLETE | FLAG | CHAR (1) | |
| INC_OFFSTNG_ACCNT | Offsetting Account for Opening Posting | ACE_ACCNT_INCEPTION_OFFSETTING | SAKNR | SKA1 | CHAR (10) |
| INC_ACCR_ACCNT | Accrual Account for Opening Posting | ACE_ACCNT_INCEPTION_ACCRUAL | SAKNR | SKA1 | CHAR (10) |
| PER_ACCR_ACCNT | Accrual Account for Periodic Posting | ACE_ACCNT_PERIODIC_ACCRUAL | SAKNR | SKA1 | CHAR (10) |
| PER_OFFSTNG_ACCNT | Offsetting Account for Periodic Posting | ACE_ACCNT_PERIODIC_OFFSETTING | SAKNR | SKA1 | CHAR (10) |
| FIN_ACCR_ACCNT | Accrual Account for Closing Posting | ACE_ACCNT_FINAL_ACCRUAL | SAKNR | SKA1 | CHAR (10) |
| FIN_OFFSTNG_ACCNT | Offsetting Account for Closing Posting | ACE_ACCNT_FINAL_OFFSETTING | SAKNR | SKA1 | CHAR (10) |
| INC_DOC_TYPE | Document Type for Opening Posting | ACEPS_INC_BLART | BLART | T003 | CHAR (2) |
| PER_DOC_TYPE | Document Type for Periodic Accrual Posting | ACEPS_PER_BLART | BLART | T003 | CHAR (2) |
| FIN_DOC_TYPE | Document Type for Closing Posting | ACEPS_FIN_BLART | BLART | T003 | CHAR (2) |
| TOTAL_ACCR_AMNT_WSL | Total Accrual Amount in Transaction Currency | ACE_TOTAL_PER_ACCR_AMNT_WCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_HSL | Total Accrual Amount in Company Code Currency | ACE_TOTAL_PER_ACCR_AMNT_HCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_KSL | Total Accrual Amount in Global Currency | ACE_TOTAL_PER_ACCR_AMNT_KCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_OSL | Total Accrual Amount in Freely Defined Currency 1 | ACE_TOTAL_PER_ACCR_AMNT_OCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_VSL | Total Accrual Amount in Freely Defined Currency 2 | ACE_TOTAL_PER_ACCR_AMNT_VCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_BSL | Total Accrual Amount in Freely Defined Currency 3 | ACE_TOTAL_PER_ACCR_AMNT_BCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_CSL | Total Accrual Amount in Freely Defined Currency 4 | ACE_TOTAL_PER_ACCR_AMNT_CCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_DSL | Total Accrual Amount in Freely Defined Currency 5 | ACE_TOTAL_PER_ACCR_AMNT_DCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_ESL | Total Accrual Amount in Freely Defined Currency 6 | ACE_TOTAL_PER_ACCR_AMNT_ECURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_FSL | Total Accrual Amount in Freely Defined Currency 7 | ACE_TOTAL_PER_ACCR_AMNT_FCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTAL_ACCR_AMNT_GSL | Total Accrual Amount in Freely Defined Currency 8 | ACE_TOTAL_PER_ACCR_AMNT_GCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| RWCURTTL | Transaction Currency | FINS_CURRW | WAERS | TCURC | CUKY (5) |
| RHCURTTL | Company Code Currency | FINS_CURRH | WAERS | TCURC | CUKY (5) |
| RKCURTTL | Global Currency | FINS_CURRK | WAERS | TCURC | CUKY (5) |
| ROCURTTL | Freely Defined Currency 1 | FINS_CURR1 | WAERS | TCURC | CUKY (5) |
| RVCURTTL | Freely Defined Currency 2 | FINS_CURR2 | WAERS | TCURC | CUKY (5) |
| RBCURTTL | Freely Defined Currency 3 | FINS_CURR3 | WAERS | TCURC | CUKY (5) |
| RCCURTTL | Freely Defined Currency 4 | FINS_CURR4 | WAERS | TCURC | CUKY (5) |
| RDCURTTL | Freely Defined Currency 5 | FINS_CURR5 | WAERS | TCURC | CUKY (5) |
| RECURTTL | Freely Defined Currency 6 | FINS_CURR6 | WAERS | TCURC | CUKY (5) |
| RFCURTTL | Freely Defined Currency 7 | FINS_CURR7 | WAERS | TCURC | CUKY (5) |
| RGCURTTL | Freely Defined Currency 8 | FINS_CURR8 | WAERS | TCURC | CUKY (5) |
| TIMESTMP | (Obsolete) Time Added (Greenwich Meantime) | ACE_HZSTMP_OBSOLETE | ACE_TSTMP | DEC (16) |
Availability
The SAP table ACESOBJ_ITEM 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 table
The following is the list of ACESOBJ_ITEM CDS views, which can also be used instead of ACESOBJ_ITEM table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_ACCRENGINEACCRPOSTINGPARAM | BASIC | Accrual Subobject Posting Parameter |
| I_ACCRENGINEACCRSUBOBJACCRITEM | BASIC | Accrual Subobject Accrual Item |
| I_ACCRENGINEACCRSUBOBJACTLITEM | BASIC | Accrual Subobject Actual Item |
| I_ACCRENGINEACCRSUBOBJASSGMT | BASIC | Accrual Subobject Account Assignment |
| I_ACCRENGINEACCRSUBOBJLIFECYC | BASIC | Accrual Subobject Life Cycle |
| I_ACCRENGINEACCRSUBOBJPARAM | BASIC | Accrual Subobject Parameter |
| I_ACCRENGINEACCRSUBOBJPLANITEM | BASIC | Accrual Subobject Plan Item |
| I_ACCRENGINEACCRSUBOBJRAWITEM | BASIC | Accrual Subobject Raw Item |
| I_ACCRENGINEACCRUALSUBOBJECT | BASIC | Accrual Engine Accrual Subobject |
| I_ACCRUALSUBOBJITEM | BASIC | Accrual Sub Object Item |
| I_MNLACCRSACCRUALSUBOBJECT | BASIC | Manual Accruals Accrual Subobject |
| I_PURCHASEORDERACCRSUBOBJECT | BASIC | PurOrdAccrs: Subobject Keys Mapping |
| P_ACCRSUBOBJPARAMBYTYPESTRUC | BASIC | Accr Subobj Params by Accr Obj Type Fields in a Param Struc |
| P_ACCRUALOBJECTPERIOD_ALL | BASIC | Proposed and unproposed period data |
| P_ACCRUALOBJECT_ITEM_TOTAL | BASIC | Accrual object item for purchase order |
| I_ACCRENGINEACCRSUBOBJITEM | COMPOSITE | Accrual Subobject Item |
| I_ACCRSUBOBJITMWTHACCTASGT | COMPOSITE | Accrual Subobject Item with Acct Assgmt |
| I_ACCRSUBOBJITMWTHPERDCAMOUNTS | COMPOSITE | Accrual Subobject Item with Periodic Amounts |
| I_ANALYZEACCRUALPOSTING | COMPOSITE | Analyze Accrual Posting |
| I_PURORDACCRSACCRSUBOBJECT | COMPOSITE | Purchase Order Accrual Subobject |
| I_PURORDACCRUALOBJECT | COMPOSITE | Purchase Order Accrual Object View |
| P_ACCRSUBOBJITEMPRECALC | COMPOSITE | Precalculation view for I_AccrEngineAccrSubobjItem |
| P_ACCRSUBOBJRAWITEMPRECALC | COMPOSITE | Precalculation view for I_AccrEngineAccrSubobjRawItem |
| 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_ACCRENGINEACCRSUBOBJASSGMTTP | CONSUMPTION | Accrual Subobject Account Assignment |
| C_ACCRENGINEACCRSUBOBJITEMTP | CONSUMPTION | Accrual Subobject Item |
| C_ACCRENGINEACCRSUBOBJPARAMTP | CONSUMPTION | Accrual Subobject Parameter |
| C_ACCRENGINEACCRUALOBJECTVH | CONSUMPTION | Accrual Engine Accrual Subobject Value Help |
| C_ACCRENGINEACCRUALSUBOBJECTTP | CONSUMPTION | Accrual Engine Accrual Subobject |
| C_ACCRENGINEACCRUALSUBOBJECTVH | CONSUMPTION | Accrual Engine Accrual Subobject Value Help |
| C_ACCRSUBOBJECTCHANGEDBYUSERVH | CONSUMPTION | Accrual Subobject Last Changed By User VH |
| C_ACCRSUBOBJECTCREATEDBYUSERVH | CONSUMPTION | Accrual Subobject Created By User VH |
| C_ACCRSUBOBJITMWTHACCTASGT | CONSUMPTION | Accrual Subobject Item with Account Assignment |
| C_ACCRSUBOBJITMWTHPERDCAMOUNTS | CONSUMPTION | Accrual Subobject Item with Periodic Amounts |
| C_ANALYZEACCRUALPOSTING | CONSUMPTION | Analyze Accrual Postings |
| C_MANUALACCRUAL | CONSUMPTION | Manual Accrual Object Consumption View |
| C_PURCHASEORDERACCRUAL | CONSUMPTION | Purchase Order Accrual Object View |
| C_PURORDACCRSACCRSUBOBJECTTP | CONSUMPTION | Purchase Order Accrual Subobject |
| C_PURORDACCRUALFORREVIEW | CONSUMPTION | Purchase Order Accrual Object for Review |
| C_PURORDACCRUALOBJECTVH | CONSUMPTION | Purchase Order Accrual Object Value Help |
| C_PURORDACCRUALSUBOBJECTVH | CONSUMPTION | Purchase Order Accrual Subobject VH |
| C_PURORDACCRUALSWORKLIST | CONSUMPTION | Purchase Order Accruals Worklist |
| C_PURORDERTOTALACCRAMOUNT | CONSUMPTION | Total Accrual Amount of Purchase Order |
