| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | SUBTY | Subtype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | HISTO | Historical Record Flag | char | 1 | 0 | | | | Allow NULL? |
| 12 | ITXEX | Text Exists for Infotype | char | 1 | 0 | | | | Allow NULL? |
| 13 | REFEX | Reference Fields Exist (Primary/Secondary Costs) | char | 1 | 0 | | | | Allow NULL? |
| 14 | ORDEX | Confirmation Fields Exist | char | 1 | 0 | | | | Allow NULL? |
| 15 | ITBLD | Infotype Screen Control | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | PREAS | Reason for Changing Master Data | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | FLAG1 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 18 | FLAG2 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 19 | FLAG3 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 20 | FLAG4 | Reserved Field/Unused Field | char | 1 | 0 | | | | Allow NULL? |
| 21 | RESE1 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | RESE2 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | GRPVL | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | SART0 | ELDA Record Type (Electronic Data Transfer) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | VENT0 | Continued Payment of Full Remuneration Until | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | STATU | Status Information for ELDA | char | 1 | 0 | | | | Allow NULL? |
| 27 | DGNR0 | Contribution Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | DGNA0 | Employer's Name | nvarchar | 70 | 0 | | | | Allow NULL? |
| 29 | DTEL0 | Employer's Telephone Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 30 | ASVGR | SI group | char | 1 | 0 | | | | Allow NULL? |
| 31 | AUSVA | Social Insurance Body | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | AUSVL | 1st Part of SI Number (Sequential Number) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | AUSVG | 2nd Part of SI Number (Birth Date) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | GEBD0 | Date of Birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | FANA0 | Family Name | nvarchar | 35 | 0 | | | | Allow NULL? |
| 36 | VONA0 | First name | nvarchar | 42 | 0 | | | | Allow NULL? |
| 37 | AKGR0 | Title | nvarchar | 15 | 0 | | | | Allow NULL? |
| 38 | WKFZ0 | City of Residence, International License Plate Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | PLZL0 | City of Residence, Postal Code | nvarchar | 7 | 0 | | | | Allow NULL? |
| 40 | WORT0 | City of Residence, City | nvarchar | 20 | 0 | | | | Allow NULL? |
| 41 | STRA0 | City of Residence, Street | nvarchar | 30 | 0 | | | | Allow NULL? |
| 42 | BEAB0 | Employed Since (Last Legally Defined Entry) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | KABE0 | Type of Employment (Worker, Salaried Employee) | char | 1 | 0 | | | | Allow NULL? |
| 44 | TAET0 | Job | nvarchar | 30 | 0 | | | | Allow NULL? |
| 45 | BTAG0 | Employment Days per Week | char | 1 | 0 | | | | Allow NULL? |
| 46 | TATU0 | Work Day Rotation | char | 1 | 0 | | | | Allow NULL? |
| 47 | LTAG0 | Last Working Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 48 | GRUN0 | Reason for Cessation of Work | nvarchar | 30 | 0 | | | | Allow NULL? |
| 49 | KZKU0 | Indicator for Illness/Accident, Work Accident/Illness | char | 1 | 0 | | | | Allow NULL? |
| 50 | ARFT0 | Vector of Days Off per Week | nvarchar | 7 | 0 | | | | Allow NULL? |
| 51 | ARTX0 | Rule for Working Days | nvarchar | 25 | 0 | | | | Allow NULL? |
| 52 | BLOE0 | Work Relationship Terminated | char | 1 | 0 | | | | Allow NULL? |
| 53 | EBSV0 | End of Work Relationship | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | BKTN0 | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 55 | BBLZ0 | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 56 | BENT0 | Tips or Commissions Contained in Gross Remuneration | char | 1 | 0 | | | | Allow NULL? |
| 57 | BVO10 | Payment From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 58 | BBI10 | Pay. To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 59 | BBE10 | Payment Amount | decimal | 9 | 2 | | | | |
| 60 | BVO20 | Payment From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | BBI20 | Pay. To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 62 | BBE20 | Payment Amount | decimal | 9 | 2 | | | | |
| 63 | BVO30 | Payment From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 64 | BBI30 | Pay. To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 65 | BBE30 | Payment Amount | decimal | 9 | 2 | | | | |
| 66 | BVO40 | Payment From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 67 | BBI40 | Pay. To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 68 | BBE40 | Payment Amount | decimal | 9 | 2 | | | | |
| 69 | BSUM0 | Total | decimal | 9 | 2 | | | | |
| 70 | SZKZ0 | Entitlement to Special Payment | char | 1 | 0 | | | | Allow NULL? |
| 71 | SBTW0 | No. of Days with Payment in Kind per Week | char | 1 | 0 | | | | Allow NULL? |
| 72 | SBZT0 | Payments in Kind (Provide Exact Types and Amounts) | nvarchar | 24 | 0 | | | | Allow NULL? |
| 73 | KEAB0 | Pay in Lieu of Notice From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 74 | KEBI0 | Pay in Lieu of Notice To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 75 | UAAB0 | Payment in Lieu of Unused Leave, From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 76 | UABI0 | Payment in Lieu of Unused Leave, To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 77 | AEFZ0 | Contd Pay Entitlement in Weeks | nvarchar | 2 | 0 | | | | Allow NULL? |
| 78 | JAGU0 | Entitlement Calc. Acc. to Working Year or Calendar Year | char | 1 | 0 | | | | Allow NULL? |
| 79 | TAGU0 | Calc. Cont. Pay Entitl. Acc. to Working Days, Calendar Days | char | 1 | 0 | | | | Allow NULL? |
| 80 | TPR10 | Partial Remuneration: Percentage of Total Pay | nvarchar | 2 | 0 | | | | Allow NULL? |
| 81 | TVO10 | Partial Remuneration From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 82 | TBI10 | Partial Remuneration To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 83 | TPR20 | Partial Remuneration: Percentage of Total Pay | nvarchar | 2 | 0 | | | | Allow NULL? |
| 84 | TVO20 | Partial Remuneration From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 85 | TBI20 | Partial Remuneration To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 86 | PROV0 | Commision During Incapacity to Work | char | 1 | 0 | | | | Allow NULL? |
| 87 | ANV10 | Count Previous Illness - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 88 | ANB10 | Count Previous Illness - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 89 | ANV20 | Count Previous Illness - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 90 | ANB20 | Count Previous Illness - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 91 | ANV30 | Count Previous Illness - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 92 | ANB30 | Count Previous Illness - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 93 | ANV40 | Count Previous Illness - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 94 | ANB40 | Count Previous Illness - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 95 | AGRD0 | Deregistration Reason: Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 96 | URLV0 | Leave Prior to Maternity Leave: From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 97 | URLB0 | Leave Prior to Maternity Leave: To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 98 | AVER0 | Earned Income in Last Three Calendar Months | decimal | 9 | 2 | | | | |
| 99 | AVON0 | Earned Income - Period From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 100 | ABIS0 | Earned Income - Period To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 101 | UNV10 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 102 | UNB10 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 103 | UNV20 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 104 | UNB20 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 105 | UNV30 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 106 | UNB30 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 107 | UNV40 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 108 | UNB40 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 109 | SZMO0 | Not used | nvarchar | 2 | 0 | | | | Allow NULL? |
| 110 | SZWO0 | Not used | nvarchar | 2 | 0 | | | | Allow NULL? |
| 111 | ANGV0 | Entitlement to Continued Pay | char | 1 | 0 | | | | Allow NULL? |
| 112 | AHEB0 | Entitlement to Half Pay Until | nvarchar | 8 | 0 | | | | Allow NULL? |
| 113 | AMEB0 | Entitlement to More Than Half Pay Until | nvarchar | 8 | 0 | | | | Allow NULL? |
| 114 | WAHR0 | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 115 | ANV50 | Count Previous Illness - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 116 | ANB50 | Count Previous Illness - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 117 | ANV60 | Count Previous Illness - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 118 | ANB60 | Count Previous Illness - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 119 | AGRD2 | Deregistration Reason: Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 120 | VOAB0 | Period of Previous Employment - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 121 | VOBI0 | Period of Previous Employment - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 122 | FEAB0 | Voluntary Remuneration Paid - From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 123 | FEBI0 | Voluntary Remuneration Paid - To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 124 | EIN10 | Orientation Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 125 | EIN20 | Orientation Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 126 | EIN30 | Orientation Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 127 | EIN40 | Orientation Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 128 | EIN50 | Orientation Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 129 | EIN60 | Orientation Day | nvarchar | 8 | 0 | | | | Allow NULL? |
| 130 | SZMO1 | Extent of Special Payment in Monthly Pay | decimal | 4 | 2 | | | | |
| 131 | SZWO1 | Extent of Special Payment in Weekly Pay | decimal | 4 | 2 | | | | |
| 132 | SBZW0 | Payment in Kind: Extension During Payment of Maternity Pay | char | 1 | 0 | | | | Allow NULL? |
| 133 | SBZE0 | Payment in Kind Included in Earned Income | char | 1 | 0 | | | | Allow NULL? |
| 134 | PRAB0 | Entry Date into Civil Service | nvarchar | 8 | 0 | | | | Allow NULL? |
| 135 | UNV50 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 136 | UNB50 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 137 | UNV60 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 138 | UNB60 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 139 | UNV70 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 140 | UNB70 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 141 | UNV80 | Suspension of Pay From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 142 | UNB80 | Suspension of Pay To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 143 | AVER2 | Earned Income for Freelance Employees (Gross) | decimal | 9 | 2 | | | | |
| 144 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | | | Allow NULL? |
| 145 | TITL2 | Second Title | nvarchar | 15 | 0 | | | | Allow NULL? |
| 146 | SBGB0 | Checkbox: Monetary Remuneration Includes Payment in Kind | char | 1 | 0 | | | | Allow NULL? |
| 147 | LABTG0 | Last Working Day - If WR Continues | nvarchar | 8 | 0 | | | | Allow NULL? |
| 148 | PLZL1 | City of Residence, Postal Code | nvarchar | 9 | 0 | | | | Allow NULL? |
| 149 | WORT1 | City of Residence, City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 150 | STRA1 | City of Residence, Street | nvarchar | 50 | 0 | | | | Allow NULL? |
| 151 | BIC0 | SWIFT/BIC for International Payments | nvarchar | 11 | 0 | | | | Allow NULL? |