MDRR SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

MDRR 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 MDRR table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include RSNUM (Number of Reservation/Dependent Requirement), RSPOS (Item Number of Reservation/Dependent Requirement), RSART (Record type), BDART (Requirement type).. 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 MDRR 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
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10RSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RSARTRecord type RSARTCHAR1RSART
BDARTRequirement type BDARTCHAR2BDARTBDA
RSSTAStatus of reservation RSSTACHAR1STATR
XLOEKItem is Deleted XLOEKCHAR1XFELD
XWAOKGoods Movement for Reservation Allowed XWAOKCHAR1XFELD
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
XFEHLMissing Part XFEHLCHAR1XFELD
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
PRVBEProduction Supply Area PRVBECHAR10PRVBEPVB
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA
PLPLADistribution of Differences PLPLACHAR10PLPLA
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
BDTERRequirement Date for the Component BDTERDATS8DATUM
BDMNGRequirement Quantity BDMNGQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
ENMNGQuantity Withdrawn ENMNGQUAN13(3) MENG13
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3T006CUNITMEINS
PLNUMPlanned order number PLNUMCHAR10PLAFALPHAPLNUMPAF
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
BAUGRMaterial number of higher-level assembly BAUGRCHAR18MARAMATN1MATNR
SERNRBOM explosion number SERNRCHAR8SNUMSERNR
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
SAKNRG/L Account Number SAKNRCHAR10ALPHASAKNRSAKC_SAKNR
POSTPItem Category (Bill of Material) POSTPCHAR1T418POSTP
POSNRBOM item number APOSNCHAR4NUMCVSPOSN
ROMS1Size 1 ROMS1QUAN13(3) MENG13
ROMS2Size 2 ROMS2QUAN13(3) MENG13
ROMS3Size 3 ROMS3QUAN13(3) MENG13
ROMEIUnit of measure for sizes 1 to 3 ROMEIUNIT3T006CUNITMEINS
ROMENQuantity of variable-size item ROMENQUAN13(3) MENG13
ROHPSVariable-sized item indicator ROHPSCHAR1XFELD
RFORMFormula key RFORMCHAR2T418FRFORM
ROANZNumber of variable-size items ROANZQUAN13(3) MENG13
STLTYBOM category STLTYCHAR1STLTY
STLNRBill of material STNUMCHAR8NUMCVSTNUMSTLNR
STLKNBOM item node number STLKNNUMC8KNTNR
STPOZInternal counter CIM_COUNTNUMC8CIM_COUNT
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
SBTERLatest requirements date SBTERDATS8DATUM
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
PSPELWBS Element PS_POSNRNUMC8ABPSPPS_POSNR
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
PLNFLSequence PLNFOLGECHAR6ALPHAPLNFOLGE
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
RGEKZIndicator: Backflush RGEKZCHAR1XFELD
VMENGConfirmed quantity for availability check in SKU VMENGQUAN15(3) MENG15
PRREGChecking Rule for Availability Check PRREGCHAR2T441RPRREGPRR
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
LGTYPStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
ESMNGUsage quantity per order unit of measure ESMNGFLTP16(16) ESMNG
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS

Key field Non-key field



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

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

SELECT SINGLE *
FROM MDRR
INTO CORRESPONDING FIELDS OF WA_MDRR
WHERE...

How to access SAP table MDRR

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