SAP ABAP Table PS0968 (Delt@)

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	PS0968	Table Relationship Diagram
Short Description	Delt@

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in