I_WorkCenter

Work Center | view: IPPWORKCENTER | ATTR | Extraction: Full only | Component: Virtual Data Model in PP Master Data
Tables used: CRHD
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
📏 Work Center Formula Parameter Unit 6 (WorkCenterFmlaParamUnit6):
WorkCenterStandardQueueDurn Standard Queue Time
WorkCenterMinimumQueueDuration Minimum Queue Time
WorkCenterFmlaParamValue6 Work Center Formula Parameter Value 6
📏 Work Center Formula Parameter Unit 1 (WorkCenterFmlaParamUnit1):
WorkCenterFmlaParamValue1 Work Center Formula Parameter Value 1
📏 Work Center Formula Parameter Unit 2 (WorkCenterFmlaParamUnit2):
WorkCenterFmlaParamValue2 Work Center Formula Parameter Value 2
📏 Work Center Formula Parameter Unit 3 (WorkCenterFmlaParamUnit3):
WorkCenterFmlaParamValue3 Work Center Formula Parameter Value 3
📏 Work Center Formula Parameter Unit 4 (WorkCenterFmlaParamUnit4):
WorkCenterFmlaParamValue4 Work Center Formula Parameter Value 4
📏 Work Center Formula Parameter Unit 5 (WorkCenterFmlaParamUnit5):
WorkCenterFmlaParamValue5 Work Center Formula Parameter Value 5
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
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
LaborTrackingIsRequired Indicates Whether Labor Tracking is Required for Execution 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
WorkCenter Work Center ARBPL
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
WorkCenterLastChangedBy User Name CHAR12
WorkCenterLastChangeDateTime Date and Time of Last Change TZNTSTMPL
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_WORKCENTER.MANDT == KAKO.MANDT
  • I_WORKCENTER.CAPACITYINTERNALID == KAKO.KAPID
Employee Suitability
  • Client
  • Employee Suitability
  • Plant
  • I_WORKCENTER.MANDT == T423.MANDT
  • I_WORKCENTER.EMPLOYEESUITABILITY == T423.QUALF
  • I_WORKCENTER.PLANT == T423.WERKS
Employee Wage Group
  • Client
  • Plant
  • Employee Wage Group
  • I_WORKCENTER.MANDT == T421.MANDT
  • I_WORKCENTER.PLANT == T421.WERKS
  • I_WORKCENTER.EMPLOYEEWAGEGROUP == T421.LOGRP
Free Defined Table Field Semantic ID
  • Client
  • Free Defined Table Field Semantic ID
  • I_WORKCENTER.MANDT == TCN00.MANDT
  • I_WORKCENTER.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
Machine Type
  • Client
  • Machine Type
  • I_WORKCENTER.MANDT == TMATY.MANDT
  • I_WORKCENTER.MACHINETYPE == TMATY.MATYP
Operation Control Profile
  • Client
  • ?
  • Operation Control Profile
  • I_WORKCENTER.MANDT == T430.MANDT
  • I_WORKCENTER.[column in domain "PLNAW"] == T430.PLNAW
  • I_WORKCENTER.OPERATIONCONTROLPROFILE == T430.STEUS
Plant
  • Client
  • Plant
  • I_WORKCENTER.MANDT == T001W.MANDT
  • I_WORKCENTER.PLANT == T001W.WERKS
Plan Version
  • Client
  • Plan Version
  • I_WORKCENTER.MANDT == T778P.MANDT
  • I_WORKCENTER.PLANVERSION == T778P.PLVAR
Shift Note Type
  • Client
  • Shift Note Type
  • I_WORKCENTER.MANDT == TQ80.MANDT
  • I_WORKCENTER.SHIFTNOTETYPE == TQ80.QMART
Shift Report Type
  • Client
  • Shift Report Type
Operation Standard Text Internal ID
  • Client
  • Operation Standard Text Internal ID
  • I_WORKCENTER.MANDT == T435.MANDT
  • I_WORKCENTER.STANDARDTEXTINTERNALID == T435.VLSCH
Standard Value Key
  • Client
  • Standard Value Key
  • I_WORKCENTER.MANDT == TC21.MANDT
  • I_WORKCENTER.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS
Unit of Measure of Work
  • Client
  • Unit of Measure of Work
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.STANDARDWORKQUANTITYUNIT == T006.MSEHI
Production Supply Area
  • Client
  • Production Supply Area
  • Plant
  • I_WORKCENTER.MANDT == PVBE.MANDT
  • I_WORKCENTER.SUPPLYAREA == PVBE.PRVBE
  • I_WORKCENTER.PLANT == PVBE.WERKS
Work Center Category
  • Client
  • Work Center Category
  • I_WORKCENTER.MANDT == TC30.MANDT
  • I_WORKCENTER.WORKCENTERCATEGORYCODE == TC30.VERWE
Work Center Formula Parameter Unit 1
  • Client
  • Work Center Formula Parameter Unit 1
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERFMLAPARAMUNIT1 == T006.MSEHI
Work Center Formula Parameter Unit 2
  • Client
  • Work Center Formula Parameter Unit 2
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERFMLAPARAMUNIT2 == T006.MSEHI
Work Center Formula Parameter Unit 3
  • Client
  • Work Center Formula Parameter Unit 3
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERFMLAPARAMUNIT3 == T006.MSEHI
Work Center Formula Parameter Unit 4
  • Client
  • Work Center Formula Parameter Unit 4
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERFMLAPARAMUNIT4 == T006.MSEHI
Work Center Formula Parameter Unit 5
  • Client
  • Work Center Formula Parameter Unit 5
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERFMLAPARAMUNIT5 == T006.MSEHI
Work Center Formula Parameter Unit 6
  • Client
  • Work Center Formula Parameter Unit 6
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERFMLAPARAMUNIT6 == T006.MSEHI
Work Center Formula Parameter 1
  • Client
  • Work Center Formula Parameter 1
  • I_WORKCENTER.MANDT == TC20.MANDT
  • I_WORKCENTER.WORKCENTERFORMULAPARAM1 == TC20.PARID
Work Center Formula Parameter 2
  • Client
  • Work Center Formula Parameter 2
  • I_WORKCENTER.MANDT == TC20.MANDT
  • I_WORKCENTER.WORKCENTERFORMULAPARAM2 == TC20.PARID
Work Center Formula Parameter 3
  • Client
  • Work Center Formula Parameter 3
  • I_WORKCENTER.MANDT == TC20.MANDT
  • I_WORKCENTER.WORKCENTERFORMULAPARAM3 == TC20.PARID
Work Center Formula Parameter 4
  • Client
  • Work Center Formula Parameter 4
  • I_WORKCENTER.MANDT == TC20.MANDT
  • I_WORKCENTER.WORKCENTERFORMULAPARAM4 == TC20.PARID
Work Center Formula Parameter 5
  • Client
  • Work Center Formula Parameter 5
  • I_WORKCENTER.MANDT == TC20.MANDT
  • I_WORKCENTER.WORKCENTERFORMULAPARAM5 == TC20.PARID
Work Center Formula Parameter 6
  • Client
  • Work Center Formula Parameter 6
  • I_WORKCENTER.MANDT == TC20.MANDT
  • I_WORKCENTER.WORKCENTERFORMULAPARAM6 == TC20.PARID
Object ID of the resource
  • Client
  • Object types of the CIM resource
  • Object ID of the resource
  • I_WORKCENTER.MANDT == CRID.MANDT
  • I_WORKCENTER.WORKCENTERTYPECODE == CRID.OBJTY
  • I_WORKCENTER.WORKCENTERINTERNALID == CRID.OBJID
Work center location
  • Client
  • Plant
  • Work center location
  • I_WORKCENTER.MANDT == T499S.MANDT
  • I_WORKCENTER.PLANT == T499S.WERKS
  • I_WORKCENTER.WORKCENTERLOCATION == T499S.STAND
Unit for the Minimum Queue Time
  • Client
  • Unit for the Minimum Queue Time
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERMINIMUMQUEUEDURNUNIT == T006.MSEHI
Work Center Setup Type
  • Client
  • Plant
  • Work Center Setup Type
  • I_WORKCENTER.MANDT == T428.MANDT
  • I_WORKCENTER.PLANT == T428.WERKS
  • I_WORKCENTER.WORKCENTERSETUPTYPE == T428.RASCH
Standard Work Quantity Unit 1
  • Client
  • Standard Work Quantity Unit 1
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTANDARDWORKQTYUNIT1 == T006.MSEHI
Standard Work Quantity Unit 2
  • Client
  • Standard Work Quantity Unit 2
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTANDARDWORKQTYUNIT2 == T006.MSEHI
Standard Work Quantity Unit 3
  • Client
  • Standard Work Quantity Unit 3
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTANDARDWORKQTYUNIT3 == T006.MSEHI
Standard Work Quantity Unit 4
  • Client
  • Standard Work Quantity Unit 4
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTANDARDWORKQTYUNIT4 == T006.MSEHI
Standard Work Quantity Unit 5
  • Client
  • Standard Work Quantity Unit 5
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTANDARDWORKQTYUNIT5 == T006.MSEHI
Standard Work Quantity Unit 6
  • Client
  • Standard Work Quantity Unit 6
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTANDARDWORKQTYUNIT6 == T006.MSEHI
Unit for the Standard Queue Time
  • Client
  • Unit for the Standard Queue Time
  • I_WORKCENTER.MANDT == T006.MANDT
  • I_WORKCENTER.WORKCENTERSTDQUEUEDURNUNIT == T006.MSEHI
Work Center Usage in Bill of Operations
  • Client
  • Work Center Usage in Bill of Operations
  • I_WORKCENTER.MANDT == TC23.MANDT
  • I_WORKCENTER.WORKCENTERUSAGE == TC23.PLANV
Human Resource Object ID
  • Client
  • Human Resource Object ID
  • Plan Version
  • ?
  • I_WORKCENTER.MANDT == PLOGI.MANDT
  • I_WORKCENTER.WRKCTRHUMRSCEOBJID == PLOGI.OBJID
  • I_WORKCENTER.PLANVERSION == PLOGI.PLVAR
  • I_WORKCENTER.[column in domain "OTYPE"] == PLOGI.OTYPE
Formula for the Internal Processing Duration
  • Client
  • Formula for the Internal Processing Duration
  • I_WORKCENTER.MANDT == TC25.MANDT
  • I_WORKCENTER.WRKCTRINTPROCGSCHEDGFMLA == TC25.IDENT
Formula for the duration of processing time
  • Client
  • Formula for the duration of processing time
  • I_WORKCENTER.MANDT == TC25.MANDT
  • I_WORKCENTER.WRKCTRPROCGSCHEDGFMLA == TC25.IDENT
Formula for setup time
  • Formula for setup time
  • Client
  • I_WORKCENTER.WRKCTRSETUPSCHEDGFMLA == TC25.IDENT
  • I_WORKCENTER.MANDT == TC25.MANDT
Formula for teardown time
  • Client
  • Formula for teardown time
  • I_WORKCENTER.MANDT == TC25.MANDT
  • I_WORKCENTER.WRKCTRTEARDOWNSCHEDGFMLA == TC25.IDENT
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Client
  • Plant
  • Person Responsible for the Work Center
  • I_WORKCENTER.MANDT == TC24.MANDT
  • I_WORKCENTER.PLANT == TC24.WERKS
  • I_WORKCENTER.WORKCENTERRESPONSIBLE == TC24.VERAN