MDVA SAP (Availability structure for several items) Structure details

Dictionary Type: Structure
Description: Availability structure for several items




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




Structure field list including key, data, relationships and ABAP select examples

MDVA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Availability structure for several items" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MDVA TYPE MDVA.

The MDVA table consists of various fields, each holding specific information or linking keys about Availability structure for several items data available in SAP. These include WERKS (Plant), LGORT (Storage Location), CHARG (Batch Number), KDAUF (Sales Order 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: Can be enhanced (character-type or numeric)


SAP MDVA structure 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
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
PSPELWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
MTVFPChecking Group for Availability Check MTVFPCHAR2Assigned to domainMTVFP
PRREGChecking Rule for Availability Check PRREGCHAR2Assigned to domainPRREGPRR
DELKZMRP element DELKZCHAR2DELKZ
DELNRMRP element number DELNRCHAR10DELNR
DELPSMRP element item DELPSNUMC6DELPS
DELETSchedule Line Number MRP Element DELETNUMC4DELET
BAARTP.O./Order type BAARTCHAR4BAART
BDARTRequirement type BDARTCHAR2BDARTBDA
PLARTPlanning type PLARTCHAR1Assigned to domainPLART
VBTYPSD document category VBTYPCHAR1VBTYP
VERKZSingle-Character Indicator CHAR1CHAR1CHAR1
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
SIMKZSingle-Character Indicator CHAR1CHAR1CHAR1
KORKZSingle-Character Indicator CHAR1CHAR1CHAR1
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
BDTERRequirement Date for the Component BDTERDATS8DATUM
BDMNGRequirement Quantity BDMNGQUAN13(3) MENG13
VMENGCommitted Quantity MNG06QUAN13(3) MENGV13
ATPMGATP quantity MNG04QUAN13(3) MENGV13
FMENGQuantity is Fixed FMENGCHAR1XFELD
DAT01Committed Date DAT05DATS8DATUM
ERRKZSingle-Character Indicator CHAR1CHAR1CHAR1
SELKZSingle-Character Indicator CHAR1CHAR1CHAR1
XFEHLMissing Part XFEHLCHAR1XFELD
XLINELine index for internal table processing XLINEINT410XLINE
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
MENGERequirement quantity of the component CO_MENGEQUAN13(3) MENGV13
DVMENGConfirmed quantity/allocated quantity PP_VMENGQUAN13(3) MENGV13
DATPMGATP quantity/available quantity PP_ATPMGQUAN13(3) MENGV13
AUSMEUnit of issue AUSMEUNIT3Assigned to domainCUNITMEINS
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
SHOWXCheckbox XFELDCHAR1XFELD
COUNTERNumc3, internal use NUMC3NUMC3NUMC3
ALPSTAlternative item: strategy CS_ALPSTCHAR1CS_ALPST
ALPGRAlternative item: group CS_ALPGRCHAR2CHAR2
ALPRFAlternative item: ranking order CS_ALPRFNUMC2NUM2
KFPOSIndicator: 'configurable item' KFPOSCHAR1XFLAG
STLTYBOM category STLTYCHAR1STLTY
STLNRBill of material STNUMCHAR8NUMCVSTNUMSTLNR
STLKNBOM item node number STLKNNUMC8KNTNR
STPOZInternal counter CIM_COUNTNUMC8CIM_COUNT
ACENQMaterial block in availability check with transfer of qties ACENQCHAR1XFELD
XWAOKGoods Movement for Reservation Allowed XWAOKCHAR1XFELD
RGBKZSingle-Character Indicator CHAR1CHAR1CHAR1
ENMNGQuantity Withdrawn ENMNGQUAN13(3) MENG13
TRTYPTransaction type TRTYPCHAR1TRTYP
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
POSNR_PPBOM item number APOSNCHAR4NUMCVSPOSN
VORNR_PPOperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
VPZUOAllocation Indicator VPZUOCHAR1ZUVKZ
ATPM1ATP Server: ATP quantity ATPMNGQUAN15(3) MENGV15
DATPM1ATP quantity/available quantity PP_ATPM1QUAN15(3) MENGV15
ALPLPAlternative Items with Level and Path ALPLPCHAR1ALPLP
AUFWGOrder path AUFWGNUMC2AUFWG
AUFSTOrder level AUFSTNUMC2AUFST

Key field Non-key field



How do I retrieve data from SAP structure MDVA using ABAP code?

As MDVA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MDVA as there is no data to select.

How to access SAP table MDVA

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