J_3GHBEST - Historical Stock

Historical Stock information is stored in SAP table J_3GHBEST.
It is part of development package J3GD in software component IS-EC-CEM. This development package consists of objects that can be grouped under "CEM Dictionary Objects".

Fields for table J_3GHBEST

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
J_3GBART	Indicator for Stock Type	X	J_3GBART	NUMC	2
J_3GEMPFAE	Recipient	X	J_3GEMPFAE	CHAR	20	KNA1
J_3GAGEXT	Debtor of Recipient	X	J_3GEMPDEB	CHAR	20	KNA1
J_3GWEEXT	External Ship-To Party - Recipient	X	J_3GEMPEXT	CHAR	20	KNA1
J_3GRESTYP	Resource Indicator	X	J_3GRESTYP	CHAR	4
J_3GRESSOU	Resource	X	J_3GRESSOU	CHAR	80
J_3GLVART	Activity Type	X	J_3GLVART	CHAR	8	J_3GLEIART
J_3GDATVON	From Date	X	J_3GDATVO	DATS	16
J_3GLFDNR	Sequence Number	X	J_3GLFDNR4	NUMC	8
J_3GSTORNO	Canc. Ind. (Derived Size from Canc./Reversal Doc.)	X	J_3GSTORNO	CHAR	2
J_3GMENGE	Quantity With +/- Sign		J_3GMENGEV13	QUAN	7
J_3GMEINS	Unit of measure		MEINA	UNIT	6	*
J_3GDATBIS	To Date		J_3GDATBI	DATS	16
J_3GDATZU	Acquisition Date		J_3GDATZU	DATS	16
J_3GBELZU	Document Number for Acquisition		J_3GBELZU	CHAR	20
J_3GPOSZU	Document Item - Acquisition		J_3GPOSZU	NUMC	10	*
J_3GDATAB	Retirement Date		J_3GDATAB	DATS	16
J_3GBELAB	Document Number for Retirement		J_3GBELAB	CHAR	20
J_3GPOSAB	Document Item - Retirement		J_3GPOSAB	NUMC	10	*
J_3GABDATI	Internal Settlement Date		J_3GABDATI	DATS	16
J_3GABDATE	External Settlement Date		J_3GABDATE	DATS	16