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

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

Foreign Keys

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

History

Last changed by/on	SAP	20080626
SAP Release Created in