SAP ABAP Table HRSP_REQ_ASSIGN (Shift Planning: Requirements and Assigned Persons)

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	HRSP_REQ_ASSIGN	Table Relationship Diagram
Short Description	Shift Planning: Requirements and Assigned Persons

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in