| Table of Contents |
|---|
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.
...
- 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 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 :
...
- 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.
...