SAP ABAP Table PDREQ (Shift Planning: Requirements Matchup)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ PT-SP (Application Component) Shift Planning
     ⤷ PP08 (Package) Shift Planning

Basic Data

Table Category	INTTAB	Structure
Structure	PDREQ	Table Relationship Diagram
Short Description	Shift Planning: Requirements Matchup

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	REQ_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
2	EXPAND	☐	EXPAFLAG	SYCHAR01	CHAR	1	0	Expanded display
3	MARK	☐	CUA_CHOICE	CUA_CHOICE	CHAR	1	0	Selection of element to be edited
4	ORGEH_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
5	ORGEH_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
6	ORGEH_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
7	JOB_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
8	JOB_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
9	JOB_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
10	BEGIN_TIME	☐	BEGTIME	TIMES	TIMS	6	0	Start time of a shift
11	END_TIME	☐	ENDTIME	TIMES	TIMS	6	0	End time of a shift
12	SHIFT	☐	DAYPROG	DAYPROG	CHAR	4	0	Shift abbreviation for Shift Planning	T77ED
13	SHIFT_TEXT	☐	DIENSTTEXT	TEXT20	CHAR	20	0	Shift description
14	ACTUAL_REQ	☐	ACTUAL_REQ	NUM4	NUMC	4	0	Current requirements coverage for a shift
15	NORM_REQ	☐	NORMAL	NUM4	NUMC	4	0	Target Number of Employees Needed for Personnel Requirement
16	MIN_REQ	☐	MINIMUM	NUM4	NUMC	4	0	Minimum Number of Employees Needed for Personnel Requirement
17	MAX_REQ	☐	MAXIMUM	NUM4	NUMC	4	0	Maximum Number of Employees Needed for Personnel Requirement
18	QUAL_EXIST	☐	QUAL_EXIST	ICON_INT	CHAR	8	0	Indicator that qualifications are needed in requirements
19	REQ_MATCHUP	☐	REQ_MATCHUP	ICON_INT	CHAR	8	0	Result of requirements matchup in Shift Planning
20	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
21	NAME	☐	STEXT	TEXT40	CHAR	40	0	Object Name
22	SHIFTGROUP	☐	DIENSTGR	DIENSTGR	CHAR	10	0	Shift group for organizational units	T77DB
23	ADDWORK	☐	ADDWORK	PROPERTY	CHAR	1	0	ID: Employee can also cover this requirement
24	REQMTTXT	☐	REQMTTXT	TEXT40	CHAR	40	0	Comments
25	ORG_TYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
26	ZELLE01	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
27	ZELLE02	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
28	ZELLE03	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
29	ZELLE04	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
30	ZELLE05	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
31	ZELLE06	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
32	ZELLE07	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
33	ZELLE08	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
34	ZELLE09	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
35	ZELLE10	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
36	ZELLE11	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
37	ZELLE12	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
38	ZELLE13	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
39	ZELLE14	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
40	ZELLE15	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
41	ZELLE16	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
42	ZELLE17	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
43	ZELLE18	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
44	ZELLE19	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
45	ZELLE20	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
46	ZELLE21	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
47	ZELLE22	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
48	ZELLE23	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
49	ZELLE24	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
50	ZELLE25	☐	LABOURTIME	CHAR5	CHAR	5	0	Shift time of employee in shift plan
51	COMPLEX_REQ	☐	WFP_COMPLEX_REQ	ICON_INT	CHAR	8	0	Indicator for extended requirement record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PDREQ	SHIFT	T77ED	DIENSTE
2	PDREQ	SHIFTGROUP	T77DB	DIENSTGR

History

Last changed by/on	SAP	20030714
SAP Release Created in