SAP ABAP Table P01T_LST (ETStmt: General Employment Tax Data)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE-NT-TX (Application Component) Tax
     ⤷ P01T (Package) HR Germany: Tax

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	P01T_LST	Table Relationship Diagram
Short Description	ETStmt: General Employment Tax Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	ETStmt: Shared Key for Elster Tables
3	PERNR	☑	PERNR_D	PERNR	NUMC	8	0	Personnel Number	*
4	LBART	☑	P01T_LBART	P01T_LBART	NUMC	2	0	ETStmt: Type of Employment Tax Statement	*
5	ENDDA	☑	P01T_BENDD		DATS	8	0	ETStmt: End of Statement Period	*
6	LFDNR	☑	P01T_LFDNR		NUMC	4	0	ETStmt: Current Number	*
7	.INCLUDE	☐				0	0	HR-DST: General Employment Tax Data
8	LSART	☐	P01T_LSART	P01T_LSART	CHAR	7	0	ETStmt: Type of Employment Tax Statement
9	VERSN	☐	P01T_VERSN		NUMC	6	0	ETStmt: Version
10	BJAHR	☐	P01T_BJAHR	CHAR4	CHAR	4	0	Employment Tax Statement: Statement Year
11	BANFA	☐	P01T_BANFA	CHAR4	CHAR	4	0	ETStmt: Start of Statement Period
12	BENDE	☐	P01T_BENDE	CHAR4	CHAR	4	0	ETStmt: End of Statement Period
13	KETIN	☐	P01T_KETIN	CHAR14	CHAR	14	0	ETStmt: Self-Determined ETIN
14	OMMAG	☐	P01T_OMMAG	TEXT12	CHAR	12	0	ETStmt: Administrative Feature ER
15	GMDNR	☐	P01T_GMDNR	GMNDN	NUMC	8	0	ETStmt: General Municipality Key	*
16	GMDTX	☐	P01T_GMDTX	TEXT48	CHAR	48	0	ETStmt: Municipality
17	GESCH	☐	P01T_GESCH	P01T_GESCH	CHAR	1	0	ETStmt: Gender
18	NACHN	☐	P01T_NACHN	TEXT30	CHAR	30	0	ETStmt: Last Name
19	VORNA	☐	P01T_VORNA	TEXT30	CHAR	30	0	ETStmt: First Name
20	VORSA	☐	P01T_VORSA	TEXT20	CHAR	20	0	ETStmt: Name Prefix for Last Name
21	NAMZU	☐	P01T_NAMZU	TEXT20	CHAR	20	0	ETStmt: Addition to Last Name
22	TITEL	☐	P01T_TITEL	TEXT20	CHAR	20	0	ETStmt: Title
23	NAME2	☐	P01T_NAME2	TEXT30	CHAR	30	0	ETStmt: Name at Birth
24	VORS2	☐	P01T_VORS2	TEXT20	CHAR	20	0	ETStmt: Name Prefix for Name at Birth
25	NAMZ2	☐	P01T_NAMZ2	TEXT20	CHAR	20	0	ETStmt: Addition to Name at Birth
26	GBDAT	☐	P01T_GBDAT		DATS	8	0	ETStmt: Date of Birth
27	STRAS	☐	P01T_STRAS	TEXT33	CHAR	33	0	ETStmt: Street
28	HAUSN	☐	P01T_HAUSN		NUMC	9	0	ETStmt: House No.
29	HAUSZ	☐	P01T_HAUSZ	TEXT15	CHAR	15	0	ETStmt: House No. Affix
30	ANSZU	☐	P01T_ANSZU	TEXT40	CHAR	40	0	ETStmt: Address Affix
31	PSTLZ	☐	P01T_PSTLZ	NUMC5	NUMC	5	0	ETStmt: Postal Code
32	ORT01	☐	P01T_ORT01	TEXT34	CHAR	34	0	ETStmt: City of Residence
33	STRKL	☐	P01T_STRKL	STRKL	CHAR	1	0	ETStmt: Tax Class
34	KDFBT	☐	P01T_KDFBT		DEC	3	1	ETStmt: Number of Tax Exemptions for Children
35	FRBJ1	☐	P01T_FRBJ1	P01T_BETRG	CURR	15	2	ETStmt: Annual Tax-Free Amount
36	HINZJ	☐	P01T_HINZJ	P01T_BETRG	CURR	15	2	ETStmt: Annual Additional Amount
37	ANZLU	☐	P01T_ANZLU		NUMC	2	0	ETStmt: Number of Unpaid Absences
38	STTAB	☐	P01T_STTAB	STTAB	CHAR	1	0	ETStmt: Tax Table
39	AGNAM	☐	P01T_AGNAM	TEXT60	CHAR	60	0	ETStmt: Employer Name
40	AGSNR	☐	P01T_AGSNR	CHAR15	CHAR	15	0	Tax Number in Electronic Tax Return Format
41	AGSTR	☐	P01T_AGSTR	TEXT33	CHAR	33	0	ETStmt: Street of Employer
42	AGHNR	☐	P01T_AGHNR		NUMC	9	0	ETStmt: House No. of Employer
43	AGHNZ	☐	P01T_AGHNZ	TEXT15	CHAR	15	0	ETStmt: Employer's House Number Affix
44	AGANZ	☐	P01T_AGANZ	TEXT40	CHAR	40	0	ETStmt: Employer's Address Affix
45	AGPLZ	☐	P01T_AGPLZ	NUMC5	NUMC	5	0	Employment Tax Statement: Employer's Postal Code
46	AGORT	☐	P01T_AGORT	TEXT34	CHAR	34	0	ETStmt: Location of Employer
47	FZAMT	☐	P01T_FZAMN	FZAMN	NUMC	4	0	ETStmt: Tax Office Number (Germany)	*
48	FZTXT	☐	P01T_FZTXT	TEXT57	CHAR	57	0	ETStmt: Tax Office
49	AGFZA	☐	P01T_FZAMN	FZAMN	NUMC	4	0	ETStmt: Tax Office Number (Germany)	*
50	AGFZT	☐	P01T_FZTXT	TEXT57	CHAR	57	0	ETStmt: Tax Office
51	GRSBS	☐	P01T_GRSBS	P01T_GRSBS	CHAR	30	0	ETStmt: Uppercase Letters
52	LANDD	☐	P01T_LANDD	P01T_DUSTA	CHAR	3	0	DUEVO: Nationality	*
53	ALPLZ	☐	P01T_ALPLZ	P01T_ALPLZ	CHAR	13	0	ETStmt: Postal Code for Address Abroad
54	AGPBX	☐	P01T_AGPBX	NUMC8	NUMC	8	0	ETStmt: Postcode of Employer
55	GKPLZ	☐	P01T_GKPLZ	NUMC5	NUMC	5	0	ETStmt: Corporate Postal Code of Employer
56	BEGVB	☐	P01T_BEGVB	NUMC6	NUMC	6	0	Start Benefits Payment
57	VBEZB	☐	P01T_VBEZB	P01T_BETRG	CURR	15	2	ETStmt: Assessment Basis for Tax Exemption for Pensions
58	STRKZ	☐	STRKZ	XFELD	CHAR	1	0	Indicator: Tax Card Not Submitted
59	SIDNR	☐	P01_SIDNR		NUMC	11	0	Tax Identification Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P01T_LST	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C