Skip to Content
0
Jun 30, 2022 at 05:32 PM

"FIELDS" is not allowed here. "ON" is expected

118 Views Last edit Jul 01, 2022 at 06:35 AM 4 rev

  SELECT      FROM ekko AS a INNER JOIN ekpo AS b
ON a~ebeln = b~ebeln
LEFT OUTER JOIN cdhdr AS c INNER JOIN cdpos AS d
ON c~objectclas = d~objectclas
AND c~objectid = '4500000000'
AND c~changenr = d~changenr
LEFT OUTER JOIN wyt3 AS w
ON a~lifnr = w~lifnr AND w~parvw = 'VN'
LEFT OUTER JOIN t052u AS t
ON a~zterm = t~zterm AND t~spras = sy-langu
LEFT OUTER JOIN t024 AS t0
ON a~ekgrp = t0~ekgrp
FIELDS a~ebeln , b~loekz,
c~tcode, w~lifn2,t~text1,
t0~eknam
WHERE a~ebeln = @gs_nast-objky+0(10)
INTO TABLE @DATA(lt_data).
I am facing error - <strong>"FIELDS" is not allowed here. "ON" is expected</strong>, Can someone help what could be wrong. Host Variables have @Escape char NW - 755