MWZDM07M2 SAP (ZDM07M2) Table details

Dictionary Type: Table
Description: ZDM07M2




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




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

MWZDM07M2 is a standard SAP Table which is used to store ZDM07M2 data and is available within R/3 SAP systems depending on the version and release level.

The MWZDM07M2 table consists of various fields, each holding specific information or linking keys about ZDM07M2 data available in SAP. These include MBLNR (Number of Material Document), MJAHR (Material Document Year), ZEILE (Item in Material Document), VBUND (Company ID of trading partner).. 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: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MWZDM07M2 table 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 MANDTCLNT3Assigned to domainMANDT
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MBLPOPOS
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
XOWSTNo value string where valuation types the same XOWSTCHAR1XFELD
XPRMSMaterial status already checked XPRMSCHAR1XFELD
XLAUTAutomatic creation of storage location allowed XLAUTCHAR1XFELD
XWESCCheckbox XFELDCHAR1XFELD
KZGRUControl: Reason for Movement KZGRUCHAR1FAUSW
GRTXTText: Reason for Goods Movement GRTXTCHAR20TEXT20
WESCHQuantity: Number of GR/GI slips to be printed WESCHQUAN13(3) MENG13
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
KASPEBlocked Stock SPEMEQUAN13(3) MENG13V
KAVSPBlocked stock of previous period VMSPEQUAN13(3) MENG13V
SASPEBlocked Stock SPEMEQUAN13(3) MENG13V
XSTBWReversal movement type XSTBWCHAR1XFELD
ZEILOItem in Material Document MBLPONUMC4MBLPOPOS
DIMNGDifference quantity for goods movements MB_DIMNGQUAN13(3) MENGV13
BWTORValuation Type BWTAR_DCHAR10T149DBWTARBWT
PRREGChecking Rule for Availability Check PRREGCHAR2Assigned to domainPRREGPRR
KO_GSBERBusiness area reported to the partner GSBER_GPCHAR4Assigned to domainGSBER
KO_PARGBassumed business area of the business partner PARGB_GPCHAR4Assigned to domainGSBER
XBKNGNegative stocks in valuation area allowed XBKNGCHAR1XFELD
XMCNGNegative stocks allowed in plant XMCNGCHAR1XFELD
XLONGNegative stocks allowed in storage location XLONGCHAR1XFELD
XSVNGStock of ret. packaging w. cust. allowed to become negative XSVNGCHAR1XFELD
XSMNGRTP stock allowed to become negative XSMNGCHAR1XFELD
UMXBNNegative stocks in valuation area allowed XBKNGCHAR1XFELD
UMXMNNegative stocks allowed in plant XMCNGCHAR1XFELD
UMXLNNegative stocks allowed in storage location XLONGCHAR1XFELD
UMXSVStock of ret. packaging w. cust. allowed to become negative XSVNGCHAR1XFELD
UMXSMRTP stock allowed to become negative XSMNGCHAR1XFELD
RESWKPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LEWEDLatest Possible Goods Receipt LEWEDDATS8DATUM
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
KANBAKanban Indicator KBNKZCHAR1KBNKZ
SERNPSerial Number Profile SERAILCHAR4Assigned to domainSERAIL
UMMLMMaterial ledger activated at material level CK_ML_MAACCHAR1XFELD
UMKALCost Estimate Number - Product Costing CK_KALNR1NUMC12Assigned to domainCK_KALNRKNE
VMVPRPrice Control Indicator in Previous Period VMVPRCHAR1VPRSV
UMVMVPrice control for prev. month - stock transfer line UMVMVCHAR1VPRSV
ANZL1Number of Storage Units to be Placed Into Storage LVS_ANZLEDEC3LVS_ANZLE
ANZL2Number of Storage Units to be Placed Into Storage LVS_ANZLEDEC3LVS_ANZLE
LMEN1Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMENQUAN13(3) MENG13
LMEN2Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMENQUAN13(3) MENG13
LETY1Storage Unit Type LVS_LETYPCHAR3T307LVS_LETYP
LETY2Storage Unit Type LVS_LETYPCHAR3T307LVS_LETYP
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
SONUMSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
UMSONSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
UMHKMMaterial-related origin HKMATCHAR1HKMAT
UMXVKSales price valuation active XVKBWCHAR1XFELD
KZMHDCheck Best Before Date/Production Date KZMHDCHAR1KZMHD
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
MHDHBTotal shelf life MHDHBDEC4DEC4
UMXCHBatch management requirement indicator XCHPFCHAR1XFELD
QM_ZUSTDBatch status with status changed in QM (internal) QM_ZUSTDCHAR1CHAR1
QM_UMZSTStatus of receiv. batch when status changed in QM (intern.) QM_UMZSTCHAR1CHAR1
KZCLAOption to classify batches KZCLACHAR1KZCLA
MHDATSLED/Best-Before Date or Date of Production TMHHDDATS8DATUM
ANZSNNumber of Serial Numbers/Pieces of Equipment to be Created ANZSERINT410CK_INT4
UMPRDHAProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
UMSATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
UMBWVORProcurement rule BWVORCHAR1Assigned to domainBWVOR
UMBWSCLSource of Supply BWSCLCHAR1Assigned to domainBQSCL
UMSAISOSeason Category SAISOCHAR4Assigned to domainSAISOSAISO
UMVOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
UMPLGTPPrice Band Category PLGTPCHAR2Assigned to domainPLGTP
UMSERVGIS-R service level W_SERVGRDCHAR1Assigned to domainW_SERVGRD
EAN11_BMEInternational Article Number (EAN/UPC) in Order Unit EAN11_BMECHAR18EAN11EAN11EAN
EAN11_KONInternational Article Number (EAN/UPC) Check EAN11_KONCHAR18EAN11EAN11EAN
EANMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
CLASSClass number KLASSE_DCHAR18KLASSEKLA
UMCLAClass number KLASSE_DCHAR18KLASSEKLA
QMAT_INAKTX and Blank QKZCHAR1QKZ
CHSMMSearch procedure for batch determination KALSMA_CHCHAR6Assigned to domainKALSM
UMCHSSearch procedure for batch determination KALSMA_CHCHAR6Assigned to domainKALSM
XCLASCheckbox XFELDCHAR1XFELD
UMXCLCheckbox XFELDCHAR1XFELD
RMVCTTransaction Type RMVCTCHAR3Assigned to domainRMVCT
EK_VKWRTValue at Sales Prices Including Value-Added Tax VKWRTCURR13(2) WERT7
EK_VKWRAValue at Sales Prices Including Value-Added Tax VKWRTCURR13(2) WERT7
PKNUMControl cycle number PKNUMCHAR7Assigned to domainALPHAPKNUMPKNUM
PKPOSKanban item number / control cycle item PKPOSNUMC3PKPOS
PKLVSRequirement Number LVS_BENUMCHAR10ALPHALVS_BENUM
UMLIFCHVendor Account Number ELIFNCHAR10Assigned to domainALPHALIFNRLIFKRED_C
UMLICHAVendor Batch Number LICHNCHAR15LICHN
UMLWEDTDate of last goods receipt LWEDTDATS8DATUM
UMVFDATShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
UMHSDATDate of Manufacture HSDATDATS8DATUM
MHDAT_OLDSLED/Best-Before Date or Date of Production TMHHDDATS8DATUM
UMQNDATNext Inspection Date QNPDATDATS8DATUM
XKOKOCost element accounting XKOKOCHAR1XKOKO
UMAUTAutomatic Transfer Order Creation LVS_AUTTACHAR1Assigned to domainAUTTA
TBBELMaterial doc. no. of transfer requirement to be cancelled LVS_TBBELCHAR10ALPHABELNRMBN
TBBPOMaterial doc. item of transf.reqmnt item to be cancelled LVS_TBBPONUMC4MBLPOPOS
TBBJRMaterial doc. year of transfer requirement to be cancelled LVS_TBBJRNUMC4GJAHRGJAHRMJA
VFMNGConfirmed quantity for availability check in SKU VMENGQUAN15(3) MENG15
CUOBJInternal object number CUOBMNUMC18CUOBJ
STDPDConfigurable material STDPDCHAR18Assigned to domainMATN1MATNR
TBPKZIndicator: No Transfer Requirement Created LVS_TBFKZCHAR1XFELD
TAFKZIndicator: do not cal up automatic TO creation LVS_TAFKZCHAR1XFELD
XWARTIndicates that the value-only material is to be inventoried XWARTCHAR1XFELD
DGLTSScheduled finish CO_GLTRSDATS8DATUM
UMMENQuantity Updating in Material Master Record MENGUCHAR1XFELD
UMXEIIndicator: Purchase Account Processing is Active XEINKCHAR1XFELD
DGLTPBasic finish date CO_GLTRPDATS8DATUM
UMKZBMovement Indicator KZBEWCHAR1KZBEW
UMMLAMaterial Price Determination: Control CK_ML_ABSTCHAR1CK_ML_ABST
UMSAISJSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
EQUMGQuantity MENGE_DQUAN13(3) MENG13
XEXEQExclusive enqueue for MBEW required XEXEQCHAR1XFELD
UMXEXEQExclusive enqueue for MBEW required XEXEQCHAR1XFELD
GLMNGQuantity Delivered (Stock Transfer) GLMNGQUAN13(3) MENG13
UMKZBAAIndicator: valuation type is set automatically KZBAACHAR1XFELD
DIRTAAutomatic TO Creation Immediately After TR Generation LVS_DIRTACHAR1XFELD
UMSERNPSerial Number Profile SERAILCHAR4Assigned to domainSERAIL
KZECHDetermination of batch entry in the production/process order KZECHCHAR1KZECH
FCHARBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
XKCFCExtended classification via CFC XKCFCCHAR1XFELD
KZCHPIndicator: Check of the batch entered is active KZCHPCHAR1XFELD
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
BWSPAValuation margin BWSPADEC6(2) PRZ32V
UPVORSubitems Exist UPVORCHAR1CHAR1
UPTYPSubitem Category, Purchasing Document UPTYPCHAR1Assigned to domainUPTYP
MEKORIndicates quantity correlation MEKORCHAR1XFELD
UEZEIItem in Material Document MBLPONUMC4MBLPOPOS
UEBPOHigher-Level Item in Purchasing Documents UEBPONUMC5Assigned to domainEBELP
LWMNGQuantity Reduced (MRP) DABMGQUAN13(3) MENGE
LWSBSGR blocked stock in order unit per shipping notif. item LWSBSQUAN13(3) MENG13
XWMHDCheck Best Before Date/Production Date XWMHDCHAR1XFELD
LAMNGQuantity as Per Vendor Confirmation BBMNGQUAN13(3) MENGE
PRVBEProduction Supply Area PRVBECHAR10Assigned to domainPRVBEPVB
VEXVKExternally Entered Sales Value in Local Currency EXVKWCURR13(2) WERT7
RBLVSReference movement type for WM from material movements RBLVSNUMC3LVS_BWREF
UMRBLReference movement type for transfer in warehouse mgmt LVS_UMRBLNUMC3LVS_BWREF
UMRBUReference movement type for posting change in whse mgmt LVS_UMRBUNUMC3LVS_BWREF
PARWKPlant involved in settlement PARWKCHAR4Assigned to domainWERKS
KTOMAAcct entered manually KTOMACHAR1CHAR1
XLBPDPrice difference posting in GR for subcontract oder XLBPDCHAR1XFELD
XBNSBDebit delivery costs separately XBNSBCHAR1XFELD
XWAITCheckbox XFELDCHAR1XFELD
XNOEQCheckbox XFELDCHAR1XFELD
XSKNGConsignment stock from vendor allowed to become negative XSKNGCHAR1XFELD
XSONGStock of material prov. to vendor allowed to become negative XSONGCHAR1XFELD
XSWNGConsignment Stock with Customer Allowed to Become Negative XSWNGCHAR1XFELD
UMXSKConsignment stock from vendor allowed to become negative XSKNGCHAR1XFELD
UMXSOStock of material prov. to vendor allowed to become negative XSONGCHAR1XFELD
UMXSWConsignment Stock with Customer Allowed to Become Negative XSWNGCHAR1XFELD
XEWRXPost purchase account with receipt value XEWRXCHAR1XFELD
X2FDOTwo FI documents with purchase account X2FDOCHAR1XFELD
UMVKWValue at Sales Prices Including Value-Added Tax VKWRTCURR13(2) WERT7
UMVKAValue at sales prices excluding value-added tax VKWRACURR13(2) WERT7
XSENGSales order stock allowed to become negative XSENGCHAR1XFELD
XSQNGProject stock allowed to become negative XSQNGCHAR1XFELD
UMXSESales order stock allowed to become negative XSENGCHAR1XFELD
UMXSQProject stock allowed to become negative XSQNGCHAR1XFELD
AREWWClearing value on GR/IR clearing account (transac. currency) AREWWCURR13(2) WERT7
MHDLGMinimum Remaining Shelf Life (8-Char. Calculation Field) MHDLGDEC8DEC8
VWERWAmount in document currency WRBTRCURR13(2) WERT7
KZWSOUnits of measure usage KZWSOCHAR1KZWSO
UMATTMaterial Category ATTYPCHAR2ATTYPMTY
KZKUBIndicator: Do not create posting change notice LVS_KZKUBCHAR1XFELD
UBTYPStorage Type LGTYPCHAR3Assigned to domainLGTYPLGTH_T301
UBLGPStorage Bin LGPLACHAR10Assigned to domainLGPLALGPLAG1
UMKZBWSValuation of Special Stock KZBWSCHAR1KZBWS
SETKZBWSKZWBS was set SETKZBWSCHAR1XFELD
UMKZVBRConsumption Posting KZVBRCHAR1KZVBR
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_DCHAR6Assigned to domainKALSM
UMKALNRCost Estimate Number for Cost Est. w/o Qty Structure CK_KALNRNUMC12Assigned to domainCK_KALNRKNR
URERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
URVERMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
UMMTAMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
MBBMEBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MLBWGMovement Type Group for ML Update CKML_MLBWGCHAR2Assigned to domainCKML_MLBWG
UMXSTAUBreak down structure XSTAUCHAR1XFELD
UMXHEADIndicates header of structured material XHEADCHAR1XFELD
EKALRMaterial Is Costed with Quantity Structure CK_EKALRELCHAR1XFELD
UMEKALRMaterial Is Costed with Quantity Structure CK_EKALRELCHAR1XFELD
EPRIOWithdrawal sequence group for stocks EPRIOCHAR4Assigned to domainEPRIO
UMEPRWithdrawal sequence group for stocks EPRIOCHAR4Assigned to domainEPRIO
RULESStock determination rule BF_RULESCHAR4Assigned to domainBF_RULES
AUFPL_ORDRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZL_ORDGeneral counter for order CO_APLZLNUMC8Assigned to domainCO_APLZL
XERSYEvaluated Receipt Settlement (ERS) XERSYCHAR1XFELD
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
ELIKZ_INPUTCheckbox XFELDCHAR1XFELD
UMLGNTBDo not adopt storage location into transfer requirement LVS_LGNTBCHAR1XFELD
XOARCStorage upon goods movements active XOARCCHAR1XFELD
XBEWMValuation based on the batch-specific unit of measure XBEWWCHAR1XFELD
UMXBEWMValuation based on the batch-specific unit of measure XBEWWCHAR1XFELD
KZEAR_INPCheckbox XFELDCHAR1XFELD
VUMVKWValue at Sales Prices Including Value-Added Tax VKWRTCURR13(2) WERT7
ORZEILItem in Material Document MBLPONUMC4MBLPOPOS
MTUSEUsage of the material J_1BMATUSECHAR1J_1BMATUSE
NFVALNet Value J_1BNETVALCURR15(2) WERTV8
JV_CRPCALCFlag CRP Calculation: Yes or NO JV_CRPCALCHAR1XFELD
JV_RECINDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
HSDAT_INPUTDate of Manufacture HSDATDATS8DATUM
VFDAT_INPUTShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
UMXWMHDCheck Best Before Date/Production Date XWMHDCHAR1XFELD
UMMHDHBTotal shelf life MHDHBDEC4DEC4
UMMHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
BWTAR_XMBWLValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
UMBWTAR_XMBWLValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
RDMHDRounding rule for calculation of SLED RDMHDCHAR1RDMHD
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
IPRKZ_HBDPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
UMIPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
ESTAKStatus of Purchasing Document ESTAKCHAR1ESTAK
MBLFMPeriod of MBEW or EBEW or QBEW MBLFMNUMC2MONAT
MBGJAFiscal year of MBEW or EBEW or QBEW MBGJANUMC4GJAHRGJAHR
RMBEWHInd.: MBEWH/EBEWH/QBEWH for prev. period could not be read RMBEWHCHAR1XFELD
MBRUEMBEWH rec. already exists for per. before last of MBEW per. MBRUECHAR1XFELD
XSAUTCreate serial number automatically XSAUTCHAR1XFELD
UMMBLFMPeriod of MBEW or EBEW or QBEW MBLFMNUMC2MONAT
UMMBGJAFiscal year of MBEW or EBEW or QBEW MBGJANUMC4GJAHRGJAHR
UMRMBEWHInd.: MBEWH/EBEWH/QBEWH for prev. period could not be read RMBEWHCHAR1XFELD
UMMBRUEMBEWH rec. already exists for per. before last of MBEW per. MBRUECHAR1XFELD
GWEMGQuantity of Goods Received WEMNGQUAN13(3) MENG13
XREFCCheckbox XFELDCHAR1XFELD
UCUOBInternal object number CUOBMNUMC18CUOBJ
USTDPConfigurable material STDPDCHAR18Assigned to domainMATN1MATNR
PRERRPrice determination error at time of goods receipt PRERRCHAR12CHAR12
FRLFDEarliest delivery date FRLFDDATS8DATUM
XEXITCancel item (dialog) XEXITCHAR1XFELD
VBELN_VLDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
VBELP_VLDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
KZXABGR/GI slip number is active KZXABCHAR1XFELD
UMKZXABGR/GI slip number is active KZXABCHAR1XFELD
UEKLASegment string EKLA SEKLA_DCHAR3SEGST
UMXLAUTAutomatic creation of storage location allowed XLAUTCHAR1XFELD
XVASHMain item with supplementary logistics services XVASHCHAR1XFELD
UMBFLMEGeneric Material with Logistical Variants BFLMECHAR1BFLME
KSTARAccount number KONTOCHAR16ALPHAKTO16
ORUMLItem in Material Document MBLPONUMC4MBLPOPOS

Key field Non-key field



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

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

SELECT SINGLE *
FROM MWZDM07M2
INTO CORRESPONDING FIELDS OF WA_MWZDM07M2
WHERE...

How to access SAP table MWZDM07M2

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