[romario2]

Hola,

tengo una duda con este inner join, en la parte de:

ON a~bukrs = b~bukrs
AND a~kunnr = b~kunnr
* AND a~gjahr = b~gjahr
* AND a~blart = b~blart
* AND a~budat = b~budat
* AND a~gsber = b~gsber

no se si debo añadir más o menos condiciones, no me filtra bien el parámetro de año: p_gjahr y no se el motivo.


CLEAR it_bsid.
REFRESH it_bsid.
SELECT a~bukrs a~kunnr a~gjahr a~blart a~budat a~belnr a~xblnr a~gsber
INTO TABLE it_bsid
FROM bsid AS a
INNER JOIN bsad AS b
ON a~bukrs = b~bukrs
AND a~kunnr = b~kunnr
* AND a~gjahr = b~gjahr
* AND a~blart = b~blart
* AND a~budat = b~budat
* AND a~gsber = b~gsber
WHERE a~bukrs = p_bukrs
* AND a~gjahr = p_gjahr
AND a~blart IN s_blart
AND a~budat IN s_budat
AND a~kunnr IN rg_kunnr
AND a~gsber IN s_gsber.

Saludos y gracias,