#1
|
|||
|
|||
Inner Join
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, |
Herramientas | Buscar en Tema |
Desplegado | |
|
|