| 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 | MODSZ | Modifier for special payment | nvarchar | 4 | 0 | CHAR | (N' ') | No | | MDSZ1 | Allow NULL? |
| 4 | LGART | Wage type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | LGAR1 | 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 | SZVAR | Special payment variant | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SZVAR | Allow NULL? |
| 8 | VERIV | Type of entitlement period | char | 1 | 0 | CHAR | (N' ') | Yes | | VERIV | Allow NULL? |
| 9 | BEGVR | Begin of entitlement period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BEGVR | Allow NULL? |
| 10 | DAUVR | Duration of entitlement period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DAUVR | Allow NULL? |
| 11 | AUSZL | Payment I | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AUSZL | Allow NULL? |
| 12 | WZTAZ | Waiting period in days for payment I | decimal | 4 | 0 | DEC | ((0)) | Yes | | WZTAZ | |
| 13 | RESTZ | Payment II | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | RESTZ | Allow NULL? |
| 14 | WZTRZ | Waiting period in days for payment II | decimal | 4 | 0 | DEC | ((0)) | Yes | | WZTRZ | |
| 15 | WZTSZ | Waiting period in days for payment | decimal | 3 | 0 | DEC | ((0)) | Yes | | WZTSZ | |
| 16 | VORGB | Advance condition | char | 1 | 0 | CHAR | (N' ') | Yes | | VORGB | Allow NULL? |
| 17 | JABGR | Delimitation of annual waiting period for new employees | char | 1 | 0 | CHAR | (N' ') | Yes | | JABGR | Allow NULL? |
| 18 | RUND1 | Calculation basis for entitlement | char | 1 | 0 | CHAR | (N' ') | Yes | | RUND1 | Allow NULL? |
| 19 | RUND2 | Rounding provision | char | 1 | 0 | CHAR | (N' ') | Yes | | RUND2 | Allow NULL? |
| 20 | SONDE | Special payment provision | char | 1 | 0 | CHAR | (N' ') | Yes | | SONDE | Allow NULL? |
| 21 | B530C | Modifier for exception requirements | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T530B | B530C | Allow NULL? |
| 22 | D530C | Modifier for factors related to length of service | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T530D | D530C | Allow NULL? |
| 23 | L530C | 3-Byte field | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CHAR3 | Allow NULL? |
| 24 | T530D | NN | char | 1 | 0 | CHAR | (N' ') | Yes | | T530D_D | Allow NULL? |
| 25 | DATAR | Date type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | DATAR | Allow NULL? |
| 26 | BAAAZ | Amount-Based Adjustment I | char | 1 | 0 | CHAR | (N' ') | Yes | | BAAAZ | Allow NULL? |
| 27 | BAVRZ | Amount-Based Adjustment II | char | 1 | 0 | CHAR | (N' ') | Yes | | BAVRZ | Allow NULL? |
| 28 | BAEVP | Amount-based adjustment at end of clearing period | char | 1 | 0 | CHAR | (N' ') | Yes | | BAEVP | Allow NULL? |
| 29 | SOLGA | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 30 | PKSYM | Char 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CHAR20 | Allow NULL? |
| 31 | BWGR1 | Technical standard wage type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | BWGR1 | Allow NULL? |
| 32 | BWGR2 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 33 | LGAR2 | NN | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | LGAR2 | Allow NULL? |
| 34 | SOLG2 | NN | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SOLG2 | Allow NULL? |
| 35 | T530L | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 36 | BWGG1 | Valuation I | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BWGG1 | Allow NULL? |
| 37 | BWGG2 | Valuation II | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BWGG2 | Allow NULL? |
