SAP ABAP Table MAAPV (Material Master View: Sales Screen 1)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       MG (Package) Application development R/3 material master prior to 3.0
Basic Data
Table Category INTTAB    Structure 
Structure MAAPV   Table Relationship Diagram
Short Description Material Master View: Sales Screen 1    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MATNR MATNR MATNR CHAR 18   0   Material Number *
2 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM *
3 BRGEW BRGEW MENG13 QUAN 13   3   Gross weight  
4 NTGEW NTGEW MENG13 QUAN 13   3   Net weight  
5 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
6 VOLUM VOLUM MENG13 QUAN 13   3   Volume  
7 VOLEH VOLEH MEINS UNIT 3   0   Volume unit *
8 RAUBE RAUBE RAUBE CHAR 2   0   Storage conditions T142
9 TEMPB TEMPB TEMPB CHAR 2   0   Temperature conditions indicator T143
10 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
11 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
12 VERSG VERSG VERSG CHAR 1   0   Statistics group *
13 BONUS BONUS BONUS CHAR 2   0   Volume rebate group *
14 PROVG PROVG PROVG CHAR 2   0   Commission group *
15 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
16 VMSTA VMSTA VMSTA CHAR 2   0   Distribution-chain-specific material status *
17 VMSTD VMSTD DATUM DATS 8   0   Date from which distr.-chain-spec. material status is valid  
18 AUMNG MINAU MENG13 QUAN 13   3   Minimum order quantity in base unit of measure  
19 LFMNG MINLF MENG13 QUAN 13   3   Minimum delivery quantity in delivery note processing  
20 EFMNG MINEF MENG13 QUAN 13   3   Minimum make-to-order quantity  
21 SCMNG SCHRT MENG13 QUAN 13   3   Delivery unit  
22 SCHME SCHME MEINS UNIT 3   0   Unit of measure of delivery unit *
23 VRKME VRKME MEINS UNIT 3   0   Sales unit *
24 SPART SPART SPART CHAR 2   0   Division *
25 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
26 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy *
27 PMATN PMATN MATNR CHAR 18   0   Pricing Reference Material *
28 MTPOS MTPOS MTPOS CHAR 4   0   Item category group from material master *
29 DWERK DWERK WERKS CHAR 4   0   Delivering Plant *
30 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
31 TRAGR TRAGR TRAGR CHAR 4   0   Transportation Group *
32 MATKL MATKL MATKL CHAR 9   0   Material Group T023
33 MTART MTART MTART CHAR 4   0   Material type *
34 KONDM KONDM KONDM CHAR 2   0   Material Pricing Group *
35 KTGRM KTGRM KTGRM CHAR 2   0   Account assignment group for this material *
36 MVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 TVM1
37 MVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 TVM2
38 MVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 TVM3
39 MVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 TVM4
40 MVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 TVM5
41 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy *
42 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
43 DISST DISST DISST CHAR 3   0   Low-level code  
44 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
45 VHART VHIART TRATY CHAR 4   0   Shipping material type *
46 FUELG FUELG DEC3 DEC 3   0   Filling level (by volume)  
47 STFAK STFAK INT2 INT2 5   0   Stacking factor  
48 MAGRV MAGRV MAGRV CHAR 4   0   Material Group: Packaging Materials *
49 ERGEI GEWEI MEINS UNIT 3   0   Weight Unit *
50 ERGEW ERGEW MENG13 QUAN 13   3   Allowed packaging weight  
51 ERVOE VOLEH MEINS UNIT 3   0   Volume unit *
52 ERVOL ERVOL MENG13 QUAN 13   3   Allowed packaging volume  
53 GEWTO GEWTO PRZ21 DEC 3   1   Excess weight tolerance for shipping unit  
54 VOLTO VOLTO PRZ21 DEC 3   1   Excess volume tolerance limit during packing  
55 PRAT1 PRAT1 PRATA CHAR 1   0   ID for product attribute 1  
56 PRAT2 PRAT2 PRATA CHAR 1   0   ID for product attribute 2  
57 PRAT3 PRAT3 PRATA CHAR 1   0   ID for product attribute 3  
58 PRAT4 PRAT4 PRATA CHAR 1   0   ID for product attribute 4  
59 PRAT5 PRAT5 PRATA CHAR 1   0   ID for product attribute 5  
60 PRAT6 PRAT6 PRATA CHAR 1   0   ID for product attribute 6  
61 PRAT7 PRAT7 PRATA CHAR 1   0   ID for product attribute 7  
62 PRAT8 PRAT8 PRATA CHAR 1   0   ID for product attribute 8  
63 PRAT9 PRAT9 PRATA CHAR 1   0   ID for product attribute 9  
64 PRATA PRATA PRATA CHAR 1   0   ID for product attribute 10  
65 MLGUT W_MITLEERG FLAG CHAR 1   0   Empties Bill of Material  
66 KZUMW KZUMW XFELD CHAR 1   0   Indicator: Environmentally relevant  
67 KOSCH KOSCH KOSCH CHAR 18   0   Product allocation determination procedure *
68 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
69 MBRSH MBRSH MBRSH CHAR 1   0   Industry sector T137
70 KZGVH KZGVH XFELD CHAR 1   0   Shipping material is closed packaging  
71 MSTAV MSTAV VMSTA CHAR 2   0   Cross-distribution-chain material status *
72 MSTDV MSTDV DATUM DATS 8   0   Date from which the X-distr.-chain material status is valid  
73 KZWSM KZWSO KZWSO CHAR 1   0   Units of measure usage  
74 PROFL ADGE_PROFL ADGD_PROFL CHAR 3   0   Dangerous goods indicator profile *
75 MPROF MPROF MPROF CHAR 4   0   Mfr part profile *
76 SATNR SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material *
77 KZKFG KZKFG XFELD CHAR 1   0   Configurable Material  
78 MTPOS_MARA MTPOS_MARA MTPOS CHAR 4   0   General item category group *
79 VAVME VAVME XFELD CHAR 1   0   Variable Sales Unit Not Allowed  
80 BFLME BFLME BFLME CHAR 1   0   Generic Material with Logistical Variants  
81 PVMSO PVMSO PVMSO NUMC 8   0   Material sorting in product proposal *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MAAPV MATKL T023 MATKL    
2 MAAPV MBRSH T137 MBRSH    
3 MAAPV MVGR1 TVM1 MVGR1    
4 MAAPV MVGR2 TVM2 MVGR2    
5 MAAPV MVGR3 TVM3 MVGR3    
6 MAAPV MVGR4 TVM4 MVGR4    
7 MAAPV MVGR5 TVM5 MVGR5    
8 MAAPV RAUBE T142 RAUBE    
9 MAAPV TEMPB T143 TEMPB    
History
Last changed by/on SAP  20130529 
SAP Release Created in