Cacher is the code snippet organizer for pro developers

  SELECT a~lifnr, a~name1, a~land1, a~regio, a~ort01,
         a~pstlz, a~stras, a~stceg, a~stcd1, a~kunnr,
         a~vbund, a~ktokk, b~bukrs, b~zterm, b~zwels,
         b~zahls, b~lnrze, b~altkn, c~ekorg, c~zterm AS zterm2
    FROM lfa1 AS a
    INNER JOIN lfb1 AS  b ON a~lifnr EQ b~lifnr
    LEFT  JOIN lfm1 AS  c ON a~lifnr EQ c~lifnr
    INNER JOIN t024e AS d ON ( d~bukrs EQ @p_bukrs
                          OR   d~bukrs EQ @space )
                         AND   c~ekorg EQ d~ekorg
    INTO TABLE @DATA(lt_lfa1)
    WHERE a~lifnr IN @s_lifnr
    AND   b~bukrs EQ @p_bukrs.