SAP table MAAPV (Material Master View: Sales Screen 1)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MATNR
ZIEME Target Quantity UoM UNIT 3 0 DZIEME
BRGEW Gross weight QUAN 13 3 BRGEW
NTGEW Net weight QUAN 13 3 NTGEW
GEWEI Weight Unit UNIT 3 0 GEWEI
VOLUM Volume QUAN 13 3 VOLUM
VOLEH Volume unit UNIT 3 0 VOLEH
RAUBE Storage conditions CHAR 2 0 T142 RAUBE
TEMPB Temperature conditions indicator CHAR 2 0 T143 TEMPB
VKORG Sales Organization CHAR 4 0 VKORG
VTWEG Distribution Channel CHAR 2 0 VTWEG
VERSG Statistics group CHAR 1 0 VERSG
BONUS Volume rebate group CHAR 2 0 BONUS
PROVG Commission Group CHAR 2 0 PROVG
SKTOF Cash Discount Indicator CHAR 1 0 SKTOF
VMSTA Distribution-chain-specific material status CHAR 2 0 VMSTA
VMSTD Date from which distr.-chain-spec. material status is valid DATS 8 0 VMSTD
AUMNG Minimum order quantity in base unit of measure QUAN 13 3 MINAU
LFMNG Minimum Delivery Quantity in Delivery Note Processing QUAN 13 3 MINLF
EFMNG Minimum make-to-order quantity QUAN 13 3 MINEF
SCMNG Delivery unit QUAN 13 3 SCHRT
SCHME Unit of measure of delivery unit UNIT 3 0 SCHME
VRKME Sales unit UNIT 3 0 VRKME
SPART Division CHAR 2 0 SPART
ARKTX Short text for sales order item CHAR 40 0 ARKTX
PRODH Product hierarchy CHAR 18 0 PRODH_D
PMATN Pricing Reference Material CHAR 40 0 PMATN
MTPOS Item Category Group from Material Master CHAR 4 0 MTPOS
DWERK Delivering Plant CHAR 4 0 DWERK
MEINS Base Unit of Measure UNIT 3 0 MEINS
TRAGR Transportation Group CHAR 4 0 TRAGR
MATKL Material Group CHAR 9 0 T023 MATKL
MTART Material type CHAR 4 0 MTART
KONDM Material Price Group CHAR 2 0 KONDM
KTGRM Account Assignment Group for Material CHAR 2 0 KTGRM
MVGR1 Material Group 1 CHAR 3 0 TVM1 MVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MVGR3 Material Group 3 CHAR 3 0 TVM3 MVGR3
MVGR4 Material Group 4 CHAR 3 0 TVM4 MVGR4
MVGR5 Material Group 5 CHAR 3 0 TVM5 MVGR5
PRDHA Product hierarchy CHAR 18 0 PRODH_D
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
DISST Low-Level Code CHAR 3 0 DISST
KUNNR Customer Number CHAR 10 0 KUNNR
VHART Packaging Material Type CHAR 4 0 VHIART
FUELG Maximum level (by volume) DEC 3 0 FUELG
STFAK Stacking factor INT2 5 0 STFAK
MAGRV Material Group: Packaging Materials CHAR 4 0 MAGRV
ERGEI Weight Unit UNIT 3 0 GEWEI
ERGEW Allowed packaging weight QUAN 13 3 ERGEW
ERVOE Volume unit UNIT 3 0 VOLEH
ERVOL Allowed packaging volume QUAN 13 3 ERVOL
GEWTO Excess Weight Tolerance for Handling unit DEC 3 1 GEWTO
VOLTO Excess Volume Tolerance of the Handling Unit DEC 3 1 VOLTO
PRAT1 ID for product attribute 1 CHAR 1 0 PRAT1
PRAT2 ID for product attribute 2 CHAR 1 0 PRAT2
PRAT3 ID for product attribute 3 CHAR 1 0 PRAT3
PRAT4 ID for product attribute 4 CHAR 1 0 PRAT4
PRAT5 ID for product attribute 5 CHAR 1 0 PRAT5
PRAT6 ID for product attribute 6 CHAR 1 0 PRAT6
PRAT7 ID for product attribute 7 CHAR 1 0 PRAT7
PRAT8 ID for product attribute 8 CHAR 1 0 PRAT8
PRAT9 ID for product attribute 9 CHAR 1 0 PRAT9
PRATA ID for product attribute 10 CHAR 1 0 PRATA
Product does not have this attribute
X Product has this attribute
MLGUT Empties Bill of Material CHAR 1 0 W_MITLEERG
KZUMW Environmentally Relevant CHAR 1 0 KZUMW
KOSCH Product allocation determination procedure CHAR 18 0 KOSCH
ATTYP Material Category CHAR 2 0 ATTYP
Product
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 CHAR 1 0 T137 MBRSH
KZGVH Packaging Material is Closed Packaging CHAR 1 0 KZGVH
MSTAV Cross-distribution-chain material status CHAR 2 0 MSTAV
MSTDV Date from which the X-distr.-chain material status is valid DATS 8 0 MSTDV
KZWSM Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
PROFL Dangerous Goods Indicator Profile CHAR 3 0 ADGE_PROFL
MPROF Mfr part profile CHAR 4 0 MPROF
SATNR Cross-Plant Configurable Material CHAR 40 0 SATNR
KZKFG Configurable Material CHAR 1 0 KZKFG
MTPOS_MARA General item category group CHAR 4 0 MTPOS_MARA
VAVME Variable Sales Unit Not Allowed CHAR 1 0 VAVME
BFLME Generic Material with Logistical Variants CHAR 1 0 BFLME
Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
PVMSO Material sorting in product proposal NUMC 8 0 PVMSO
SGT_REL Segmentation Relevant CHAR 1 0 SGT_REL
CHML_CMPLNC_RLVNCE_IND Chemical Compliance Relevance Indicator CHAR 1 0 CHML_CMPLNC_RLVNCE_IND
Not Decided
N No
Y Yes
COLOR Characteristic Value for Colors of Variants CHAR 18 0 WRF_COLOR
SIZE1 Characteristic Value for Main Sizes of Variants CHAR 18 0 WRF_SIZE1
SIZE2 Characteristic Value for Second Size for Variants CHAR 18 0 WRF_SIZE2

MAAPV foreign key relationships

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