SAP ABAP Table SAWE_S_SA_WORKLIST (Flat structure of a staff assignment)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-PRS-LS (Application Component) Lean Staffing
     ⤷ PSAWE_SA_BL (Package) Staff Assignment Business Layer

Basic Data

Table Category	INTTAB	Structure
Structure	SAWE_S_SA_WORKLIST	Table Relationship Diagram
Short Description	Flat structure of a 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	.INCLUDE	☐				0	0	Staff assignment header key attributes
2	OBJECT_TYPE	☐	WE_ENGAGEMENT_TYPE	WE_ENGAGEMENT_TYPE	CHAR	1	0	Assignment Obj. Type	TWE_ENGTYPE
3	OBJECT_ID	☐	SWO_OBJID	SWO_OBJID	CHAR	90	0	Object ID
4	EMPLOYEE_ID	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	.INCLUDE	☐				0	0	Staff assignment item attributes
6	FC_GROUP	☐	SAWE_FC_GROUP	SYSUUID	RAW	16	0	Forecast Grouping Key
7	START_DATE	☐	SAWE_DATE_FROM	DATUM	DATS	8	0	Start Date of Staff Assignment
8	END_DATE	☐	SAWE_DATE_TO	DATUM	DATS	8	0	End Date of Staff Assignment
9	TASKTYPE	☐	CATSTASKTYPE	CATSTASKTYPE	CHAR	4	0	Task Type
10	TASKLEVEL	☐	CATSTASKLEVEL	CATSTASKLEVEL	CHAR	8	0	Task Level
11	ACTIVITY_CLASS	☐	SAWE_QUALIFICATION	HROBJID	NUMC	8	0	Competency	*
12	DESCRIPTION	☐	SAWE_DESCRIPTION	TEXT80	CHAR	80	0	Staff Assignment: Item Description
13	EXPECTED_DAYS	☐	SAWE_EXP_DAYS	SAWE_EXP_DAYS	NUMC	4	0	Staff Assignment: Expected Days
14	MAXIMUM_DAYS	☐	SAWE_MAX_DAYS	SAWE_MAX_DAYS	NUMC	4	0	Staff Assignment: Maximum Days
15	BOOKING_STATUS	☐	SAWE_BOOKING_STATUS	SAWE_BOOKING_STATUS	CHAR	1	0	Booking Status
16	EXP_TRVL_EXP	☐	SAWE_EXP_TRAVEL_EXPENSE	WERT7	CURR	13	2	Expected Travel Expense
17	EXP_TRVL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
18	MAIL_STATUS	☐	SAWE_MAIL_STATUS	SAWE_MAIL_STATUS	CHAR	1	0	E-Mail Status
19	CATS_RELEVANT	☐	SAWE_CATS_RELEVANT	BOOLE	CHAR	1	0	Staff Assignment: CATS-Relevant
20	FC_RELEVANT	☐	SAWE_FORECAST_RELEVANT	BOOLE	CHAR	1	0	Staff Assignment: Relevant for Forecasting
21	.INCLUDE	☐				0	0	Administrative data
22	DATETIME_CR	☐	/BOBF/DATETIME_CR	/BOBF/TIMESTAMP	DEC	15	0	Date/Time of Item Creation
23	USER_ID_CR	☐	/BOBF/USER_ID_CR	UNAME	CHAR	12	0	Object Created By
24	DATETIME_CH	☐	/BOBF/DATETIME_CH	/BOBF/TIMESTAMP	DEC	15	0	Date/Time of Item Change
25	USER_ID_CH	☐	/BOBF/USER_ID_CH	UNAME	CHAR	12	0	Object Changed By
26	.INCLUDE	☐				0	0
27	.INCLU--AP	☐				0	0	Staff assignment item extended attributes
28	TASKCOMPONENT	☐	CATSTASKCOMPONENT	CATSTASKCOMPONENT	CHAR	8	0	Task component
29	ACTIVITY_TYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
30	ROLE	☐	SAWE_SA_ROLE	SAWE_SA_ROLE	CHAR	4	0	Staff Assignment Role

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SAWE_S_SA_WORKLIST	ACTIVITY_TYPE	CSLA	LSTAR
2	SAWE_S_SA_WORKLIST	EXP_TRVL_CURR	TCURC	WAERS		1	CN
3	SAWE_S_SA_WORKLIST	OBJECT_TYPE	TWE_ENGTYPE	ENGAGEMENT_TYPE	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	605