| 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 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PA0003 | PERSNO | Allow NULL? |
| 3 | SUBTY | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SUBTY | Allow NULL? |
| 4 | OBJPS | Object Identification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | OBJPS | Allow NULL? |
| 5 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | CHAR | (N' ') | No | | SPRPS | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SEQNR | Allow NULL? |
| 9 | AEDTM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 10 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 11 | HISTO | Historical Record Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | HISTO | Allow NULL? |
| 12 | ITXEX | Text Exists for Infotype | char | 1 | 0 | CHAR | (N' ') | Yes | | ITXEX | Allow NULL? |
| 13 | REFEX | Reference Fields Exist (Primary/Secondary Costs) | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFEX | Allow NULL? |
| 14 | ORDEX | Confirmation Fields Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | ORDEX | Allow NULL? |
| 15 | ITBLD | Infotype Screen Control | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ITBLD | Allow NULL? |
| 16 | PREAS | Reason for Changing Master Data | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T530E | PREAS | Allow NULL? |
| 17 | FLAG1 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 18 | FLAG2 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 19 | FLAG3 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 20 | FLAG4 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 21 | RESE1 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUSED2 | Allow NULL? |
| 22 | RESE2 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUSED2 | Allow NULL? |
| 23 | GRPVL | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PCCE_GPVAL | Allow NULL? |
| 24 | KGBVN | First Name of Child Allowance Beneficiary | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_KGBVN | Allow NULL? |
| 25 | KGBNN | Last Name of Child Allowance Beneficiary | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_KGBNN | Allow NULL? |
| 26 | KIGNR | Child Allowance Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P01W_KIGNR | Allow NULL? |
| 27 | BEKNZ | Processing Indicator | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P01W_BEKNZ | Allow NULL? |
| 28 | ABDAU | Training Expected to Last Until | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_ABDAU | Allow NULL? |
| 29 | AVDAT | Date of Training Contract | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AVDAT | Allow NULL? |
| 30 | AVEIN | Training Contract: Date of Entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AVEIN | Allow NULL? |
| 31 | AVEIB | Training Contract: Date of Application | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AVEIB | Allow NULL? |
| 32 | AVEWO | Training Amount: City of Application | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_AVEWO | Allow NULL? |
| 33 | REGNR | Registration Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P01W_REGNR | Allow NULL? |
| 34 | SUERG | Written Notification of Exam Result | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_SUERG | Allow NULL? |
| 35 | VLAVH | Extension of Training Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_VLAVH | Allow NULL? |
| 36 | AVEND | End Date of Training Relationship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AVEND | Allow NULL? |
| 37 | ABPRF | Final Exam Passed? | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_ABPRF | Allow NULL? |
| 38 | APDAT | Date of Audit | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_APDAT | Allow NULL? |
| 39 | UNAAV | Transfer to Work Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_UNAAV | Allow NULL? |
| 40 | AVBEG | Start of Work Relationship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AVBEG | Allow NULL? |
| 41 | BRTUN | Gross Remuneration upon Transfer to Work Relationship | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_BRTUN | |
| 42 | PAULO | Wage Taxed at a Flat Rate Acc. to Sections 40 and 40a EStG | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_PAULO | Allow NULL? |
| 43 | ARTLE | Type of Flat-Rate Benefit | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | P01W_ARTLE | Allow NULL? |
| 44 | PDAT1 | Calendar Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01W_PDATE | Allow NULL? |
| 45 | PBET1 | Amount of Flat-Rate Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_PBETR | |
| 46 | PDAT2 | Calendar Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01W_PDATE | Allow NULL? |
| 47 | PBET2 | Amount of Flat-Rate Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_PBETR | |
| 48 | PDAT3 | Calendar Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01W_PDATE | Allow NULL? |
| 49 | PBET3 | Amount of Flat-Rate Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_PBETR | |
| 50 | PDAT4 | Calendar Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01W_PDATE | Allow NULL? |
| 51 | PBET4 | Amount of Flat-Rate Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_PBETR | |
| 52 | PDAT5 | Calendar Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01W_PDATE | Allow NULL? |
| 53 | PBET5 | Amount of Flat-Rate Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_PBETR | |
| 54 | PDAT6 | Calendar Year | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P01W_PDATE | Allow NULL? |
| 55 | PBET6 | Amount of Flat-Rate Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_PBETR | |
| 56 | NBET1 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 57 | NDAT1 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 58 | NBET2 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 59 | NDAT2 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 60 | NBET3 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 61 | NDAT3 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 62 | NBET4 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 63 | NDAT4 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 64 | NBET5 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 65 | NDAT5 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 66 | NBET6 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 67 | NDAT6 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 68 | NBET7 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 69 | NDAT7 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 70 | NBET8 | Amount of Irregularly Paid Benefit | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_NBETX | |
| 71 | NDAT8 | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_NDATX | Allow NULL? |
| 72 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | T500W | P01W_WAERS | Allow NULL? |
| 73 | ARTNL | Type of Irregular Benefit | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | P01W_ARTNL | Allow NULL? |
| 74 | TLZEI | Full-Time Employment upon Transfer to Work Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_TLZEI | Allow NULL? |
| 75 | AUEND | End of Training Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_AUEND | Allow NULL? |
