360Validation.sql

Source: DMF/PuC/MFCS/360Validation.sql

-- reports
SELECT * FROM DMF_GEN_REPORT_ITEM_MASTER_CTRL_VW;
SELECT * FROM DMF_GEN_REPORT_STORE_ADD_CTRL_VW;
SELECT * FROM DMF_GEN_REPORT_WH_CTRL_VW;
 
-- channels and org units
select * from channels_ctrl order by channel_id;
select * from org_unit_ctrl order by ORG_UNIT_ID;
select * from XREF_ORG_UNIT;
 
-- store and warehouse
select count(1) from store_add_ctrl;
select * from PUC_store_CFA_EXT_VW;
select count(1) from wh_ctrl;
select * from PUC_WH_CFA_EXT_VW;
 
select * from puc_wh_cfa_ext_vw where wh = 161;
select vkorg, w.* from sap_slt_prod_pv1.wrf1 w where locnr = '0000000161'; -- delete wh 0161
 
-- cfa values
 
select BASE_TABLE, VIEW_COL_NAME AS ATTRIBUTE, CFA.CODE_TYPE, CDETAIL.CODE, CDETAIL.CODE_DESC
  from PUC_CFA_MFCS_MVW CFA,
       PUC_CODE_DETAIL_VW CDETAIL          
where CFA.CODE_TYPE = CDETAIL.CODE_TYPE
 AND CFA.base_table = 'STORE' 
 AND CFA.CODE_TYPE IS NOT NULL
 ORDER BY VIEW_COL_NAME, CODE_SEQ;
 
select BASE_TABLE, VIEW_COL_NAME AS ATTRIBUTE, CFA.CODE_TYPE, CDETAIL.CODE, CDETAIL.CODE_DESC
  from PUC_CFA_MFCS_MVW CFA,
       PUC_CODE_DETAIL_VW CDETAIL          
where CFA.CODE_TYPE = CDETAIL.CODE_TYPE
 AND CFA.base_table = 'WH' 
 AND CFA.CODE_TYPE IS NOT NULL
 ORDER BY VIEW_COL_NAME, CODE_SEQ; 
 
select * from PUC_CODE_DETAIL_VW where code_type = 'PCOM';
select * from PUC_CODE_DETAIL_TL_VW;
 
-- partner
select 'PARTNER', ctrl_status, count(1) from partner_ctrl group by ctrl_status;
 
 
-- supplier
 
 
-- merch hier
 
select * from item_master_ctrl where item_level = tran_level and item = '000000402855703632' ;
select zzwgr_wawi,m.* from sap_slt_prod_pv1.mara m where matnr = '000000402855703632';
select * from xref_zsta_stw2 where wgr = '0015427'