General presentation
Objective of the application
BW application used to populate data from Order Book to SalesForce, using MFT process as middleware between the systems.
Tool and IT leaders of the application are:
- BW OtC : Felipe Rodrigues (Pending orders & Account on BW)
- Salesforce : Emmanuel Gaheri / Dina Mendes
- WebMethods : Reiner Hellstern / Nikhil Bhosle
- Developer: Felipe Rodrigues
Usage information
This project have only Salesforce users.
History
The project removed the SAP function module dependency, getting data directly from order book to be invoiced report.
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
Dataflow overview
The old process used to get data from PF1 tables by function module, the current process gets data from BW ADSO based on records used in the report Order book: To be invoiced Full (BW_QRY_MVSDSO41_SD011).
The table ABSDSO03S uses data from two queries, according to the date, the first 10 days of the month, the base is query BW_QRY_MVSDSO41_0013, current and previous month data from SpP in the currency of the order, from day 11 query BW_QRY_MVSDSO41_0013 using only the current month, both are a copy of the report BW_QRY_MVSDSO41_SD011.
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Source of the process: queries BW_QRY_MVSDSO41_0012 and BW_QRY_MVSDSO41_0013 work only with GBU SP and no as intercompany data flag.
The key figures are the same used BW_QRY_MVSDSO41_SD011, the main difference as mentioned above, the second one gets data based on M-1 for the first ten days of the month.
The propagation layer ADSO APSDSO03S receives data from these queries, aggregating the key figures according to the key below.
On this point, the key figures are checked to identify and threat, the currency without decimal places, like JPY and CLP by the BAPI: BAPI_CURRENCY_CONV_TO_INTERNAL
And the conversion to VKG by Z_MD_CONVERT_MATERIAL_UNIT2,
The dataflow upwards to the business layer, ABSDSO03S, is divided by an infosource, where in the transformation before that, we concentrate all look-up processes to select data from other tables in complement to the data requested by iCARe, using AMDP code, and the data after infosource is used to currency conversion by ABAP code.
AMDP Code
Rule1) Check the last requested date corresponding to last schedule line
Rule2) Check if there is any corresponding precedent document for each order line, this process is used to assign the billing status in case of the order line is not completely assigned by the vbuk/vbup.
Rule3) It's assign values into fields for all tables mentioned in the list below.
ABAP Code
Rule1) Case the order is not in EUR, the process convert to EUR according to the billing status.
1.1) Fully invoiced (STS_BILL = 'C')
Last day of month, based on CAR3 rate.
1.2) Pending orders
CAR4, based on begin of the month.
The last BW object used is the HANA Analysis Process, which is responsible to get the codes from ABSDSO03S, convert them into texts according to their respectives master data in the procedure, and store the results to be used by webMethods interface (Z_ZSF_GET_PENDING_ORDERS) into ZSF_OPEN_ORDS2 table.
i.e.:
Dependencies with other applications
Salesforce : is the CRM which receives data from SAP (PF1 → WBP → SF)
Monitoring :
- Check if SFDC job is complete with success : Setup → Jobs → Apex Jobs → Apply View: [Select a View]
- For more detailed info, please refer to Document : IS - Appl - CRM - Monitor Interfaces
- In case of failure : please contact : fas-salesforce@solvay.com
WebMethods : is the middleware which triggers the step from SAP and SF.
- Technical document of WM process is here
- In case of failure : create a freshdesk ticket and assign it to IS-CAPG-ERP group
Data loadings
Info providers and objects loaded
PC_SDSO_03
Loading frequency
Full load daily, except weekends and holidays (BE calendar).
Average performance
The process is linked to the PC_OBAS_REPORTING, starting around 5:30 AM and it takes around 5 minutes to be complete daily.
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 5 min |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | 19.000 records |
| ~ Average Runtime for 10k lines | 2 min |
Record Keeping
Full load keeping only the last two months in the first ten days of the month and the current month in the other days.
Reporting
Queries End User Documentation
N/a
Maintenance
Known bugs
The SalesForce interface requires corresponding Salesforce ID for the fields customer (table ZSF_ACCOUNTS) and material group (ZSF_PRODUCTS), the SalesForce should be contacted in these cases.
The same in case of creation of the new pick list.