Describe in a few words the content of application + link with functional or technical specifications (google links) done with during the project or linked with PPMO
The iCare application was migrated from PQ1 to WBP in October 2017 by PQ1 decommissioning project and consist in developing a BW flow and Function Modules, regarding Accounts, Pending Orders and Overdues to be sent to Salesforce (SF).
Function Modules(FM) are used, through multiple type of operations, to synchronized Salesforce & BW.
WebMethods (WM) is used as a Middleware between both .
Tool and IT leaders of the application are:
This project have only Salesforce users.
This project consist on a migration of existing Function Modules and BW objects from PQ1 to WBP.
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
Authorization to access report is managed by Salesforce because the reports are in salesforce platform. For BW, it is only preparing data on tables and DSO in order to load to SF
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B8xksr4mF3-aZFNVY3V3TF9DVFE
As WebMethods is used as a Middleware, it triggers every steps of each application (BW, SF), and send data from a side to the other.
Other operations :
Monitoring :
The aim of the interface is to daily load the invoices in overdues from SAP into Salesforce CRM.
The scope is limited to the invoices and will present the purchase orders and the materials associated to the invoice for GBU Specialty Polymers.
The data will be automatically refreshed once a day (during the night) starts in SFDC at 02:00 CET.
Every day, all overdues data are deleted from SFDC and loaded from SAP into SFDC.
There are 5 steps :
Returncode of the function module meaning
| Return Code | Meaning |
|---|---|
| 00 | OK |
| 01 | Can't find information of FI document header (BKPF) |
| 02 | FI doc does not have type VBRK (BKPF) |
| 03 | Can't find information in billing document (VBRK) |
| 04 | Can't find information from the items of the billing doc (VBRP) |
| 06 | Can't find information from PO order (VBAK) |
Other Operations :
Operation J : Update by job (No variables)
Operation U : Update data from the ODS (No variables)
Operation H : Init the synchronization for a date (Variables : IE_ACKID)
Operation R : Delete table contents (No variables)
Monitoring : See 'Dependencies with other applications > Salesforce' Chapter.
missing monitor PC and table in WBP
This interface has been done to provide Sold and Pending information from SAP and link it with Salesforce Accounts.
The Scope is limited to Specialty Polymers Customers.
The data will be automatically refreshed once a day (during the night) - start in SAP at 11:00 pm CET (00:00 CEST) and starts in SFDC at 10:00 CET (11:00 CEST).
There are 3 steps (Operations) :
Operation S : WebMethods reads entries from table ZSF_OPEN_ORDS to check if the first line contains number of records. SF delete all entries and receives response and creates new entries, then sends the Ack to WBP, starting operation ‘A’.
Operation A : WBP receives ack from WM and Updates ACKID and LAST_SYNC fields of ZSF_OPEN_ORDS. SF updates entries.
Other Operations :
Monitoring :
In SAP PF1_020 :
In SAP WBP_400 :
Function Module Variables :
I_ORIGIN - Possible values are : 'P' (Perform actions) and 'S' (Simulation)
I_OPERATION : Different operations previously explained ('S', 'A', 'I', 'P' for Overdues)
Salesforce : is the CRM which receives data from SAP (PRS/PF1 → BWP → SF)
Monitoring :
WebMethods : is the middleware which triggers the step from SAP and SF.
There is only one process chain on this project. It's for the overdues : PC_SFDC_OVD_01. It loads data from DSOs DBFIAR02 & DBFIAR16 to the newly created DSO : DBFIAR22.
The process chain is running every day at 2AM.
if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 30 minutes |
| ~ Average nb of rows loaded per load | 7300 |
| ~ Total nb of rows loaded (if full) | 7300 |
| ~ Average Runtime for 10k lines |
Give details if any historisation is done, example: keep only data greater than beginning of Y-3
The reports are available only on Salesforce
List the most important and complex queries only with a link to the documentation
Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts
Indicate if there are broadcasts and give some details on the broadcast settings.
Give the list and explanation on the known, not-solved, bugs.
List recurring procedures
Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016
00 = OK
01 = Can't find information of FI document header (BKPF)
02 = FI doc does not have type VBRK (BKPF)
03 = Can't find information in billing document (VBRK)
04 = Can't find information from the items of the billing doc (VBRP)
05 No use any more
06 = Can't find information from PO order (VBAK)
- update X on field 'Must be sync' flag on ZSF_OVD_INVC when returncode = 00 and SF_ID <>""