SAP ABAP Table P0968 (HR master record for infotypes 0968)

Hierarchy

☛ SAP_HRCES (Software Component) Sub component SAP_HRCES of SAP_HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PB04 (Package) HR Master Data: Spain

Basic Data

Table Category	INTTAB	Structure
Structure	P0968	Table Relationship Diagram
Short Description	HR master record for infotypes 0968

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	Delt@
28	.INCLUDE	☐				0	0	Status administration
29	EMETH	☐	PES_EMETH	PES_EMETH	CHAR	1	0	Type of electronic production file
30	EFILE	☐	PES_EFILE	CHAR20	CHAR	20	0	Production file identifier
31	SSTAT	☐	PES_SSTAT	PES_SSTAT	NUMC	2	0	Status of the live generation
32	CSTAT	☐	PES_CSTAT	PES_CSTAT	NUMC	2	0	Notification status
33	TIPOP	☐	PES_TIPOP	PES_TIPOP	CHAR	1	0	Type of report
34	CDLUG	☐	PES_CDLUG	PES_CDLUG	CHAR	1	0	Place code
35	CNTRT	☐	PES_CNTRT	CHAR1	CHAR	1	0	Hires
36	TRFCO	☐	PES_TRFCO	PES_BOOLE	CHAR	1	0	Traffic accident
37	DIREC	☐	PES_DIREA	TEXT32	CHAR	32	0	Address where accident took place
38	VIAKM	☐	PES_VIAKM	TEXT40	CHAR	40	0	Via knowledge management
39	OTROC	☐	PES_OTROC	TEXT40	CHAR	40	0	Other
40	MUNIC	☐	PES_CDLOC	NUM5	NUMC	5	0	Municipality code	*
41	PROVN	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
42	CPAIS	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
43	CEMP2	☐	PES_CEMP2	PES_BOOLE	CHAR	1	0	Centre matches the company
44	CTEP2	☐	PES_CTEP2	PES_BOOLE	CHAR	1	0	Center belongs to the company
45	CIFTY	☐	PES_CIFTY	PES_CIFTY	CHAR	1	0	Type of CIF (tax ID number)
46	CIFCO	☐	PES_CIFCO	CHAR10	CHAR	10	0	Company CIF (tax ID number)
47	RAZON	☐	PES_RAZON	TEXT40	CHAR	40	0	Registered company name
48	DMCIL	☐	PES_DMCIL	TEXT60	CHAR	60	0	Address of center
49	CPROV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
50	CPOST	☐	PES_CPOST	PSTLZ	CHAR	10	0	Center's postal code	T5E35
51	CTELE	☐	PES_CTELE		CHAR	14	0	Work center telephone number
52	CPLAN	☐	PES_CPLAN		NUMC	5	0	Work center staff
53	FECAC	☐	PES_FECAC		DATS	8	0	Accident date
54	FECBA	☐	PES_FECBA		DATS	8	0	Sick leave date
55	HORAA	☐	PES_HORAA	UZEIT	TIMS	6	0	Time of accident
56	HTRAB	☐	PES_HTRAB	PES_HTRAB	CHAR	2	0	Work time when the accident occurred
57	HABIT	☐	PES_HABIT	PES_BOOLE	CHAR	1	0	Usual work of the worker
58	EVALU	☐	PES_EVALU	PES_BOOLE	CHAR	1	0	Risk evaluation has been carried out
59	ADES1	☐	PES_ADESC	TEXT255	CHAR	255	0	Description of accident
60	ADES2	☐	PES_ADESC	TEXT255	CHAR	255	0	Description of accident
61	LUGAR	☐	PES_LUGAR	CHAR3	CHAR	3	0	Place code	T5ED1
62	CDTRA	☐	PES_CDTRA		CHAR	2	0	Work code	T5ED3
63	ESPEC	☐	PES_CDACT		CHAR	2	0	Specific activity code	T5ED4
64	CDAGE	☐	PES_CDAGE	PES_CDAGE	CHAR	8	0	Material agent of the activity	T5ED8
65	CDDES	☐	PES_CDDES		CHAR	2	0	Variance code	T5ED2
66	AGENT	☐	PES_AGENT	PES_CDAGE	CHAR	8	0	Triggering material agent	T5ED8
67	TPMOD	☐	PES_TPMOD	TEXT200	CHAR	200	0	Mode of injury
68	CDCON	☐	PES_CDCON		CHAR	2	0	Means of contact code	T5ED5
69	AGENM	☐	PES_AGENM	PES_CDAGE	CHAR	8	0	Material agent of the injury	T5ED8
70	MULTI	☐	PES_MULTI	PES_BOOLE	CHAR	1	0	More than one worker affected
71	TESTI	☐	PES_TESTI	PES_BOOLE	CHAR	1	0	Witnesses to the accident
72	DATTE	☐	PES_DATTE	TEXT200	CHAR	200	0	Names, addresses and telephone numbers of witnesses
73	CDLES	☐	PES_CDLES		CHAR	3	0	Injury description code	T5ED7
74	GRADO	☐	PES_GRADO	PES_GRADO	CHAR	1	0	Degree of injury
75	CDPAR	☐	PES_CDPAR		CHAR	2	0	Code of the injured body part	T5ED6
76	MDNOM	☐	PES_MDNON	TEXT40	CHAR	40	0	Doctor's name
77	MDDOM	☐	PES_MDDOM	TEXT80	CHAR	80	0	Doctor's address
78	MDTEL	☐	PES_MDTEL	TELNR	CHAR	14	0	Doctor's telephone number
79	ASIST	☐	PES_ASIST	PES_ASIST	CHAR	1	0	Healthcare type
80	CDHOS	☐	PES_CDHOS	PES_BOOLE	CHAR	1	0	Casualty has been hospitalised
81	HOSPI	☐	PES_HOSPI	TEXT40	CHAR	40	0	Hospital name
82	EPLAN	☐	PES_EPLAN		NUMC	5	0	Number of hourly wage workers in the company
83	DTCCC	☐	PES_DTCCC	NUM11	NUMC	11	0	CA code of the center where the accident occurred
84	DCNAC	☐	PES_DCNAC	CHAR5	CHAR	5	0	Main business activity code of the accident center	T5E4F
85	CDCNO	☐	PES_CDCNO	CHAR4	CHAR	4	0	Worker employment code	T5ED9
86	FENOM	☐	PES_FENOM	TEXT40	CHAR	40	0	Name and surnames of the report issuer
87	FECAL	☐	PES_FECAL	TEXT20	CHAR	20	0	Report issuer charge
88	FEPRO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
89	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
90	BCOTM	☐	PES_BCOTM	P_AMT08	CURR	15	2	Monthly contribution basis in previous month
91	ACOTM	☐	PES_ACOTM	NUMC2	NUMC	2	0	Contribution days in the previous month
92	BCTB1	☐	PES_BCTB1	P_AMT08	CURR	15	2	Annual contribution basis for overtime (B1)
93	BCTB2	☐	PES_BCTB2	P_AMT08	CURR	15	2	Annual contribution basis for other items (B2)
94	BREGA	☐	PES_BREGA	P_AMT08	CURR	15	2	Regalutory basis A
95	BCTBT	☐	PES_BCTBT	P_AMT08	CURR	15	2	Sum of contribution bases B1 + B2
96	PRGAD	☐	PES_PRGAD	P_AMT08	CURR	15	2	Daily average of the regulatory base A
97	PCTBD	☐	PES_PCTBD	P_AMT08	CURR	15	2	Basis B daily average
98	PRGBD	☐	PES_PRGBD	P_AMT08	CURR	15	2	Daily average of the regulatory base B
99	BRGTD	☐	PES_BRGTD	P_AMT08	CURR	15	2	Daily regulatory basis total
100	PBD75	☐	PES_PBD75	P_AMT08	CURR	15	2	75 percent compensation
101	CMUNI	☐	PES_CODLOC	NUM5	NUMC	5	0	Town code according to INEM	T5E35
102	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0968	AGENM	T5ED8	CDAGE
2	P0968	AGENT	T5ED8	CDAGE
3	P0968	CDAGE	T5ED8	CDAGE
4	P0968	CDCNO	T5ED9	CDCNO	REF	1	CN
5	P0968	CDCON	T5ED5	CDCON	REF	1	CN
6	P0968	CDDES	T5ED2	CDDES	REF	1	CN
7	P0968	CDLES	T5ED7	CDLES
8	P0968	CDPAR	T5ED6	CDPAR	REF	1	CN
9	P0968	CDTRA	T5ED3	CDTRA
10	P0968	CMUNI	T5E35	COD_LOC	KEY	C	CN
11	P0968	CPAIS	T005	LAND1
12	P0968	CPOST	T5E35	COD_POS	REF	1	CN
13	P0968	CPROV	T005S	BLAND
14	P0968	DCNAC	T5E4F	CNAEC	REF	1	CN
15	P0968	ESPEC	T5ED4	ACTIV
16	P0968	FEPRO	T005S	BLAND	REF	1	CN
17	P0968	INFTY	T582A	INFTY
18	P0968	LUGAR	T5ED1	LUGAR
19	P0968	PREAS	T530E	PREAS
20	P0968	PROVN	T005S	BLAND
21	P0968	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in