| 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 | BFSCR | Temporary Work Relationship Agreed in Writing | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_BFSCR | Allow NULL? |
| 25 | KDSCR | Written Notice | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDSCR | Allow NULL? |
| 26 | KDGAM | Termination On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_KDGAM | Allow NULL? |
| 27 | KDZUM | Termination On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_KDZUM | Allow NULL? |
| 28 | KDGRD | Termination Reason | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_KDGRD | Allow NULL? |
| 29 | KDZUS | Termination: Additional Agreements | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDZUS | Allow NULL? |
| 30 | KDWID | Termination: Contract Violations | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDWID | Allow NULL? |
| 31 | KDWIT | Termination: Due to Long-Term Weather Conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDWIT | Allow NULL? |
| 32 | KDSCH | Termination: Details | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P01W_KDSCH | Allow NULL? |
| 33 | KDONO | Ordinary Notice of Dismissal | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDONO | Allow NULL? |
| 34 | KDOGR | Exception Reasons for Termination | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_KDOGR | Allow NULL? |
| 35 | KDOAF | Ordinary Notice of Dismissal vs. Severance Pay | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDOAF | Allow NULL? |
| 36 | GEFUE | Managing Director | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_GEFUE | Allow NULL? |
| 37 | KPATL | Capital Amount | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01W_KPATL | |
| 38 | SPMIN | Blocking Minority | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_SPMIN | Allow NULL? |
| 39 | FBEG1 | Absence: From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_FEBEG | Allow NULL? |
| 40 | FEND1 | Absence To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_FEEND | Allow NULL? |
| 41 | FGRD1 | Absence Time: Reason | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_FEGRD | Allow NULL? |
| 42 | FBEG2 | Absence: From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_FEBEG | Allow NULL? |
| 43 | FEND2 | Absence To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_FEEND | Allow NULL? |
| 44 | FGRD2 | Absence Time: Reason | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_FEGRD | Allow NULL? |
| 45 | FBEG3 | Absence: From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_FEBEG | Allow NULL? |
| 46 | FEND3 | Absence To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_FEEND | Allow NULL? |
| 47 | FGRD3 | Absence Time: Reason | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_FEGRD | Allow NULL? |
| 48 | BVAVH | Work/Employment Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_BVAVH | Allow NULL? |
| 49 | BVAVG | Work/Employment Relationship: Reasons | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P01W_BVAVG | Allow NULL? |
| 50 | ABPRF | Final Exam Passed? | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_ABPRF | Allow NULL? |
| 51 | APDAT | Date of Audit | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_APDAT | Allow NULL? |
| 52 | HAURJ | Homeworker: Vacation per Year | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P01W_HAURJ | Allow NULL? |
| 53 | HAURB | Homeworker: Statemented Vacation Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P01W_HAURB | Allow NULL? |
| 54 | HAURE | Homeworker: Vacation Pay Included in Gross Remuneration | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_HAURE | |
| 55 | HABEZ | Homeworker: Payment Type/Vacation Pay | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_HABEZ | Allow NULL? |
| 56 | ABEG1 | Deviations - Weekly Working Time: Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AWBEG | Allow NULL? |
| 57 | AEND1 | Deviations - Weekly Working Time: End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AWEND | Allow NULL? |
| 58 | ASTW1 | Deviations - Weekly Working Time: Hours/Week | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01W_AWSTW | |
| 59 | ABEG2 | Deviations - Weekly Working Time: Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AWBEG | Allow NULL? |
| 60 | AEND2 | Deviations - Weekly Working Time: End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AWEND | Allow NULL? |
| 61 | ASTW2 | Deviations - Weekly Working Time: Hours/Week | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01W_AWSTW | |
| 62 | AZGRD | Deviations - Weekly Working Time: Reason | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P01W_AZGRD | Allow NULL? |
| 63 | VVOLL | Working Time of Comparable Full-Time Employee | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01W_VVOLL | |
| 64 | ZULEI | Entitlement to Other Benefits | char | 1 | 0 | NUMC | (N'0') | Yes | | P01W_ZULEI | Allow NULL? |
| 65 | ZLGRD | Reason for Unknown Supplementary Benefits | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_ZLGRD | Allow NULL? |
| 66 | WEIAE | Continued Remuneration | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_WEIAE | Allow NULL? |
| 67 | WADAT | Continued Remuneration To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_WADAT | Allow NULL? |
| 68 | VRUGD | Early Retirement Pension | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_VRUGD | Allow NULL? |
| 69 | VRBEG | Early Retirement Pension: Start of Payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_VRBEG | Allow NULL? |
| 70 | VRPRZ | Early Retirement Pension: Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01W_VRPRZ | |
| 71 | HWAA1 | Further Notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | P01W_WHWAA | Allow NULL? |
| 72 | HWAA2 | Further Notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | P01W_WHWAA | Allow NULL? |
| 73 | HWAA3 | Further Notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | P01W_WHWAA | Allow NULL? |
| 74 | HWAA4 | Further Notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | P01W_WHWAA | Allow NULL? |
| 75 | ASNAM | Applicant: Last Name | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | P01W_ASNAM | Allow NULL? |
| 76 | ASVNM | Applicant: First Name | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | P01W_ASVNM | Allow NULL? |
| 77 | ASKNR | Applicant: Customer Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | P01W_ASKNR | Allow NULL? |
| 78 | ASARA | Federal Employment Office - Branch Office | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P01W_ASARA | Allow NULL? |
| 79 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | T500W | P01W_WAERS | Allow NULL? |
| 80 | TAEUU | HR-DBW: Standard Pay upon Transfer to Work Relationship | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_TAEUU | |
| 81 | TWZUU | HR-DBW: Working Time upon Transfer to Work Relationship | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01W_TWZUU | |
| 82 | TEZUU | HR-DBW: NrPs upon Transfer to Work Relationship | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01W_TEZUU | |
| 83 | BBKDG | Dismissal for Operational Reasons | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_BBKDB | Allow NULL? |
| 84 | KDGSK | Claim for Unlawful Dismissal | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_KDGSK | Allow NULL? |
| 85 | DATFR | Date of Temporary Work Relationship | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_DATFR | Allow NULL? |
| 86 | NRBDG | HR-DBW: Number of Cohabitation | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | P01W_NRBDG | Allow NULL? |
| 87 | CSBFA | HR-DBW: Confirmation by Clearing Center of BfA | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_CSBFA | Allow NULL? |
| 88 | QPROJ | HR-DBW: Participation in Qualification Project | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_QPROJ | Allow NULL? |
| 89 | AMDAT | Date of Written Warning | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AMDAT | Allow NULL? |
| 90 | KDGZS | Communication Type of Termination | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_KDGSZ | Allow NULL? |
| 91 | KDGZG | HR-DBW: Arrival of Termination | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_KDGZG | Allow NULL? |
| 92 | AVVRL | Extension of Employment Contract | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01W_AVVRL | Allow NULL? |
| 93 | MIND6 | HR-DBW: Fixed-Term Employment for at Least 6 Months | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_MIND6 | Allow NULL? |
| 94 | WBSCH | HR-DBW: Possibility of Continued Employment | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_WBSCH | Allow NULL? |
| 95 | ABF05 | Amount of Severance Pay | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_ABF05 | Allow NULL? |
| 96 | ABFGR | HR-DBW: Reason | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_ABFGR | Allow NULL? |
| 97 | BVAVZ | Work Relationship and Employment Relationship: Period | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P01W_BVAVZ | Allow NULL? |
| 98 | UNBET | HR-DBW: Equity Holding | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_UNBET | Allow NULL? |
| 99 | AUFBE | Termination Contract: Ben. Even in Event of Termin. | char | 1 | 0 | CHAR | (N' ') | Yes | | P01W_AUFBE | Allow NULL? |
| 100 | KBNAM | Name of Person Entitled to Child Allowance | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_KBNAM | Allow NULL? |
| 101 | KBVNM | First Name of Person Entitled to Child Allowance | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01W_KBVNM | Allow NULL? |
| 102 | KGNUM | Child Allowance Number | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | P01W_KGNUM | Allow NULL? |
| 103 | ADRS1 | Address line | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | LINES | Allow NULL? |
| 104 | ADRS2 | Address line | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | LINES | Allow NULL? |
| 105 | ADRS3 | Address line | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | LINES | Allow NULL? |
| 106 | FMEZ1 | Month in Which Non-Recurring Payment Is Due | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P01_FLMEZ | Allow NULL? |
| 107 | FJEZ1 | Year in Which Non-Recurring Payment is Due | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P01_FLJEZ | Allow NULL? |
| 108 | EART1 | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512T | LGART | Allow NULL? |
| 109 | FMEZ2 | Month in Which Non-Recurring Payment Is Due | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P01_FLMEZ | Allow NULL? |
| 110 | FJEZ2 | Year in Which Non-Recurring Payment is Due | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P01_FLJEZ | Allow NULL? |
| 111 | EART2 | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512T | LGART | Allow NULL? |
| 112 | HKDAM | Employer Would Have Terminated Work Relationship On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_HKDAM | Allow NULL? |
| 113 | HKDZM | ER Would Have Terminated Work Relationship Starting From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_HKDZM | Allow NULL? |
| 114 | HKDBB | ER Would Have Terminated Work Relationship: Operat. Reasons | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_HKDBB | Allow NULL? |
| 115 | HKDVW | ER Would Have Terminated Wrk Rel.:Behavior Violates Contract | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_HKDVW | Allow NULL? |
| 116 | TFHOE | Activity to Be Continued: Amount of Secondary Income | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_TFHOE | Allow NULL? |
| 117 | TFBTG | Activity to Be Continued: Amount of Secondary Income | decimal | 13 | 2 | CURR | ((0)) | Yes | | P01_TFBTG | |
| 118 | TFZTR | Activity to Be Continued: Period for Amount | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_TFZTR | Allow NULL? |
| 119 | HAAUS | Working from Home: Output Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_HAAUS | Allow NULL? |
| 120 | HAABL | Working from Home: Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_HAABL | Allow NULL? |
| 121 | KUGJN | Reduced Hours Compensation at Other Company | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_KUGJN | Allow NULL? |
| 122 | KUGFA | Reduced Hours Compensation at Other Company: Name, HQ | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P01_KUGFA | Allow NULL? |
| 123 | BSBEG | Start of Agreement to Preserve Employment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_BSBEG | Allow NULL? |
| 124 | BSEND | End of Agreement to Preserve Employment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_BSEND | Allow NULL? |
| 125 | BSAZT | Working Time with No Agreement to Preserve Employment | decimal | 5 | 2 | DEC | ((0)) | Yes | | P01_BSAZT | |
| 126 | BTAUS | Company Training Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_BTAUS | Allow NULL? |
