SAP ABAP Table P0038 (HR Master Record: Infotype 0038 (Fiscal Data CH))

Hierarchy

☛ SAP_HRCCH (Software Component) Sub component SAP_HRCCH of SAP_HR
   ⤷ PA-PA-CH (Application Component) Switzerland
     ⤷ PB02 (Package) HR Master Data: Switzerland

Basic Data

Table Category	INTTAB	Structure
Structure	P0038	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0038 (Fiscal Data CH)

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 0038 (Fiscal Data CH)
28	KANTO	☐	KANTO	CHAR2	CHAR	2	0	Canton Indicator
29	GEMND	☐	GEMND	GEMND	CHAR	4	0	Municipality	T5C1O
30	QSTPF	☐	QSTPF	P02_QSTPF	CHAR	1	0	Tax liability	*
31	LAUWG	☐	P02_LAUWG	P02_LAUWG	CHAR	1	0	Flat-rate cost reimbursement
32	ARBOR	☐	P02_ARBOR	TEXT25	CHAR	25	0	Work location
33	BEMZ1	☐	HRCHBEMZ1	TEXT100	CHAR	100	0	Comments: Line 1 (LAW Switz.)
34	BEMZ2	☐	HRCHBEMZ2	TEXT100	CHAR	100	0	Remarks: line 2 (LAW Switz.)
35	BEMZ3	☐	HRCHBEMZ3	TEXT100	CHAR	100	0	Comments: Line 3 (LAW Switz.)
36	QSTAB	☐	P02_CQTAB	P02_CQTAB	CHAR	6	0	Withholding Tax Scale	T5C2K
37	QSPRO	☐	QSPRO	DEC3_2	DEC	5	2	Withholding Tax Percentage
38	QSBTR	☐	QSBTR	WERT5	CURR	9	2	Withholding tax amount
39	.INCLUDE	☐				0	0	HR-CH: Employee Attributes
40	ACL01	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
41	EMA01	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
42	ACL02	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
43	EMA02	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
44	ACL03	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
45	EMA03	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
46	ACL04	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
47	EMA04	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
48	ACL05	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
49	EMA05	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
50	ACL06	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
51	EMA06	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
52	ACL07	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
53	EMA07	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
54	ACL08	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
55	EMA08	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
56	WGMGE	☐	P02_GETIS_WGMGE	P02_GETIS_LOCCD	NUMC	2	0	Municip. Code in WHT Statement for Residences in Canton GE	T5C2P_LOCCD
57	AGMGE	☐	P02_GETIS_ARB_0038	P02_GETIS_LOCCD	NUMC	2	0	Municipal. Code in WHT Statement for Work Place in Canton GE	T5C2P_LOCCD
58	NMSRC	☐	P02_NMSRC	P02_NMSRC	CHAR	20	0	Employee's WHT Number
59	AKANT	☐	P02_AKANT	P02_AKANT	CHAR	2	0	Canton of Place of Work
60	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0038	ACL01	T5CAP	ACLAS	KEY	1	CN
2	P0038	ACL02	T5CAP	ACLAS	KEY	1	CN
3	P0038	ACL03	T5CAP	ACLAS	KEY	1	CN
4	P0038	ACL04	T5CAP	ACLAS	KEY	1	CN
5	P0038	ACL05	T5CAP	ACLAS	KEY	1	CN
6	P0038	ACL06	T5CAP	ACLAS	KEY	1	CN
7	P0038	ACL07	T5CAP	ACLAS	KEY	1	CN
8	P0038	ACL08	T5CAP	ACLAS	KEY	1	CN
9	P0038	AGMGE	T5C2P_LOCCD	LOCCD
10	P0038	EMA01	T5CA0	ATTRI	KEY	1	CN
11	P0038	EMA02	T5CA0	ATTRI	KEY	1	CN
12	P0038	EMA03	T5CA0	ATTRI	KEY	1	CN
13	P0038	EMA04	T5CA0	ATTRI	KEY	1	CN
14	P0038	EMA05	T5CA0	ATTRI	KEY	1	CN
15	P0038	EMA06	T5CA0	ATTRI	KEY	1	CN
16	P0038	EMA07	T5CA0	ATTRI	KEY	1	CN
17	P0038	EMA08	T5CA0	ATTRI	KEY	1	CN
18	P0038	GEMND	T5C1O	PLZAR
19	P0038	INFTY	T582A	INFTY
20	P0038	PREAS	T530E	PREAS
21	P0038	QSTAB	T5C2K	QSTAB
22	P0038	WGMGE	T5C2P_LOCCD	LOCCD

History

Last changed by/on	SAP	20080626
SAP Release Created in