J_1GVL_ML

Material Ledger | #transactional | Component: Financials Greece
Column Name Description
MANDT FK Client
VRSIO ML data version Show values
SPTAG Period to analyze - current date
WHBCODE Warehouse Book Code
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
BUZEI Billing Item
WERKS FK Plant
LOCAT Warehousebook location
MATNR FK Material Number
BWTAR FK Valuation Type
ORGN Record origin Show values
Column Name Description
💲 Local Currency (HWAER):
VLIS_VS Initial Stock SAP Value
VLIS_VA Initial Stock Actual Value
VLRM_VS Remaining SAP Value
VLRM_VA Remaining Actual Value
VLPD_VS Produced SAP Value
VLPD_VA Produced Actual Value (Components + expenses)
VLPC_VA Produced Actual Value (Components)
VLAE_VA Expences AE
VLEE_VA Expences EE
VLFS_VA Expences FACON
VLPU_VS Purchases SAP Value
VLPU_VA Purchases Invoices
VLGR_VA Purchases GR Value
VLOI_VS Other Import SAP Value
VLOI_VA Other Imports Actual Value
VLDI_VS (IN) Int. Movement SAP Value
VLDI_VA (IN) Int. Movement Actual Value
VLOP_VS Overplus SAP Value
VLOP_VA Overplus Actual Value
VLOE_VS Other Exports SAP Value
VLOE_VA Other Exports Actual Value
VLDO_VS (OUT) Int. Movement SAP Value
VLDO_VA (OUT) Int. Movement Actual Value
VLDF_VS Deficit SAP Value
VLDF_VA Deficit Actual Value
VLCP_VS Consum. In Production SAP Value
VLCP_VA Consum. In Production Actual Value
VLCO_VS Other Consumption SAP Value
VLCO_VA Other Consumption Actual Value
VLSL_VS Cost of Sales SAP Value
VLSL_VA Cost of Sales Actual Value
VLRV_VA Sales Revenues
VLSX_VA Sales Direct Expenses
VLGP_VA Gross Profit
VLTR_VS Stock in Transit SAP Value
VLTR_VA Stock in Transit Actual Value
VLLC_VA Transportation costs Actual Value
Column Name Description
📏 Base Unit of Measure (BASME):
VLIS_QS Init Stock Quantity
VLRM_QS Remaining Quantity
VLPD_QS Produced Quantity
VLPU_QS Purchases Quantity
VLOI_QS Other Imports Quantity
VLDI_QS (IN) Int. Movement Quantity
VLOP_QS Overplus Quantity
VLOE_QS Other Exports Quantity
VLDO_QS (OUT) Int. Movement Quantity
VLDF_QS Deficit Quantity
VLCP_QS Consum. In Production Quantity
VLCO_QS Other Consumption Quantity
VLSL_QS Cost of Sales Quantity
VLTR_QS Stock in Transit Q
MENGE quantity with sign
Column Name Description
SPTAG Period to analyze - current date
BUDAT Posting Date in the Document
ERDAT Date on which the record was created
ERZET Entry time
Column Name Description
VRSIO ML data version Show values
ORGN Record origin Show values
KZBEW Movement Indicator Show values
KZZUG Receipt Indicator Show values
KZVBR Consumption posting Show values
SHKZG Debit/Credit Indicator Show values
LOTYP location type (for WHB) Show values
SCOPE Object class (language-independent) Show values
Column Name Description Domain name
VLWRK Plant (empty if valuation at Company Level) WERKS
TRACT Transaction Category CHAR02
XBLNR Reference Document Number XBLNR
GJAHR Fiscal Year GJAHR
MJAHR Material Document Year GJAHR
SAKTO G/L Account Number SAKNR
AWREF Reference document number AWREF
ACTIVITY Operation/Activity Number VORNR
KDAUF Sales Order Number VBELN
KOSTL Cost Center KOSTL
UMMAT Receiving/Issuing Material MATNR
UMBAR Valuation Type of Transfer Batch BWTAR
SORTIND Sorting Indicator NUMC02
CHARG Batch Number CHARG
POSNR_SD Item number of the SD document POSNR
AUBEL Sales Document VBELN
AUPOS Sales Document Item POSNR
AWREF_REV Reversal: Reference Document No. of Document to Be Reversed AWREF
KDPOS Item number in Sales Order NUM06
REPID ABAP Program Name PROGNAME
UNAME User Name UNAME
VERSN Version COVERSI
REFBN Number of Reference Purchase Requisition BANFN
OBJNR Object number (forecast) OBJNR
KSTAR Cost Element KSTAR
VRGNG CO Business Transaction J_VORGANG
PAROB Partner Object J_OBJNR
CORDER ORDER/ITEM CHAR20
ACCDOCNR Document Number of an Accounting Document BELNR
ACCDOCLN Number of Line Item Within Accounting Document BUZEI
MLBUZALT null
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • J_1GVL_ML.AUFNR == AUFK.AUFNR
  • J_1GVL_ML.MANDT == AUFK.MANDT
Reference procedure J_1GVL_ML.AWTYP == TTYP.AWTYP
Base Unit of Measure
  • J_1GVL_ML.MANDT == T006.MANDT
  • J_1GVL_ML.BASME == T006.MSEHI
Valuation Class
  • Valuation Class
  • Client
  • J_1GVL_ML.BKLAS == T025.BKLAS
  • J_1GVL_ML.MANDT == T025.MANDT
Document Type
  • Document Type
  • Client
  • J_1GVL_ML.BLART == T003.BLART
  • J_1GVL_ML.MANDT == T003.MANDT
Company Code
  • J_1GVL_ML.MANDT == T001.MANDT
  • J_1GVL_ML.BUKRS == T001.BUKRS
Movement type (inventory management)
  • J_1GVL_ML.MANDT == T156.MANDT
  • J_1GVL_ML.BWART == T156.BWART
Valuation Type
  • J_1GVL_ML.MANDT == T149D.MANDT
  • J_1GVL_ML.BWTAR == T149D.BWTAR
Business Area
  • J_1GVL_ML.MANDT == TGSB.MANDT
  • J_1GVL_ML.GSBER == TGSB.GSBER
Local Currency
  • J_1GVL_ML.MANDT == TCURC.MANDT
  • J_1GVL_ML.HWAER == TCURC.WAERS
Account number of customer
  • J_1GVL_ML.MANDT == KNA1.MANDT
  • J_1GVL_ML.KUNNR == KNA1.KUNNR
Storage location
  • Storage location
  • Client
  • Plant
  • J_1GVL_ML.LGORT == T001L.LGORT
  • J_1GVL_ML.MANDT == T001L.MANDT
  • J_1GVL_ML.WERKS == T001L.WERKS
Vendor's account number
  • J_1GVL_ML.MANDT == LFA1.MANDT
  • J_1GVL_ML.LIFNR == LFA1.LIFNR
Client J_1GVL_ML.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_1GVL_ML.MATNR == MARA.MATNR
  • J_1GVL_ML.MANDT == MARA.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • J_1GVL_ML.NPLNR == AUFK.AUFNR
  • J_1GVL_ML.MANDT == AUFK.MANDT
Current number of the appropriate project
  • J_1GVL_ML.MANDT == PROJ.MANDT
  • J_1GVL_ML.PROJECT == PROJ.PSPNR
Special Stock Indicator
  • J_1GVL_ML.MANDT == T148.MANDT
  • J_1GVL_ML.SOBKZ == T148.SOBKZ
Receiving plant/issuing plant
  • J_1GVL_ML.MANDT == T001W.MANDT
  • J_1GVL_ML.UMWRK == T001W.WERKS
Plant
  • J_1GVL_ML.MANDT == T001W.MANDT
  • J_1GVL_ML.WERKS == T001W.WERKS