ISU Select with Join

SELECT  fkkvkp~gpart
        fkkvkp~abwvk
        fkkvkp~ausgrup_in
        fkkvkp~vkont
        ever~sparte
        ever~vertrag
        ever~auszdat
        eanlh~aklasse
        adrc~name1
        adrc~house_num1 adrc~street adrc~city1 
        adrc~post_code1 adrc~region evbs~haus_num2
 FROM  fkkvkp 
 INNER JOIN ever  ON fkkvkp~vkont = ever~vkonto
 INNER JOIN eanl  ON ever~anlage = eanl~anlage
 INNER JOIN eanlh ON eanl~anlage = eanlh~anlage
 INNER JOIN evbs  ON eanl~vstelle = evbs~vstelle
 INNER JOIN iflot ON evbs~haus    = iflot~tplnr
 INNER JOIN iloa  ON iflot~iloan  = iloa~iloan
 INNER JOIN adrc  ON iloa~adrnr   = adrc~addrnumber
 INTO TABLE lt_address
 WHERE eanlh~bis       >= sy-datum AND
       eanlh~ab        <= sy-datum AND
       fkkvkp~gpart    = lv_gpart
 ORDER BY ever~vertrag DESCENDING 
          ever~auszdat DESCENDING.
 IF sy-subrc EQ 0.
 ENDIF.
Output : N/A
Share this:

Like this:
