1. Home
  2. Resources
  3. SAP Tables
  4. MAAPV - Material Master View: Sales Screen 1

SAP Table MAAPV

Material Master View: Sales Screen 1

MAAPV (Material Master View: Sales Screen 1) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MAAPV to other SAP tables.

MAAPV table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR CHAR 18 0
ZIEME Target quantity UoM DZIEME UNIT 3 0
BRGEW Gross Weight BRGEW QUAN 13 3
NTGEW Net Weight NTGEW QUAN 13 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume VOLUM QUAN 13 3
VOLEH Volume unit VOLEH UNIT 3 0
RAUBE Storage conditions RAUBE T142 CHAR 2 0
TEMPB Temperature conditions indicator TEMPB T143 CHAR 2 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
VERSG Statistics group VERSG CHAR 1 0
BONUS Volume rebate group BONUS CHAR 2 0
PROVG Commission group PROVG CHAR 2 0
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
VMSTA Distribution-chain-specific material status VMSTA CHAR 2 0
VMSTD Date from which distr.-chain-spec. material status is valid VMSTD DATS 8 0
AUMNG Minimum order quantity in base unit of measure MINAU QUAN 13 3
LFMNG Minimum delivery quantity in delivery note processing MINLF QUAN 13 3
EFMNG Minimum make-to-order quantity MINEF QUAN 13 3
SCMNG Delivery unit SCHRT QUAN 13 3
SCHME Unit of measure of delivery unit SCHME UNIT 3 0
VRKME Sales unit VRKME UNIT 3 0
SPART Division SPART CHAR 2 0
ARKTX Short text for sales order item ARKTX CHAR 40 0
PRODH Product hierarchy PRODH_D CHAR 18 0
PMATN Pricing Reference Material PMATN CHAR 18 0
MTPOS Item category group from material master MTPOS CHAR 4 0
DWERK Delivering Plant DWERK CHAR 4 0
MEINS Base Unit of Measure MEINS UNIT 3 0
TRAGR Transportation Group TRAGR CHAR 4 0
MATKL Material Group MATKL T023 CHAR 9 0
MTART Material Type MTART CHAR 4 0
KONDM Material Pricing Group KONDM CHAR 2 0
KTGRM Account assignment group for this material KTGRM CHAR 2 0
MVGR1 Material group 1 MVGR1 TVM1 CHAR 3 0
MVGR2 Material group 2 MVGR2 TVM2 CHAR 3 0
MVGR3 Material group 3 MVGR3 TVM3 CHAR 3 0
MVGR4 Material group 4 MVGR4 TVM4 CHAR 3 0
MVGR5 Material group 5 MVGR5 TVM5 CHAR 3 0
PRDHA Product hierarchy PRODH_D CHAR 18 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
DISST Low-Level Code DISST CHAR 3 0
KUNNR Customer Number KUNNR CHAR 10 0
VHART Packaging Material Type VHIART CHAR 4 0
FUELG Maximum level (by volume) FUELG DEC 3 0
STFAK Stacking factor STFAK INT2 5 0
MAGRV Material Group: Packaging Materials MAGRV CHAR 4 0
ERGEI Weight Unit GEWEI UNIT 3 0
ERGEW Allowed packaging weight ERGEW QUAN 13 3
ERVOE Volume unit VOLEH UNIT 3 0
ERVOL Allowed packaging volume ERVOL QUAN 13 3
GEWTO Excess Weight Tolerance for Handling unit GEWTO DEC 3 1
VOLTO Excess Volume Tolerance of the Handling Unit VOLTO DEC 3 1
PRAT1 ID for product attribute 1 PRAT1 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT2 ID for product attribute 2 PRAT2 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT3 ID for product attribute 3 PRAT3 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT4 ID for product attribute 4 PRAT4 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT5 ID for product attribute 5 PRAT5 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT6 ID for product attribute 6 PRAT6 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT7 ID for product attribute 7 PRAT7 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT8 ID for product attribute 8 PRAT8 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT9 ID for product attribute 9 PRAT9 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRATA ID for product attribute 10 PRATA CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
MLGUT Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
KZUMW Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
KOSCH Product allocation determination procedure KOSCH CHAR 18 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
MBRSH Industry sector MBRSH T137 CHAR 1 0
KZGVH Packaging Material is Closed Packaging KZGVH CHAR 1 0
X Yes
NULL No
MSTAV Cross-distribution-chain material status MSTAV CHAR 2 0
MSTDV Date from which the X-distr.-chain material status is valid MSTDV DATS 8 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
PROFL Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 0
MPROF Manufacturer Part Profile MPROF CHAR 4 0
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
MTPOS_MARA General item category group MTPOS_MARA CHAR 4 0
VAVME Variable Sales Unit Not Allowed VAVME CHAR 1 0
X Yes
NULL No
BFLME Generic Material with Logistical Variants BFLME CHAR 1 0
NULL Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
PVMSO Material sorting in product proposal PVMSO NUMC 8 0
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)

MAAPV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MAAPV MATKL SYST MANDT T023 Material Groups MANDT
MAAPV MATKL MAAPV MATKL T023 Material Groups MATKL
MAAPV MBRSH SYST MANDT T137 Industries for materials MANDT
MAAPV MBRSH MAAPV MBRSH T137 Industries for materials MBRSH
MAAPV MVGR1 SYST MANDT TVM1 Material Pricing Group 1 MANDT
MAAPV MVGR1 MAAPV MVGR1 TVM1 Material Pricing Group 1 MVGR1
MAAPV MVGR2 SYST MANDT TVM2 Material Pricing Group 2 MANDT
MAAPV MVGR2 MAAPV MVGR2 TVM2 Material Pricing Group 2 MVGR2
MAAPV MVGR3 SYST MANDT TVM3 Material Pricing Group 3 MANDT
MAAPV MVGR3 MAAPV MVGR3 TVM3 Material Pricing Group 3 MVGR3
MAAPV MVGR4 MAAPV MVGR4 TVM4 Material Pricing Group 4 MVGR4
MAAPV MVGR4 SYST MANDT TVM4 Material Pricing Group 4 MANDT
MAAPV MVGR5 SYST MANDT TVM5 Material Pricing Group 5 MANDT
MAAPV MVGR5 MAAPV MVGR5 TVM5 Material Pricing Group 5 MVGR5
MAAPV RAUBE * T142 Storage Conditions for Materials MANDT
MAAPV RAUBE MAAPV RAUBE T142 Storage Conditions for Materials RAUBE
MAAPV TEMPB * T143 Temperature Conditions for Storing Materials MANDT
MAAPV TEMPB MAAPV TEMPB T143 Temperature Conditions for Storing Materials TEMPB