MWZDM07M1 SAP (ZDM07M1) Table details

Dictionary Type: Table
Description: ZDM07M1




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




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

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

The MWZDM07M1 table consists of various fields, each holding specific information or linking keys about ZDM07M1 data available in SAP. These include MBLNR (Number of Material Document), MJAHR (Material Document Year), ZEILE (Item in Material Document), ZEILD (Item in Material Document).. 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 MWZDM07M1 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
ZEILDItem in Material Document MBLPONUMC4MBLPOPOS
EXWRTAmount in Local Currency DMBTRCURR13(2) WERT7
KONTOG/L Account Number SAKNRCHAR10SKA1ALPHASAKNRSAKC_SAKNR
XKMANAccount entered manually XKMANCHAR1XFELD
FAUSWField Selection String FAUSWCHAR128FA128
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
TXARTText type in material master record (purchasing/sales) TXARTCHAR1TXART
RMBEWReturn code MBEW RMBEWCHAR1XFELD
XLORTStorage location necessary XLORTCHAR1XFELD
KZZDEMaintain status data of a batch KZZDECHAR1XFELD
KZDRUPrinting of document item KZDRUCHAR1Assigned to domainKZDRU
XLIFOLIFO/FIFO-Relevant XLIFOCHAR1LIFO_FIFO
VMENGQuantity MENGE_DQUAN13(3) MENG13
VERMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
VBSMGGoods receipt quantity in order unit MB_BSTMGQUAN13(3) MENG13
VBPMGGoods Receipt Quantity in Purchase Order Price Unit BPWEMQUAN13(3) MENG13
VWERTAmount in Local Currency DMBTRCURR13(2) WERT7
VVKWRValue at Sales Prices Including Value-Added Tax VKWRTCURR13(2) WERT7
VWERRAmount in Local Currency DMBTRCURR13(2) WERT7
VWALTAmount posted in alternative price control BUALTCURR13(2) WERTV7
VWEREAmount in Local Currency DMBTRCURR13(2) WERT7
BTEXTMovement Type Text (Inventory Management) BWTXTCHAR20BTEXT
XEINKIndicator: Purchase Account Processing is Active XEINKCHAR1XFELD
KTOPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
PERIVFiscal Year Variant PERIVCHAR2T009PERIV
BWMODValuation Grouping Code BWMODCHAR4CHAR4
BKLASValuation Class BKLASCHAR4T025BKLAS
EKLASValuation Class for Sales Order Stock EKLASCHAR4Assigned to domainBKLAS
QKLASValuation Class for Project Stock QKLASCHAR4Assigned to domainBKLAS
OKLASValuation Class for Special Stock at the Vendor OKLASCHAR4Assigned to domainBKLAS
BWTTYValuation Category BWTTY_DCHAR1T149CBWTTY
PEINHPrice Unit PEINHDEC5PACK3
STPRSStandard price STPRSCURR11(2) WERT11V
VERPRMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
SALKVValue based on moving average price (only with price ctrl S) SALKVCURR13(2) WERT13N
VKSALValue of Total Valuated Stock at Sales Price VKSALCURR13(2) WERT13N
VMKUMTotal valuated stock in previous period VMKUMQUAN13(3) MENG13V
VMSALValue of total valuated stock in previous period VMSALCURR13(2) WERT13N
VMPEIPrice unit of previous period VMPEIDEC5PACK3
VMSTPStandard price in the previous period VMSTPCURR11(2) WERT11V
VMVERMoving Average Price/Periodic Unit Price in Previous Period VMVERCURR11(2) WERT11V
VMSAVValue based on moving average price (previous period) VMSAVCURR13(2) WERT13N
KZVBLArithmetic KZARICHAR1KZARI
KZVBUConsumption posting KZVBUCHAR1KZVBU
PERKZPeriod Indicator PERKZCHAR1PERKZPKZ
PERIMFiscal Year Variant PERIVCHAR2T009PERIV
VZBEWSign (+/-) of Material Posting VZBEWCHAR1VZBEW
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
NAME1Name NAME1CHAR30TEXT30
ORT01City ORT01CHAR25TEXT25
PSTLZPostal Code PSTLZCHAR10PSTLZ
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
BPUMZNumerator for Conversion of Order Price Unit into Order Unit BPUMZDEC5UMBSZ
BPUMNDenominator for Conv. of Order Price Unit into Order Unit BPUMNDEC5UMBSN
BSMNGQuantity Ordered BESTMQUAN13(3) MENGE
BPBMGPurchase order quantity in order price unit BPBMGQUAN13(3) MENGE
UETMGOverdelivery tolerance (quantity) UETMGQUAN13(3) MENG13
UNTMGUnderdelivery Tolerance (Quantity) UNTMGQUAN13(3) MENG13
WAMNGIssued Quantity WAMNGQUAN13(3) MENG13
WAWRTSum of the values of goods issues WAWRTCURR13(2) WERT7
WESBSGoods Receipt Blocked Stock in Order Unit WESBSQUAN13(3) MENG13
BPWESQuantity in GR blocked stock in order price unit BPWESQUAN13(3) MENG13
WEMNGQuantity of Goods Received WEMNGQUAN13(3) MENG13
WWMNGValuated goods receipt quantity WWMNGQUAN13(3) MENG13
MB_BPRMEQuantity in Purchase Order Price Unit MB_BPRMEUNIT3T006CUNITMEINS
BPWEMGoods Receipt Quantity in Purchase Order Price Unit BPWEMQUAN13(3) MENG13
BPWWMValuated goods receipt quantity in order unit BPWWMQUAN13(3) MENG13
WEWRTValue of goods received in local currency WEWRTCURR13(2) WERT7
REMNGQuantity invoiced REMNGQUAN13(3) MENG13
BPREMInvoice receipt quantity in order price unit BPREMQUAN13(3) MENG13
MULKOIndicator: Multiple account assignment MULKOCHAR1XFELD
REWRTInvoice value in local currency REWRTCURR13(2) WRTV7
AREWRGR/IR account clearing value in local currency AREWRCURR13(2) WERT7
XELIKSuggest 'delivery completed' indicator XELIKCHAR1XFELD
SPERQFunction That Will Be Blocked QSPERRFKTCHAR2Assigned to domainQSPERRFKT
SSQSSControl Key for Quality Management in Procurement QSSPURCHAR8Assigned to domainQSSPUR
ZGTYPCertificate Type QZGTYPCHAR4Assigned to domainQZGTYPQCT
XZGVHProcessing of certificate in procurement active XZGVHCHAR1QXZGVH
INSNCQuality inspection indicator cannot be changed INSNCCHAR1XFELD
KZUMLStock transfer/transfer posting KZUMLCHAR1XFELD
UMRMBReturn code MBEW RMBEWCHAR1XFELD
UMBUKCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
UMBWKValuation Area BWKEYCHAR4T001KBWKEYBWK
UMXLILIFO/FIFO-Relevant XLIFOCHAR1LIFO_FIFO
UMHRKOrigin Group as Subdivision of Cost Element HRKFTCHAR4Assigned to domainHRKFT
UMGJAFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
UMMONFiscal Period MONATNUMC2MONAT
UMXRMAllow Posting to Previous Period (Backposting) XRUEMCHAR1XFELD
UMXRJIndicator: post to previous year XRUEJCHAR1XFELD
UMLFGFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
UMLFMCurrent period (posting period) LFMONNUMC2MONAT
UMTYPValuation Category BWTTY_DCHAR1T149CBWTTY
UMWAECurrency Key WAERSCUKY5TCURCWAERSFWS
UMVWEAmount in Local Currency DMBTRCURR13(2) WERT7
UMVWRAmount in Local Currency DMBTRCURR13(2) WERT7
UMBUAAmount posted in alternative price control BUALTCURR13(2) WERTV7
UMVWAAmount posted in alternative price control BUALTCURR13(2) WERTV7
UMPEIPrice Unit PEINHDEC5PACK3
UMVPRPrice control indicator VPRSVCHAR1VPRSV
UMGSBBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
UMPRCProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
UMKPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
UMPERFiscal Year Variant PERIVCHAR2T009PERIV
UMBWMValuation Grouping Code BWMODCHAR4CHAR4
UMBKLValuation Class BKLASCHAR4T025BKLAS
UMEKLValuation Class for Sales Order Stock EKLASCHAR4Assigned to domainBKLAS
UMQKLValuation Class for Project Stock QKLASCHAR4Assigned to domainBKLAS
UMOKLValuation Class for Special Stock at the Vendor OKLASCHAR4Assigned to domainBKLAS
UMLBKTotal Valuated Stock LBKUMQUAN13(3) MENG13V
UMSALValue of Total Valuated Stock SALK3CURR13(2) WERT13N
UMSTPStandard price STPRSCURR11(2) WERT11V
UMVERMoving Average Price/Periodic Unit Price VERPRCURR11(2) WERT11V
UMSAVValue based on moving average price (only with price ctrl S) SALKVCURR13(2) WERT13N
UMVKSValue of Total Valuated Stock at Sales Price VKSALCURR13(2) WERT13N
UMVKUTotal valuated stock in previous period VMKUMQUAN13(3) MENG13V
UMVSAValue of total valuated stock in previous period VMSALCURR13(2) WERT13N
UMVPEPrice unit of previous period VMPEIDEC5PACK3
UMVSPStandard price in the previous period VMSTPCURR11(2) WERT11V
UMVVPMoving Average Price/Periodic Unit Price in Previous Period VMVERCURR11(2) WERT11V
UMVMSValue based on moving average price (previous period) VMSAVCURR13(2) WERT13N
UMWERValue Update in Material Master Record WERTUCHAR1XFELD
UMMYKLIFO valuation level MYKEYCHAR4T001YMYKEYMYL
UMKZV+/- sign for consumption update in material master record KZVBLCHAR1KZVBL
UMMTVChecking Group for Availability Check MTVFPCHAR2Assigned to domainMTVFP
UMFABFactory calendar key FABKLCHAR2Assigned to domainWFCID
UMPLIPlanned Delivery Time in Days PLIFZDEC3DEC3
UMEISSafety Stock EISBEQUAN13(3) MENG13
UMMINBEReorder Point MINBEQUAN13(3) MENG13
UMWEBGoods Receipt Processing Time in Days WEBAZDEC3DEC3
UMWZETotal replenishment lead time (in workdays) WZEITDEC3DEC3
UMBESProcurement Type BESKZCHAR1BESKZMBS
UMUMLStock in Transfer (Plant to Plant) UMLMEQUAN13(3) MENG13V
UMXQSNo Manual Inventory Posting for QM-Relevant Material QQSSPCHAR1QKZ
UMSOFSpecial stock ind.: Accounting/bookkeeping assignment SOBFICHAR1SOBFI
UMSOLSpecial stock indicator: Logistics assignment SOBLOCHAR1SOBLO
UMSOVSpecial stock indicator: Transaction assignment SOBVOCHAR1SOBVO
UMARCSegment string MARC SMARC_DCHAR3SEGST
UMARDSegment string MARD SMARD_DCHAR3SEGST
UMCHBSegment string MCHB SMCHB_DCHAR3SEGST
UMBPRSegment string MBPR SMBPRCHAR3SEGST
UMLIBSegment string SMLIBCHAR3SEGST
UMKOLSegment string MKOL SMKOL_DCHAR3SEGST
UMEIKSegment string MEIK SMEIKCHAR3SEGST
UMKLKSegment string MKLK SMKLKCHAR3SEGST
UMKUBSegment string MKVB SMKUBCHAR3SEGST
UEKPOSegment string EKPO SEKPO_DCHAR3SEGST
UFAUPSegment string FAUP SFAUP_DCHAR3SEGST
UMRESSegment string MRES SMRES_DCHAR3SEGST
UMSKUSegment string MSKU SMSKU_DCHAR3SEGST
UMSLBSegment string MSLB SMSLB_DCHAR3SEGST
UMSSLSegment string MSSL SMSSL_DCHAR3SEGST
UMSKASegment string MSKA SMSKA_DCHAR3SEGST
UMSSASegment string MSSA SMSSA_DCHAR3SEGST
UMSPRSegment string MSPR SMSPR_DCHAR3SEGST
UMSSQSegment string MSSQ SMSSQ_DCHAR3SEGST
UMSCASegment string MSCA SMSCACHAR3SEGST
UMSOASegment string MSOA SMSOACHAR3SEGST
UMSCPSegment string MSCP SMSCPCHAR3SEGST
UMSOPSegment string MSOP SMSOPCHAR3SEGST
UMLBBStock Type of Goods Movement (Primary Posting) LBBSACHAR2Assigned to domainLBBSA
UMKBBStock Type of Goods Movement (Complementary Posting) KBBSACHAR2Assigned to domainLBBSA
UMDISStorage location MRP indicator DISKZCHAR1DISKZ
UMDITLow-Level Code DISSTCHAR3DISST
UMXPBRequirements reduction upon goods movements XPBEDCHAR1XFELD
UMMISMixed MRP indicator MISKZCHAR1MISKZ
UMVRMConsumption mode VRMODCHAR1VRMOD
UMVI1Consumption period: backward VINT1NUMC3VRINT
UMVI2Consumption period: forward VINT2NUMC3VRINT
UMBDTRequirement Date for the Component BDTERDATS8DATUM
KZVBPDynamic availability check for goods movement KZVBPCHAR1KZVBP
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
UMLMCQuantity MENGE_DQUAN13(3) MENG13
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
WZEITTotal replenishment lead time (in workdays) WZEITDEC3DEC3
ATPM1ATP quantity MNG04QUAN13(3) MENGV13
BESKZProcurement Type BESKZCHAR1BESKZMBS
UBFKZIndicator: Creation of a Posting Change Notice T321_UBFKZCHAR1XFELD
UMLGNWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
UMLGTStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
UMLGPStorage Bin LGPLACHAR10LAGPLGPLALGPLAG1
UMBSQStock Category in the Warehouse Management System BESTQCHAR1BESTQ
UMBLVMovement Type for Warehouse Management BWLVSNUMC3T333BWLVSBWL
UMXBLIndicator: posting in warehouse management system XBLVSCHAR1XFELD
UMVOSInd: interim storage posting for source stor.type and bin T333_VSCHNCHAR1XFELD
UMNASInd.: interim storage posting for dest.stor.type and bin T333_NSCHNCHAR1XFELD
UMDYPIndicator: dynamic storage bin DYPLACHAR1XFELD
UMTBFIndicator: Creation/Cancellation of a Transfer Requirement T321_TBFKZCHAR1T321_TBFKZ
UMTRAShipment Type LVS_TRARTCHAR1T333ALVS_TRARTH_T333A
UMBTYRequirement Type LVS_BETYPCHAR1T308LVS_BETYP
UMBENRequirement Number LVS_BENUMCHAR10ALPHALVS_BENUM
UMTBPTransfer Priority TBPRICHAR1TBPRI
UMWKZIndicator: generate goods receipt date T321_WEDKZCHAR1T321_WEDKZ
UMBKZPosting change indicator in Warehouse Management (WM) LVS_UMBKZCHAR1XFELD
WENUMGoods Receipt Number LVS_WENUMCHAR10ALPHABELNR
MBLMGQuantity MENGE_DQUAN13(3) MENG13
MBLBMQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
MBBMGQuantity Ordered Against this Purchase Requisition BSMNGQUAN13(3) MENG13
FABKLFactory calendar key FABKLCHAR2TFACDWFCID
RSHKZDebit/Credit Indicator SHKZGCHAR1SHKZG
BDMNGRequirement Quantity BDMNGQUAN13(3) MENG13
ENMNGQuantity Withdrawn ENMNGQUAN13(3) MENG13
BDARTRequirement type BDARTCHAR2BDARTBDA
ENWRTValue Withdrawn ENWRTCURR13(2) VWERT13
RLGORStorage Location LGORT_DCHAR4T001LLGORTLAG
RCHARBatch Number CHARG_DCHAR10MCHACHARGCHA
KONPRConsignment price KONPRCURR11(2) WERT11
KOPEIPrice unit for consignment price KOPEIDEC5DEC5
ANZRERules for display of goods movements ANZRECHAR3ANZRE
ANBWAAsset Transaction Type ANBWACHAR3TABWBWASL
LNRANSequence number of asset line items in fiscal year LNRANNUMC5Assigned to domainLNRAN
BEWARConsolidation Transaction Type BEWARCHAR3Assigned to domainRMVCT
VMVKSValue of Tot. Valuated Stock at Sales Price in Previous Per. VMVKSCURR13(2) WERT13N
UMVMVKSValue of Tot. Valuated Stock at Sales Price in Previous Per. VMVKSCURR13(2) WERT13N
UMXHUPFHandling unit requirement XHUPFCHAR1XFELD
UMVKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
UMVSTELShipping Point/Receiving Point VSTELCHAR4Assigned to domainVSTELVST
UMVTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
UMSPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
UMSDLIFAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
UMSDKUNCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
UISEGSegment string ISEG SISEG_DCHAR3SEGST
UMIBPOIPointer on phys. inv. docmt item IBPOICHAR10ALPHABELNR
IMSEG_ORIGINALItem in Material Document MBLPONUMC4MBLPOPOS
UMDISMMMRP Type DISMMCHAR2Assigned to domainDISMM
PARBWValuation Grouping Code BWMODCHAR4CHAR4

Key field Non-key field



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

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

SELECT SINGLE *
FROM MWZDM07M1
INTO CORRESPONDING FIELDS OF WA_MWZDM07M1
WHERE...

How to access SAP table MWZDM07M1

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