A_ProductPlantIntlTrd

International Trade Data | view: APRDPLNTFRIGNTRD | Extraction: Not supported | 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
  • ?
  • Control code for consumption taxes in foreign trade
  • Client
  • A_PRODUCTPLANTINTLTRD.[column in domain "LAND1"] == T604F.LAND1
  • A_PRODUCTPLANTINTLTRD.CONSUMPTIONTAXCTRLCODE == T604F.STEUC
  • A_PRODUCTPLANTINTLTRD.MANDT == T604F.MANDT
Country/Region of Origin of Product
  • Country/Region of Origin of Product
  • Client
  • A_PRODUCTPLANTINTLTRD.COUNTRYOFORIGIN == T005.LAND1
  • A_PRODUCTPLANTINTLTRD.MANDT == T005.MANDT
Checking group
  • Material Group for Intrastat
  • Client
  • A_PRODUCTPLANTINTLTRD.EXPORTANDIMPORTPRODUCTGROUP == TVFM.MTVER
  • A_PRODUCTPLANTINTLTRD.MANDT == TVFM.MANDT
Plant
  • Client
  • Plant
  • A_PRODUCTPLANTINTLTRD.MANDT == T001W.MANDT
  • A_PRODUCTPLANTINTLTRD.PLANT == T001W.WERKS
Foreign trade: PRODCOM number
  • ?
  • Production statistics: PRODCOM number for foreign trade
  • Client
  • A_PRODUCTPLANTINTLTRD.[column in domain "LAND1"] == T609G.LAND1
  • A_PRODUCTPLANTINTLTRD.PRODINTLTRADECLASSIFICATION == T609G.GPNUM
  • A_PRODUCTPLANTINTLTRD.MANDT == T609G.MANDT
Product Number
  • Client
  • Product Number
  • A_PRODUCTPLANTINTLTRD.MANDT == MARA.MANDT
  • A_PRODUCTPLANTINTLTRD.PRODUCT == MARA.MATNR
Foreign trade: CAS number - pharmaceutical products
  • ?
  • Client
  • CAS number for pharmaceutical products in foreign trade
  • A_PRODUCTPLANTINTLTRD.[column in domain "EILAN"] == T610C.LAND1
  • A_PRODUCTPLANTINTLTRD.MANDT == T610C.MANDT
  • A_PRODUCTPLANTINTLTRD.PRODUCTCASNUMBER == T610C.CASNR
Region of Origin
  • Country/Region of Origin of Product
  • Region of Origin
  • Client
  • A_PRODUCTPLANTINTLTRD.COUNTRYOFORIGIN == T005S.LAND1
  • A_PRODUCTPLANTINTLTRD.REGIONOFORIGIN == T005S.BLAND
  • A_PRODUCTPLANTINTLTRD.MANDT == T005S.MANDT