‎2018 Oct 14 7:39 PM
Hi,
I checked below link for inner join and inline declaration of table . So copy pasted the code from below link
got error as below :

Though the code was copy, pasted then I changed the sequence of into table as below then got offset error

Again to check in simple code and no join, still getting offset error
Using the new syntax, pls help me understand what exactly the error is saying
SELECT bukrs,belnr,gjahr
FROM bkpf
INTO TABLE @data(lt_bkpf) ( row - 47)
WHERE bukrs = @p_bukrs
AND belnr = @p_belnr.

Thanks,
Mohan
‎2018 Oct 14 9:36 PM
Have you thought about the fact, that it could be a wrong message at your error tab?
And why don't you use ADT, not sure, if all syntax checks are also available via SE38...
Without a system, I would suggest, that the second select is valid (first screen).
The into at the end is located at the right position when using escaping.
And what's that with (row-47).. what do you try here?
‎2018 Oct 14 9:36 PM
Have you thought about the fact, that it could be a wrong message at your error tab?
And why don't you use ADT, not sure, if all syntax checks are also available via SE38...
Without a system, I would suggest, that the second select is valid (first screen).
The into at the end is located at the right position when using escaping.
And what's that with (row-47).. what do you try here?
‎2018 Oct 15 5:44 AM
Thanks Florian. I checked in ADT and the syntax for inner join is fine.
Some of the syntax in GUI like inline declaration for variable/Work area work but inline table gives syntax. Even some syntax like aggregation in select works in GUI.
I thought of some basic inline syntax declaration works in GUI then why this offeset issue with inline table declaration.
Thanks,
Mohan