Diffs.sql

Source: DMF/PuC/AIF/Diffs.sql

select * from diff_ids_stg;
delete from diff_ids_stg;
 
select * from diff_ids_ctrl;
delete from diff_ids_ctrl;
 
select * from diff_ids_tl_stg;
select * from diff_ids_tl_ctrl;
 
select * from diff_type_stg;
select * from diff_type_ctrl;
 
select * from diff_type_stg;
select * from diff_type_ctrl;
 
select * from diff_group_head_stg;
select * from diff_group_head_ctrl;
 
select * from diff_group_detail_stg;
select * from diff_group_detail_ctrl;
 
select * from SAP_SLT_PROD_PV1.zsta_kat where status = 2 and kennung = '01250' order by ident; -- 01250 group of color / 01450 color / 1255 color hue
-- 01250 group of color / 01450 color / 1255 color hue
/*
0000001
0000002
0000003
0000004
0000005
0000006
0000007
0000008
0000009
0000010
0000011
0000012
0000013
0000014
0000015
0000099
*/
 
select k.status 
       ,k.kennung 
       ,k.ident
       ,k.hierknotentyp
       ,k.hier_ident
       ,k.ogr_ident
       ,kx.description
       ,kx.langu
from SAP_SLT_PROD_PV1.zsta_kat k
left join SAP_SLT_PROD_PV1.zsta_ktx kx on kx.status = k.status 
                                    and kx.kennung = k.kennung
                                    and kx.ident = k.ident
                                    and kx.hier_ident = k.hier_ident
                                    and kx.hierknotentyp = k.hierknotentyp
where k.status = 2 
  and k.kennung = '1255' 
  --and description <> ' '
  order by k.ident,k.hier_ident ; -- 01700 group of size / 01715 sizes
 
select status,kennung,ident,hier_ident
from SAP_SLT_PROD_PV1.zsta_kat where status = 2 and kennung = '01700' and cre_timestamp = upd_timestamp group by status,kennung,ident,hier_ident having count(1) > 1;
 
select * from SAP_SLT_PROD_PV1.zsta_kat where status = 2 and kennung = '01700' and ident = '0000008' and hier_ident = '0000775';
-- 01700 group of size / 01715 sizes
/*
0000001
0000002
0000003
0000004
0000005
0000006
0000007
0000008
0000009
0000010
0000011
0000012
0000013
0000014
0000015
0000016
0000017
0000018
0000019
0000020
0000021
0000022
0000023
0000024
0000025
0000026
0000027
0000028
0000029
0000030
0000031
0000032
0000033
0000100
*/
 
select * from SAP_SLT_PROD_PV1.zsta_ktx where status = 2 and kennung = '01250' and ident = '0000014' and hier_ident = '00000000';