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
⤷ 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 |