SAP ABAP Table P0012 (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	P0012	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	.INCLUDE	☐				0	0	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	HR Master Record: Infotype 0012 (Fiscal Data - Germany)
28	FZAMT	☐	FZAMN	FZAMN	NUMC	4	0	Tax Office Number (D)	T5D2A
29	GMDNR	☐	GMNDN	GMNDN	NUMC	8	0	Municipality Number (D)	T5D2B
30	STKNR	☐	STKNR	NUM12	NUMC	12	0	Tax Card Number
31	STRKZ	☐	STRKZ	XFELD	CHAR	1	0	Indicator: Tax Card Not Submitted
32	STRKS	☐	STRKS	STRKS	CHAR	1	0	Reason for Not Submitting Tax Card
33	STKRT	☐	STKRT	NUM2	NUMC	2	0	Certification period
34	STKAG	☐	STKAG	DATUM	DATS	8	0	Date of Issue of Tax Card
35	STRKL	☐	STRKL	STRKL	CHAR	1	0	Tax Class (D)
36	STTAB	☐	STTAB	STTAB	CHAR	1	0	Tax Table (D)
37	KDFBT	☐	KDFBT	DEC2_1	DEC	3	1	Number of Tax Exemptions for Children (D)
38	STRKD	☐	STRKD	DEC3	DEC	3	0	Number of Children for Berlin Supplement
39	KISTA	☐	KISTA	KISTA	CHAR	2	0	Church tax deduction - employee
40	KISTE	☐	KISTE	KISTA	CHAR	2	0	Church Tax Deduction - Spouse
41	BRDLD	☐	KISTG	KISTG	CHAR	2	0	Church Tax Area (D)	T5D2L
42	STPFL	☐	STPFL	STRMM	CHAR	1	0	Tax Liability	T5D2D
43	PRMNZ	☐	PRMNZ	STRMM	CHAR	1	0	Tax procedure	T5D2D
44	STFRG	☐	STFRG	STRMM	CHAR	1	0	Flat-Rate Tax Procedure	T5D2D
45	STBFG	☐	STBFG	STRMM	CHAR	1	0	Tax Exemption Reason	T5D2D
46	STRSO	☐	STRSO	STRMM	CHAR	1	0	Special Rule for Taxation (D)	T5D2D
47	STRS2	☐	STRSO	STRMM	CHAR	1	0	Special Rule for Taxation (D)	T5D2D
48	VFREI	☐	VFREI	STRMM	CHAR	1	0	Pension Tax Exemption Granted	T5D2D
49	FRB1M	☐	FRB1M	WERT5	CURR	9	2	Monthly Personal Exemption According to Tax Card
50	FRB1J	☐	FRB1J	WERT5	CURR	9	2	Annual Personal Exemption According to Tax Card
51	FRB2M	☐	FRB2M	WERT5	CURR	9	2	Monthly Exemption for Specific Occupational Groups
52	FRB2J	☐	FRB2J	WERT5	CURR	9	2	Annual Exemption for Specific Occupational Groups
53	STBEL	☐	STBEL	STBEL	CHAR	1	0	Elster Special Processing
54	BEGVB	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
55	VBEZL	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
56	VBEZS	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
57	ENDVB	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
58	KJAHR	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
59	LGVBZ	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
60	BEGV2	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
61	VBE2L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
62	VBE2S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
63	ENDV2	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
64	KJAH2	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
65	LGVB2	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
66	BEGV3	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
67	VBE3L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
68	VBE3S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
69	ENDV3	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
70	KJAH3	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
71	LGVB3	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
72	BEGV4	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
73	VBE4L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
74	VBE4S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
75	ENDV4	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
76	KJAH4	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
77	LGVB4	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
78	BEGV5	☐	BEGVB	DATUM	DATS	8	0	Start Date of Benefit Payment
79	VBE5L	☐	VBEZL	WERT5	CURR	9	2	Regular Benefits Payment
80	VBE5S	☐	VBEZS	WERT5	CURR	9	2	Estimated Special Payments
81	ENDV5	☐	ENDVB	DATUM	DATS	8	0	Benefits Payment End Date
82	KJAH5	☐	JAHRK	NUMC4	NUMC	4	0	Different Start Year for Pension Income
83	LGVB5	☐	LGVBZ	P_SUML	CHAR	4	0	Benefits Payments Wage Type Group	T596G
84	SIDNR	☐	P01_SIDNR		NUMC	11	0	Tax Identification Number
85	FAKTR	☐	P01_TX_F		DEC	4	3	Factor for Factor Procedure
86	E2HAG	☐	P01_TX_KNZ_HAUPTAG	XFELD	CHAR	1	0	Elster: Indicator Main Employer
87	E2SON	☐	P01_TX_E2_SONDER	P01_TX_E2_SONDER	CHAR	1	0	Special Processing for ELStAM Procedure
88	E2SON_AN	☐	P01_TX_E2_SONDER_AN	P01_TX_E2_SONDER_ANAB	CHAR	1	0	Special Processing of Registration for ELStAM Procedure
89	E2SON_AB	☐	P01_TX_E2_SONDER_AB	P01_TX_E2_SONDER_ANAB	CHAR	1	0	Special Processing of Deregistration for ELStAM Procedure
90	E2ABM	☐	P01_TX_E2_DATUM_ABM	DATUM	DATS	8	0	ELStAM: Date Deregistration On
91	E2SON_GRUND	☐	P01_TX_E2_SONDER_GRUND	P01_TX_E2_SONDER_GRUND	CHAR	1	0	Reason for Special Processing for ELStAM Procedure
92	E2ELSTAM	☐	P01_TX_E2_KNZ_ELSTAM	XFELD	CHAR	1	0	Change by ELStAM
93	E2SPERRE	☐	P01_TX_E2_SPERRE	P01_TX_E2_SPERRE	CHAR	1	0	ELStAM Block
94	E2SPERRE_GRUND	☐	P01_TX_E2_SPERRE_GRUND	P01_TX_E2_SPERRE_GRUND	CHAR	1	0	ELStAM: Reason for Block
95	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in