| 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 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 3 | AVRULE | Calculation rule for averages | nvarchar | 4 | 0 | CHAR | (N' ') | No | | AVRULE | 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 | RELRULE | Relevance rule averages | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T51AV_R | RELRULE | Allow NULL? |
| 7 | CUMRULE | Cumulation rule for bases for calculating average values | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T51AV_B | CUMRULE | Allow NULL? |
| 8 | ENDRULE | Rule for final processing of average calculation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T51AV_E | ENDRULE | Allow NULL? |
| 9 | COMPRULE | Rule for comparison with wage types | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T51AV_W | COMPRULE | Allow NULL? |
| 10 | RELNUMP | Number of relevant periods | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RELNUMP | Allow NULL? |
| 11 | RELUNIT | Time unit for average periods | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AVER_UNIT | Allow NULL? |
| 12 | MAXNUMP | Maximum number of periods included | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | MAXNUMP | Allow NULL? |
| 13 | MAXUNIT | Time unit for average periods | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AVER_UNIT | Allow NULL? |
| 14 | CURRENT_PER | Also take current period into account | char | 1 | 0 | CHAR | (N' ') | Yes | | CURRENT_PER | Allow NULL? |
| 15 | FROZEN | Freeze average value | char | 1 | 0 | CHAR | (N' ') | Yes | | FROZEN | Allow NULL? |
| 16 | WGTYP_AV | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LGART | Allow NULL? |
| 17 | NUMBER_AV | Hourly Average (Number Average) | char | 1 | 0 | CHAR | (N' ') | Yes | | NUMBER_AV | Allow NULL? |