Hi
When I execute this query through abap report I am not getting the correct result
using se11 vbak vbeln = '3504131'
also
using se11 vbpa vbeln = u20183504131u2019 parvw = 'Z4'
then I am getting the result
What is wrong with my query.
d_zuonr = u20183504131u2019
SELECT SINGLE vbak~vgbel AS aubel
vbak~vbeln
vbpa~pernr
tvkbt~bezei
tvkot~vtext
INTO CORRESPONDING FIELDS OF wa_cmtype
FROM vbak
LEFT JOIN vbpa ON vbpavbeln EQ vbakvbeln AND
vbpa~parvw EQ 'Z4'
LEFT JOIN tvkot ON vbakvkorg EQ tvkotvkorg AND
tvkot~spras EQ sy-langu
LEFT JOIN tvkbt ON vbakvkbur EQ tvkbtvkbur AND
tvkbt~spras EQ sy-langu
WHERE vbak~vbeln EQ d_zuonr
sy-subrc is 4 only after executing the query.
regards
Sebastian John.