SAP ABAP Table PDSPREQ (Shift Planning: Requirements Definition Interface)

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	PDSPREQ	Table Relationship Diagram
Short Description	Shift Planning: Requirements Definition Interface

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	DATUM	☐	REQ_STICHTG	DATUM	DATS	8	0	Key date of requirement record
3	BEGIN_TIME	☐	BEGTIME	TIMES	TIMS	6	0	Start time of a shift
4	END_TIME	☐	ENDTIME	TIMES	TIMS	6	0	End time of a shift
5	BEGIN_DATE	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
6	END_DATE	☐	ENDDATUM	DATUM	DATS	8	0	End Date
7	ORG_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
8	ORG_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
9	SHIFT	☐	DAYPROG	DAYPROG	CHAR	4	0	Shift abbreviation for Shift Planning	T77ED
10	REQ_TYPE	☐	BEDART	BEDART	CHAR	10	0	Requirements type for Shift Planning	T77RD
11	REQ_PRIO	☐	BPRIOX	NUMC2	NUMC	2	0	Priority of requirements type
12	NORMAL	☐	NORMAL	NUM4	NUMC	4	0	Target Number of Employees Needed for Personnel Requirement
13	MINIMUM	☐	MINIMUM	NUM4	NUMC	4	0	Minimum Number of Employees Needed for Personnel Requirement
14	MAXIMUM	☐	MAXIMUM	NUM4	NUMC	4	0	Maximum Number of Employees Needed for Personnel Requirement
15	FIT_REQ	☐	PERNR_FITS	NUMC4	NUMC	4	0	Number of suitable employees for a shift
16	JOB_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
17	ADDWORK	☐	ADDWORK	PROPERTY	CHAR	1	0	ID: Employee can also cover this requirement
18	SHIFTGROUP	☐	DIENSTGR	DIENSTGR	CHAR	10	0	Shift group for organizational units	T77DB
19	SWITCH	☐	ICON_INT	ICON_INT	CHAR	8	0	Icon internal format
20	QUAL_EXIST	☐	QUALFLAG	KEYFLAG	CHAR	1	0	Indicator that qualifications exist
21	REQMTTXT	☐	REQMTTXT	TEXT40	CHAR	40	0	Comments
22	REQMTTYFLAG	☐	REQMTTYFLAG	KEYFLAG	CHAR	1	0	Mark a requirements record as blank
23	STNBY	☐	STNBY	STNBY	CHAR	2	0	Availability Subtype	*
24	TPROG	☐	TPROG	TPROG	CHAR	4	0	Daily Work Schedule	*
25	VARIA	☐	VARIA	VARIA	CHAR	1	0	Daily Work Schedule Variant
26	AWART	☐	AWART	AWART	CHAR	4	0	Attendance or Absence Type	*
27	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
28	ATTTY	☐	ATTTY	CHAR4	CHAR	4	0	Attendance type for assigning employee to requirements
29	ATTTYFLAG	☐	ATTTYFLAG	PROPERTY	CHAR	1	0	Inficator that assignment is recorded as absence
30	FOREIGN_REQUEST	☐	FLAG	FLAG	CHAR	1	0	General Flag
31	COMPLEX_REQ	☐	FLAG	FLAG	CHAR	1	0	General Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PDSPREQ	ORG_OTYPE	T778O	OTYPE
2	PDSPREQ	REQ_TYPE	T77RD	BEDART
3	PDSPREQ	SHIFT	T77ED	DIENSTE
4	PDSPREQ	SHIFTGROUP	T77DB	DIENSTGR

History

Last changed by/on	SAP	20130529
SAP Release Created in