| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | COMP | Accrual Engine Application Component | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ACE_COMP | Allow NULL? |
| 3 | FUNCTYPE | Function Type | char | 1 | 0 | CHAR | (N' ') | Yes | | ACE_FUNCTYPE | Allow NULL? |
| 4 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 5 | SSTRUC_CO | Accrual Engine: Account Determination Structure Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ACE_ACDT_SSTRUC_NAME | Allow NULL? |
| 6 | REFKEY_TAB_NAME | Table Name for Component-Specific External References | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ACE_REFKEY_COMP_TABNAME | Allow NULL? |
| 7 | REF_KEY_FIELDS | Structure with RefKey Fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ACE_REF_KEY_FIELD_STRUC | Allow NULL? |
| 8 | REF_SUBKEY_FLDS | Structure with RefSubKey Fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ACE_REF_SUBKEY_FIELD_STRUC | Allow NULL? |
| 9 | PARAM_FIELDS | Structure with Fields (Entries) in Table ACEDSOP | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ACE_PARAMETER_FIELD_STRUC | Allow NULL? |
| 10 | ALLOWED_ASSGMTS | Structure with Permitted Account Assignment Fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ACE_ALLOWED_ASSIGNMENTS | Allow NULL? |
| 11 | TREE_STRUCTURE | Structure of Tree in Manual Data Maintenance Transaction | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ACE_TREE_STRUCTURE | Allow NULL? |
| 12 | RESULT_LIST_PP | Periodic Posting: Structure of the Results List | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ACE_STRUC_PERPOST_RESULT_LIST | Allow NULL? |
| 13 | RESULT_LIST_AP | Preparation for Archiving: Structure of the Result List | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ACE_STRUC_ARCHPREP_RESULT_LIST | Allow NULL? |
| 14 | BW_EXTRACT_CALC | Structure for BW Extraction of Calculated Accrual Values | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ACE_BW_EXTRAKT_STRUC_CALC | Allow NULL? |
| 15 | BW_EXTRACT_POST | Structure for BW Extraction of Posted Accrual Values | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ACE_BW_EXTRAKT_STRUC_POST | Allow NULL? |
| 16 | TCODEPFIX | Prefix of Transactions for a Component | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ACE_TRANSACT_PREFIX | Allow NULL? |
| 17 | NRRANGENR | Number Range Interval Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ACE_NRNR | Allow NULL? |
| 18 | MANUAL_CHANGE | Indicator: Manual Change/Creation of Data Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | ACE_MANUAL_DATA_MAINTAINANCE | Allow NULL? |
| 19 | ENVIRONMENT | Environment in Which Accrual Engine is Used: ERP or BusAcc. | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ACE_ENVIRONMENT | Allow NULL? |
| 20 | REF_KEY_DEL | Indicator: Automatically Delete Data from Comp.-Spec. Table | char | 1 | 0 | CHAR | (N' ') | Yes | | ACE_REFKEY_COMP_TAB_DEL | Allow NULL? |
