ACE_ITEM_DRAFT is a standard SAP table in SAP ECC (or) S/4HANA which stores I_ACCRENGINEACCRUALSUBOBJECTTP I_ACCRENGINEACCRSUBOBJITEMTP data. There are total 59 fields in ACE_ITEM_DRAFT table.This blog post provides key technical details of SAP table ACE_ITEM_DRAFT, including its availability across SAP S/4HANA versions and the list of CDS views for ACE_ITEM_DRAFT 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 ACE_ITEM_DRAFT Table Fields
The following is the list of fields that are available in SAP ACE_ITEM_DRAFT 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) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | SYSUUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | SYSUUID | RAW (16) | |
| ACCRUALENGINEACCRUALOBJECTTYPE | Accrual Engine Application Component | ACE_COMP | ACE_COMP | CHAR (4) | |
| ACCRUALOBJECTLOGICALSYSTEM | Logical System of Accrual Object | ACE_LOGSYS | LOGSYS | CHAR (10) | |
| COMPANYCODE | Company Code | ACE_BUKRS | BUKRS | CHAR (4) | |
| ACCRUALOBJECT | Identifier of the Accrual Object | ACE_OBJ_ID | ACE_OBJ_ID | CHAR (32) | |
| ACCRUALSUBOBJECT | Identifier of the Accrual Subobject | ACE_SUBOBJ_ID | ACE_SUBOBJ_ID | CHAR (32) | |
| ACCRUALITEMTYPE | Accrual Item Type | ACE_ITEMTYPE | ACE_ITEMTYPE | CHAR (11) | |
| LEDGER | Ledger in General Ledger Accounting | FINS_LEDGER | FINS_LEDGER | CHAR (2) | |
| ACCRSUBOBJECTITMVALDTYENDDTE | To Date of Accrual Item | ACE_DATETO | DATS | DATS (8) | |
| ACCRUALITEMTYPENAME | Accrual Item Type Text | ACE_ITEMTYPE_TXT | TXT50 | CHAR (50) | |
| ACCRUALITEMTYPEFOREDIT | Accrual Item Type | ACE_ITEMTYPE | ACE_ITEMTYPE | CHAR (11) | |
| LEDGERGROUP | Ledger Group | ACE_LDGRP | FAGL_LDGRP | CHAR (4) | |
| ACCRPERDCPOSTINGFREQUENCY | Frequency for Periodic Posting Program | ACE_RHYTHM | ACE_RHYTHM | CHAR (1) | |
| ACCRPERDCPOSTINGFREQUENCYNAME | Frequency Name for Periodic Posting | ACE_S4_RHYTHM_NAME | TEXT50 | CHAR (50) | |
| ACCRSUBOBJECTITMVALDTYSTRTDTE | From Date of an Entry | ACE_DATEFROM | DATS | DATS (8) | |
| ACCRUALMETHOD | Accrual/Deferral Method | ACEDS_ACRMETHOD | ACE_ACCMETHOD | CHAR (10) | |
| PLANACCRUALITEMTYPE | Accrual Item Type for Planned Costs | ACE_PLANNED_ITEMTYPE | ACE_ITEMTYPE | CHAR (11) | |
| PLANACCRUALITEMTYPENAME | Accrual Item Type Text for Planned Costs | ACE_S4_PLAN_ITEMTYPE_NAME | TEXT50 | CHAR (50) | |
| PLANACCRUALMETHOD | Planned Accrual Method | ACEDS_ACRMETHOD_PLND | ACE_ACCMETHOD | CHAR (10) | |
| ACTUALACCRUALITEMTYPE | Accrual Item Type for Costs Posted by Invoices or Goods Rcpt | ACE_ACTUAL_ITEMTYPE | ACE_ITEMTYPE | CHAR (11) | |
| ACTUALACCRUALITEMTYPENAME | Actual Accrual Item Type Text | ACE_S4_ACTUAL_ITEMTYPE_NAME | TEXT50 | CHAR (50) | |
| ACTUALACCRUALMETHOD | Actual Accrual Method | ACEDS_ACRMETHOD_ACTL | ACE_ACCMETHOD | CHAR (10) | |
| ACCRUALMETHODNAME | Accrual Method Text | ACE_ACCMETHOD_TEXT | TXT70 | CHAR (70) | |
| ACCRUALITEMISOBSOLETE | Accrual Item is Obsolete | ACEDS_XOBSOLETE | FLAG | CHAR (1) | |
| ACCRUALITEMTYPEISDERIVED | Accrual Item Type is Derived | ACE_XDEPENDENT_S4 | XFELD | CHAR (1) | |
| TOTALACCRUALQUANTITY | Total Quantity to Accrue | ACE_TOTAL_QUANTITY | MENGV8 | QUAN (15) | |
| TOTALACCRUALQUANTITYUNIT | Unit of Measure for Accrual Items | ACE_UNIT | MEINS | UNIT (3) | |
| TOTALACCRAMOUNTINTRANSCRCY | Total Accrual Amount in Transaction Currency | ACE_TOTAL_PER_ACCR_AMNT_WCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTALACCRAMTINCOMPANYCODECRCY | Total Accrual Amount in Company Code Currency | ACE_TOTAL_PER_ACCR_AMNT_HCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TOTALACCRAMOUNTINGLOBALCRCY | Total Accrual Amount in Global Currency | ACE_TOTAL_PER_ACCR_AMNT_KCURR | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| TRANSACTIONCURRENCY | Transaction Currency | FINS_CURRW | WAERS | CUKY (5) | |
| COMPANYCODECURRENCY | Company Code Currency | FINS_CURRH | WAERS | CUKY (5) | |
| GLOBALCURRENCY | Global Currency | FINS_CURRK | WAERS | CUKY (5) | |
| ACCROPNGPOSTGDOCUMENTTYPE | Document Type for Opening Posting | ACEPS_INC_BLART | BLART | CHAR (2) | |
| ACCROPNGPOSTGDOCUMENTTYPENAME | Document Type Name for Opening Posting | ACE_S4_INC_BLART_TEXT | TEXT20 | CHAR (20) | |
| ACCRPERDCPOSTGDOCUMENTTYPE | Document Type for Periodic Accrual Posting | ACEPS_PER_BLART | BLART | CHAR (2) | |
| ACCRPERDCPOSTGDOCUMENTTYPENAME | Document Type Name for Periodic Accrual Posting | ACE_S4_PER_BLART_TEXT | TEXT20 | CHAR (20) | |
| ACCRCLSGPOSTGDOCUMENTTYPE | Document Type for Closing Posting | ACEPS_FIN_BLART | BLART | CHAR (2) | |
| ACCRCLSGPOSTGDOCUMENTTYPENAME | Document Type Name for Closing Posting | ACE_S4_FIN_BLART_TEXT | TEXT20 | CHAR (20) | |
| ACCROPNGPOSTGACCRACCOUNT | Accrual Account for Opening Posting | ACE_ACCNT_INCEPTION_ACCRUAL | SAKNR | CHAR (10) | |
| ACCROPNGPOSTGACCRACCOUNTNAME | Accrual Account Name for Opening Posting | ACE_S4_INC_ACCR_ACCNT_TEXT | TEXT20 | CHAR (20) | |
| ACCROPNGPOSTGOFFSTGACCOUNT | Offsetting Account for Opening Posting | ACE_ACCNT_INCEPTION_OFFSETTING | SAKNR | CHAR (10) | |
| ACCROPNGPOSTGOFFSTGACCOUNTNAME | Offsetting Account Name for Opening Posting | ACE_S4_INC_OFFSTG_ACCNT_TEXT | TEXT20 | CHAR (20) | |
| ACCRPERDCPOSTGACCRACCOUNT | Accrual Account for Periodic Posting | ACE_ACCNT_PERIODIC_ACCRUAL | SAKNR | CHAR (10) | |
| ACCRPERDCPOSTGACCRACCOUNTNAME | Accrual Account Name for Periodic Posting | ACE_S4_PER_ACCR_ACCNT_TEXT | TEXT20 | CHAR (20) | |
| ACCRPERDCPOSTGOFFSTGACCT | Offsetting Account for Periodic Posting | ACE_ACCNT_PERIODIC_OFFSETTING | SAKNR | CHAR (10) | |
| ACCRPERDCPOSTGOFFSTGACCTNAME | Offsetting Account Name for Periodic Posting | ACE_S4_PER_OFFSTG_ACCNT_TEXT | TEXT20 | CHAR (20) | |
| ACCRCLSGPOSTGACCRACCOUNT | Accrual Account for Closing Posting | ACE_ACCNT_FINAL_ACCRUAL | SAKNR | CHAR (10) | |
| ACCRCLSGPOSTGACCRACCOUNTNAME | Accrual Account Name for Closing Posting | ACE_S4_FIN_ACCR_ACCNT_TEXT | TEXT20 | CHAR (20) | |
| ACCRCLSGPOSTGOFFSTGACCOUNT | Offsetting Account for Closing Posting | ACE_ACCNT_FINAL_OFFSETTING | SAKNR | CHAR (10) | |
| ACCRCLSGPOSTGOFFSTGACCOUNTNAME | Offsetting Account Name for Closing Posting | ACE_S4_FIN_OFFSTG_ACCNT_TEXT | TEXT20 | CHAR (20) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | BOOLE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | TZNTSTMPL | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | TZNTSTMPL | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | SYSUUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | SDRAFT_OPERATION_CODE | CHAR (1) |
Availability
The SAP table ACE_ITEM_DRAFT 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 ACE_ITEM_DRAFT table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
