Hello Experts, I’m trying to write a JOIN SELECT statement on VBAK and VBAP tables but having challenge to get information which I need. Following is the select statement. I’ve provided as many filters as I could and two of them (b~kdmat and a~bstdk pv_ship_date) are taken from input parameters.
SELECT a~vbeln a~audat a~vbtyp a~auart a~faksk a~bsark a~bstdk a~zzshch
b~posnr b~kdmat b~cuobj
INTO TABLE t_sales_order
FROM vbak AS a INNER JOIN vbap AS b ON a~vbeln = b~vbeln
where a~vbtyp = lc_vbtyp
and ( a~auart = lc_zlcy or a~auart = lc_zshp )
and ( a~augru = lc_sh or a~augru = lc_lc )
and ( a~bsark = lc_zonl or a~bsark eq lc_zpws or a~bsark = lc_zoff or a~bsark = lc_zedi or a~bsark = lc_zotb )
and b~kdmat = pv_pin_number
and a~bstdk eq pv_ship_date.
Based on input parameter when I look into the tables VBAK and VBAP then I can find records (one each) in both tables but the above statement doesn’t fetch it and SY-SUBRC value becomes 4. Can anybody see what’s wrong with this statement? Many thanks in Advance. Best Regards.
Bluesky
