P_Productsuppliereanwd

Product Supplier EAN Union View | view: PPRDSUPLREANWD | Extraction: Not supported | Component: Material Master
Tables used: SDRAFT_ADMIN, USR21, MLEA, PRD_ROOT, PRD_SUPLR_EAN, PRD_UOM
Column Name Description
Draftkey UUID in X form (binary)
ActiveProduct FK Material Number
ActiveAlternativeUnit FK Unit of Measure for Display
ActiveSupplier FK Account Number of Supplier
ActiveProductUnit FK Unit of Measure for Display
ActiveSequenceNumber Consecutive Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsSupplierMainGTINIndicator Indicator: Main EAN of the vendor Show values
IsActiveEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasActiveEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasDraftEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
ParentDraftKey UUID in X form (binary) SYSUUID
RootDraftKey UUID in X form (binary) SYSUUID
SequenceNumber Consecutive Number CHAR5
GlobalTradeItemNumber International Article Number (EAN/UPC) EAN11
SupplierProduct Material Number Used by Supplier IDNEX
DraftAdministrativeDataUUID UUID in X form (binary) SYSUUID
Master Data Relations Join Conditions
Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Material Number
  • Material Number
  • Client
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.PRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.PRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == MARM.MANDT
Material Number
  • Material Number
  • Material Number
  • Client
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCT == MARA.MATNR
  • P_PRODUCTSUPPLIEREANWD.PRODUCT == MARA.MATNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == MARA.MANDT
Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Material Number
  • Material Number
  • Client
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.PRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.PRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == MARM.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_PRODUCTSUPPLIEREANWD.SUPPLIER == LFA1.LIFNR
  • P_PRODUCTSUPPLIEREANWD.ACTIVESUPPLIER == LFA1.LIFNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == LFA1.MANDT
Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Material Number
  • Material Number
  • Client
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.PRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.PRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == MARM.MANDT
Material Number
  • Material Number
  • Material Number
  • Client
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCT == MARA.MATNR
  • P_PRODUCTSUPPLIEREANWD.PRODUCT == MARA.MATNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == MARA.MANDT
Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Unit of Measure for Display
  • Material Number
  • Material Number
  • Client
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ALTERNATIVEUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.PRODUCTUNIT == MARM.MEINH
  • P_PRODUCTSUPPLIEREANWD.ACTIVEPRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.PRODUCT == MARM.MATNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == MARM.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_PRODUCTSUPPLIEREANWD.SUPPLIER == LFA1.LIFNR
  • P_PRODUCTSUPPLIEREANWD.ACTIVESUPPLIER == LFA1.LIFNR
  • P_PRODUCTSUPPLIEREANWD.MANDT == LFA1.MANDT