SAP ABAP Table PS0012 (HR Master Record: Infotype 0012 (Fiscal Data - Germany))

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PA-PA-DE (Application Component) Germany
     ⤷ PB01 (Package) HR Master Data: Germany

Basic Data

Table Category	INTTAB	Structure
Structure	PS0012	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0012 (Fiscal Data - Germany)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	FZAMT	☐	FZAMN	FZAMN	NUMC	4	0	Tax Office Number (D)	T5D2A
2	GMDNR	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
3	STKNR	☐	STKNR	NUM12	NUMC	12	0	Tax Card Number
4	STRKZ	☐	STRKZ	XFELD	CHAR	1	0	Indicator: Tax Card Not Submitted
5	STRKS	☐	STRKS	STRKS	CHAR	1	0	Reason for Not Submitting Tax Card
6	STKRT	☐	STKRT	NUM2	NUMC	2	0	Certification period
7	STKAG	☐	STKAG	DATUM	DATS	8	0	Date of Issue of Tax Card
8	STRKL	☐	STRKL	STRKL	CHAR	1	0	Tax Class (D)
9	STTAB	☐	STTAB	STTAB	CHAR	1	0	Tax Table (D)
10	KDFBT	☐	KDFBT	DEC2_1	DEC	3	1	Number of Tax Exemptions for Children (D)
11	STRKD	☐	STRKD	DEC3	DEC	3	0	Number of Children for Berlin Supplement
12	KISTA	☐	KISTA	KISTA	CHAR	2	0	Church tax deduction - employee
13	KISTE	☐	KISTE	KISTA	CHAR	2	0	Church Tax Deduction - Spouse
14	BRDLD	☐	KISTG	KISTG	CHAR	2	0	Church Tax Area (D)	T5D2L
15	STPFL	☐	STPFL	STRMM	CHAR	1	0	Tax Liability	T5D2D
16	PRMNZ	☐	PRMNZ	STRMM	CHAR	1	0	Tax procedure	T5D2D
17	STFRG	☐	STFRG	STRMM	CHAR	1	0	Flat-Rate Tax Procedure	T5D2D
18	STBFG	☐	STBFG	STRMM	CHAR	1	0	Tax Exemption Reason	T5D2D
19	STRSO	☐	STRSO	STRMM	CHAR	1	0	Special Rule for Taxation (D)	T5D2D
20	STRS2	☐	STRSO	STRMM	CHAR	1	0	Special Rule for Taxation (D)	T5D2D
21	VFREI	☐	VFREI	STRMM	CHAR	1	0	Pension Tax Exemption Granted	T5D2D
22	FRB1M	☐	FRB1M	WERT5	CURR	9	2	Monthly Personal Exemption According to Tax Card
23	FRB1J	☐	FRB1J	WERT5	CURR	9	2	Annual Personal Exemption According to Tax Card
24	FRB2M	☐	FRB2M	WERT5	CURR	9	2	Monthly Exemption for Specific Occupational Groups
25	FRB2J	☐	FRB2J	WERT5	CURR	9	2	Annual Exemption for Specific Occupational Groups
26	STBEL	☐	STBEL	STBEL	CHAR	1	0	Elster Special Processing
27	BEGVB	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
28	VBEZL	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
29	VBEZS	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
30	ENDVB	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
31	KJAHR	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
32	LGVBZ	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
33	BEGV2	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
34	VBE2L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
35	VBE2S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
36	ENDV2	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
37	KJAH2	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
38	LGVB2	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
39	BEGV3	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
40	VBE3L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
41	VBE3S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
42	ENDV3	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
43	KJAH3	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
44	LGVB3	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
45	BEGV4	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
46	VBE4L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
47	VBE4S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
48	ENDV4	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
49	KJAH4	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
50	LGVB4	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
51	BEGV5	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
52	VBE5L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
53	VBE5S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
54	ENDV5	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
55	KJAH5	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
56	LGVB5	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
57	SIDNR	☐	P01_SIDNR		NUMC	11	0	Tax Identification Number
58	FAKTR	☐	P01_TX_F		DEC	4	3	Factor for Factor Procedure
59	E2HAG	☐	P01_TX_KNZ_HAUPTAG	XFELD	CHAR	1	0	Elster: Indicator Main Employer
60	E2SON	☐	P01_TX_E2_SONDER	P01_TX_E2_SONDER	CHAR	1	0	Special Processing for ELStAM Procedure
61	E2SON_AN	☐	P01_TX_E2_SONDER_AN	P01_TX_E2_SONDER_ANAB	CHAR	1	0	Special Processing of Registration for ELStAM Procedure
62	E2SON_AB	☐	P01_TX_E2_SONDER_AB	P01_TX_E2_SONDER_ANAB	CHAR	1	0	Special Processing of Deregistration for ELStAM Procedure
63	E2ABM	☐	P01_TX_E2_DATUM_ABM	DATUM	DATS	8	0	ELStAM: Date Deregistration On
64	E2SON_GRUND	☐	P01_TX_E2_SONDER_GRUND	P01_TX_E2_SONDER_GRUND	CHAR	1	0	Reason for Special Processing for ELStAM Procedure
65	E2ELSTAM	☐	P01_TX_E2_KNZ_ELSTAM	XFELD	CHAR	1	0	Change by ELStAM
66	E2SPERRE	☐	P01_TX_E2_SPERRE	P01_TX_E2_SPERRE	CHAR	1	0	ELStAM Block
67	E2SPERRE_GRUND	☐	P01_TX_E2_SPERRE_GRUND	P01_TX_E2_SPERRE_GRUND	CHAR	1	0	ELStAM: Reason for Block
68	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0012	BRDLD	T5D2L	BRDLD
2	PS0012	FZAMT	T5D2A	FZAMT
3	PS0012	GMDNR	T5D2B	GMDNR
4	PS0012	LGVB2	T596G	SUMLG	REF	1	CN
5	PS0012	LGVB3	T596G	SUMLG	REF	1	CN
6	PS0012	LGVB4	T596G	SUMLG	REF	1	CN
7	PS0012	LGVB5	T596G	SUMLG	REF	1	CN
8	PS0012	LGVBZ	T596G	SUMLG	REF	1	CN
9	PS0012	PRMNZ	T5D2D	SRKEN
10	PS0012	STBFG	T5D2D	SRKEN
11	PS0012	STFRG	T5D2D	SRKEN
12	PS0012	STPFL	T5D2D	SRKEN
13	PS0012	STRS2	T5D2D	SRKEN
14	PS0012	STRSO	T5D2D	SRKEN
15	PS0012	VFREI	T5D2D	SRKEN

History

Last changed by/on	SAP	20130529
SAP Release Created in