I_WrkCtrBySemanticKeyVH

Work Center by Semantic Key | view: IWCBSK__VH1 | Extraction: Not supported | Component: Virtual Data Model in PP Master Data

Tables used: CRHD

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

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

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

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