| 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 | GROUPING_REASON | Grouping Reason for Personnel Assignments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PCCE_GPRSN | Allow NULL? |
| 6 | GROUPING_VALUE | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PCCE_GPVAL | Allow NULL? |
| 7 | SEQNO | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | CDSEQ | Allow NULL? |
| 8 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGART | Allow NULL? |
| 9 | FPPER | For-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | FAPER | Allow NULL? |
| 10 | IPERI | In-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | IPERI | Allow NULL? |
| 11 | BONDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BONDT | Allow NULL? |
| 12 | CKDAT | Check Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CHKDT | Allow NULL? |
| 13 | CBDAT | Check date on which remaining balance is moved | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HRCCE_CHKDT_REMBAL_MOV | Allow NULL? |
| 14 | REPYR | Repayment from prior year | char | 1 | 0 | CHAR | (N' ') | Yes | | HRCCE_REPAYMENT_FROM_PRIOR_YR | Allow NULL? |
| 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 16 | PAYTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 17 | PAYID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 18 | JUPER | Legal Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JUPER | Allow NULL? |
| 19 | OVHRS | HR payroll: Number | decimal | 15 | 2 | DEC | ((0)) | Yes | | PRANZ | |
| 20 | OBHRS | HR payroll: Number | decimal | 15 | 2 | DEC | ((0)) | Yes | | PRANZ | |
| 21 | OVAMT | Overpayment in original payroll run | decimal | 15 | 2 | CURR | ((0)) | Yes | | HRCCE_ORG_OVERPAY_AMT | |
| 22 | OBAMT | Remaining overpayment amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | HRCCE_BAL_OVERPAY | |
| 23 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 24 | INDRI | Indicator to differentiate rules framework and IT0909 | char | 1 | 0 | CHAR | (N' ') | Yes | | INDRI | Allow NULL? |
| 25 | REAMT | Amount Recovered in the current period | decimal | 15 | 2 | CURR | ((0)) | Yes | | HRCCE_CURR_REC_AMT | |
| 26 | PFGRV | Forgiven amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | HRCCE_FORGIVEN_AMT | |
| 27 | TFGRV | Total forgiveness of claims | char | 1 | 0 | CHAR | (N' ') | Yes | | HRCCE_TOTAL_FORGIVENESS | Allow NULL? |
| 28 | PERNR | Personnel Assignment | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PCCE_PERNR | Allow NULL? |
| 29 | SUBTY | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SUBTY | Allow NULL? |
| 30 | OBJPS | Object Identification | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OBJPS | Allow NULL? |
| 31 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | SPRPS | Allow NULL? |
| 32 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 33 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 34 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SEQNR | Allow NULL? |
| 35 | APZNR | PC205 assignment | varbinary | 1 | 0 | RAW | | Yes | | APZNR | |
| 36 | C1ZNR | Pointer to cost accounting | varbinary | 2 | 0 | RAW | | Yes | | C1ZNO | |
| 37 | IPEND | End of payroll period (IN period) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IPEND | Allow NULL? |
| 38 | INPTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 39 | INPID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 40 | OSEQN | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | CDSEQ | Allow NULL? |
