Tuesday, 27 March 2012

For all entries example


If gdt_mhnk is not INITIAL .
 S ELECT  kunnr
              adrnr
              INTO TABLE gdt_kna1
              FROM kna1
              FOR ALL ENTRIES IN gdt_mhnk
              WHERE kunnr = gdt_mhnk-kunnr.

Endif.



IF the internal table is empty, then it will fetch all the records from the database table.

No comments:

Post a Comment