SAP ABAP Table PS0038 (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	PS0038	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	KANTO	☐	KANTO	CHAR2	CHAR	2	0	Canton Indicator
2	GEMND	☐	GEMND	GEMND	CHAR	4	0	Municipality	T5C1O
3	QSTPF	☐	QSTPF	P02_QSTPF	CHAR	1	0	Tax liability	*
4	LAUWG	☐	P02_LAUWG	P02_LAUWG	CHAR	1	0	Flat-rate cost reimbursement
5	ARBOR	☐	P02_ARBOR	TEXT25	CHAR	25	0	Work location
6	BEMZ1	☐	HRCHBEMZ1	TEXT100	CHAR	100	0	Comments: Line 1 (LAW Switz.)
7	BEMZ2	☐	HRCHBEMZ2	TEXT100	CHAR	100	0	Remarks: line 2 (LAW Switz.)
8	BEMZ3	☐	HRCHBEMZ3	TEXT100	CHAR	100	0	Comments: Line 3 (LAW Switz.)
9	QSTAB	☐	P02_CQTAB	P02_CQTAB	CHAR	6	0	Withholding Tax Scale	T5C2K
10	QSPRO	☐	QSPRO	DEC3_2	DEC	5	2	Withholding Tax Percentage
11	QSBTR	☐	QSBTR	WERT5	CURR	9	2	Withholding tax amount
12	.INCLUDE	☐				0	0	HR-CH: Employee Attributes
13	ACL01	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
14	EMA01	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
15	ACL02	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
16	EMA02	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
17	ACL03	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
18	EMA03	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
19	ACL04	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
20	EMA04	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
21	ACL05	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
22	EMA05	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
23	ACL06	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
24	EMA06	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
25	ACL07	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
26	EMA07	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
27	ACL08	☐	P02_ACLAS	P02_ACLAS	CHAR	2	0	HR-CH: EE Attributes Class	T5CAP
28	EMA08	☐	P02_ATTRI	P02_ATTRI	NUMC	2	0	HR-CH: EE Attribute	T5CA0
29	WGMGE	☐	P02_GETIS_WGMGE	P02_GETIS_LOCCD	NUMC	2	0	Municip. Code in WHT Statement for Residences in Canton GE	T5C2P_LOCCD
30	AGMGE	☐	P02_GETIS_ARB_0038	P02_GETIS_LOCCD	NUMC	2	0	Municipal. Code in WHT Statement for Work Place in Canton GE	T5C2P_LOCCD
31	NMSRC	☐	P02_NMSRC	P02_NMSRC	CHAR	20	0	Employee's WHT Number
32	AKANT	☐	P02_AKANT	P02_AKANT	CHAR	2	0	Canton of Place of Work
33	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20080505
SAP Release Created in