MABW

Management of Differently Maintained Material Data in Retail | #masterdata | Component: Article

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

Column Name	Description
MANDT FK	Client
MATNR FK	Material Number
ZHLER	Eight-digit numeric value

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Valuation area Valuation area Client	`MABW.BWKEY == T001K.BWKEY` `MABW.MANDT == T001K.MANDT`
Material/valuation area/valuation type Material Number Valuation area Valuation Type	`MABW.MANDT == MBEW.MANDT` `MABW.MATNR == MBEW.MATNR` `MABW.BWKEY == MBEW.BWKEY` `MABW.BWTAR == MBEW.BWTAR`
Material/warehouse number Warehouse Number / Warehouse Complex Material Number	`MABW.MANDT == MLGN.MANDT` `MABW.LGNUM == MLGN.LGNUM` `MABW.MATNR == MLGN.MATNR`
Material/plant/storage location Plant Material Number Storage location	`MABW.MANDT == MARD.MANDT` `MABW.WERKS == MARD.WERKS` `MABW.MATNR == MARD.MATNR` `MABW.LGORT == MARD.LGORT`
Material/warehouse number/storage type Storage Type Client Material Number Warehouse Number / Warehouse Complex	`MABW.LGTYP == MLGT.LGTYP` `MABW.MANDT == MLGT.MANDT` `MABW.MATNR == MLGT.MATNR` `MABW.LGNUM == MLGT.LGNUM`
Client	`MABW.MANDT == T000.MANDT`
Material Material Number Client	`MABW.MATNR == MARA.MATNR` `MABW.MANDT == MARA.MANDT`
Sales organization	`MABW.MANDT == TVKO.MANDT` `MABW.VKORG == TVKO.VKORG`
Material/sales organization/distribution channel Distribution Channel Client Material Number Sales Organization	`MABW.VTWEG == MVKE.VTWEG` `MABW.MANDT == MVKE.MANDT` `MABW.MATNR == MVKE.MATNR` `MABW.VKORG == MVKE.VKORG`
Material/plant Material Number Client Plant	`MABW.MATNR == MARC.MATNR` `MABW.MANDT == MARC.MANDT` `MABW.WERKS == MARC.WERKS`