MerchHier.sql

Source: DMF/PuC/AIF/MerchHier.sql

SELECT DISTINCT xr.resgr            AS group_no,
       xr.ressort_gr_bezeichnung    AS group_name,
       tmp.dept,
       xr.ressort_bezeichnung       AS dept_name,
       tmp.class,
       wbt.brand_descr              AS class_name,
       tmp.subclass,
       (SELECT kx.description_long
          FROM sap_slt_prod_pv1.zsta_kat k,
               sap_slt_prod_pv1.zsta_ktx kx
         WHERE k.kennung     = '03720'
           AND k.ident       = tmp.category
           AND k.status      = 2
           AND kx.mandt      = k.mandt
           AND kx.kennung    = k.kennung
           AND kx.ident      = k.ident
           AND kx.status     = k.status
           AND kx.langu      = 'D') AS subclass_desc,
        tmp.brand_id as brand_aggregation,
        brand_type
  FROM (SELECT DISTINCT dept,
               class,
               subclass,
               brand_id,
               category,
               brand_type
          FROM puc_sku_im_excl_brands_tmp
         UNION ALL
        SELECT DISTINCT dept,
               class,
               subclass,
               brand_id,
               category,
               brand_type
          FROM puc_sku_im_own_brands_tmp) tmp,
       xref_zsta_stw2 xr,
       sap_slt_prod_pv1.wrf_brands_t wbt
 WHERE xr.res       (+) = tmp.dept
   AND wbt.brand_id (+) = tmp.brand_id
 ORDER BY GROUP_NO, DEPT, CLASS, SUBCLASS
   
   
   
   
   select * from xref_zsta_stw2 where wgr = '20817' ;
   
   select zzwgr_wawi, brand_id, m.* from sap_slt_prod_pv1.mara m;