SAP ABAP Table SAWE_S_EXTR_PSEA (Extraction Structure Employee 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_EXTR_PSEA	Table Relationship Diagram
Short Description	Extraction Structure Employee 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	EMPLOYEE_ID	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
2	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
3	COST_CENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
4	CO_AREA	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
5	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	EMPLOYEE_FIRSTNAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
7	EMPLOYEE_LASTNAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
8	OBJECT_ID	☐	SWO_OBJID	SWO_OBJID	CHAR	90	0	Object ID
9	OBJECT_TYPE	☐	WE_ENGAGEMENT_TYPE	WE_ENGAGEMENT_TYPE	CHAR	1	0	Assignment Obj. Type	TWE_ENGTYPE
10	OBJECT_TYPE_TXT	☐	SAWE_OBJECT_TYPE_TXT	DESCR_40	CHAR	40	0	Object Type Description
11	DESCRIPTION	☐	SAWE_DESCRIPTION	TEXT80	CHAR	80	0	Staff Assignment: Item Description
12	DATE_ASSIGNMENT	☐	DATUM	DATUM	DATS	8	0	Date
13	START_DATE	☐	SAWE_DATE_FROM	DATUM	DATS	8	0	Start Date of Staff Assignment
14	END_DATE	☐	SAWE_DATE_TO	DATUM	DATS	8	0	End Date of Staff Assignment
15	FC_GROUP	☐	SAWE_FC_GROUP	SYSUUID	RAW	16	0	Forecast Grouping Key
16	TASKTYPE	☐	CATSTASKTYPE	CATSTASKTYPE	CHAR	4	0	Task Type
17	TASKLEVEL	☐	CATSTASKLEVEL	CATSTASKLEVEL	CHAR	8	0	Task Level
18	MAXIMUM_DAYS	☐	SAWE_MAX_DAYS	SAWE_MAX_DAYS	NUMC	4	0	Staff Assignment: Maximum Days
19	EXPECTED_DAYS	☐	SAWE_EXP_DAYS	SAWE_EXP_DAYS	NUMC	4	0	Staff Assignment: Expected Days
20	ACTIVITY_CLASS	☐	STEXT	TEXT40	CHAR	40	0	Object Name
21	CATS_RELEVANT	☐	SAWE_CATS_RELEVANT	BOOLE	CHAR	1	0	Staff Assignment: CATS-Relevant
22	BOOKING_STATUS	☐	SAWE_BOOKING_STATUS	SAWE_BOOKING_STATUS	CHAR	1	0	Booking Status
23	CATSHOURS	☐	CATSHOURS	CATSHOURS	QUAN	4	2	Hours
24	MEINH_CATS	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	*
25	CATS_MISSING_AUTH	☐	SAWE_CATS_MISSING_AUTHORITY	BOOLE	CHAR	1	0	CATs Missing Authority Indicator
26	PROJECT_ID	☐	SWO_OBJID	SWO_OBJID	CHAR	90	0	Object ID
27	SALESDOC_ID	☐	SWO_OBJID	SWO_OBJID	CHAR	90	0	Object ID
28	.INCLU--AP	☐				0	0	Extraction Structure Employee Assignment Append
29	TASKCOMPONENT	☐	CATSTASKCOMPONENT	CATSTASKCOMPONENT	CHAR	8	0	Task component
30	ACTIVITY_TYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SAWE_S_EXTR_PSEA	COST_CENTER	CSKS	KOSTL
2	SAWE_S_EXTR_PSEA	CO_AREA	TKA01	KOKRS
3	SAWE_S_EXTR_PSEA	OBJECT_TYPE	TWE_ENGTYPE	ENGAGEMENT_TYPE	KEY	1	CN
4	SAWE_S_EXTR_PSEA	ORGEH	T527X	ORGEH

History

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