I_WorkCenterVH

Work Center | view: IWC__VH3 | Extraction: Not supported | Component: Virtual Data Model in PP Master Data

Tables used: CRHD

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

Column Name	Description
WorkCenterInternalID FK	Object ID of the resource
WorkCenterTypeCode	Object types of the CIM resource	Show values

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