C_Productsupplierean

Consumption - SupplierGTIN | view: CPRDSUPLREAN | Extraction: Not supported | Component: Material Master

Tables used: MLEA

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (1)
Other (3)
🔗 Relations (7)

Column Name	Description
Product FK	Material Number
AlternativeUnit FK	Unit of Measure for Display
ProductUnit FK	Unit of Measure for Display
Supplier FK	Account Number of Supplier
SequenceNumber	Consecutive Number

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
IsSupplierMainGTINIndicator	Indicator: Main EAN of the vendor	Show values

Column Name	Description	Domain name
SequenceNumberForEdit	Consecutive Number	CHAR5
GlobalTradeItemNumber	International Article Number (EAN/UPC)	EAN11
SupplierProduct	Material Number Used by Supplier	IDNEX

Master Data Relations	Join Conditions
Unit of Measure for Display Client Material Number Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display	`C_PRODUCTSUPPLIEREAN.MANDT == MARM.MANDT` `C_PRODUCTSUPPLIEREAN.PRODUCT == MARM.MATNR` `C_PRODUCTSUPPLIEREAN.PRODUCTUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.PRODUCTUNITFOREDIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNITFOREDIT == MARM.MEINH`
Unit of Measure for Display Client Material Number Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display	`C_PRODUCTSUPPLIEREAN.MANDT == MARM.MANDT` `C_PRODUCTSUPPLIEREAN.PRODUCT == MARM.MATNR` `C_PRODUCTSUPPLIEREAN.PRODUCTUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.PRODUCTUNITFOREDIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNITFOREDIT == MARM.MEINH`
Material Number Client Material Number	`C_PRODUCTSUPPLIEREAN.MANDT == MARA.MANDT` `C_PRODUCTSUPPLIEREAN.PRODUCT == MARA.MATNR`
Unit of Measure for Display Client Material Number Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display	`C_PRODUCTSUPPLIEREAN.MANDT == MARM.MANDT` `C_PRODUCTSUPPLIEREAN.PRODUCT == MARM.MATNR` `C_PRODUCTSUPPLIEREAN.PRODUCTUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.PRODUCTUNITFOREDIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNITFOREDIT == MARM.MEINH`
Unit of Measure for Display Client Material Number Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display Unit of Measure for Display	`C_PRODUCTSUPPLIEREAN.MANDT == MARM.MANDT` `C_PRODUCTSUPPLIEREAN.PRODUCT == MARM.MATNR` `C_PRODUCTSUPPLIEREAN.PRODUCTUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.PRODUCTUNITFOREDIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNIT == MARM.MEINH` `C_PRODUCTSUPPLIEREAN.ALTERNATIVEUNITFOREDIT == MARM.MEINH`
Account Number of Supplier Account Number of Supplier Account Number of Supplier Client	`C_PRODUCTSUPPLIEREAN.SUPPLIER == LFA1.LIFNR` `C_PRODUCTSUPPLIEREAN.SUPPLIERFOREDIT == LFA1.LIFNR` `C_PRODUCTSUPPLIEREAN.MANDT == LFA1.MANDT`
Account Number of Supplier Account Number of Supplier Account Number of Supplier Client	`C_PRODUCTSUPPLIEREAN.SUPPLIER == LFA1.LIFNR` `C_PRODUCTSUPPLIEREAN.SUPPLIERFOREDIT == LFA1.LIFNR` `C_PRODUCTSUPPLIEREAN.MANDT == LFA1.MANDT`