P_ProductsByWorkCenter

Products by work center | view: PPRODBYWRKCNTR | Extraction: Not supported | Component: Gantt
Tables used: MARAPLPOMAPLMARCKAKOMDMAT438AT001WMARACRTXCRHDSDM_AOR
Column Name Description
Material FK Material Number
WorkCenterInternalID FK Object ID of the resource
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
WorkCenterIsToBeDeleted Deletion flag for work center Show values
AdvancedPlanningIsSupported Indicator for Advanced Planning Show values
CapacityIsFinite Indicator: Capacity Relevant to Finite Scheduling Show values
Column Name Description Domain name
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
CapacityInternalID Capacity ID KAPID
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • P_PRODUCTSBYWORKCENTER.MANDT == MARA.MANDT
  • P_PRODUCTSBYWORKCENTER.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • P_PRODUCTSBYWORKCENTER.MANDT == T001W.MANDT
  • P_PRODUCTSBYWORKCENTER.PLANT == T001W.WERKS
Work Center Category
  • Client
  • Work Center Category
  • P_PRODUCTSBYWORKCENTER.MANDT == TC30.MANDT
  • P_PRODUCTSBYWORKCENTER.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Client
  • Object ID of the resource
  • Object types of the CIM resource
  • P_PRODUCTSBYWORKCENTER.MANDT == CRID.MANDT
  • P_PRODUCTSBYWORKCENTER.WORKCENTERINTERNALID == CRID.OBJID
  • P_PRODUCTSBYWORKCENTER.WORKCENTERTYPECODE == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Client
  • Person Responsible for the Work Center
  • Plant
  • P_PRODUCTSBYWORKCENTER.MANDT == TC24.MANDT
  • P_PRODUCTSBYWORKCENTER.WORKCENTERRESPONSIBLE == TC24.VERAN
  • P_PRODUCTSBYWORKCENTER.PLANT == TC24.WERKS