Test

Test
 avatar
unknown
abap
6 months ago
1.8 kB
2
Indexable
lt_new_data2 =
        SELECT  SESSION_CONTEXT('CLIENT') AS mandt,
                smat.supplier,
                smat.s_matnr,
                smat.material_group,
                _txt.MaterialGroupText AS material_group_description,
                smat_t.description,
                CASE WHEN ltx_l2.supplier IS NOT NULL
                     THEN CONCAT(ltx_l1.text_line, ltx_l2.text_line)
                     ELSE ltx_l1.text_line
                END AS text_line,
                _catalog.wminr,
                smat.matnr AS material,
                ROW_NUMBER() OVER ( PARTITION BY smat.supplier, smat.s_matnr
                                      ORDER BY smat.supplier, smat.s_matnr )
                                      AS row_num
        FROM :filtered_smat AS smat
        INNER JOIN "/ESAP/CMT_SMAT_T" AS smat_t
            ON smat.supplier = smat_t.supplier
            AND smat.s_matnr = smat_t.s_matnr
            AND smat_t.language = 'O'
        LEFT OUTER JOIN "/ESAPGL/SMAT_LTX" AS ltx_l1
            ON smat.supplier = ltx_l1.supplier
            AND smat_t.s_matnr = ltx_l1.s_matnr
            AND ltx_l1.text_type = 'ZPUR'
            AND ltx_l1.language = 'O'
            AND ltx_l1.line_number = '1'
        LEFT OUTER JOIN "/ESAPGL/SMAT_LTX" AS ltx_l2
            ON smat.supplier = ltx_l2.supplier
            AND smat_t.s_matnr = ltx_l2.s_matnr
            AND ltx_l2.text_type = 'ZPUR'
            AND ltx_l2.language = 'O'
            AND ltx_l2.line_number = '2'
        INNER JOIN ZMM_I_NSC_CATALOG AS _catalog
            ON smat.supplier = _catalog.supplier
            AND smat.s_matnr = _catalog.s_matnr
        LEFT OUTER JOIN i_materialgrouptext AS _txt
            ON smat.material_group = _txt.MaterialGroup
            AND _txt.language = 'O';
Editor is loading...
Leave a Comment