SAP ABAP Table SAWE_S_SA_LIST_ASSIGNMENT (Structure list assignment for staff assignment)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ IS-PRS-LS (Application Component) Lean Staffing
⤷ PSAWE_SA_UI (Package) Staff Assignment UI Layer
⤷ IS-PRS-LS (Application Component) Lean Staffing
⤷ PSAWE_SA_UI (Package) Staff Assignment UI Layer
Basic Data
Table Category | INTTAB | Structure |
Structure | SAWE_S_SA_LIST_ASSIGNMENT | Table Relationship Diagram |
Short Description | Structure list assignment for staff assignment |
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 | .INCLU-HD | 0 | 0 | Staff Assignment Header | |||||
2 | .INCLUDE | 0 | 0 | Include Structure for Key Information | |||||
3 | KEYHD | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
4 | PARENT_KEYHD | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
5 | ROOT_KEYHD | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
6 | .INCLUDE | 0 | 0 | Staff assignment header attributes | |||||
7 | .INCLUDE | 0 | 0 | Staff assignment header key attributes | |||||
8 | OBJECT_TYPEHD | WE_ENGAGEMENT_TYPE | WE_ENGAGEMENT_TYPE | CHAR | 1 | 0 | Assignment Obj. Type | TWE_ENGTYPE | |
9 | OBJECT_IDHD | SWO_OBJID | SWO_OBJID | CHAR | 90 | 0 | Object ID | ||
10 | EMPLOYEE_IDHD | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
11 | TO_BE_ARCHIVEDHD | SAWE_TO_BE_ARCHIVED | BOOLE | CHAR | 1 | 0 | Archivable Indicator | ||
12 | STATUSHD | J_ISTAT | J_ISTAT | CHAR | 5 | 0 | System status | TJ02 | |
13 | .INCLUDE | 0 | 0 | Administrative data | |||||
14 | DATETIME_CRHD | /BOBF/DATETIME_CR | /BOBF/TIMESTAMP | DEC | 15 | 0 | Date/Time of Item Creation | ||
15 | USER_ID_CRHD | /BOBF/USER_ID_CR | UNAME | CHAR | 12 | 0 | Object Created By | ||
16 | DATETIME_CHHD | /BOBF/DATETIME_CH | /BOBF/TIMESTAMP | DEC | 15 | 0 | Date/Time of Item Change | ||
17 | USER_ID_CHHD | /BOBF/USER_ID_CH | UNAME | CHAR | 12 | 0 | Object Changed By | ||
18 | .INCLUDE | 0 | 0 | Staff Assignment: Transient Header Data | |||||
19 | FIRST_NAMEHD | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
20 | LAST_NAMEHD | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
21 | EMPLOYEE_NAMEHD | PAD_CNAME | TEXT80 | CHAR | 80 | 0 | Complete Name | ||
22 | COST_CENTERHD | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
23 | COMPANY_CODEHD | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
24 | EXTERNALHD | SAWE_EXTERNAL | BOOLE | CHAR | 1 | 0 | External Employee Indicator | ||
25 | FLAG_VALIDATION_FAILEDHD | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
26 | READONLYHD | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
27 | .INCLU--AP | 0 | 0 | Append Structure for Staff Assignment Header | |||||
28 | COST_CENTER_TEXTHD | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
29 | COMPANY_CODE_TEXTHD | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
30 | .INCLU-ITM | 0 | 0 | Staff Assignment Item | |||||
31 | .INCLUDE | 0 | 0 | Include Structure for Key Information | |||||
32 | KEYITM | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
33 | PARENT_KEYITM | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
34 | ROOT_KEYITM | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
35 | .INCLUDE | 0 | 0 | Staff assignment item attributes | |||||
36 | FC_GROUPITM | SAWE_FC_GROUP | SYSUUID | RAW | 16 | 0 | Forecast Grouping Key | ||
37 | START_DATEITM | SAWE_DATE_FROM | DATUM | DATS | 8 | 0 | Start Date of Staff Assignment | ||
38 | END_DATEITM | SAWE_DATE_TO | DATUM | DATS | 8 | 0 | End Date of Staff Assignment | ||
39 | TASKTYPEITM | CATSTASKTYPE | CATSTASKTYPE | CHAR | 4 | 0 | Task Type | * | |
40 | TASKLEVELITM | CATSTASKLEVEL | CATSTASKLEVEL | CHAR | 8 | 0 | Task Level | ||
41 | ACTIVITY_CLASSITM | SAWE_QUALIFICATION | HROBJID | NUMC | 8 | 0 | Competency | * | |
42 | DESCRIPTIONITM | SAWE_DESCRIPTION | TEXT80 | CHAR | 80 | 0 | Staff Assignment: Item Description | ||
43 | EXPECTED_DAYSITM | SAWE_EXP_DAYS | SAWE_EXP_DAYS | NUMC | 4 | 0 | Staff Assignment: Expected Days | ||
44 | MAXIMUM_DAYSITM | SAWE_MAX_DAYS | SAWE_MAX_DAYS | NUMC | 4 | 0 | Staff Assignment: Maximum Days | ||
45 | BOOKING_STATUSITM | SAWE_BOOKING_STATUS | SAWE_BOOKING_STATUS | CHAR | 1 | 0 | Booking Status | ||
46 | EXP_TRVL_EXPITM | SAWE_EXP_TRAVEL_EXPENSE | WERT7 | CURR | 13 | 2 | Expected Travel Expense | ||
47 | EXP_TRVL_CURRITM | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
48 | MAIL_STATUSITM | SAWE_MAIL_STATUS | SAWE_MAIL_STATUS | CHAR | 1 | 0 | E-Mail Status | ||
49 | CATS_RELEVANTITM | SAWE_CATS_RELEVANT | BOOLE | CHAR | 1 | 0 | Staff Assignment: CATS-Relevant | ||
50 | FC_RELEVANTITM | SAWE_FORECAST_RELEVANT | BOOLE | CHAR | 1 | 0 | Staff Assignment: Relevant for Forecasting | ||
51 | .INCLUDE | 0 | 0 | Administrative data | |||||
52 | DATETIME_CRITM | /BOBF/DATETIME_CR | /BOBF/TIMESTAMP | DEC | 15 | 0 | Date/Time of Item Creation | ||
53 | USER_ID_CRITM | /BOBF/USER_ID_CR | UNAME | CHAR | 12 | 0 | Object Created By | ||
54 | DATETIME_CHITM | /BOBF/DATETIME_CH | /BOBF/TIMESTAMP | DEC | 15 | 0 | Date/Time of Item Change | ||
55 | USER_ID_CHITM | /BOBF/USER_ID_CH | UNAME | CHAR | 12 | 0 | Object Changed By | ||
56 | .INCLUDE | 0 | 0 | ||||||
57 | .INCLU--AP | 0 | 0 | Staff assignment item extended attributes | |||||
58 | TASKCOMPONENTITM | CATSTASKCOMPONENT | CATSTASKCOMPONENT | CHAR | 8 | 0 | Task component | ||
59 | ACTIVITY_TYPEITM | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | CSLA | |
60 | ROLEITM | SAWE_SA_ROLE | SAWE_SA_ROLE | CHAR | 4 | 0 | Staff Assignment Role | ||
61 | .INCLUDE | 0 | 0 | Transient data for item | |||||
62 | FLAG_VALIDATION_FAILEDITM | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
63 | ITEM_KEY_REPLACEDITM | /BOBF/CONF_KEY | /BOBF/CONF_KEY | RAW | 16 | 0 | NodeID | ||
64 | MAIL_STATUS_TEXTITM | SAWE_MAIL_STATUS_TEXT | SAWE_MAIL_STATUS_TEXT | CHAR | 40 | 0 | Text for E-Mail status | ||
65 | FLAG_BOPF_READONLY_RELEV_CITM | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
66 | FLAG_BOPF_READONLY_RELEV_FITM | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
67 | EVENT_SET_IN_UI_FOR_ADAPTERITM | CHAR | 40 | 0 | |||||
68 | ACTIVITY_TYPE_TXTITM | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
69 | FORECAST | SAWE_SA_FORECAST | SAWE_SA_FORECAST | CHAR | 20 | 0 | Forecast | ||
70 | FLAG_READ_ONLY | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
71 | FLAG_FAILED_KEY | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
72 | MAIL_STATUS_TEXT | SAWE_MAIL_STATUS_TEXT | SAWE_MAIL_STATUS_TEXT | CHAR | 40 | 0 | Text for E-Mail status | ||
73 | FLAG_READ_ONLY_AFTER_SAVE | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
74 | HY_CONTACT | SAWE_HY_CONTACT | SAWE_HY | STRG | 0 | 0 | Contact Information | ||
75 | FLAG_KEY_FIELDS | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
76 | FLAG_READ_ONLY_BY_TYPE | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
77 | FLAG_CHECK_FAILED_UI | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
78 | FLAG_READ_ONLY_BOOKING_STATE | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
79 | FLAG_UI_READ_ONLY_RELEVANCE_C | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
80 | FLAG_UI_READ_ONLY_RELEVANCE_F | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
81 | .INCLU--AP | 0 | 0 | Staff Assignment Structure Append Struc | |||||
82 | FLAG_READ_ONLY_TASKS | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
83 | FLAG_READ_ONLY_ACTIVITY_TYPE | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SAWE_S_SA_LIST_ASSIGNMENT | ACTIVITY_TYPEITM | CSLA | LSTAR | |||
2 | SAWE_S_SA_LIST_ASSIGNMENT | EXP_TRVL_CURRITM | TCURC | WAERS | 1 | CN | |
3 | SAWE_S_SA_LIST_ASSIGNMENT | OBJECT_TYPEHD | TWE_ENGTYPE | ENGAGEMENT_TYPE | KEY | 1 | CN |
4 | SAWE_S_SA_LIST_ASSIGNMENT | STATUSHD | TJ02 | ISTAT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 605 |