MDSB SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

MDSB 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 MDSB 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), AUFST (Order level).. 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 MDSB 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
AUFSTOrder level AUFSTNUMC2AUFST
AUFWGOrder path AUFWGNUMC2AUFWG
POSNRBOM item number APOSNCHAR4NUMCVSPOSN
SORTFSort String SORTPCHAR10CHAR10
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
PRVBEProduction Supply Area PRVBECHAR10PRVBEPVB
BDARTRequirement type BDARTCHAR2BDARTBDA
POSTPItem Category (Bill of Material) POSTPCHAR1T418POSTP
XLOEKItem is Deleted XLOEKCHAR1XFELD
NODSPEffective for Materials Planning NO_DISP_PLUSCHAR1NO_DISP_PLUS
UPSKZIndicator: sub-items exist UPSKZCHAR1XFELD
SCHGTIndicator: Bulk Material SCHGTCHAR1XFELD
TXTPSItem text indicator TXTPSCHAR1XFELD
INPOSIndicator: intra material INPOSCHAR1XFELD
DUMPSPhantom item indicator DUMPSCHAR1XFELD
KFPOSIndicator: 'configurable item' KFPOSCHAR1XFLAG
CLAKZIndicator: classification exists CLAKZCHAR1XFELD
DBSKZDirect procurement indicator DBSKZCHAR1DBSKZ
SANKAIndicator for Relevancy to Costing CK_SELKZCHAR1TCK08CK_SELKZ
BDMNGRequirement Quantity BDMNGQUAN13(3) MENG13
VMENGConfirmed quantity for availability check in SKU VMENGQUAN15(3) MENG15
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
ESMNGUsage quantity per order unit of measure ESMNGFLTP16(16) ESMNG
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
BEIKZMaterial Provision Indicator BEIKZCHAR1T417BEIKZ
ERSKZIndicator: spare part ERSKZCHAR1T413ERSKZ
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3T006CUNITMEINS
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
FMENGQuantity is Fixed FMENGCHAR1XFELD
ALPOSAlternative item indicator ALTPSCHAR1XFELD
EWAHRUsage probability in % (alternative item) EWAHRDEC3DEC3
ALPGRAlternative item: group CS_ALPGRCHAR2CHAR2
ALPRFAlternative item: ranking order CS_ALPRFNUMC2NUM2
ALPSTAlternative item: strategy CS_ALPSTCHAR1CS_ALPST
AUSCHComponent scrap in percent KAUSFDEC5(2) DEC3_2
AVOAUOperation scrap AVOAUDEC5(2) DEC3_2
NETAUIndicator: Net scrap NETAUCHAR1XFELD
BDTERRequirement Date for the Component BDTERDATS8DATUM
SBTERLatest requirements date SBTERDATS8DATUM
VERTIMRP Distribution Key SA_VERTLCHAR4T437VSA_VERTL
NLFZTLead-time offset NLFZTDEC3NLFZT
BDZTPTime that reservation quantity required BDZTPTIMS6BDZTP
ROHPSVariable-sized item indicator ROHPSCHAR1XFELD
ROANZNumber of variable-size items ROANZQUAN13(3) MENG13
ROMENQuantity of variable-size item ROMENQUAN13(3) MENG13
ROMEIUnit of measure for sizes 1 to 3 ROMEIUNIT3T006CUNITMEINS
ROMS1Size 1 ROMS1QUAN13(3) MENG13
ROMS2Size 2 ROMS2QUAN13(3) MENG13
ROMS3Size 3 ROMS3QUAN13(3) MENG13
RFORMFormula key RFORMCHAR2T418FRFORM
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
KZVBRConsumption Posting KZVBRCHAR1KZVBR
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
KDEINDelivery Schedule for Sales Order KDEINNUMC4NUM04
PSPELWBS Element PS_POSNRNUMC8ABPSPPS_POSNR
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
KZAUSDiscontinuation type AUSLFCHAR1AUSLF
NFEAGDiscontinuation group CS_NFEAGCHAR2CHAR2
NFGRPFollow-up group CS_NFGRPCHAR2CHAR2
NFPKZIndicator: Follow-Up Item CS_KZNFPCHAR1XFELD
NAFKZIndicator: follow-up material active/not active NAFKZCHAR1XFELD
NOMNGRequired quantity NOMNGQUAN13(3) MENG13
NFUMLNOT USED: Quantity transfer factor for follow-up material NFUMLDEC5(4) NFUML
NOMATFollow-Up/Original Material NOMATCHAR18MARAMATN1MATNR
LTXSPLanguage: The long text was stored in this language LTXSPLANG1T002ISOLASPRAS
POTX1BOM Item Text (Line 1) POTX1CHAR40TEXT40
POTX2BOM item text (line 2) POTX2CHAR40TEXT40
PLNUMPlanned order number PLNUMCHAR10PLAFALPHAPLNUMPAF
BANFNPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
BNFPOItem Number of Purchase Requisition BNFPONUMC5EBANBNFPOBAP
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
EBELEDelivery Schedule Line Counter EETENNUMC4EKETEETEN
BAUGRMaterial number of higher-level assembly BAUGRCHAR18MARAMATN1MATNR
BAUSTAssembly order level BAUSTNUMC2AUFST
BAUWGAssembly order path BAUWGNUMC2AUFWG
SERNRBOM explosion number SERNRCHAR8SNUMSERNR
AENNRChange Number AENNRCHAR12AENRAENNRAENNRAEN
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
STLTYBOM category STLTYCHAR1STLTY
STLNRBill of material STNUMCHAR8NUMCVSTNUMSTLNR
STLKNBOM item node number STLKNNUMC8KNTNR
STPOZInternal counter CIM_COUNTNUMC8CIM_COUNT
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
ENMNGQuantity Withdrawn ENMNGQUAN13(3) MENG13
SAKNRG/L Account Number SAKNRCHAR10ALPHASAKNRSAKC_SAKNR
KZKUPIndicator: co-product KZKUPCHAR1XFELD
STLALAlternative BOM STALTCHAR2ALPHAALTNR
STVKNInherited node number of BOM item STVKNNUMC8KNTNR
PBDNRRequirements Plan Number PBDNRCHAR10CHAR10PBN
VRPLAIndicator: planning without final assembly VRPLACHAR1XFELD
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
TECHSParameter Variant/Standard Variant TECHSCHAR12TECHS
NLFZVLead-time offset for operation CS_NLFZVDEC3NLFZT
NLFMVUnit for lead-time offset for operation CS_NLFMVUNIT3T006CUNITMEINS
XFEHLMissing Part XFEHLCHAR1XFELD
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA

Key field Non-key field



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

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

SELECT SINGLE *
FROM MDSB
INTO CORRESPONDING FIELDS OF WA_MDSB
WHERE...

How to access SAP table MDSB

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