1. Home
  2. Resources
  3. SAP Tables
  4. PDREQ - Shift Planning: Requirements Matchup

SAP Table PDREQ

Shift Planning: Requirements Matchup

PDREQ (Shift Planning: Requirements Matchup) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PDREQ to other SAP tables.

PDREQ table fields

Field Data element Checktable Datatype Length Decimals
REQ_OBJID Object ID OBJEKTID NUMC 8 0
EXPAND Expanded display EXPAFLAG CHAR 1 0
MARK Selection of element to be edited CUA_CHOICE CHAR 1 0
NULL No selection
X Selection
ORGEH_OBJID Object ID OBJEKTID NUMC 8 0
ORGEH_SHORT Object Abbreviation SHORT_D CHAR 12 0
ORGEH_STEXT Object Name STEXT CHAR 40 0
JOB_OBJID Object ID OBJEKTID NUMC 8 0
JOB_SHORT Object Abbreviation SHORT_D CHAR 12 0
JOB_STEXT Object Name STEXT CHAR 40 0
BEGIN_TIME Start time of a shift BEGTIME TIMS 6 0
END_TIME End time of a shift ENDTIME TIMS 6 0
SHIFT Shift abbreviation for Shift Planning DAYPROG T77ED CHAR 4 0
SHIFT_TEXT Shift description DIENSTTEXT CHAR 20 0
ACTUAL_REQ Current requirements coverage for a shift ACTUAL_REQ NUMC 4 0
NORM_REQ Target Number of Employees Needed for Personnel Requirement NORMAL NUMC 4 0
MIN_REQ Minimum Number of Employees Needed for Personnel Requirement MINIMUM NUMC 4 0
MAX_REQ Maximum Number of Employees Needed for Personnel Requirement MAXIMUM NUMC 4 0
QUAL_EXIST Indicator that qualifications are needed in requirements QUAL_EXIST CHAR 8 0
REQ_MATCHUP Result of requirements matchup in Shift Planning REQ_MATCHUP CHAR 8 0
PERNR Personnel Number PERNR_D NUMC 8 0
NAME Object Name STEXT CHAR 40 0
SHIFTGROUP Shift group for organizational units DIENSTGR T77DB CHAR 10 0
ADDWORK ID: Employee can also cover this requirement ADDWORK CHAR 1 0
REQMTTXT Comments REQMTTXT CHAR 40 0
ORG_TYPE Object Type OTYPE CHAR 2 0
ZELLE01 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE02 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE03 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE04 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE05 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE06 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE07 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE08 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE09 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE10 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE11 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE12 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE13 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE14 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE15 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE16 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE17 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE18 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE19 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE20 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE21 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE22 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE23 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE24 Shift time of employee in shift plan LABOURTIME CHAR 5 0
ZELLE25 Shift time of employee in shift plan LABOURTIME CHAR 5 0
COMPLEX_REQ Indicator for extended requirement record WFP_COMPLEX_REQ CHAR 8 0

PDREQ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PDREQ SHIFT PDREQ SHIFT T77ED Shift Planning: Definition of Shifts DIENSTE
PDREQ SHIFT SYST MANDT T77ED Shift Planning: Definition of Shifts MANDT
PDREQ SHIFT PDREQ SHIFTGROUP T77ED Shift Planning: Definition of Shifts DIENSTGR
PDREQ SHIFTGROUP SYST MANDT T77DB Shift Groups for Organizational Units MANDT
PDREQ SHIFTGROUP PDREQ SHIFTGROUP T77DB Shift Groups for Organizational Units DIENSTGR