Skip to Content
0
Former Member
Mar 24, 2009 at 01:00 PM

can anyone explain

119 Views

Please use meaningful subjects for your posts in future.

Hi guys,

can anyone explain this code in detail....

    SELECT mara~matnr meins AS meinh mara~bbtyp filia AS werks
    INTO CORRESPONDING FIELDS OF TABLE p_t_mat_asort_site
    FROM mara INNER JOIN wlk1 ON
      mara~matnr = wlk1~artnr
      INNER JOIN maw1 ON
        maw1~matnr = wlk1~artnr
    FOR ALL entries IN wa_site_tmp
    WHERE
      wlk1~filia = wa_site_tmp-kunnr
      AND maw1~bbtyp IN so_bbtyp
      AND wlk1~quell IN ('C','L','1','2','3')
      AND wlk1~datab LE g_datum
      AND wlk1~datbi GE g_datum
      AND wlk1~strli NE 'X'
      AND maw1~bbtyp IN so_bbtyp
      AND mtart NE 'ZPAI'.

Thanks in advance.

Edited by: Matt on Mar 24, 2009 2:05 PM

Edited by: Matt on Mar 24, 2009 2:06 PM