| 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 | SRCWT | XDEC: Cost Wage Type (source) | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_CST_LGART | Allow NULL? |
| 4 | RETRO | XDEC: Recalculation in each retro period (X or blank) | char | 1 | 0 | CHAR | (N' ') | No | | P_99_DEC_CST_RETRO | Allow NULL? |
| 5 | BASE | XDEC: Base Wage Type Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T7PBSDEC_WTGRP | P_99_DEC_BASE_GRP | Allow NULL? |
| 6 | PRIWT | XDEC: Primary Costed Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_PRI_LGART | Allow NULL? |
| 7 | SECB1 | XDEC: Secondary Wage Type Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T7PBSDEC_WTGRP | P_99_DEC_SEC_GRP | Allow NULL? |
| 8 | SECT1 | XDEC: Secondary Costed Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_SEC_LGART | Allow NULL? |
| 9 | SECB2 | XDEC: Secondary Wage Type Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T7PBSDEC_WTGRP | P_99_DEC_SEC_GRP | Allow NULL? |
| 10 | SECT2 | XDEC: Secondary Costed Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_SEC_LGART | Allow NULL? |
| 11 | SECB3 | XDEC: Secondary Wage Type Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T7PBSDEC_WTGRP | P_99_DEC_SEC_GRP | Allow NULL? |
| 12 | SECT3 | XDEC: Secondary Costed Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_SEC_LGART | Allow NULL? |
| 13 | SECB4 | XDEC: Secondary Wage Type Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T7PBSDEC_WTGRP | P_99_DEC_SEC_GRP | Allow NULL? |
| 14 | SECT4 | XDEC: Secondary Costed Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_SEC_LGART | Allow NULL? |
| 15 | SECB5 | XDEC: Secondary Wage Type Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T7PBSDEC_WTGRP | P_99_DEC_SEC_GRP | Allow NULL? |
| 16 | SECT5 | XDEC: Secondary Costed Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T512W | P_99_DEC_SEC_LGART | Allow NULL? |
| 17 | RCALC | XDEC: The cost is subject to Country Specific Recalculation | char | 1 | 0 | CHAR | (N' ') | No | | P_99_DEC_CST_RCALC | Allow NULL? |
| 18 | NATIO | XDEC: The cost is subject to Country Specific rules | char | 1 | 0 | CHAR | (N' ') | No | | P_99_DEC_CST_NATIO | Allow NULL? |