SAP ABAP Table PA0012 (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	TRANSP	Transparent table
Transparent table	PA0012	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0012 (Fiscal Data - Germany)

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in