The new wiki link for this data flow is here:
Please update the doc there and no longer here.
Project: SAG was "Select A Guide"
Point of Contact: Juan.Mantilla@solvay.com or tiago.ramalho-ext@solvay.com
(before james.kyndt@solvay.com)
Dev BW :
Query used : QVSBS QVSBS_BW_QRY_MVCOPA01_0004 (core query : BW_QRY_MVCOPA01_0004)
Folder used : /exploit/bw/Smartfloat
APD :APD_PL_0023
Routine :
DATA: ls_source TYPE y_source_fields,
ls_target TYPE y_target_fields.
*ls_target-CALYEAR = 'Year'.
*ls_target-APPLICATION = 'Application'.
*ls_target-END_USE = 'End-Use'.
*ls_target-SHIP_TO = 'Ship-to'.
*ls_target-PRODUCT = 'Product'.
*ls_target-PRODUCT_CODE = 'Product Code'.
*ls_target-SALES_REP = 'Sales Rep'.
*ls_target-REVENUE_USD = 'Revenue (k USD)'.
* APPEND ls_target TO et_target.
LOOP AT it_source INTO ls_source.
MOVE-CORRESPONDING ls_source TO ls_target.
CONDENSE ls_target-REVENUE_USD.
APPEND ls_target TO et_target.
ENDLOOP.
Process chain :
PC_PL_APD0001
Frequently : Every Monday (weekly method) at 10:00 (before Every Saturday (weekly method) at 10:00, change done 6th September 2021)
Flat file generated : product_sales_records_.csv
Using logical file name : Z_BW_SMARTFLOAT_EXTRACT
Path on BW server : /exploit/BW/Smartfloat/<FILENAME>
Logical path : Z_BW_SMARTFLOAT
+ Webmethods to move from BW server to Google cloud plateform (need to check webmethod team for this part)