| 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 | APPL | Commission Application (ICM) | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | CACSAPPL | Allow NULL? |
| 3 | VARNAME | Name of Variant | nvarchar | 30 | 0 | CHAR | (N' ') | No | | CACSDETVARIANTNAME | Allow NULL? |
| 4 | ERNAM | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACSCHUSR | Allow NULL? |
| 5 | ERDAT | Date on Which Object was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CACSCHGDAT | Allow NULL? |
| 6 | ERZZT | Time at Which Object was Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CACSCHGTIM | Allow NULL? |
| 7 | VARDESC | Variant Description | ntext | 1073741823 | 0 | | | Yes | | CACSDETVARIANTDESC | |
| 8 | ENTRY_POINT | Entry Point | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CACSDETENTRYPOINT | Allow NULL? |
| 9 | SELTAB | Name of Selection Table for Commission Contract | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CACS_SELTAB | Allow NULL? |
| 10 | OLD_DET | Boolean Variables (X=true, space=false) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN_FLG | Allow NULL? |
| 11 | NEW_DET | Boolean Variables (X=true, space=false) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN_FLG | Allow NULL? |
| 12 | BUSI_NOW | Boolean Variables (X=true, space=false) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN_FLG | Allow NULL? |
| 13 | BUSI_OTHER | Boolean Variables (X=true, space=false) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN_FLG | Allow NULL? |
| 14 | BUSI | Effective Validity (Time Stamp YYYY.MM.DD hh:mm:ss) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSBUSITIME | Allow NULL? |
| 15 | TECH_NOW | Boolean Variables (X=true, space=false) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN_FLG | Allow NULL? |
| 16 | TECH_OTHER | Boolean Variables (X=true, space=false) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN_FLG | Allow NULL? |
| 17 | TECH | Technical Validity (Time Stamp: YYYY.MM.DD hh:mm:ss) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSTECHTIME | Allow NULL? |
| 18 | FLT_CTRT_TYPE | Filter of Commission Contract Type for Determination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CACSDETFLTCTRTTYPE | Allow NULL? |
| 19 | FLT_CTRTST_ID | Filter of Standard Commission Contract for Determination | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACSDETFLTCTRTSTID | Allow NULL? |
| 20 | COMBTP_ID | Number of Characteristics Combination Type | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACS_COMBTP_ID | Allow NULL? |
| 21 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID | Allow NULL? |
| 22 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTST_ID | Allow NULL? |
| 23 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CACS_AGR_TYP | Allow NULL? |
| 24 | STCAGR_ID | Standard Agreement Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACS_STCAGR_ID | Allow NULL? |
| 25 | BUSOBJ_TYPE | Business Object Category that Triggers Commission | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | CACSBUSOBJTYP | Allow NULL? |
| 26 | SELRULE_ID | Identification of Selection Rule in Remuneration Clearing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSSELRULEID | Allow NULL? |
| 27 | RGOAID | FOA Connection: Rule Group for Object Assignment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CACSRGOAID | Allow NULL? |
| 28 | STMTYPE_ID | Identification of Settlement Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACS_STMTYPE_ID | Allow NULL? |
| 29 | OATYID | FOA: ID of Assignment Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACSOATYID | Allow NULL? |
| 30 | OARUID | FOA: ID of Assignment Rule | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACSOARUID | Allow NULL? |
| 31 | REMTYPE | Remuneration Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACSREM | Allow NULL? |
| 32 | BOBJTYPE | Credentialing: Object Types | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CRDOBJTYPE | Allow NULL? |
| 33 | EVENTTYPE | Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CRDEVENTTYPE | Allow NULL? |
| 34 | CONTEXT | Context of Credentials Check | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | CRDCONTEXT | Allow NULL? |
| 35 | SELGRIDVARIANT | Layout | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SLIS_VARI | Allow NULL? |
