J_1GVL_ML - Material Ledger

Material Ledger information is stored in SAP table J_1GVL_ML.
It is part of development package J1G_WHB in software component FI-LOC-FI-GR. This development package consists of objects that can be grouped under "Greek Localization - Material valuation / Warehouse book".

Fields for table J_1GVL_ML

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
VRSIO	ML data version	X	J_1GVL_VRSIO	CHAR	6
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
WHBCODE	Warehouse Book Code	X	J_1GVL_WHBC	CHAR	6
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
BUZEI	Billing Item	X	POSNR_VF	NUMC	12
WERKS	Plant	X	WERKS_D	CHAR	8	T001W
LOCAT	Warehousebook location	X	J_1GMMLOCAT	CHAR	20
MATNR	Material Number	X	MATNR	CHAR	80	MARA
BWTAR	Valuation Type	X	BWTAR_D	CHAR	20	T149D
ORGN	Record origin	X	J_1GVL_ORGN	CHAR	4
VLWRK	Plant (empty if valuation at Company Level)		J_1GVL_WERKS	CHAR	8
BASME	Base Unit of Measure		MEINS	UNIT	6	T006
HWAER	Local Currency		HWAER	CUKY	10	TCURC
BWART	Movement type (inventory management)		BWART	CHAR	6	T156
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2	T148
KZBEW	Movement Indicator		KZBEW	CHAR	2
KZZUG	Receipt Indicator		KZZUG	CHAR	2
KZVBR	Consumption posting		KZVBR	CHAR	2
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
BLART	Document Type		BLART	CHAR	4	T003
TRACT	Transaction Category		J_1GVL_TRACT	CHAR	4
KUNNR	Account number of customer		EKUNN	CHAR	20	KNA1
LIFNR	Vendor's account number		ELIFN	CHAR	20	LFA1
UMWRK	Receiving plant/issuing plant		UMWRK	CHAR	8	T001W
XBLNR	Reference Document Number		XBLNR	CHAR	32
AUFNR	Order Number		AUFNR	CHAR	24	AUFK
BKLAS	Valuation Class		BKLAS	CHAR	8	T025
GJAHR	Fiscal Year		GJAHR	NUMC	8
MJAHR	Material Document Year		MJAHR	NUMC	8
BUDAT	Posting Date in the Document		BUDAT	DATS	16
SAKTO	G/L Account Number		SAKNR	CHAR	20
.INCLUDE	LC			J_1GVL_MLLC	0
VLIS_QS	Init Stock Quantity		J_1GVL_ISQS	QUAN	7
VLIS_VS	Initial Stock SAP Value		J_1GVL_ISVS	CURR	12
VLIS_VA	Initial Stock Actual Value		J_1GVL_ISVA	CURR	12
VLRM_QS	Remaining Quantity		J_1GVL_RMQS	QUAN	7
VLRM_VS	Remaining SAP Value		J_1GVL_RMVS	CURR	12
VLRM_VA	Remaining Actual Value		J_1GVL_RMVA	CURR	12
VLPD_QS	Produced Quantity		J_1GVL_PDQS	QUAN	7
VLPD_VS	Produced SAP Value		J_1GVL_PDVS	CURR	12
VLPD_VA	Produced Actual Value (Components + expenses)		J_1GVL_PDVA	CURR	12
VLPC_VA	Produced Actual Value (Components)		J_1GVL_PCVA	CURR	12
VLAE_VA	Expences AE		J_1GVL_PDVAE	CURR	12
VLEE_VA	Expences EE		J_1GVL_PDVEE	CURR	12
VLFS_VA	Expences FACON		J_1GVL_PDVFS	CURR	12
VLPU_QS	Purchases Quantity		J_1GVL_PUQS	QUAN	7
VLPU_VS	Purchases SAP Value		J_1GVL_PUVS	CURR	12
VLPU_VA	Purchases Invoices		J_1GVL_PUIR	CURR	12
VLGR_VA	Purchases GR Value		J_1GVL_PUGR	CURR	12
VLOI_QS	Other Imports Quantity		J_1GVL_OIQS	QUAN	7
VLOI_VS	Other Import SAP Value		J_1GVL_OIVS	CURR	12
VLOI_VA	Other Imports Actual Value		J_1GVL_OIVA	CURR	12
VLDI_QS	(IN) Int. Movement Quantity		J_1GVL_DIQS	QUAN	7
VLDI_VS	(IN) Int. Movement SAP Value		J_1GVL_DIVS	CURR	12
VLDI_VA	(IN) Int. Movement Actual Value		J_1GVL_DIVA	CURR	12
VLOP_QS	Overplus Quantity		J_1GVL_OPQS	QUAN	7
VLOP_VS	Overplus SAP Value		J_1GVL_OPVS	CURR	12
VLOP_VA	Overplus Actual Value		J_1GVL_OPVA	CURR	12
VLOE_QS	Other Exports Quantity		J_1GVL_OEQS	QUAN	7
VLOE_VS	Other Exports SAP Value		J_1GVL_OEVS	CURR	12
VLOE_VA	Other Exports Actual Value		J_1GVL_OEVA	CURR	12
VLDO_QS	(OUT) Int. Movement Quantity		J_1GVL_DOQS	QUAN	7
VLDO_VS	(OUT) Int. Movement SAP Value		J_1GVL_DOVS	CURR	12
VLDO_VA	(OUT) Int. Movement Actual Value		J_1GVL_DOVA	CURR	12
VLDF_QS	Deficit Quantity		J_1GVL_DFQS	QUAN	7
VLDF_VS	Deficit SAP Value		J_1GVL_DFVS	CURR	12
VLDF_VA	Deficit Actual Value		J_1GVL_DFVA	CURR	12
VLCP_QS	Consum. In Production Quantity		J_1GVL_CPQS	QUAN	7
VLCP_VS	Consum. In Production SAP Value		J_1GVL_CPVS	CURR	12
VLCP_VA	Consum. In Production Actual Value		J_1GVL_CPVA	CURR	12
VLCO_QS	Other Consumption Quantity		J_1GVL_COQS	QUAN	7
VLCO_VS	Other Consumption SAP Value		J_1GVL_COVS	CURR	12
VLCO_VA	Other Consumption Actual Value		J_1GVL_COVA	CURR	12
VLSL_QS	Cost of Sales Quantity		J_1GVL_SLQS	QUAN	7
VLSL_VS	Cost of Sales SAP Value		J_1GVL_SLVS	CURR	12
VLSL_VA	Cost of Sales Actual Value		J_1GVL_SLVA	CURR	12
VLRV_VA	Sales Revenues		J_1GVL_SLVR	CURR	12
VLSX_VA	Sales Direct Expenses		J_1GVL_SLVX	CURR	12
VLGP_VA	Gross Profit		J_1GVL_GPVA	CURR	12
VLTR_QS	Stock in Transit Q		J_1GVL_TRQS	QUAN	7
VLTR_VS	Stock in Transit SAP Value		J_1GVL_TRVS	CURR	12
VLTR_VA	Stock in Transit Actual Value		J_1GVL_TRVA	CURR	12
VLLC_VA	Transportation costs Actual Value		J_1GVL_LCVA	CURR	12
AWTYP	Reference procedure		AWTYP	CHAR	10	TTYP
AWREF	Reference document number		AWREF	CHAR	20
MENGE	quantity with sign		J_1GVL_MENGE15	QUAN	8
LGORT	Storage location		LGORT_D	CHAR	8	T001L
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24	AUFK
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
ACTIVITY	Operation/Activity Number		VORNR	CHAR	8
PROJECT	Current number of the appropriate project		PS_PSPHI	NUMC	16	PROJ
KDAUF	Sales Order Number		KDAUF	CHAR	20
EBELN	Purchasing Document Number		EBELN	CHAR	20	EKKO
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	EKPO
GSBER	Business Area		GSBER	CHAR	8	TGSB
LOTYP	location type (for WHB)		J_1GVL_LOCTYP	CHAR	2
KOSTL	Cost Center		KOSTL	CHAR	20
UMMAT	Receiving/Issuing Material		UMMAT	CHAR	80
UMBAR	Valuation Type of Transfer Batch		UMBAR	CHAR	20
SORTIND	Sorting Indicator		J_1GVL_SORT	NUMC	4
CHARG	Batch Number		CHARG_D	CHAR	20
POSNR_SD	Item number of the SD document		POSNR	NUMC	12
AUBEL	Sales Document		VBELN_VA	CHAR	20
AUPOS	Sales Document Item		POSNR_VA	NUMC	12
AWREF_REV	Reversal: Reference Document No. of Document to Be Reversed		AWREF_REV	CHAR	20
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERZET	Entry time		ERZET	TIMS	12
REPID	ABAP Program Name		REPID	CHAR	80
UNAME	User Name		UNAME	CHAR	24
VERSN	Version		VERSN	CHAR	6
REFBN	Number of Reference Purchase Requisition		REFBN	CHAR	20
OBJNR	Object number (forecast)		OBJNR	CHAR	36
SCOPE	Object class (language-independent)		SCOPE	CHAR	4
KSTAR	Cost Element		KSTAR	CHAR	20
VRGNG	CO Business Transaction		CO_VORGANG	CHAR	8
PAROB	Partner Object		PAROB	CHAR	44
CORDER	ORDER/ITEM		J_1GVL_ORDER	CHAR	40
ACCDOCNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
ACCDOCLN	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
MLBUZALT	Flag: ML's item nr (BUZEI) artificially modified			CHAR	2