Overview
ACEDS_PERIODDATA is a standard SAP S/4HANA table that stores Data specific for a period in the Accrual Engine data. There are total 34 fields in the ACEDS_PERIODDATA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACEDS_PERIODDATA belongs to Accrual Engine (FI-GL-GL-ACE) module and is located in the package Accrual Engine: Distribution Server Basis (ACE-DS).
In addition, following links provide an overview of foreign key relationships, if any, that link ACEDS_PERIODDATA to other SAP tables and standard CDS views available based on ACEDS_PERIODDATA table in S/4HANA 2020.
Techincal Settings of ACEDS_PERIODDATA
Below are technical details of the table ACEDS_PERIODDATA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACEDS_PERIODDATA Fields
The following table gives you an overview of the fields available in ACEDS_PERIODDATA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| MANDT | Client | MANDT | | CLNT | 3 |
| COMP | Accrual Engine Application Component | ACE_COMP | | CHAR | 4 |
| BUKRS | Company Code | ACE_BUKRS | | CHAR | 4 |
| OBJID | Accrual Object (Internal Display in Form of a GUID) | ACE_GUID | | RAW | 16 |
| ACRTYPE | Accrual Type | ACE_ACRTYPE | | CHAR | 6 |
| ACCRULE | Accounting Principle | ACCOUNTING_PRINCIPLE | | CHAR | 4 |
| PERIOD_END_DATE | Last day of period in Accrual Engine | ACE_DS_PERIOD_END_DATE | | DATS | 8 |
| PERIOD_START_DATE | First day of period in Accrual Engine | ACE_DS_PERIOD_START_DATE | | DATS | 8 |
| UPLOADED_ACCR_AMNT | Uploaded Accrual Amount | ACE_DS_PERIOD_UPLD_ACCR_AMNT | | CURR | 23 |
| UPLOADED_ACCR_AMNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | | CUKY | 5 |
| PROPOSED_ACCR_AMNT | Proposed Accrual Amount | ACE_DS_PERIOD_PROPSD_ACCR_AMNT | | CURR | 23 |
| PROPOSED_ACCR_AMNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | | CUKY | 5 |
| PROPOSED_BY | Name of the user who has proposed the accrual amount | ACE_DS_PACCR_PROPOSEDBY_UNAME | | CHAR | 12 |
| PROPOSED_ON | Day on which the accrual amount was proposed | ACE_DS_PROPOSED_ON_DATE | | DATS | 8 |
| PROPOSED_AT | Time at which the accrual amount was proposed | ACE_DS_PROPOSED_AT_TIME | | TIMS | 6 |
| ACCRUAL_AMOUNT | Current Accrual Amount | ACE_ACCRUAL_VALUE_ACT | | CURR | 23 |
| ACCRUAL_AMOUNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | | CUKY | 5 |
| 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 |
| REVWD_APPRVD_AMOUNT | Reviewed or Approved Accrual Amount | ACE_DS_PERIOD_RVAPVD_ACCR_AMNT | | CURR | 23 |
| REVWD_APPRVD_AMOUNT_CUKEY | Currency of Accrual Item | ACE_DS_CURRENCY | | CUKY | 5 |
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 ACEDS_PERIODDATA
Other References