SAP MDEZ_DB Table in S/4 HANA - MDEZ DB Table









MDEZ_DB is a standard SAP Table which is used to store MDEZ DB Table data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system

Even using an S/4 Hana system you can still view further information about the SAP MDEZ_DB table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MDEZ_DB


MDEZ_DB table structure field list

Below is the full MDEZ_DB 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
MANDTClientS_MANDTCLNT3(0) MANDT
MATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
PLANTPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
LINENumeric field length 8NUM08NUMC8(0) NUM08
PLAABMaterial requirements planning segmentPLAABNUMC2(0) PLAAB
PLANRPlanning segment numberPLANRCHAR20(0) PLANR
SORT0Numeric field length 8NUM08NUMC8(0) NUM08
TAG00Daily shift (sort indicator 0)TAG00NUMC2(0) TAG00
SORT1Sort indicator 01SORT1CHAR1(0) SORT1
SORT2Sort indicator 02SORT2CHAR2(0) SORT2
DELKZMRP elementDELKZCHAR2(0) DELKZ
PLUMIReceipt/issue indicatorPLUMICHAR1(0) CHAR1
VRFKZAvailability indicatorVRFKZCHAR1(0) VRFKZ
DAT00Receipt/Requirements dateDAT00DATS8(0) DATUM
DAT01Delivery/order finish dateDAT01DATS8(0) DATUM
DELB0Abbreviation for MRP elementDELB0CHAR6(0) DELB0
EXTRAMRP element dataEXTRACHAR40(0) CHAR40
AUSSLException message keyAUSSLCHAR2(0) AUSSL
AUSKTException message numberAUSKTCHAR2(0) AUSKT
MNG01Quantity received or quantity requiredMNG01QUAN13(3) MENGV13
MNG02Available quantityVRFMGQUAN13(3) MENGV13
MNG03Available quantityVRFMGQUAN13(3) MENGV13
MNG04ATP quantityMNG04QUAN13(3) MENGV13
FBYTESingle-Character FlagCHAR1CHAR1(0) CHAR1
ALINELine index for internal table processingXLINEINT410(0) XLINE
ZLINELine index for internal table processingXLINEINT410(0) XLINE
SELKZSelection flagSELKZCHAR1(0) SELKZ
ABEKZException indicatorABEKZCHAR1(0) CHAR1
VERIDProduction VersionVERIDCHAR4(0) VERIDVER
SERNRBOM explosion numberSERNRCHAR8(0) SERNR
REVLVRevision levelREVLVCHAR2(0) NUMCVREVLVRVS
MNAUSVariable scrap quantityMNG02QUAN13(3) MENG13
DAT02Start/release dateDAT02DATS8(0) DATUM
DAT03Opening dateDAT03DATS8(0) DATUM
SOBESSpecial procurement typeSOBESCHAR1(0) SOBES
ESOBSSpecial procurement - external displayESOBSCHAR1(0) ESOBS
WRK01Planning PlantPLWRKCHAR4(0) WERKSWRK
WRK02Planning PlantPLWRKCHAR4(0) WERKSWRK
SLOC2Issuing/Receiving Storage LocationSLOC2CHAR4(0) LGORT
LGORTStorage locationLGORT_DCHAR4(0) LGORTLAG
UMDATRescheduling dateUMDATDATS8(0) DATUM
LIFNRAccount Number of Vendor or CreditorLIFNRCHAR10(0) ALPHALIFNRLIFKRED_CLIFNR
KUNNRCustomer NumberKUNNRCHAR10(0) ALPHAKUNNRKUNC_KUNNRKUNNR
MD4KDCustomer nameMD4KDCHAR35(0) NAME
MD4LIVendor NameMD4LICHAR35(0) NAME
LLMSGException at a lower BOM levelLLMESSAGECHAR2(0) AUSSL
LLDLYDelay for lower BOM levelsMDDELAYINT410(0) INT4
TRAMGMRP: Stock in TransitTRAMGQUAN13(3) MENGV13
USEX1Field to be filled by user exitUSEEXCHAR30(0) CHAR30
USEX2Field to be filled by user exitUSEEXCHAR30(0) CHAR30
USEX3Field to be filled by user exitUSEEXCHAR30(0) CHAR30
SORT3Sort indicator for individual customer segmentsSRTKDNUMC8(0) NUM8
UNIV1Quantity received or quantity requiredMNG01QUAN13(3) MENGV13
UNIV2Available quantityVRFMGQUAN13(3) MENGV13
UNIV3Text fieldTEXTCHAR29(0) FL_TEXT
DETAIL_ICONCarrier field for iconsICON_TEXTCHAR132(0) SYCHAR132
PRIO_URGRequirement UrgencyPRIO_URGNUMC2(0) PURGPRIO_URG
PRIO_REQRequirement PriorityPRIO_REQNUMC3(0) PREQPRIO_REQ
MDMATMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
MDLOCLocation of MRP ElementMDLOCCHAR20(0)
MDWRKPlantWERKS_DCHAR4(0) WERKSWRKH_T001W_CWERKS
MDBERMRP AreaBERIDCHAR10(0) BERIDBERID
SGT_RCATRequirement SegmentSGT_RCATCHAR40(0) SGT_SRCASGT_RSGT_CAT_FIELD_POPUPVALUE
SGT_SCATStock SegmentSGT_SCATCHAR40(0) SGT_SRCASGT_SSGT_CAT_FIELD_POPUPVALUE
MPNMTMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR




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!