MB_MDBS SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

MB_MDBS 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 MB_MDBS table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), ETENR (Delivery Schedule Line Counter), MATNR (Material Number).. 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 MB_MDBS 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
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EBELPBSP
ETENRDelivery Schedule Line Counter EETENNUMC4EETEN
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant EWERKCHAR4T001WWERKSWRK
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
LOEKZDeletion Indicator in Purchasing Document ELOEKCHAR1ELOEK
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
MEINSPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
UMREZNumerator for Conversion of Order Unit to Base Unit UMBSZDEC5UMBSZ
UMRENDenominator for Conversion of Order Unit to Base Unit UMBSNDEC5UMBSN
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
PSTYPItem Category in Purchasing Document PSTYPCHAR1T163PSTYP
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
KZVBRConsumption Posting KZVBRCHAR1KZVBR
ETFZ1Firm Zone (Go-Ahead for Production) ETFZ1DEC3PACK2
ETFZ2Trade-Off Zone (Go-Ahead for Materials Procurement) ETFZ2DEC3PACK2
BSTAEConfirmation Control Key BSTAECHAR4T163LBSTAE
ARSNRSettlement reservation number ARSNRNUMC10MDNUM
ARSPSItem number of the settlement reservation ARSPSNUMC4RSPOS
ETDRKIndicator: Print-relevant schedule lines exist ETDRKCHAR1ETDRK
EINDTItem Delivery Date EINDTDATS8DATUM
MENGEScheduled Quantity ETMENQUAN13(3) MENGE
WEMNGQuantity of Goods Received WEEMGQUAN13(3) MENG13
DABMGQuantity Reduced (MRP) DABMGQUAN13(3) MENGE
WAMNGIssued Quantity WAMNGQUAN13(3) MENG13
GLMNGQuantity Delivered (Stock Transfer) GLMNGQUAN13(3) MENG13
QUNUMNumber of Quota Arrangement QUNUMCHAR10ALPHAQUNUM
QUPOSQuota Arrangement Item QUPOSNUMC3NUM03
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10RSNUMRES
ESTKZCreation Indicator (Purchase Requisition/Schedule Lines) ESTKZCHAR1ESTKZ
BEDATOrder date of schedule line ETBDTDATS8DATUM
FIXKZSchedule Line is 'Fixed' ETFIXCHAR1XFELD
SERNRBOM explosion number SERNRCHAR8SERNR
AMENGPrevious Quantity (Delivery Schedule Lines) VOMNGQUAN13(3) MENG13V
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
WEPOSGoods Receipt Indicator WEPOSCHAR1XFELD
CHARGBatch Number CHARG_DCHAR10CHARGCHA
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
RETPOReturns Item RETPOCHAR1XFELD
STATURFQ status ASTATCHAR1ASTAT
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10LFA1ALPHALIFNR
LBLKZSubcontracting vendor LBLKZCHAR1XFELD
EREKZFinal Invoice Indicator EREKZCHAR1XFELD
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
EGLKZ'Outward Delivery Completed' Indicator EGLKZCHAR1XFELD
KZFIXFirm/Trade-Off Zones Binding with Regard to Mat. Planning MRPRECHAR1KZFIX
INSMKStock Type INSMKCHAR1INSMK
STAPOItem is statistical STAPOCHAR1XFELD
NETWRNet Order Value in PO Currency BWERTCURR13(2) WERT7
BSTMGPurchase Order Quantity BSTMGQUAN13(3) MENG13
BERIDMRP Area BERIDCHAR10MDLVBERIDBERID

Key field Non-key field



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

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

SELECT SINGLE *
FROM MB_MDBS
INTO CORRESPONDING FIELDS OF WA_MB_MDBS
WHERE...

How to access SAP table MB_MDBS

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