General presentation


Open Hub Destination OH_CON_01

 


Objective of the application

This application it is used to transfer data from the query BW_QRY_MV_SPD01_0027, based on the Multiprovider MV_SPD01, to the Transaction Code AL11, into the following Path

  • /exploit
  • /BW
  • /CONVERGENCE
  • /Convergence.CSV

where WebMethod team (Support.XML@solvay.com) picks it up and transfer it to its system for data cleaning and later integration in Convergence (Salesforce).


Logical Path and Logical Path Name in Transaction File


Logical path


Assignment of Physical Path to Logical Path


Logical File Name


Dataflow overview


From the query BW_QRY_MV_SPD01_0027 data are moved to ADSO DP_OH_C1 and, then, to Open Hub destination OH_CON_01.


Query


Filters of the query 


Free Characteristics


Rows

 


Conditions


Columns


Variable in BEX, Class in Transaction SE24 and Variable in Transaction SM30


Variable in BEX

  1. V_0CALMONTH_CR_17_M                 for the InfoObject 0CALMONTH

  2. V_C_CREDID__C_GRPPUR_0001         for the InfoObject V_C_CREDID__C_GRPPUR

  3. V_0LOGSYS_0001                               for the InfoObject V_0LOGSYS

  4. V_C_COMPCDE__C_AUTHMA_0002   for the InfoObject C_COMPCDE__C_AUTHMA

  5. V_C_PLANT__C_AUTHMA_0001         for the InfoObject C_PLANT__C_AUTHMA


Class in Transaction SE24

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

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

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

  4. ZCL_BIU001_V_C_COMPCDE__C_AUTH   to be linked in the below step with its variable of the above step

  5. ZCL_BIU001_V_C_PLANT__C_AUTH         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_CR_17_M                 linked to its Class above

  2. V_C_CREDID__C_GRPPUR_0001         linked to its Class above

  3. V_0LOGSYS_0001                               linked to its Class above

  4. V_C_COMPCDE__C_AUTHMA_0002   linked to its Class above

  5. V_C_PLANT__C_AUTHMA_0001         linked to its Class above


Transformations


Between the query BW_QRY_MV_SPD01_0027 and the ADSO DP_OH_C1

Mapping 1 by 1, without abap rules.

 


Between the ADSO DP_OH_C1 and the Open Hub Destination OH_CON_01

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


ADSO

The ADSO DP_OH_C1 has been created in order to manage the preponderant

  • Creditor Segment (P)
  • Creditor Class (P)
  • Creditor Nature (P)

that at query level have been managed through the three Conditions seven points above, but that in the Open Hub are not transferred, therefore, they are managed through the below abap code built in the Transformation between the ADSO DP_OH_C1 and the Open Hub Destination OH_CON_01.


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_0002, V_C_PLANT__C_AUTHMA_0001, V_C_CREDID__C_GRPPUR_0001, V_0LOGSYS_0001).


Process Chain


PC_CONVERGENCE_OH_CON_01 - CONVERGENCE: Open Hub OH_CON_01

 


Loading

Weekly, on Monday at 6:30 AM CET.


Maintenance

In case of issue create a Freshdesk ticket.


Known bugs

No


Recurring procedure

This Open Hub transfers data (File Convergence.CSV) to the Transaction Code AL11, into the Path "/exploit/BW/CONVERGENCE" each Monday at 6:30 AM CET. 


Planned Evolution

No



  • No labels