General presentation
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
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).
Process Chain
PC_SOLSTICE_ZOH_SOL006 - Solstice Informatica Download for ZOH_SOL006
Loading
Daily at 7 AM
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 7AM.
Planned Evolution
No