SQ02 - query - external program

[former_member591577]

Hi,

I have created SQ02 query with structure and external program. When I add output field in SQ01 from my structure to display in output list I get runtime error field not found (any and all of the fields from the structure). After inspection of generated report, it seems to me it has TABLES declaration too late...

I have created my external program according to:

https://help.sap.com/saphelp_sm71_sp14/helpdata/en/d2/cb45b2455611d189710000e8322d00/content.htm?no_...

I have my TABLES statement with my structure (DB table). My *<Query_head> comment after which I do select into internal table. Then I loop my internal table a move line into fields of my TABLES statement and finish the loop just after *<Query_body> comment.

It is mentioned that not following given report structure the generated query might be meaningless, which happens. But it seems to me that I followed all the requirements for external retrieval program.

Any advice on the topic is welcomed. Thanks in advance.

The reason for implementing sq02 by external program is that if it is done as inner join on DB tables it does select/endselect. I would like to be able to do select and do some custom logic afterwards.

Best regards,

Jakub Wozniak

[former_member591577 · Accepted solution]

Didn´t managed to resolve. I have abandoned external program route and opt out for program written in SQ. That way I was able to meet customer demands. Although, writting programs in SQ is a bit of a pain (line length restriction and switching between different program events).

Hopefuly I will get to similiar issue in future.