-----------------------------------------------------------------------
-- Query to data loagind SAP B1 to ONCLICK
-- @BFAGUNDES - Version 180719.1
-- #sapb1 #sapb1_oitm #mssql #Onclick
-----------------------------------------------------------------------
SELECT	 OITM.ItemCode			as [CODPROD]
		,OITM.CodeBars			as [CODBARRA]
		,OITM.SWW				as [CODFABRICANTE]
		,''						as [CODBARRADUN14]
		,OITM.ItemName			as [DESCRICAO]
		,OITM.FrgnName			as [REDUZIDO]
		,''						as [DESCRICAO COMPRA]
		,''						as [OBSERVACAO]
		,OITM.UserText			as [OBSPRODUTO]
		,''						as [ESTATUAL]
		,''						as [ESTMINIMO]
		,''						as [ESTMAXIMO]
		,OITM.SWeight1			as [PESOLIQ]
		,OITM.SWeight2			as [PESOBRU]
		,''						as [LOCALIZACAO]
		,OITM.SalUnitMsr		as [UNID VAREJO]
		,OITM.SalPackMsr		as [EMBAL VAREJO]
		,OITM.BuyUnitMsr		as [UNID COMPRA]
		,OITM.PurPackMsr		as [EMBAL COMPRA]
		,''						as [DTCOMPRA]
		,''						as [DTVENDA]
		,''						as [DTALTESTOQUE]
		,''						as [CUSTOMEDIO]
		,OITM.frozenFor			as [INATIVO]
		,''						as [VENDASUSPENSA]
		,OITM.CreateDate		as [DTCAD]
		,''						as [TRIBUTACAO]
		,''						as [TRIBUTACAO_FORAUF]
		,''						as [ICMSSP]
		,''						as [ICMSPR]
		,''						as [ICMSDF]
		,''						as [PRECOVAR]
		,''						as [MARGEM]
		,OITM.NCMCode			as [CLASSFISCAL]
		,''						as [PRECOVAR]
		,''						as [CATEGORIA]
		,OITB.ItmsGrpNam		as [GRUPO]
		,''						as [SUBGRUPO]
		,''						as [CARAC1?]
		,''						as [CARAC2?]
		,''						as [CARAC3?]
FROM	 OITM
INNER JOIN OITB
	ON	 OITM.ItmsGrpCod = OITB.ItmsGrpCod
WHERE	 LEN(OITM.ItemCode) = 8 -- Limited only itens with 3 digits after hyphen