Hi folks,
The query is not fetching data correctly.... What can be the reason?
SELECT
a~zzproinvno,
a~zzproinvamt,
a~zterm,
a~deffered_status,
a~product_item_name,
a~bank,
c~banka,
a~bukrs,
a~lifnr,
a~zzversion,
a~status,
* b~bankl,
b~bankn,
b~bkref,
c~loevm
FROM zumm_pi_lc AS a
INNER JOIN lfbk AS b
ON ( a~bank = b~bankl )
INNER JOIN bnka AS c
ON ( a~bank = c~bankl )
INTO TABLE @DATA(lt_pi_zumm)
WHERE bukrs = @p_com
AND a~lifnr = @p_ven
AND status = 'AUDITED'
AND c~loevm = ''.