ACEDS_PERIODDATA is a standard SAP table in SAP ECC (or) S/4HANA which stores Data specific for a period in the Accrual Engine data. There are total 34 fields in ACEDS_PERIODDATA table.This blog post provides key technical details of SAP table ACEDS_PERIODDATA, including its availability across SAP S/4HANA versions and the list of CDS views for ACEDS_PERIODDATA table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Accrual Engine: Distribution Server Basis (ACE-DS) |
| Technical Component | Accrual Engine (FI-GL-GL-ACE) |
SAP ACEDS_PERIODDATA Table Fields
The following is the list of fields that are available in SAP ACEDS_PERIODDATA 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 | CHAR (4) | |
| BUKRS | Company Code | ACE_BUKRS | BUKRS | CHAR (4) | |
| OBJID | Accrual Object (Internal Display in Form of a GUID) | ACE_GUID | ACE_GUID | RAW (16) | |
| ACRTYPE | Accrual Type | ACE_ACRTYPE | ACE_ACRTYPE | CHAR (6) | |
| ACCRULE | Accounting Principle | ACCOUNTING_PRINCIPLE | ACCOUNTING_PRINCIPLE | CHAR (4) | |
| PERIOD_END_DATE | Last day of period in Accrual Engine | ACE_DS_PERIOD_END_DATE | DATS | DATS (8) | |
| PERIOD_START_DATE | First day of period in Accrual Engine | ACE_DS_PERIOD_START_DATE | DATE | DATS (8) | |
| UPLOADED_ACCR_AMNT | Uploaded Accrual Amount | ACE_DS_PERIOD_UPLD_ACCR_AMNT | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| UPLOADED_ACCR_AMNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | WAERS | CUKY (5) | |
| PROPOSED_ACCR_AMNT | Proposed Accrual Amount | ACE_DS_PERIOD_PROPSD_ACCR_AMNT | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| PROPOSED_ACCR_AMNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | WAERS | CUKY (5) | |
| PROPOSED_BY | Name of the user who has proposed the accrual amount | ACE_DS_PACCR_PROPOSEDBY_UNAME | UNAME | CHAR (12) | |
| PROPOSED_ON | Day on which the accrual amount was proposed | ACE_DS_PROPOSED_ON_DATE | DATUM | DATS (8) | |
| PROPOSED_AT | Time at which the accrual amount was proposed | ACE_DS_PROPOSED_AT_TIME | UZEIT | TIMS (6) | |
| ACCRUAL_AMOUNT | Current Accrual Amount | ACE_ACCRUAL_VALUE_ACT | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| ACCRUAL_AMOUNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | WAERS | CUKY (5) | |
| 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) | |
| REVWD_APPRVD_AMOUNT | Reviewed or Approved Accrual Amount | ACE_DS_PERIOD_RVAPVD_ACCR_AMNT | AFLE15D2O21S_TO_23D2O31S | CURR (23) | |
| REVWD_APPRVD_AMOUNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | WAERS | CUKY (5) |
Availability
The SAP table ACEDS_PERIODDATA 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 ACEDS_PERIODDATA table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
