CUSTOS_PLANEJADOS_REALIZADOS_SUMARIZADOS
- Rodrigo Frazani (Unlicensed)
Documentação:
Descrição da tabela:
No aguarda da subida das tabelas COSP e COSS no databricks, tabela com bloqueios
Tabelas utilizadas:
SAP_HEQ.COSP
SAP_HEQ.COSS
Montagem:
1 - Select na tabela COSP trazendo os seguintes campos:
MANDT,LEDNR,OBJNR,GJAHR,WRTTP,VERSN,KSTAR,HRKFT,VRGNG,VBUND,'null' PAROB,PARGB,'null' USPOB
,BEKNZ,TWAER,PERBL,MEINH,WTG001,WTG002,WTG003,WTG004,WTG005,WTG006,WTG007,WTG008,WTG009,WTG010
,WTG011,WTG012,WTG013,WTG014,WTG015,WTG016,WOG001,WOG002,WOG003,WOG004,WOG005,WOG006,WOG007
,WOG008,WOG009,WOG010,WOG011,WOG012,WOG013,WOG014,WOG015,WOG016,WKG001,WKG002,WKG003,WKG004
,WKG005,WKG006,WKG007,WKG008,WKG009,WKG010,WKG011,WKG012,WKG013,WKG014,WKG015,WKG016,WKF001
,WKF002,WKF003,WKF004,WKF005,WKF006,WKF007,WKF008,WKF009,WKF010,WKF011,WKF012,WKF013,WKF014
,WKF015,WKF016,PAG001,PAG002,PAG003,PAG004,PAG005,PAG006,PAG007,PAG008,PAG009,PAG010,PAG011
,PAG012,PAG013,PAG014,PAG015,PAG016,'null' PAF001,'null' PAF002,'null' PAF003,'null' PAF004
,'null' PAF005,'null' PAF006,'null' PAF007,'null' PAF008,'null' PAF009,'null' PAF010,'null' PAF011
,'null' PAF012,'null' PAF013,'null' PAF014,'null' PAF015,'null' PAF016,MEG001,MEG002,MEG003,MEG004
,MEG005,MEG006,MEG007,MEG008,MEG009,MEG010,MEG011,MEG012,MEG013,MEG014,MEG015,MEG016,MEF001
,MEF002,MEF003,MEF004,MEF005,MEF006,MEF007,MEF008,MEF009,MEF010,MEF011,MEF012,MEF013,MEF014
,MEF015,MEF016,MUV001,MUV002,MUV003,MUV004,MUV005,MUV006,MUV007,MUV008,MUV009,MUV010,MUV011
,MUV012,MUV013,MUV014,MUV015,MUV016,BELTP,TIMESTMP,BUKRS,FKBER,SEGMENT,GEBER,GRANT_NBR,BUDGET_PD
FILTRO : GJAHR like year(current_date)
2 - Select na tabela: COSS trazendo os seguintes campos:
MANDT,LEDNR,OBJNR,GJAHR,WRTTP,VERSN,KSTAR,HRKFT,VRGNG,'null' VBUND ,PAROB,'null' PARGB
,USPOB,BEKNZ,TWAER,PERBL,MEINH,WTG001,WTG002,WTG003,WTG004,WTG005,WTG006,WTG007,WTG008
,WTG009,WTG010,WTG011,WTG012,WTG013,WTG014,WTG015,WTG016,WOG001,WOG002,WOG003,WOG004
,WOG005,WOG006,WOG007,WOG008,WOG009,WOG010,WOG011,WOG012,WOG013,WOG014,WOG015,WOG016
,WKG001,WKG002,WKG003,WKG004,WKG005,WKG006,WKG007,WKG008,WKG009,WKG010,WKG011,WKG012
,WKG013,WKG014,WKG015,WKG016,WKF001,WKF002,WKF003,WKF004,WKF005,WKF006,WKF007,WKF008
,WKF009,WKF010,WKF011,WKF012,WKF013,WKF014,WKF015,WKF016,PAG001,PAG002,PAG003,PAG004
,PAG005,PAG006,PAG007,PAG008,PAG009,PAG010,PAG011,PAG012,PAG013,PAG014,PAG015,PAG016
,PAF001,PAF002,PAF003,PAF004,PAF005,PAF006,PAF007,PAF008,PAF009,PAF010,PAF011,PAF012
,PAF013,PAF014,PAF015,PAF016,MEG001,MEG002,MEG003,MEG004,MEG005,MEG006,MEG007,MEG008
,MEG009,MEG010,MEG011,MEG012,MEG013,MEG014,MEG015,MEG016,MEF001,MEF002,MEF003,MEF004
,MEF005,MEF006,MEF007,MEF008,MEF009,MEF010,MEF011,MEF012,MEF013,MEF014,MEF015,MEF016
,MUV001,MUV002,MUV003,MUV004,MUV005,MUV006,MUV007,MUV008,MUV009,MUV010,MUV011,MUV012
,MUV013,MUV014,MUV015,MUV016,BELTP,TIMESTMP,BUKRS,FKBER,SEGMENT,GEBER,GRANT_NBR,BUDGET_PD
FILTRO : GJAHR like year(current_date)
3 - União entre as duas tabelas:
select * from cosp
union all
select * from coss
Databricks:
camada_semantica.custos_planejados_realizados_sumarizados
Documentação de desenvolvimento - Basseto
1 -Data-types 2 - Regra de desenvolvimento
