C_ProductsByWorkCenter

Products by work center | view: CPRODBYWRKCNTR | Extraction: Not supported | Component: Buffer Positioning
Tables used: PLPOMAPLKAKOCRTXCRHD
Column Name Description
Material FK Material Number
Plant FK Plant
WorkCenter Work Center
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
WorkCenterText Work Center Text TEXT40
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • C_PRODUCTSBYWORKCENTER.MATERIAL == MARA.MATNR
  • C_PRODUCTSBYWORKCENTER.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • C_PRODUCTSBYWORKCENTER.MANDT == T001W.MANDT
  • C_PRODUCTSBYWORKCENTER.PLANT == T001W.WERKS
Work Center Category
  • Client
  • Work Center Category
  • C_PRODUCTSBYWORKCENTER.MANDT == TC30.MANDT
  • C_PRODUCTSBYWORKCENTER.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Client
  • Object ID of the resource
  • Object types of the CIM resource
  • C_PRODUCTSBYWORKCENTER.MANDT == CRID.MANDT
  • C_PRODUCTSBYWORKCENTER.WORKCENTERINTERNALID == CRID.OBJID
  • C_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
  • C_PRODUCTSBYWORKCENTER.MANDT == TC24.MANDT
  • C_PRODUCTSBYWORKCENTER.WORKCENTERRESPONSIBLE == TC24.VERAN
  • C_PRODUCTSBYWORKCENTER.PLANT == TC24.WERKS