P01T_LST

ETStmt: General Employment Tax Data | #transactional | Component: Tax
Column Name Description
MANDT FK Client
PERNR FK Personnel Number
LBART FK ETStmt: Type of Employment Tax Statement Show values
ENDDA FK ETStmt: End of Statement Period
LFDNR FK ETStmt: Current Number
Column Name Description
💲 Currency Key (T500C.WAERS):
FRBJ1 ETStmt: Annual Tax-Free Amount
HINZJ ETStmt: Annual Additional Amount
VBEZB ETStmt: Assessment Basis for Tax Exemption for Pensions
Column Name Description
Column Name Description
ENDDA FK ETStmt: End of Statement Period
GBDAT ETStmt: Date of Birth
Column Name Description
LSART ETStmt: Type of Employment Tax Statement Show values
GESCH ETStmt: Gender Show values
STRKL ETStmt: Tax Class Show values
STTAB ETStmt: Tax Table Show values
STRKZ Indicator: Tax Card Not Submitted Show values
ABNAM Type of Block Name Show values
Column Name Description Domain name
VERSN ETStmt: Version
BJAHR Employment Tax Statement: Statement Year CHAR4
BANFA ETStmt: Start of Statement Period CHAR4
BENDE ETStmt: End of Statement Period CHAR4
KETIN ETStmt: Self-Determined ETIN CHAR14
OMMAG ETStmt: Administrative Feature ER TEXT12
GMDNR ETStmt: General Municipality Key GMNDN
GMDTX ETStmt: Municipality TEXT48
NACHN ETStmt: Last Name TEXT30
VORNA ETStmt: First Name TEXT30
VORSA ETStmt: Name Prefix for Last Name TEXT20
NAMZU ETStmt: Addition to Last Name TEXT20
TITEL ETStmt: Title TEXT20
NAME2 ETStmt: Name at Birth TEXT30
VORS2 ETStmt: Name Prefix for Name at Birth TEXT20
NAMZ2 ETStmt: Addition to Name at Birth TEXT20
STRAS ETStmt: Street TEXT33
HAUSN ETStmt: House No.
HAUSZ ETStmt: House No. Affix TEXT15
ANSZU ETStmt: Address Affix TEXT40
PSTLZ ETStmt: Postal Code NUMC5
ORT01 ETStmt: City of Residence TEXT34
KDFBT ETStmt: Number of Tax Exemptions for Children
ANZLU ETStmt: Number of Unpaid Absences
AGNAM ETStmt: Employer Name TEXT60
AGSNR Tax Number in Electronic Tax Return Format CHAR15
AGSTR ETStmt: Street of Employer TEXT33
AGHNR ETStmt: House No. of Employer
AGHNZ ETStmt: Employer's House Number Affix TEXT15
AGANZ ETStmt: Employer's Address Affix TEXT40
AGPLZ Employment Tax Statement: Employer's Postal Code NUMC5
AGORT ETStmt: Location of Employer TEXT34
FZAMT ETStmt: Tax Office Number (Germany) FZAMN
FZTXT ETStmt: Tax Office TEXT57
AGFZA ETStmt: Tax Office Number (Germany) FZAMN
AGFZT ETStmt: Tax Office TEXT57
GRSBS ETStmt: Uppercase Letters P01T_GRSBS
LANDD DUEVO: Nationality P01T_DUSTA
ALPLZ ETStmt: Postal Code for Address Abroad P01T_ALPLZ
AGPBX ETStmt: Postcode of Employer NUMC8
GKPLZ ETStmt: Corporate Postal Code of Employer NUMC5
BEGVB Start Benefits Payment NUMC6
SIDNR Tax Identification Number P01_SIDNR
BNAME Block Name TEXT45
Master Data Relations Join Conditions
Client P01T_LST.MANDT == T000.MANDT