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

1. V_0CALMONTH_PR_CR_M                 for 0CALMONTH

2. V_0LOGSYS_0014                               for 0LOGSYS

3. V_C_COMPCDE__C_AUTHMA_0003   for C_COMPCDE__C_AUTHMA

4. V_C_PLANT__C_AUTHMA_0003         for C_PLANT__C_AUTHMA

Class in Transaction SE24 

1. ZCL_BIU001_V_0CALMONTH_PR_CR_M   to be linked in the below step with its variable of the above step

2. ZCL_BIU001_V_0LOGSYS_0014                 to be linked in the below step with its variable of the above step

3. ZCL_BIU001_V_C_COMPCDE_0003           to be linked in the below step with its variable of the above step

4. 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) 

1. V_0CALMONTH_PR_CR_M                 linked to its Class above

2. V_0LOGSYS_0014                               linked to its Class above

3. V_C_COMPCDE__C_AUTHMA_0003   linked to its Class above

4. 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 dily 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, each day only previous and current months are loaded.

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