MDQM SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

MDQM 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 MDQM table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PRUEFLOS (Inspection Lot Number), MATNR (Material Number), WERKVORG (Plant Where Stock for Inspection Lot Is Held), INSMK (Quantity Is or Was in Inspection Stock).. 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 MDQM 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
MANDANTClient MANDTCLNT3T000MANDT
PRUEFLOSInspection Lot Number QPLOSNUMC12QPLOSQLSQALS
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKVORGPlant Where Stock for Inspection Lot Is Held QWERKVORGCHAR4T001WWERKS
INSMKQuantity Is or Was in Inspection Stock QVINSMKCHAR1QKZ
PASTRTERMInspection Start Date QPRSTARTDATS8DATUM
PAENDTERMEnd Date of the Inspection QPRENDEDATS8DATUM
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
LAGORTVORGStorage Location for Inspection Lot Stock QLGORTVORGCHAR4T001LLGORT
LOSMENGEInspection Lot Quantity QLOSMENGEQUAN13(3) QMENGEPLOS
LMENGEZUBQuantity That Must Be Posted QLMENGEZUBQUAN13(3) QMENGEPLOS
MENGENEINHBase Unit of Measure for The Inspection Lot Quantity QLOSMENGEHUNIT3T006CUNITMEINS
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
PSTYPItem Category in Purchasing Document PSTYPCHAR1T163PSTYP
KDAUFSales Order Number of Valuated Sales Order Stock MAT_KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSSales Order Item of Valuated Sales Order Stock MAT_KDPOSNUMC6NUM06KPO
PS_PSP_PNRValuated Sales Order Stock WBS Element MAT_PSPNRNUMC8PRPSKONPRPS_POSNR
STAT34Stock Postings Completed QSTAT34CHAR1QKZ
STAT35Usage Decision Has Been Made QSTAT35CHAR1QKZ
HERKUNFTInspection Lot Origin QHERKCHAR2TQ31QHERKQHK
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS

Key field Non-key field



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

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

SELECT SINGLE *
FROM MDQM
INTO CORRESPONDING FIELDS OF WA_MDQM
WHERE...

How to access SAP table MDQM

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