General presentation
The Quantity and the Base Unit of Measure
Open Hub Destination OH_SOL006
Objective of the application
This application it is used to transfer data from the query BW_QRY_MV_SPD01_0026, based on the Multiprovider MV_SPD01, to Cytec INFORMATICA system .
Dataflow overview
From the query BW_QRY_MV_SPD01_0026 data are moved to the Open Hub destination OH_SOL006.
Query
Filters of the query
Free Characteristics
No free characteristics
Rows
Columns
Variable in BEX, Class in Transaction SE24 and Variable in Transaction SM30
Variable in BEX
V_0CALMONTH_PR_CR_M for 0CALMONTH
V_0LOGSYS_0014 for 0LOGSYS
V_C_COMPCDE__C_AUTHMA_0003 for C_COMPCDE__C_AUTHMA
V_C_PLANT__C_AUTHMA_0003 for C_PLANT__C_AUTHMA
Class in Transaction SE24
ZCL_BIU001_V_0CALMONTH_PR_CR_M to be linked in the below step with its variable of the above step
ZCL_BIU001_V_0LOGSYS_0014 to be linked in the below step with its variable of the above step
ZCL_BIU001_V_C_COMPCDE_0003 to be linked in the below step with its variable of the above step
ZCL_BIU001_V_C_PLANT_0003 to be linked in the below step with its variable of the above step
Variable in Transaction SM30 (table ZBIU001_V_VAR)
V_0CALMONTH_PR_CR_M linked to its Class above
V_0LOGSYS_0014 linked to its Class above
V_C_COMPCDE__C_AUTHMA_0003 linked to its Class above
V_C_PLANT__C_AUTHMA_0003 linked to its Class above
- For the Variable: V_0CALMONTH_PR_CR_M , in the class ZCL_BIU001_V_0CALMONTH_PR_CR_M . In the change for the UC: 4000027607, the variable V_0CALMONTH_PR_CR_M is fed through the Global Filter C_GLBFILT The range of the 0calmonth is based on the fields /BIC/C_LOW and /BIC/C_HIGH of the Global Filter where normally we should have 0 in /BIC/C_HIGH (meaning current month) and 1 in /BIC/C_LOW (meaning one month less than /BIC/C_HIGH).
And in case of need we can easily change those two values in the Global Filter for example
/BIC/C_HIGH = 3 (meaning three months less than the current month), /BIC/C_LOW = 2 (meaning two months less than /BIC/C_HIGH)
Transformation
In the Transformation there is a Start Routine built in order to feed Internal Tables used, then, in the Rule Details, in order to feed Master Data and Text of the Open Hub Destination
Global Filter
The below Rules in the Gloabal Filter (C_GLBFILT) are used to feed the variables created in the Query Designer (V_C_COMPCDE__C_AUTHMA_0003, V_C_PLANT__C_AUTHMA_0003, V_0LOGSYS_0014).
The below Rules in the Gloabal Filter (C_GLBFILT) are used to determine the period that everyday has to be loaded into INFORMATICA system.
Normally C_HIGH is setted at 0 that means current month and C_LOW is setted at 1 that means 1 month less than the current month, therefore, everyday only the previous and the current months are loaded.
But in case of needs to reload the past, it can be easily managed in those two fileds, C_HIGH and C_LOW.
For example today is February 2021 and it needs to reload Sectember, October and November 2020; in C_HIGH it needs to put 3 that means 3 months less than the current month and in C_LOW it needs to put 2 that means 2 months less than November 2020.
After the reloading it needs to reset C_HIGH =0 and C_LOW = 1 for the next daily loadings.
Process Chain
PC_SOLSTICE_ZOH_SOL006 - Solstice Informatica Download for ZOH_SOL006
Loading
Daily at 7:00 AM CET
Maintenance
In case of issue create a Freshdesk ticket.
Known bugs
No
Recurring procedure
This Open Hub transfers data to Cytec INFORMATICA system each day at 7:00 AM CET.
Planned Evolution
No