Test
Testunknown
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