I_ProductPlantIntlTrd

Product Plant Intrntionl Trade | view: IPRDPLNTFRIGNTRD | Extraction: Full or Incremental | Component: Material Master
Tables used: MARC
Column Name Description
Product FK Product Number
Plant FK Plant
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Foreign trade: control code
  • Client
  • ?
  • Control code for consumption taxes in foreign trade
  • I_PRODUCTPLANTINTLTRD.MANDT == T604F.MANDT
  • I_PRODUCTPLANTINTLTRD.[column in domain "LAND1"] == T604F.LAND1
  • I_PRODUCTPLANTINTLTRD.CONSUMPTIONTAXCTRLCODE == T604F.STEUC
Country/Region of Origin of Product
  • Country/Region of Origin of Product
  • Client
  • I_PRODUCTPLANTINTLTRD.COUNTRYOFORIGIN == T005.LAND1
  • I_PRODUCTPLANTINTLTRD.MANDT == T005.MANDT
Checking group
  • Material Group for Intrastat
  • Client
  • I_PRODUCTPLANTINTLTRD.EXPORTANDIMPORTPRODUCTGROUP == TVFM.MTVER
  • I_PRODUCTPLANTINTLTRD.MANDT == TVFM.MANDT
Plant
  • Client
  • Plant
  • I_PRODUCTPLANTINTLTRD.MANDT == T001W.MANDT
  • I_PRODUCTPLANTINTLTRD.PLANT == T001W.WERKS
Foreign trade: PRODCOM number
  • Production statistics: PRODCOM number for foreign trade
  • Client
  • ?
  • I_PRODUCTPLANTINTLTRD.PRODINTLTRADECLASSIFICATION == T609G.GPNUM
  • I_PRODUCTPLANTINTLTRD.MANDT == T609G.MANDT
  • I_PRODUCTPLANTINTLTRD.[column in domain "LAND1"] == T609G.LAND1
Product Number
  • Client
  • Product Number
  • I_PRODUCTPLANTINTLTRD.MANDT == MARA.MANDT
  • I_PRODUCTPLANTINTLTRD.PRODUCT == MARA.MATNR
Foreign trade: CAS number - pharmaceutical products
  • Client
  • CAS number for pharmaceutical products in foreign trade
  • ?
  • I_PRODUCTPLANTINTLTRD.MANDT == T610C.MANDT
  • I_PRODUCTPLANTINTLTRD.PRODUCTCASNUMBER == T610C.CASNR
  • I_PRODUCTPLANTINTLTRD.[column in domain "EILAN"] == T610C.LAND1
Region of Origin
  • Country/Region of Origin of Product
  • Client
  • Region of Origin
  • I_PRODUCTPLANTINTLTRD.COUNTRYOFORIGIN == T005S.LAND1
  • I_PRODUCTPLANTINTLTRD.MANDT == T005S.MANDT
  • I_PRODUCTPLANTINTLTRD.REGIONOFORIGIN == T005S.BLAND