| 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 | * | MANDT | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 5 | ARGSP | Tax split | varbinary | 1 | 0 | RAW | | Yes | | PRSPL | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 8 | RGLTN | Regulation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | P05_RGLTN | Allow NULL? |
| 9 | NARGS | Status of the cluster table | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_NARG_STATUS | Allow NULL? |
| 10 | ESTAT | Entitlement Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_ENT_STATUS | Allow NULL? |
| 11 | RSTAT | Reservation Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_RES_STATUS | Allow NULL? |
| 12 | PSTAT | Payment Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_PAY_STATUS | Allow NULL? |
| 13 | RPERB | Begin period of regulation | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | P05_RPERB_YYYYPP | Allow NULL? |
| 14 | RPERE | Last period of regulation | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | P05_RPERE_YYYYPP | Allow NULL? |
| 15 | FPPER | Future Payment Period | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | P05_FPPER | Allow NULL? |
| 16 | RFPWT | Wagetype containing future payment amount | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P05_RFPWT | Allow NULL? |
| 17 | RFAMT | Future amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | P05_RFAMT | |
| 18 | RKOFC | Calculation Component of Regulation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P05_RKOFC | Allow NULL? |
| 19 | RGLTC | Calculation Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P05_RGLTC | Allow NULL? |
| 20 | CTYPE | Calculation Type | char | 1 | 0 | CHAR | (N' ') | Yes | | P05_CTYPE | Allow NULL? |
| 21 | RGPCT | Replacement of Calculation Percentage for Entitlement | decimal | 7 | 4 | DEC | ((0)) | Yes | | P05_RGPCT | |
| 22 | RGBAS | Replacement of Basis Amount for Entitlement | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RGBAS | |
| 23 | RCBAS | Replacement of Cumulative Entitlement | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RCBAS | |
| 24 | RGPTP | Replacement of Part Time Percentage for Entitlement | decimal | 5 | 2 | DEC | ((0)) | Yes | | P05_RGPTP | |
| 25 | RCPTP | Replacement of Cumulative Part-Time Percentage for Pay-out | decimal | 7 | 2 | DEC | ((0)) | Yes | | P05_RCPTP | |
| 26 | RPAMT | Replacement of Payment for Regulation | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RPAMT | |
| 27 | RGAMT | Replacement Amount for Entitlement | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RGAMT | |
| 28 | RRPCT | Replacement of Calculation Percentage for Reservation | decimal | 7 | 4 | DEC | ((0)) | Yes | | P05_RRPCT | |
| 29 | RRPTP | Replacement of Part Time Percentage for Reservation | decimal | 5 | 2 | DEC | ((0)) | Yes | | P05_RRPTP | |
| 30 | RRBAS | Replacement of Basis Amount for Reservation | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RRBAS | |
| 31 | RRAMT | Replacement Amount for Reservation | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RRAMT | |
| 32 | RPPCT | Replacement of Calculation Percentage for Pay-out | decimal | 7 | 4 | DEC | ((0)) | Yes | | P05_RPPCT | |
| 33 | RPPTP | Replacement of Part Time Percentage for Pay-out | decimal | 5 | 2 | DEC | ((0)) | Yes | | P05_RPPTP | |
| 34 | RPBAS | Replacement of Basis Amount for Pay-out | decimal | 13 | 2 | CURR | ((0)) | Yes | | P05_RPBAS | |
