Skip to Content
0
Former Member
Jun 09, 2009 at 08:30 AM

Matching records not found

43 Views

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.