MLVSV SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

MLVSV 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 MLVSV 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), LGNUM (Warehouse Number / Warehouse Complex), WERKS (Plant), 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 MLVSV 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
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
BSTMEPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
BRGEWGross Weight BRGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
STOFFHazardous material number STOFFCHAR18MGEFMATN1STOFFSTO
LVOR2Flag Material for Deletion at Plant Level LVOWKCHAR1XFELD
AUSMEUnit of issue AUSMEUNIT3T006CUNITMEINS
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
LVORMDeletion flag for all material data of a warehouse number LVOLNCHAR1XFELD
LGBKZStorage Section Indicators LVS_LGBKZCHAR3T304LVS_LGBKZ
LTKZEStorage type indicator for stock placement MLGN_LTKZECHAR3T305LVS_LGTKZ
LTKZAStorage type indicator for stock removal MLGN_LTKZACHAR3T305LVS_LGTKZ
LHMG1Loading equipment quantity 1 LVS_LHMNG1QUAN13(3) MENG13
LHMG2Loading equipment quantity 2 LVS_LHMNG2QUAN13(3) MENG13
LHMG3Loading equipment quantity 3 LVS_LHMNG3QUAN13(3) MENG13
LETY11st storage unit type LVS_LETYP1CHAR3T307LVS_LETYP
LETY22nd storage unit type LVS_LETYP2CHAR3T307LVS_LETYP
LETY33rd storage unit type LVS_LETYP3CHAR3T307LVS_LETYP
LVSMEWarehouse Management Unit of Measure LVS_LVSMEUNIT3T006CUNITMEINS
KZZULIndicator: Allow addition to existing stock MLGN_KZZULCHAR1XFELD
BLOCKBulk storage indicator LVS_BLOCK2CHAR2T338LVS_BLOCK2
KZMBFIndicator: Message to inventory management KZMBFCHAR1XFELD
BSSKZSpecial movement indicator for warehouse management LVS_BSSKZCHAR1T306LVS_BSSKZ
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
MMSTAPlant-Specific Material Status MMSTACHAR2T141MMSTA
MKAPVCapacity usage MLGN_MKAPVDEC11(3) DEC8_3
BEZMEUnit of measure for capacity consumption MLGN_BEZMEUNIT3T006CUNITMEINS
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
MHDHBTotal shelf life MHDHBDEC4DEC4
MHDLPStorage percentage MHDLPDEC3DEC3
MLGUTEmpties Bill of Material W_MITLEERGCHAR1FLAG
PLKPTPicking storage type for rough-cut and detailed planning MLGN_PLKPTCHAR3T301LGTYPLGT
VOLUMVolume VOLUMQUAN13(3) MENG13
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
VOMEMDefault for unit of measure from material master record MLGN_VOMEMCHAR1LVS_VOME
L2SKRMaterial relevance for 2-step picking MLGN_L2SKRCHAR1LVS_2SKREL
EPRIOStock determination group BF_GROUPCHAR4T434GBF_GROUP
KZWSMUnits of measure usage KZWSOCHAR1KZWSO
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
BWTTYValuation Category BWTTY_DCHAR1T149CBWTTY
LHME1Unit of measure for loading equipment quantity 1 LHMEH1UNIT3T006CUNITMEINS
LHME2Unit of measure for loading equipment quantity 2 LHMEH2UNIT3T006CUNITMEINS
LHME3Unit of measure for loading equipment quantity 3 LHMEH3UNIT3T006CUNITMEINS
MAGRVMaterial Group: Packaging Materials MAGRVCHAR4TVEGRMAGRV
MSTAECross-Plant Material Status MSTAECHAR2T141MMSTA
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ

Key field Non-key field



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

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

SELECT SINGLE *
FROM MLVSV
INTO CORRESPONDING FIELDS OF WA_MLVSV
WHERE...

How to access SAP table MLVSV

Within an ECC or HANA version of SAP you can also view further information about MLVSV 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!