| 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 | T000 | MANDT | Allow NULL? |
| 2 | CAREA | Compensation area | nvarchar | 2 | 0 | CHAR | (N' ') | No | T71C3 | CMP_AREA | Allow NULL? |
| 3 | MATRIX | Guideline Matrix | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CMP_MATRIX | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 6 | D1IND | Indicator for dimension 1 of compensation matrix | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_D1_IND | Allow NULL? |
| 7 | DIMS1 | Dimension for compensation matrix | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T71GD | CMP_DIMENSION | Allow NULL? |
| 8 | D2IND | Indicator for dimension 2 of compensation matrix | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_D2_IND | Allow NULL? |
| 9 | DIMS2 | Dimension for compensation matrix | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T71GD | CMP_DIMENSION | Allow NULL? |
| 10 | D3IND | Indicator for dimension 3 of compensation matrx | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_D3_IND | Allow NULL? |
| 11 | DIMS3 | Dimension for compensation matrix | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T71GD | CMP_DIMENSION | Allow NULL? |
| 12 | VTYPE | Calculation Variant | char | 1 | 0 | CHAR | (N' ') | Yes | T71GT | CMP_VTYPE | Allow NULL? |
| 13 | CURCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CURCY | Allow NULL? |
| 14 | UNIT | Time/Measurement Unit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | PT_ZEINH | Allow NULL? |
| 15 | DAMTI | Default amount is relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_DAMNT_IND | Allow NULL? |
| 16 | LAMTI | Input minimum amount | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_LOAMT_IND | Allow NULL? |
| 17 | HAMTI | Input maximum amount | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_HIAMT_IND | Allow NULL? |
| 18 | EAMTI | Message type for amount range | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_EAMNT_IND | Allow NULL? |
| 19 | DPRCI | Default percentage is relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_DPRCT_IND | Allow NULL? |
| 20 | LPRCI | Input minimum percentage | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_LPRCT_IND | Allow NULL? |
| 21 | HPRCI | Input maximum percentage | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_HPRCT_IND | Allow NULL? |
| 22 | EPRCI | Message type for percentage range | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_EPRCT_IND | Allow NULL? |
| 23 | DNUMI | Default number is relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_DNUMB_IND | Allow NULL? |
| 24 | LNUMI | Input minimum number | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_LNUMB_IND | Allow NULL? |
| 25 | HNUMI | Input maximum number | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_HNUMB_IND | Allow NULL? |
| 26 | ENUMI | Message type for number range | char | 1 | 0 | CHAR | (N' ') | Yes | | CMP_ENUMB_IND | Allow NULL? |
