| 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 | TRFAR | Pay scale type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T510A | TRFAR | Allow NULL? |
| 4 | FKTMO | Function Model for Public Sector | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01_OFKTM | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | TRFDF | Pay Scale Definition for Leave/Sick Pay Premium (Pub. Sect.) | nvarchar | 2 | 0 | CHAR | (N' ') | No | | P01_OTRFDF | Allow NULL? |
| 8 | LGAMO | Wage Type Model for Leave and Sick Pay Premium | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D89 | P01_OLGAMO | Allow NULL? |
| 9 | LGAM1 | Alternative Wage Type Model for Leave and Sick Pay Premium | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D89 | P01_OLGAM1 | Allow NULL? |
| 10 | NEUMO | Model: Events at Start of Calc. Per. fr Leave/Sick Pay Prem. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5D92 | P01_ONEUMO | Allow NULL? |
| 11 | DYNAS | Dynamic Modification of Premium for Standard Pay Increase | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_ODYNAS | Allow NULL? |
| 12 | FAANZ | Fixing of Premium Rate After Recalculation (Number) | decimal | 3 | 0 | DEC | ((0)) | Yes | | P01_OFAANZ | |
| 13 | FAEIN | Fixing of Premium Rate After Recalculation (Unit) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | P01_OFAEIN | Allow NULL? |
| 14 | BEWVM | Valuation of Absence with Premium for Previous Month | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_OBEWVM | Allow NULL? |