I_WorkCenterBySemanticKey

Work Center By Semantic Key | view: IPPWRKCNTRBYSEMK | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP Master Data

Tables used: CRHD

🔑 Keys (2)
💰 Amounts
∑ Quantities (2)
📅 Dates (2)
☰ Categorical (22)
Other (5)
🔗 Relations (26)

Column Name	Description
Plant FK	Plant
WorkCenter	Work Center

Column Name	Description

Column Name	Description
📏 Unit of Measure of Work (StandardWorkQuantityUnit):
WorkCenterStandardQueueDurn	Standard Queue Time
WorkCenterMinimumQueueDuration	Minimum Queue Time

Column Name	Description
ValidityStartDate	Valid-From Date
ValidityEndDate	Valid-To Date

Column Name	Description
WorkCenterTypeCode	Object types of the CIM resource	Show values
WorkCenterIsToBeDeleted	Deletion flag for work center	Show values
WorkCenterIsLocked	Indicator: Work center is locked	Show values
WorkCenterIsMntndForCosting	Indicator: Work center is maintained for costing	Show values
WorkCenterIsMntndForScheduling	Indicator: Work center is maintained for scheduling	Show values
AdvancedPlanningIsSupported	Indicator for Advanced Planning	Show values
LaborTrackingIsRequired	Indicates Whether Labor Tracking is Required for Execution	Show values
MatlCompIsMarkedForBackflush	Indicator: Backflushing	Show values
StandardTextIDIsReferenced	Indicator: Standard Text ID is Referenced	Show values
EmployeeWageTypeIsReferenced	Indicator: Wage Type is Referenced	Show values
NmbrOfTimeTicketsIsReferenced	Indicator: Number of Time Tickets is Referenced	Show values
EmployeeWageGroupIsReferenced	Indicator: Wage Group is Referenced	Show values
EmplSuitabilityIsReferenced	Indicator: Suitability is Referenced	Show values
WorkCenterSetpTypeIsReferenced	Indicator: Setup Type Key is Referenced	Show values
OpControlProfileIsReferenced	Indicator: Control Profile is Referenced	Show values
NumberOfConfSlipsIsReferenced	Indicator: Number of Confirmation Slips is Referenced	Show values
WrkCtrStdValMaintRule1	Standard Value Maintenance Rule 1	Show values
WrkCtrStdValMaintRule2	Standard Value Maintenance Rule 2	Show values
WrkCtrStdValMaintRule3	Standard Value Maintenance Rule 3	Show values
WrkCtrStdValMaintRule4	Standard Value Maintenance Rule 4	Show values
WrkCtrStdValMaintRule5	Standard Value Maintenance Rule 5	Show values
WrkCtrStdValMaintRule6	Standard Value Maintenance Rule 6	Show values

Column Name	Description	Domain name
NumberOfConfirmationSlips	Number of Confirmation Slips	NUM03
WorkCenterLocationGroup	Location Group	ORTSGRUPPE
ObjectInternalID	Object number	J_OBJNR
EmployeeWageType	Employee Wage Type	LOART
NumberOfTimeTickets	Number of Time Tickets	LOHNANZ

Master Data Relations	Join Conditions
Capacity ID Client Capacity ID	`I_WORKCENTERBYSEMANTICKEY.MANDT == KAKO.MANDT` `I_WORKCENTERBYSEMANTICKEY.CAPACITYINTERNALID == KAKO.KAPID`
Employee Suitability Client Employee Suitability Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == T423.MANDT` `I_WORKCENTERBYSEMANTICKEY.EMPLOYEESUITABILITY == T423.QUALF` `I_WORKCENTERBYSEMANTICKEY.PLANT == T423.WERKS`
Employee Wage Group Client Employee Wage Group Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == T421.MANDT` `I_WORKCENTERBYSEMANTICKEY.EMPLOYEEWAGEGROUP == T421.LOGRP` `I_WORKCENTERBYSEMANTICKEY.PLANT == T421.WERKS`
Free Defined Table Field Semantic ID Client Free Defined Table Field Semantic ID	`I_WORKCENTERBYSEMANTICKEY.MANDT == TCN00.MANDT` `I_WORKCENTERBYSEMANTICKEY.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID`
Machine Type Client Machine Type	`I_WORKCENTERBYSEMANTICKEY.MANDT == TMATY.MANDT` `I_WORKCENTERBYSEMANTICKEY.MACHINETYPE == TMATY.MATYP`
Operation Control Profile Client ? Operation Control Profile	`I_WORKCENTERBYSEMANTICKEY.MANDT == T430.MANDT` `I_WORKCENTERBYSEMANTICKEY.[column in domain "PLNAW"] == T430.PLNAW` `I_WORKCENTERBYSEMANTICKEY.OPERATIONCONTROLPROFILE == T430.STEUS`
Plant Client Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == T001W.MANDT` `I_WORKCENTERBYSEMANTICKEY.PLANT == T001W.WERKS`
Plan Version Client Plan Version	`I_WORKCENTERBYSEMANTICKEY.MANDT == T778P.MANDT` `I_WORKCENTERBYSEMANTICKEY.PLANVERSION == T778P.PLVAR`
Operation Standard Text Internal ID Client Operation Standard Text Internal ID	`I_WORKCENTERBYSEMANTICKEY.MANDT == T435.MANDT` `I_WORKCENTERBYSEMANTICKEY.STANDARDTEXTINTERNALID == T435.VLSCH`
Standard Value Key Client Standard Value Key	`I_WORKCENTERBYSEMANTICKEY.MANDT == TC21.MANDT` `I_WORKCENTERBYSEMANTICKEY.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS`
Unit of Measure of Work Client Unit of Measure of Work	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.STANDARDWORKQUANTITYUNIT == T006.MSEHI`
Production Supply Area Client Production Supply Area Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == PVBE.MANDT` `I_WORKCENTERBYSEMANTICKEY.SUPPLYAREA == PVBE.PRVBE` `I_WORKCENTERBYSEMANTICKEY.PLANT == PVBE.WERKS`
Work Center Category Client Work Center Category	`I_WORKCENTERBYSEMANTICKEY.MANDT == TC30.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERCATEGORYCODE == TC30.VERWE`
Object ID of the resource Client Object ID of the resource Object types of the CIM resource	`I_WORKCENTERBYSEMANTICKEY.MANDT == CRID.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERINTERNALID == CRID.OBJID` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERTYPECODE == CRID.OBJTY`
Work center location Client Work center location Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == T499S.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERLOCATION == T499S.STAND` `I_WORKCENTERBYSEMANTICKEY.PLANT == T499S.WERKS`
Unit for the Minimum Queue Time Client Unit for the Minimum Queue Time	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERMINIMUMQUEUEDURNUNIT == T006.MSEHI`
Work Center Setup Type Client Work Center Setup Type Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == T428.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSETUPTYPE == T428.RASCH` `I_WORKCENTERBYSEMANTICKEY.PLANT == T428.WERKS`
Standard Work Quantity Unit 1 Client Standard Work Quantity Unit 1	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTANDARDWORKQTYUNIT1 == T006.MSEHI`
Standard Work Quantity Unit 2 Client Standard Work Quantity Unit 2	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTANDARDWORKQTYUNIT2 == T006.MSEHI`
Standard Work Quantity Unit 3 Client Standard Work Quantity Unit 3	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTANDARDWORKQTYUNIT3 == T006.MSEHI`
Standard Work Quantity Unit 4 Client Standard Work Quantity Unit 4	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTANDARDWORKQTYUNIT4 == T006.MSEHI`
Standard Work Quantity Unit 5 Client Standard Work Quantity Unit 5	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTANDARDWORKQTYUNIT5 == T006.MSEHI`
Standard Work Quantity Unit 6 Client Standard Work Quantity Unit 6	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTANDARDWORKQTYUNIT6 == T006.MSEHI`
Unit for the Standard Queue Time Client Unit for the Standard Queue Time	`I_WORKCENTERBYSEMANTICKEY.MANDT == T006.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERSTDQUEUEDURNUNIT == T006.MSEHI`
Work Center Usage in Bill of Operations Client Work Center Usage in Bill of Operations	`I_WORKCENTERBYSEMANTICKEY.MANDT == TC23.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERUSAGE == TC23.PLANV`

Other Relations \| to Master Data Relations ↑	Join Conditions
Person Responsible for the Work Center Client Person Responsible for the Work Center Plant	`I_WORKCENTERBYSEMANTICKEY.MANDT == TC24.MANDT` `I_WORKCENTERBYSEMANTICKEY.WORKCENTERRESPONSIBLE == TC24.VERAN` `I_WORKCENTERBYSEMANTICKEY.PLANT == TC24.WERKS`