| 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 | MOBBV | Valuation Basis According to Calculation Method | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01C_MOBBV | Allow NULL? |
| 3 | GRUAN | Grouping for Valuation Basis | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5DC7 | P01C_GRUAN | 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 | ZRMKZ | Control Period for Wage Type Selection | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_ZRMKZ | Allow NULL? |
| 7 | ZRUMR | Conversion of Basic Value | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_ZRUMR | Allow NULL? |
| 8 | ZRHOR | Projection of Basic Value to 100% | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_ZRHOR | Allow NULL? |
| 9 | ZWPER | Number of Months in Period for Calculation of Base | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P01C_ZWPER | Allow NULL? |
| 10 | KZDAR | Type of Period Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_KZDAR | Allow NULL? |
| 11 | CHKRD | Check Relevant Data Against Valuation End | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_CHKRD | Allow NULL? |
| 12 | LUECK | Indicator: Wage Type May Occur with Gaps | char | 1 | 0 | CHAR | (N' ') | Yes | | P01C_LUECK | Allow NULL? |
| 13 | ZWEND | End Date of Period for Calculation of Basis | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P01C_ZWEND | Allow NULL? |
| 14 | DAEDS | Date Type for Different Period End | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | P01C_DAEDS | Allow NULL? |
| 15 | KZUEX | Indicator for Customer Exit | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P01C_KZUEX | Allow NULL? |
| 16 | FBSVB | Function for Subsequent Processing of Basic Value | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5DWY | P01C_FBSVB | Allow NULL? |
| 17 | MINBA | Feature for Constant for Basic Value Lower Threshold | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P01C_MINBA | Allow NULL? |
| 18 | MAXBA | Feature for Constant for Basic Value Upper Threshold | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P01C_MAXBA | Allow NULL? |
| 19 | ZWBEG | Start Date of Period for Calculation of Basis | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P01C_ZWBEG | Allow NULL? |
