| 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 | KONNR | Individual PF account number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | P02K_KONNR | Allow NULL? |
| 3 | BUDAT | Posting date of a PF posting | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | P02K_BUDAT | Allow NULL? |
| 4 | SEQNR | Sequence number of posting per day | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | P02K_SEQNR | Allow NULL? |
| 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5CA2 | P02_VALTY | Allow NULL? |
| 6 | VALUE | Value within processing control | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | P02_VAL | Allow NULL? |
| 7 | VADAT | Value date for PF posting | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P02K_VADAT | Allow NULL? |
| 8 | PABRP | Payroll Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PABRP | Allow NULL? |
| 9 | PABRJ | Payroll Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PABRJ | Allow NULL? |
| 10 | EXPFL | Indicator: Open posting | char | 1 | 0 | CHAR | (N' ') | Yes | | P02K_EXPFL | Allow NULL? |
| 11 | ORGIN | Origin of a PF posting | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P02K_ORGIN | Allow NULL? |
| 12 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 13 | PERNR | Personnel number for PF posting | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P02K_PERNR | Allow NULL? |
| 14 | BUNUM | | nvarchar | 10 | 0 | | (N'0000000000') | Yes | | | Allow NULL? |
| 15 | STOFL | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 16 | CHDAT | Change Date of a PF Posting Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P02K_CHDAT | Allow NULL? |
| 17 | FIFLG | Indicator: Posting Transfer to FI Open | char | 1 | 0 | CHAR | (N' ') | Yes | | P02K_FIFLG | Allow NULL? |
| 18 | RUNID | Number of Posting Run | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | P_EVNUM | Allow NULL? |
| 19 | FIBUK | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 20 | SEQST | Sequence Number of Original Posting | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | HRPFD00_SEQST | Allow NULL? |
