MA06V SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from MA06V
Related tables to MA06V
Access table MA06V




Table View field list including key, data, relationships and ABAP select examples

MA06V is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The MA06V table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include MATNR (Material Number), WERKS (Plant), MATKL (Material Group), MEINS (Base Unit of Measure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MA06V table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
BSTMEPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
MLGUTEmpties Bill of Material W_MITLEERGCHAR1FLAG
CUOBJInternal object number CUOBMNUMC18CUOBJ
DISSTLow-Level Code DISSTCHAR3DISST
VABMEVariable Purchase Order Unit Active VABMECHAR1VABME
PSTATMaintenance status PSTAT_DCHAR15PSTAT
LVORMFlag Material for Deletion at Plant Level LVOWKCHAR1XFELD
BWTTYValuation Category BWTTY_DCHAR1T149CBWTTY
AUSMEUnit of issue AUSMEUNIT3T006CUNITMEINS
MMSTAPlant-Specific Material Status MMSTACHAR2T141MMSTA
MMSTDDate from which the plant-specific material status is valid MMSTDDATS8DATUM
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
DISPOMRP Controller (Materials Planner) DISPOCHAR3T024DDISPODGRHS_T024D
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
INSMKPost to Inspection Stock INSMK_MATCHAR1QKZ
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
DISMMMRP Type DISMMCHAR2T438ADISMM
USEQUQuota arrangement usage USEQUCHAR1TMQ2USEQU
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
EKWSLPurchasing Value Key EKWSLCHAR4T405EKWSL
BWSCLSource of Supply BWSCLCHAR1TMBW1BQSCL
NTGEWNet Weight NTGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
KORDBIndicator: Source list requirement KORDBCHAR1XFELD
STAWNCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17T604STAWN
KAUTBIndicator: 'automatic purchase order allowed' KAUTBCHAR1FLAG
HERKLCountry of origin of the material HERKLCHAR3T005LAND1LND
HERKRRegion of origin of material (non-preferential origin) HERKRCHAR3T005SREGIO
QMPURQM in Procurement is Active QMPURCHAR1XFELD
SSQSSControl Key for Quality Management in Procurement QSSPURCHAR8TQ08QSSPUR
QZGTPCertificate Type QZGTYPCHAR4TQ05QZGTYPQCT
QMATVInspection Setup Exists for Material/Plant QMATVCHAR1XFELD
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
KZREVRevision Level Has Been Assigned to the Material KZREVCHAR1XFELD
BRGEWGross Weight BRGEWQUAN13(3) MENG13
VOLUMVolume VOLUMQUAN13(3) MENG13
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
QSSYSRequired QM System for Vendor QSSYS_SOLLCHAR4TQ02QSSYS
KZKFGConfigurable Material KZKFGCHAR1XFELD
SATNRCross-Plant Configurable Material SATNRCHAR18MARAMATN1MATNR
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
BESKZProcurement Type BESKZCHAR1BESKZMBS
SOBSLSpecial procurement type SOBSLCHAR2T460ASOBSL
PRDHAProduct hierarchy PRODH_DCHAR18T179PRODHVPR
PLGTPPrice Band Category PLGTPCHAR2TWPTPLGTP
SAISOSeason Category SAISOCHAR4T6WSPSAISOSAISO
SAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
ETIARLabel type ETIARCHAR2T6WP3ETIAR
ETIFOLabel form ETIFOCHAR2T6WP4ETIFO
BWVORProcurement rule BWVORCHAR1T6WP1BWVOR
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
MHDHBTotal shelf life MHDHBDEC4DEC4
SERVGIS-R service level W_SERVGRDCHAR1TWSGW_SERVGRD
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
SBDKZDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
ALTSLMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
STDPDConfigurable material STDPDCHAR18MARAMATN1MATNR
CUOBFInternal object number CUOBMNUMC18CUOBJ
LGFSBDefault storage location for external procurement LGFSBCHAR4T001LLGORT
DATABValid-From Date DATABDATS8DATUM
LIQDTDeletion date LIQDTDATS8DATUM
MSTAECross-Plant Material Status MSTAECHAR2T141MMSTA
MSTDEDate from which the cross-plant material status is valid MSTDEDATS8DATUM
MRPPPPPC planning calendar MRPPPCHAR3T439GMRPPP
NRFHGMaterial qualifies for discount in kind NRFHGCHAR1NRFHG
MFRGRMaterial freight group MFRGRCHAR8TMFGMFRGR
STEUCControl code for consumption taxes in foreign trade STEUCCHAR16T604FSTEUC
INDUSMaterial CFOP category J_1BINDUS3CHAR2ALPHAJ_1BINDUS3
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10LFA1ALPHALIFNR
BMATNNumber of firm's own (internal) inventory-managed material MPMATCHAR18MARAMATN1MATNRMAT
MPROFManufacturer Part Profile MPROFCHAR4TMPPFMPROF
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
FABKZIndicator: Item Relevant to JIT Delivery Schedules FABKZCHAR1FABKZ
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
TRAGRTransportation Group TRAGRCHAR4TTGRTRAGR
SERNPSerial Number Profile SERAILCHAR4T377PSERAIL
BFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME
LADGRLoading Group LADGRCHAR4TLGRLADGR
LFRHYPlanning cycle LFRHYCHAR3MRPPP
PERKZPeriod Indicator PERKZCHAR1PERKZPKZ
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
RDPRFRounding Profile RDPRFCHAR4RDPRRDPRF
BSTRFRounding value for purchase order quantity BSTRFQUAN13(3) MENG13
BSTMAMaximum Lot Size BSTMAQUAN13(3) MENG13
BSTMIMinimum Lot Size BSTMIQUAN13(3) MENG13
MEGRUUnit of Measure Group MEGRUCHAR4TWMEGMEGRU
PRENCExemption certificate: Indicator for legal control PRENCCHAR1PRENC
IMATNFFF class IMATNCHAR18MATN1MATNR
PICNUMSupersession chain number PIC_PICNUM_SUSCHAR18ALPHAPIC_PICNUMPIC_PICNUM
CONS_PROCGConsignment Control WRF_CONS_PROCGCHAR1WRFT_CONS_PROCGWRF_CONS_PROCG
GI_PR_TIMEGoods Issue Processing Time in Days WRF_PSCD_WABAZDEC3DEC3
MULTIPLE_EKGRPPurchasing Across Purchasing Group WRF_POHF_OTHER_EKGRP_ALLOWCHAR1CHAR1_X

Key field Non-key field



How do I retrieve data from SAP table MA06V using ABAP code

The following ABAP code Example will allow you to do a basic selection on MA06V to SELECT all data from the table
DATA: WA_MA06V TYPE MA06V.

SELECT SINGLE *
FROM MA06V
INTO CORRESPONDING FIELDS OF WA_MA06V
WHERE...

How to access SAP table MA06V

Within an ECC or HANA version of SAP you can also view further information about MA06V and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!