| 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 | * | PERSNO | Allow NULL? |
| 3 | REVTY | Revision Type | char | 1 | 0 | CHAR | (N' ') | No | | P03_REVTY | Allow NULL? |
| 4 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 6 | SEQNR | Sequence Document Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | P03_SEQNR | Allow NULL? |
| 7 | SETYP | Record Type for Electronic Notification | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_SETYP | Allow NULL? |
| 8 | READY | Release Status for Electronic Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_READY | Allow NULL? |
| 9 | SRTZA | Process Status for Consolidation and Notification Creation | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P03_SRTZA | Allow NULL? |
| 10 | EMETH | Electronic Notification Procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_EMETH | Allow NULL? |
| 11 | LZTYP | Payslip Data Category | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_LZTYP | Allow NULL? |
| 12 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P03_MUNAM | Allow NULL? |
| 13 | DATUM | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_MDATU | Allow NULL? |
| 14 | UZEIT | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P03_MTIME | Allow NULL? |
| 15 | PGMID | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P03_MPROG | Allow NULL? |
| 16 | EPRO2 | ELDA Project | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_EPRO2 | Allow NULL? |
| 17 | ESVGR | SI Group Transferring Data | char | 1 | 0 | CHAR | (N' ') | Yes | * | P03_ESVGR | Allow NULL? |
| 18 | EUSVA | ELDA: Insurance Agency as Data Recipient | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PC03_UVST0 | Allow NULL? |
| 19 | WOBD0 | Additional Classification Key for Employer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PB03_WOBD0 | Allow NULL? |
| 20 | ZOBD0 | Additional Classification Key for Employer | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | PB03_ZOBD0 | Allow NULL? |
| 21 | EDTNR | ELDA: Data Medium Number | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | PC03_DTRNR | Allow NULL? |
| 22 | ESANR | ELDA: Sequence Record Number for Each Data Medium | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | PC03_LFDNR | Allow NULL? |
| 23 | ESANI | ELDA: Number of the Corresponding Information Record | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ESANI | Allow NULL? |
| 24 | LFVER | Payslip Tax: Structure Version | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P03_LFVER | Allow NULL? |
| 25 | TFDAT | Date of Transfer | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_TFDAT | Allow NULL? |
| 26 | TFTIM | Time of Transfer | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P03C_P_TIM | Allow NULL? |
| 27 | FEHL1 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 28 | FEHL2 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 29 | FEHL3 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 30 | FEHL4 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 31 | FEHL5 | Error ID for Electronic Notification Record | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P03_LZEID | Allow NULL? |
| 32 | ESTAT | External Process Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_EPSTA | Allow NULL? |
| 33 | ANZA0 | Payslip Tax: Number of Notifications (Current) | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ANZA0 | Allow NULL? |
| 34 | TTL16 | Total Number of Annual Payslips L16 for DME | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | P03_ANZL16 | Allow NULL? |
| 35 | REFNR | Reference Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P03_REFNR | Allow NULL? |
| 36 | AUSVL | 1st Part of SI Number (Sequential Number) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AUSVL | Allow NULL? |
| 37 | AUSVG | 2nd Part of SI Number (Birth Date) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | AUSVG | Allow NULL? |
| 38 | ANNNA | Last Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_NACHN | Allow NULL? |
| 39 | ANVNA | First Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PAD_VORNA | Allow NULL? |
| 40 | ANTIT | Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TITEL | Allow NULL? |
| 41 | GESCH | Gender Key | char | 1 | 0 | CHAR | (N' ') | Yes | | GESCH | Allow NULL? |
| 42 | ANADR | Employee's Residential Address | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P03_ANLST | Allow NULL? |
| 43 | ANLKZ | Vehicle Country Key for Home Address | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P03_ANLKZ | Allow NULL? |
| 44 | ANPLZ | Postal Code of Residential Address | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P03_ANPLZ | Allow NULL? |
| 45 | ANORT | Type of Residence | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P03_ORT01 | Allow NULL? |
| 46 | LOHNB | Employer Assignment Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P03_LOHNB | Allow NULL? |
| 47 | AGNUM | Employer Tax Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_AGNUM | Allow NULL? |
| 48 | AGFZA | Tax office number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | FZAMA | Allow NULL? |
| 49 | AGDVR | Employer's Data Processing Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_DVRNR | Allow NULL? |
| 50 | AGNAM | Name of Employer | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | P03_NAMAG | Allow NULL? |
| 51 | AGTIT | Title of Employer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P03_TITAG | Allow NULL? |
| 52 | AGADR | Address of Employer/Contracting Party/Benefits Provider | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P03_ADRAG | Allow NULL? |
| 53 | AGLKZ | Vehicle Country Key for Company Address of Empl./Contr.Party | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P03_AGLKZ | Allow NULL? |
| 54 | AGZIP | Postal Code in Company Address of Employer, Contractng Party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P03_AGPLZ | Allow NULL? |
| 55 | AGORT | City in Company Address of Employer | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P03_ORTAG | Allow NULL? |
| 56 | LVNUM | Tax Number of Payroll Service Provider | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_TRSTN | Allow NULL? |
| 57 | LVFZA | Tax Office Number of Payroll Service Provider | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | P03_TRFAN | Allow NULL? |
| 58 | LVDVR | Data Processing Number of Payroll Service Provider | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P03_TRDVR | Allow NULL? |
| 59 | ARTL0 | Type of Payslip L16 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P03_ARTL0 | Allow NULL? |
| 60 | UDV16 | Interruption of Work Relationship According to L16 | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_UDV16 | Allow NULL? |
| 61 | SOZSL | Social Status (Last Status in Payslip Period) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | P03_SOZSL | Allow NULL? |
| 62 | SOZSA | Social Status for Last Salary in Payslip Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | P03_SOZSA | Allow NULL? |
| 63 | SOZS2 | Social Status (If Worker w/ Tax-Free Amt for Agric. Laborer) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | P03_SOZS2 | Allow NULL? |
| 64 | SOZS0 | Social Status | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | P03_SOZS0 | Allow NULL? |
| 65 | TVOLL | No. of Days with Full-Time Employment in Payslip Period | decimal | 15 | 2 | DEC | ((0)) | Yes | | P03_TVOLL | |
| 66 | TTEIL | No. of Days with Part-Time Employment in Payslip Period | decimal | 15 | 2 | DEC | ((0)) | Yes | | P03_TTEIL | |
| 67 | KVOLL | Indicator: Employee Mainly in Full Employment | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KVOLL | Allow NULL? |
| 68 | KAVAB | Indicator: Tax Reduction for Single Earners Included | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KAVAB | Allow NULL? |
| 69 | KAEAB | Indicator: Tax Reduction for Single Parents Included | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KAEAB | Allow NULL? |
| 70 | STAKD | Number of Children of Employee (Tax) | decimal | 2 | 0 | DEC | ((0)) | Yes | | STRK2 | |
| 71 | PASVL | SI Number of Spouse/Partner (Sequential Number) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P03_PASVL | Allow NULL? |
| 72 | PASVG | SI Number of Spouse/Partner (Date of Birth) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P03_PASVG | Allow NULL? |
| 73 | STBDT | Death Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_STDT0 | Allow NULL? |
| 74 | PGVON | Date as of Which Nursing Allowance Is Received | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_PGBEG | Allow NULL? |
| 75 | PGBIS | Date Until Which Nursing Allowance Is Received | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P03_PGEND | Allow NULL? |
| 76 | SEUVR | Increased Accident Annuity Exists (Checkbox) | decimal | 15 | 2 | DEC | ((0)) | Yes | | P03_SEUVR | |
| 77 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 78 | KZ210 | 210: Gross Pay Sec. 25 (W/o Sec. 26, W/o Family Allowance) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ210 | |
| 79 | KZ215 | 215: Tax-Exempt Payments According to Section 68 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ215 | |
| 80 | KZ220 | 220: Pmnts Acc. to Sec.67 Para.1+2 (Within Y/6 Before SI) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ220 | |
| 81 | KZIEB | IEB: Total SI Contributions Deducted, CC, HS | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZIEB | |
| 82 | KZ225 | 225: SI Contribs for Payments Acc. to Key Fig. 220 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ225 | |
| 83 | KZ226 | 226: SI Contrib. f. Pmnts Acc. to Sec. 67 Par. 3-8 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ226 | |
| 84 | KZ230 | 230: Adjusted SI Contributions | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ230 | |
| 85 | KZ240 | 240: Tax-Free Amt for Agricultural Laborer Acc. to Sec. 104 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ240 | |
| 86 | KZAUS | AUS: Emplymnt Abroad Acc. to Sec. 3 Par. 1, Lines 10 and 11 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZAUS | |
| 87 | KZPEN | PEN: Commuter Rate Acc. to Sec. 16 Para. 1, Line 6 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZPEN | |
| 88 | KZEFB | EFB: Deducted Voluntary Amounts Acc. to Sec. 16 Par. 1 L 3b | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZEFB | |
| 89 | KZSTF | STF: Tax-Free or Flat-Rate-Taxed Pmnts Acc.to Sec.67 (3-8) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZSTF | |
| 90 | KZSSB | SSB: Other Tax-Exempt Payments | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZSSB | |
| 91 | KZ243 | 243: Total Remaining Deductions | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ243 | |
| 92 | KZ245 | 245: Taxable Payments | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ245 | |
| 93 | KZIEL | IEL: Total Employment Tax Deducted | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZIEL | |
| 94 | KZABL | ABL: Deducted Empl.Tax w/ Fixed Rates Acc.to Sec.67 Par.3-8 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZABL | |
| 95 | KZ260 | 260: Imputable Employment Tax | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZ260 | |
| 96 | KZSOB | SOB: Other Payments Acc.to Sec.67 (2,6,19) Acc.to EmpTxRate | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZSOB | |
| 97 | KZFB1 | FB1: Exemption Included According to Sec. 105 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZFB1 | |
| 98 | KZVSV | VSV: SI Assessment Basis Used for Special Payments | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZVSV | |
| 99 | KZFB2 | FB2: Exemption Included Acc. to Notification Acc. to Sec. 63 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZFB2 | |
| 100 | KZAUF | AUF: Church/OeGB Contributions Included in Recalculation | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZAUF | |
| 101 | KZFB3 | FB3: Exemption Included According to Sec. 35 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZFB3 | |
| 102 | KZNEB | NEB: Pmnts Not to Be Entered Acc.to Sec.25 Par.1 Line 2a+3a | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZNEB | |
| 103 | KZPFG | KZPFG Nursing Allowance Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZPFG | |
| 104 | KZSFB | SFB: Tax-Exempt Payments Acc. to Sec. 26 Line 4 | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZSFB | |
| 105 | KZHA1 | KZHA1 Hardship Compensation KZ245 Accident Pension | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZHA1 | |
| 106 | KZHA2 | KZHA2 Hardshp Comp. KZ220 Accdnt Pens.(Sec.67 Par1+2 Bef.SI) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZHA2 | |
| 107 | KZHA3 | KZHA3 Hardship Cmpsn KZ225 Accident Pens. (Withheld SI Con.) | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZHA3 | |
| 108 | KZUEB | UEB: Paid Transfer Amount to BV | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZUEB | |
| 109 | KFB01 | Family Allowance, Amount Paid from Own Funds (January) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB01 | Allow NULL? |
| 110 | KFB02 | Family Allowance, Amount Paid from Own Funds (February) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB02 | Allow NULL? |
| 111 | KFB03 | Family Allowance, Amount Paid from Own Funds (March) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB03 | Allow NULL? |
| 112 | KFB04 | Family Allowance, Amount Paid from Own Funds (April) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB04 | Allow NULL? |
| 113 | KFB05 | Family Allowance, Amount Paid from Own Funds (May) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB05 | Allow NULL? |
| 114 | KFB06 | Family Allowance, Amount Paid from Own Funds (June) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB06 | Allow NULL? |
| 115 | KFB07 | Family Allowance, Amount Paid from Own Funds (July) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB07 | Allow NULL? |
| 116 | KFB08 | Family Allowance, Amount Paid from Own Funds (August) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB08 | Allow NULL? |
| 117 | KFB09 | Family Allowance, Amount Paid from Own Funds (September) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB09 | Allow NULL? |
| 118 | KFB10 | Family Allowance, Amount Paid from Own Funds (October) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB10 | Allow NULL? |
| 119 | KFB11 | Family Allowance, Amount Paid from Own Funds (November) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB11 | Allow NULL? |
| 120 | KFB12 | Family Allowance, Amount Paid from Own Funds (December) | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KFB12 | Allow NULL? |
| 121 | KZAPK | KZAPK Employer's Contributions to Foreign Pension Funds | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZAPK | |
| 122 | INPER | Last In-Period of Payroll in the Record | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P03_IPERI | Allow NULL? |
| 123 | KEPAB | Increased Deductible Amount for Pensioners Included | char | 1 | 0 | CHAR | (N' ') | Yes | | P03_KEPAB | Allow NULL? |
| 124 | KZENT | KZENT Income for Aid Workers | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZENT | |
| 125 | KZPRE | KZPRE Lump Sum Travel Expense Allowance | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZPRE | |
| 126 | KWERK | KWERK Company Transportation (No. of Calendar Months) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P03_KWERK | Allow NULL? |
| 127 | REFN0 | Reference Number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P03_REFNR | Allow NULL? |
| 128 | KZPEND | KZPEND Commuter Deduction | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZPNE | |
| 129 | KUEBMO | KUEBMO Use of Car (Number of Calendar Months) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P03_KUEBM | Allow NULL? |
| 130 | KZSROL | KZSROL Extraordinary Costs Recalculation | decimal | 15 | 2 | CURR | ((0)) | Yes | | P03_KZSRO | |
| 131 | ALAND | ISO Code of Country or DTC | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P03_ALAND | Allow NULL? |
