Skip to Content
-2

inner join to loop

can this be done through without using joins.

In the below code I am taking input as werks from the user and putting in a800, based on output again taking knumh from A800 and putting in KONH to get results.

*SELECT  KONH~mandt as MANDT,

*        KONH~KNUMH as KNUMH,

*        KONH~ERNAM as ERNAM,

*        KONH~ERDAT as ERDAT,

*        KONH~VADAT as VADAT
*           INTO table @DATA(gt_final)

*      FROM A800

*  inner JOIN KONH

*      ON KONH~Knumh = A800~Knumh

* WHERE A800~WERKS IN @S_WERKS.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 06 at 06:20 PM

    What do you want to achieve? What's not working with the join? What do you mean with loop? From a short look, a subquery in the WHERE condition might be more appropriate.

    Add comment
    10|10000 characters needed characters exceeded