WB2_DDL_MKPF_MSEG

Data Selection from Material Documents (without WBGT) | view: WB2_V_MATDOC | TRAN | Extraction: Not supported | Component: Trading Execution Workbench
Tables used: MATDOCMATDOC
Column Name Description
MBLNR Number of Material Document
MJAHR Material Document Year
MANDT_I Client
MBLNR_I Number of Material Document
MJAHR_I Material Document Year
ZEILE_I Item in Material Document
Column Name Description
FRATH Unplanned delivery costs
💲 Currency Key (WAERS_I):
DMBTR_I Amount in Local Currency
BNBTR_I Delivery costs in local currency
BUALT_I Amount Posted in Alternative Price Control
DMBUM_I Revaluation amount on back-posting to a previous period
EXBWR_I Externally Entered Posting Amount in Local Currency
VKWRT_I Value at Sales Prices Including Value-Added Tax
EXVKW_I Externally Entered Sales Value in Local Currency
SALK3_I Value of total valuated stock before the posting
VKWRA_I Value at Sales Prices Excluding Value Added Tax
J_1BEXBASE_I Alternate base amount in document currency
Column Name Description
📏 Base Unit of Measure (MEINS_I):
MENGE_I Quantity
LBKUM_I Total valuated stock before the posting
📏 Unit of entry (ERFME_I):
ERFMG_I Quantity in unit of entry
📏 Order Price Unit (Purchasing) (BPRME_I):
BPMNG_I Quantity in Purchase Order Price Unit
📏 Unit of Measure From Delivery Note (LSMEH_I):
PBAMG_I Quantity
LSMNG_I Quantity in Unit of Measure from Delivery Note
📏 Purchase Order Unit of Measure (BSTME_I):
BSTMG_I Goods receipt quantity in order unit
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
AEDAT Last Changed On
VFDAT_I Shelf Life Expiration or Best-Before Date
DABRBZ_I Reference date for settlement
DABRZ_I Reference date for settlement
HSDAT_I Date of Manufacture
Column Name Description
WEVER Version for Printing GR/GI Slip Show values
BFWMS Control posting for external WMS Show values
XAUTO_I Item automatically created Show values
INSMK_I Stock Type Show values
ZUSTD_I Batch in Restricted-Use Stock Show values
SHKZG_I Debit/Credit Indicator Show values
SHKUM_I Debit/credit indicator in revaluation Show values
ELIKZ_I "Delivery Completed" Indicator Show values
XSKST_I Indicator: Statistical Posting to Cost Center Show values
XSAUF_I Indicator: Posting to Order Is Statistical Show values
XSPRO_I Indicator: Posting to Project Is Statistical Show values
XSERG_I Indicator: Posting to Profitability Analysis Is Statistical Show values
XRUEM_I Allow Posting to Previous Period (Backposting) Show values
XRUEJ_I Indicator: post to previous year Show values
KZEAR_I Final Issue for Reservation Show values
KZSTR_I Transaction/event is relevant to statistics Show values
KZBEW_I Movement Indicator Show values
KZVBR_I Consumption posting Show values
KZZUG_I Receipt Indicator Show values
WEUNB_I Goods Receipt, Non-Valuated Show values
BESTQ_I Stock Category in the Warehouse Management System Show values
XBLVS_I Indicator: posting in warehouse management system Show values
VSCHN_I Ind: interim storage posting for source stor.type and bin Show values
NSCHN_I Ind.: interim storage posting for dest.stor.type and bin Show values
DYPLA_I Indicator: dynamic storage bin Show values
XWSBR_I Reversal of GR allowed for GR-based IV despite invoice Show values
MENGU_I Quantity Updating in Material Master Record Show values
WERTU_I Value Updating in Material Master Record Show values
VPRSV_I Price control indicator Show values
XBEAU_I Purchase order created at time of goods receipt Show values
KZBWS_I Valuation of Special Stock Show values
QINSPST_I Status of Goods Receipt Inspection Show values
J_1AGIRUPD_I Goods issue revaluation performed Show values
BERKZ_I Material Staging Indicator for Production Supply Show values
XWOFF_I Calculation of val. open Show values
XOBEW_I Vendor Stock Valuation Indicator Show values
Column Name Description Domain name
VGART Transaction/Event Type VGART
BLART Document Type BLART
BLAUM Document type of revaluation document BLART
USNAM User Name XUBNAME
TCODE Undefined range (can be used for patch levels) CHAR4
XBLNR Reference Document Number XBLNR1
BKTXT Document Header Text TEXT25
FRBNR Number of Bill of Lading at Time of Goods Receipt XBLNR1
XABLN Goods Receipt/Issue Slip Number BELNR
AWSYS Logical System LOGSYS
BLA2D Doc. type for additional doc. in purchase account management BLART
TCODE2 Transaction Code TCODE
EXNUM Number of foreign trade data in MM and SD documents EXNUM
LINE_ID_I Unique identification of document line MB_LINE_ID
PARENT_ID_I Identifier of immediately superior line MB_LINE_ID
LINE_DEPTH_I Hierarchy level of line in document MB_LINE_DEPTH
BWART_I Movement type (inventory management) BWART
MATNR_I Material Number MATNR
WERKS_I Plant WERKS
LGORT_I Storage location LGORT
CHARG_I Batch Number CHARG
ZUSCH_I Batch status key ZUSCH
SOBKZ_I Special Stock Indicator SOBKZ
LIFNR_I Vendor's account number LIFNR
KUNNR_I Account number of customer KUNNR
KDAUF_I Sales Order Number VBELN
KDPOS_I Item number in Sales Order NUM06
KDEIN_I Delivery schedule for sales order NUM04
PLPLA_I Distribution of Differences PLPLA
BWTAR_I Valuation Type BWTAR
EBELN_I Purchase order number EBELN
EBELP_I Item Number of Purchasing Document EBELP
LFBJA_I Fiscal Year of a Reference Document GJAHR
LFBNR_I Document No. of a Reference Document BELNR
LFPOS_I Item of a Reference Document MBLPO
SJAHR_I Material Document Year GJAHR
SMBLN_I Number of Material Document BELNR
SMBLP_I Item in Material Document MBLPO
SGTXT_I Item Text TEXT50
EQUNR_I Equipment Number EQUNR
WEMPF_I Goods Recipient WEMPF
ABLAD_I Unloading Point TEXT25
GSBER_I Business Area GSBER
KOKRS_I Controlling Area CACCD
PARGB_I Trading partner's business area GSBER
PARBU_I Clearing company code BUKRS
KOSTL_I Cost Center KOSTL
PROJN_I Old: Project number : No longer used --> PS_POSNR PROJN
AUFNR_I Order Number AUFNR
ANLN1_I Main Asset Number ANLN1
ANLN2_I Asset Subnumber ANLN2
GJAHR_I Fiscal Year GJAHR
BUKRS_I Company Code BUKRS
BELNR_I Document Number of an Accounting Document BELNR
BUZEI_I Number of Line Item Within Accounting Document BUZEI
BELUM_I Document Number of an Accounting Document BELNR
BUZUM_I Number of Line Item Within Accounting Document BUZEI
RSNUM_I Number of reservation/dependent requirements RSNUM
RSPOS_I Item Number of Reservation / Dependent Requirements RSPOS
UMMAT_I Receiving/Issuing Material MATNR
UMWRK_I Plant WERKS
UMLGO_I Receiving/issuing storage location LGORT
UMCHA_I Receiving/Issuing Batch CHARG
UMZST_I Status of Transfer Batch ZUSTD
UMZUS_I Status key of transfer batch ZUSCH
UMBAR_I Valuation Type of Transfer Batch BWTAR
UMSOK_I Special Stock Indicator SOBKZ
PALAN_I WMS Number of pallets PALAN
LGNUM_I Warehouse Number / Warehouse Complex LGNUM
LGTYP_I Storage Type LGTYP
LGPLA_I Storage Bin LGPLA
BWLVS_I Movement Type for Warehouse Management BWLVS
TBNUM_I Transfer Requirement Number TBNUM
TBPOS_I Transfer Requirement Item TBPOS
UBNUM_I Posting Change Number UBNUM
TBPRI_I Transfer Priority TBPRI
TANUM_I Transfer Order Number TANUM
WEANZ_I Number of GR/GI Slips to Be Printed NUM3
GRUND_I Reason for Movement MB_GRBEW
EVERS_I Shipping Instructions EVERS
EVERE_I Compliance with Shipping Instructions EVERE
IMKEY_I Internal Key for Real Estate Object IMKEY
KSTRG_I Cost Object KSTRG
PAOBJNR_I Profitability Segment Number (CO-PA) RKEOBJNR
PRCTR_I Profit Center PRCTR
PS_PSP_PNR_I Work Breakdown Structure Element (WBS Element) PS_POSNR
NPLNR_I Network Number for Account Assignment AUFNR
AUFPL_I Routing number of operations in the order AUFPL
APLZL_I Internal counter CIM_COUNT
AUFPS_I Order item number CO_POSNR
VPTNR_I Partner account number KUNNR
FIPOS_I Commitment Item FIPOS
SAKTO_I G/L Account Number SAKNR
EMLIF_I Supplier to be Supplied/Who is to Receive Delivery LIFNR
AKTNR_I Promotion WAKTION
ZEKKN_I Sequential Number of Account Assignment NUM02
CUOBJ_CH_I Internal object number of the batch classification CUOBJ
PPRCTR_I Partner Profit Center PRCTR
RSART_I Record type RSART
GEBER_I Fund BP_GEBER
FISTL_I Funds Center FISTL
MATBF_I Material in Respect of Which Stock is Managed MATNR
UMMAB_I Receiving/Issuing Material MATNR
BUSTM_I Posting string for quantities BUSTM
BUSTW_I Posting String for Values BUSTW
FKBER_I Functional Area FKBER
URZEI_I Original line in material document MBLPO
MWSKZ_I Tax on sales/purchases code MWSKZ
TXJCD_I Tax Jurisdiction TXJCD
EMATN_I Material number corresponding to manufacturer part number MATNR
VKMWS_I Tax on sales/purchases code MWSKZ
MAT_KDAUF_I Sales order number of valuated sales order stock VBELN
MAT_KDPOS_I Sales Order Item of Valuated Sales Order Stock NUM06
MAT_PSPNR_I Valuated Sales Order Stock WBS Element PS_POSNR
BEMOT_I Accounting Indicator BEMOT
PRZNR_I Business Process CO_PRZNR
LLIEF_I Goods Supplier LIFNR
LSTAR_I Activity Type LSTAR