SAP MDVA Table in S/4 HANA - Availability structure for several items
MDVA is a standard SAP Table which is used to store Availability structure for several items data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MDVA table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MDVA
MDVA table structure field list
Below is the full MDVA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
WERKS | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
LGORT | Storage location | LGORT_D | CHAR | 4(0) | LGORT | LAG | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10(0) | CHARG | CHA | ||||
KDAUF | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
KDPOS | Item number in Sales Order | KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
PSPEL | WBS Element | PS_POSNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
KUNNR | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2(0) | MTVFP | |||||
PRREG | Checking rule for the availability check | PRREG | CHAR | 2(0) | PRREG | PRR | ||||
DELKZ | MRP element | DELKZ | CHAR | 2(0) | DELKZ | |||||
DELNR | MRP element number | DELNR | CHAR | 10(0) | DELNR | |||||
DELPS | MRP element item | DELPS | NUMC | 6(0) | DELPS | |||||
DELET | Schedule Line Number MRP Element | DELET | NUMC | 4(0) | DELET | |||||
BAART | P.O./Order type | BAART | CHAR | 4(0) | BAART | |||||
BDART | Requirement type | BDART | CHAR | 2(0) | BDART | BDA | ||||
PLART | Planning type | PLART | CHAR | 1(0) | PLART | |||||
VBTYP | SD Document Category | VBTYPL | CHAR | 4(0) | VBTYPL | |||||
VERKZ | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1(0) | SOBKZ | |||||
SIMKZ | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
KORKZ | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
AUFNR | Order Number | AUFNR | CHAR | 12(0) | ALPHA | AUFNR | ANR | |||
POSNR | Item number of the SD document | POSNR | NUMC | 6(0) | POSNR | |||||
BDTER | Requirements date for the component | BDTER | DATS | 8(0) | DATUM | |||||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | |||||
VMENG | Committed Quantity | MNG06 | QUAN | 13(3) | MENGV13 | |||||
ATPMG | ATP quantity | MNG04 | QUAN | 13(3) | MENGV13 | |||||
FMENG | Quantity is fixed | FMENG | CHAR | 1(0) | XFELD | |||||
DAT01 | Committed date | DAT05 | DATS | 8(0) | DATUM | |||||
ERRKZ | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
SELKZ | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
XFEHL | Missing Part | XFEHL | CHAR | 1(0) | XFELD | |||||
XLINE | Line index for internal table processing | XLINE | INT4 | 10(0) | XLINE | |||||
MAKTX | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
MENGE | Requirement Quantity of Component | CO_MENGE | QUAN | 13(3) | MENGV13 | |||||
DVMENG | Confirmed quantity/allocated quantity | PP_VMENG | QUAN | 13(3) | MENGV13 | |||||
DATPMG | ATP quantity/available quantity | PP_ATPMG | QUAN | 13(3) | MENGV13 | |||||
AUSME | Unit of issue | AUSME | UNIT | 3(0) | CUNIT | MEINS | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5(0) | UMBSN | |||||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5(0) | UMBSZ | |||||
SHOWX | Checkbox | XFELD | CHAR | 1(0) | XFELD | |||||
COUNTER | Numc3, internal use | NUMC3 | NUMC | 3(0) | NUMC3 | |||||
ALPST | Alternative item: strategy | CS_ALPST | CHAR | 1(0) | CS_ALPST | |||||
ALPGR | Alternative item: group | CS_ALPGR | CHAR | 2(0) | CHAR2 | |||||
ALPRF | Alternative item: ranking order | CS_ALPRF | NUMC | 2(0) | NUM2 | |||||
KFPOS | Indicator: Configurable Item | KFPOS | CHAR | 1(0) | XFLAG | |||||
STLTY | BOM category | STLTY | CHAR | 1(0) | STLTY | |||||
STLNR | Bill of Material | STNUM | CHAR | 8(0) | NUMCV | STNUM | STLNR | STLNR | ||
STLKN | BOM item node number | STLKN | NUMC | 8(0) | KNTNR | |||||
STPOZ | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
ACENQ | Material block in availability check with transfer of qties | ACENQ | CHAR | 1(0) | XFELD | |||||
XWAOK | Goods movement for reservation allowed | XWAOK | CHAR | 1(0) | XFELD | |||||
RGBKZ | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
ENMNG | Quantity withdrawn | ENMNG | QUAN | 13(3) | MENG13 | |||||
TRTYP | Transaction type | TRTYP | CHAR | 1(0) | TRTYP | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
POSNR_PP | BOM item number | APOSN | CHAR | 4(0) | NUMCV | SPOSN | ||||
VORNR_PP | Operation/Activity Number | VORNR | CHAR | 4(0) | NUMCV | VORNR | VGN | |||
VPZUO | Allocation Indicator | VPZUO | CHAR | 1(0) | ZUVKZ | |||||
ATPM1 | ATP Server: ATP quantity | ATPMNG | QUAN | 15(3) | MENGV15 | |||||
DATPM1 | ATP quantity/available quantity | PP_ATPM1 | QUAN | 15(3) | MENGV15 | |||||
ALPLP | Alternative Items with Level and Path | ALPLP | CHAR | 1(0) | ALPLP | |||||
AUFWG | Order path | AUFWG | NUMC | 2(0) | AUFWG | |||||
AUFST | Order level | AUFST | NUMC | 2(0) | AUFST | |||||
SGT_RCAT | Requirement Segment | SGT_RCAT | CHAR | 40(0) | SGT_SRCA | SGT_R | SGT_CAT_FIELD_POPUP | VALUE | ||
ESMNG | Usage quantity per order unit of measure | ESMNG | FLTP | 16(16) | ESMNG | |||||
EWAHR | Usage Probability in % (Alternative Item) | EWAHR | DEC | 3(0) | DEC3 | |||||
KZAUS | Discontinuation indicator | KZAUS | CHAR | 1(0) | KZAUS | |||||
.INCLU--AP | 0(0) | |||||||||
WRF_CHARSTC1 | Characteristic Value 1 | WRF_CHARSTC1 | CHAR | 18(0) | WRF_CHARSTC | WRF_MATNR_CHAR1 | COLOR | |||
WRF_CHARSTC1_TXT | Characteristic Description 1 | WRF_CHARSTC1_TEXT | CHAR | 70(0) | TEXT70 | |||||
WRF_CHARSTC2 | Characteristic Value 2 | WRF_CHARSTC2 | CHAR | 18(0) | WRF_CHARSTC | WRF_MATNR_CHAR2 | SIZE1 | |||
WRF_CHARSTC2_TXT | Characteristic Description 2 | WRF_CHARSTC2_TEXT | CHAR | 70(0) | TEXT70 | |||||
WRF_CHARSTC3 | Characteristic Value 3 | WRF_CHARSTC3 | CHAR | 18(0) | WRF_CHARSTC | WRF_MATNR_CHAR3 | SIZE2 | |||
WRF_CHARSTC3_TXT | Characteristic Description 3 | WRF_CHARSTC3_TEXT | CHAR | 70(0) | TEXT70 |
Search for further information about these or an SAP related objects