SAP ABAP Table SPASSIGN (Requirements Assignments of Employees to Cover Requirements)

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	SPASSIGN	Table Relationship Diagram
Short Description	Requirements Assignments of Employees to Cover Requirements

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	MARK	☐	CUA_CHOICE	CUA_CHOICE	CHAR	1	0	Selection of element to be edited
2	REQ_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
3	DATUM	☐	STICHTG	DATUM	DATS	8	0	Key date
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	SHIFT	☐	DAYPROG	DAYPROG	CHAR	4	0	Shift abbreviation for Shift Planning	T77ED
7	SHIFTGROUP	☐	DIENSTGR	DIENSTGR	CHAR	10	0	Shift group for organizational units	T77DB
8	SHIFT_TEXT	☐	DIENSTTEXT	TEXT20	CHAR	20	0	Shift description
9	ADDWORK	☐	ADDWORK	PROPERTY	CHAR	1	0	ID: Employee can also cover this requirement
10	REQMTTXT	☐	REQMTTXT	TEXT40	CHAR	40	0	Comments
11	ORGEH_TYP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
12	ORGEH_ID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
13	ORGEH_TEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name

Foreign Keys

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

History

Last changed by/on	SAP	20030714
SAP Release Created in