N_ProductPlant

Auxiliary view for Plant | view: NPRDPLANT | Extraction: Not supported | Component: Material Master
Tables used: T005TT001WTMABCTT024T001LMARCMARD
Column Name Description
Product FK Material Number
Plant FK Plant
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
CountryName Country/Region Name TEXT50
MaterialABCClassificationDesc Description TEXT30
PurchasingGroupName Purchasing Group Name TEXT18
Master Data Relations Join Conditions
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • N_PRODUCTPLANT.ABCINDICATOR == TMABC.MAABC
  • N_PRODUCTPLANT.MANDT == TMABC.MANDT
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • N_PRODUCTPLANT.COUNTRYOFORIGIN == T005.LAND1
  • N_PRODUCTPLANT.MANDT == T005.MANDT
MRP controller
  • MRP Controller
  • Client
  • Plant
  • N_PRODUCTPLANT.MRPRESPONSIBLE == T024D.DISPO
  • N_PRODUCTPLANT.MANDT == T024D.MANDT
  • N_PRODUCTPLANT.PLANT == T024D.WERKS
Plant
  • Client
  • Plant
  • N_PRODUCTPLANT.MANDT == T001W.MANDT
  • N_PRODUCTPLANT.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • N_PRODUCTPLANT.MANDT == MARA.MANDT
  • N_PRODUCTPLANT.PRODUCT == MARA.MATNR
Purchasing Group
  • Purchasing Group
  • Client
  • N_PRODUCTPLANT.PURCHASINGGROUP == T024.EKGRP
  • N_PRODUCTPLANT.MANDT == T024.MANDT
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Region of Origin of Material (Non-Preferential Origin)
  • Client
  • N_PRODUCTPLANT.COUNTRYOFORIGIN == T005S.LAND1
  • N_PRODUCTPLANT.REGIONOFORIGIN == T005S.BLAND
  • N_PRODUCTPLANT.MANDT == T005S.MANDT