The ITC application regroups all the reports that will permit to the credit managers to follow there customer portfolio. The different reports will present data about :
- The transactional data :
- The aged balance with the situation of the open items and overdues
- The DSO calculation
- The master data :
- The categorization of the customers for the risk management
- The credit limits
There are two main parts : the ITC reports with the global view of the customer situation, and the FSCM reports to assure the follow up of the customers (dispute and promise to pay).
For this Application the access is provided based on the BW menu "ITC - Credit Management" and it's done via Service one.
Fill the form
https://solvay-dwp.onbmc.com/dwp/app/#/itemprofile/622
In SAP system select the "WBP - BW Business Warehouse"
In WBP - BW Business Warehouse : Select the Business Role select the "ITC - Credit Management".
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 17.10.2023 | Inês Vilares | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
Capture the business process that the application supports . This can be describe through a process diagram or a business capability model
3.0 Application Feature Overview
For this application find below all the workbooks available: we need to double check if all the workbooks are in scope (Ellon and Pierre)
Folder: ITC Credit Management
1.Credit Mgt Reporting
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| Credit Mgt - Aged Balanced (Core Workbook) | BW_WBK_ITC_0016 | |||
| Credit Mgt - Anticipated payments (Core Workbook) | BW_WBK_ITC_0012 | |||
| Credit Mgt - Blocked Orders | Mandatory:
Optional:
| BW_WBK_ITC_0001 | BW_QRY_MVFIAR03_0001 BW_QRY_MVFIAR03_0002 | |
| Credit Mgt - Credit Exposure & Payment Perf. (Core Wokrbook) | BW_WBK_ITC_0004 | |||
| Credit Mgt - Credit exposure (core Workbook) | BW_WBK_ITC_0018 | |||
| Credit Mgt - Credit Management Workbook (Core Workbook) | BW_WBK_ITC_0008 | |||
| Credit Mgt - Customer Payment Terms (Core Workbook) | BW_WBK_ITC_0006 | |||
| Credit Mgt - Customer Portfolio Scan (Core Workbook) | BW_WBK_ITC_0002 | |||
| Credit Mgt - Customer review date & activation | BW_WBK_ITC_0005 | |||
| Credit Mgt - Detailed aged balance (Core Workbook) | BW_WBK_ITC_0023 | |||
| Credit Mgt - Detailed Open/Cleared items (Core Workbook) | BW_WBK_ITC_0021 | |||
| Credit Mgt - Doubtful cust. (Core Workbook) | BW_WBK_ITC_0013 | |||
| Credit Mgt - DSO (Core Workbook) | BW_WBK_ITC_0011 | |||
| Credit Mgt - Global Credit Exposure (Core Workbook) | BW_WBK_ITC_0003 | |||
| Credit Mgt - Internal control (Core Workbook) | BW_WBK_ITC_0010 | |||
| Credit Mgt - Payment perf. (Core workbook) | BW_WBK_ITC_0019 | |||
| Credit Mgt - Process Expert Workbook) | BW_WBK_ITC_0007 | |||
| Credit Mgt - Risk Distribuiton (Core Workbook) | BW_WBK_ITC_0017 | |||
| Credit Mgt - Weighted Paymt terms & delays (Core Workbook) | BW_WBK_ITC_0028 | |||
| Credit Mgt - WP1 Credit Exposure (Core Workbook) | BW_WBK_ITC_0027 | |||
| Credit Mgt - WP1 Weighted Aver. Days Paid (Core Workbook) | BW_WBK_ITC_0026 |
2.FSCM - Cash Collection Reporting (Dispute & Promise to Pay)
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| BW - PCM - by GBU (Core Workbook) | Mandatory:
Optional:
| BW_WBK_PCM_0001 | ||
| BW - WISE - Cash Collection Piloting Report (Core Workbook) | BW_WBK_FSCM_0001 | |||
| BW - WISE - Cash Collection Statistics Report (Core Workbook) | BW_WBK_FSCM_0005 | |||
| BW - WISE - Dispute Follow up wth CLM Org. Info (Core wbk) | BW_WBK_FSCM_0003 | |||
| BW - WISE - Dunning Level Report (Core workbook) | BW_WBK_FSCM_0004 | |||
| BW - WISE - Scenario Collection Piloting Report (Core wbk) | BW_WBK_FSCM_0002 |
3.Credit Mgt Without Consolidation Rules
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| Credit Mgt - Aged Balance in acct. view (Core Workbook) | This report reflects the total balance per customer and the total of overdues for the calendar day selected. It's also possible to see the amounts for the different ranges in overdue:
Default values:
| Mandatory:
Optional:
| BW_WBK_ITC_7006 | BW_QRY_MVFIAR01_7006 |
| Credit Mgt - Doubtful cust. in acct. view (Core WorkBook) | In this report we can see the total balance and the doubtfull amounts per customer. It's also possible to add more measures to compare with previous months. Default values:
what is the difference from these 2 measures "Write down for doubtful 31.05.2023" and "Doubtful - Write down 31.05.2023"? | Mandatory:
Optional:
| BW_WBK_ITC_7003 | BW_QRY_MVFIAR01_7003 |
| Credit Mgt - DSO in acct. view (Core WorkBook) | This report shows the DSO amounts for the month selected and previous months to perform a comparison between them per customer. Default values:
| Mandatory:
Optional:
| BW_WBK_ITC_7001 | BW_QRY_MVFIAR01_7001 |
| Credit Mgt - Overdue in acct. view (Core Workbook) | This report has the outstanding values, the total of overdues and the % of overdues for the selected calendar day and the previous months per customer. Default values:
| Mandatory:
Optional:
| BW_WBK_ITC_7002 | BW_QRY_MVFIAR01_7002 |
| Credit Mgt - Risk Distribution in acct' view (Core Workbook) | This report shows for each rating the total amounts for the Outstanding, Total Overdues, % of Overdues and how many PRS cusomers are. The values can be analyzed for the month selected or previous months. Default values:
| Mandatory:
Optional:
| BW_WBK_ITC_7007 | BW_QRY_MVFIAR01_7007 |
| Credit Mgt - Workbook without Solvay Conso rules (Core Workbook) | This report has several sheets where we can see different analysis based in different queries. Sheets:
| Mandatory:
Optional:
| BW_WBK_ITC_7008 | BW_QRY_MVFIAR01_7001 BW_QRY_MVFIAR01_7006 Check if it's only these queries Pierre |
Folder: ITC Credit Management - Non Solvay - Should we have this workbook in here? looks like it's duplicate since it's the same report as we have in the 3 folder for the Non Solvay reports.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| Credit Mgt - Workbook without Solvay Conso Rules (Core Workbook) | BW_WBK_ITC_7008 |
Folder: ITC Credit Management AR Payments - Can we delete this folder? Pierre
4.0 Functional Specification
4.1 General Data/Calculations
For these reports, it’s important to understand some concepts which will allow the user to work with the reports in the same way as the SAP system and/or BFC tool.
| Outstanding | Sum of documents in the customer account (excluded doubtful and advance payment) |
|---|---|
| Overdue | |
| Not yet due | |
| Doubtfull | |
| Write down | |
| DSO | DSO stands for "Days of Sales Outstanding":
|
| Best DSO | Idem DSO but with not yet due instead of the outstanding |
| Late DSO | DSO – Best DSO |
| Turnover | Sales (vat included) with posting date in the calculated period |
| Credit exposure (ERPs) | Outstanding + Commercial value = Open sales orders (S966) + Open delivery credit value (S967) + Open billing document credit value (S967) S9* tables are copies from S066 and S067 tables with the useful split to provide the GBU Dedicated extractor ZZFCM_EXPOSURE_BY_GBU |
| Statistical credit limits (PI1) | Not a real credit limit, just to split the limit by GBU Extracted from PI1 using the extractor ZZFCM_LIMIT_BY_GBU |
| Dunning |
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Finance |
|---|---|
| Application | BW reports under ITC - Credit Management and ITC - Credit Management - Non Solvay |
| Provider | MVFIAR01, MVFIAR02 and MVFIAR07 |
Same data DSO/cubes for the working Capital.
Should we move the subfolders for ITC from the wiki page in here?
Workbook Structure
1.Credit Mgt Reporting | Reports available by default in a Consolidation view perspective we cannot change this. |
|---|---|
| 2.FSCM - Cash Collection Reporting (Dispute & Promise to Pay) | Reports specific for the scope for Dispute and Collections |
| 3.Credit Mgt Without Consolidation Rules | Reports as Accounting view logic (non consolidation). Whenever we have companies where they left Solvay they have an agreement where they can still use some reports in BW and with these reports were created specific for the users outside of Solvay can access to information. |
| ITC Credit Management - Non Solvay | Just one report but the logic in the same for the folder 3. |
| ITC - Credit Management AR Payments | Not used anymore and we don't have any report available. |
Standardization of the master data
Company codes and customers
- For company code
- Table ZZR_T001_MAP
- Extractor 0COMP_CODE_ATTR
- For partners
- Table KNA1 with new fields
- Extractor 0CUSTOMER_ATTR
- Central table for consolidation methods and rates
- Table ZZF_T001_MGT
Example with a common customer: Transaction XD03 (check on Extra Master data)
GL/Account types and subtypes
- Classification of the GL/Accounts
- Types
- Receivables
- Payables
- Inventories
- Subtypes for Receivables
- 001 : Product and Services
- 002 : Advance payments
- 003 : Doubtful
- 004 : Write down
- 005 : Accruals & Revaluation
- Types
- Extractor ZZF_BW_GL_ACCOUNTS_SUBTYPES
- Table shared with BFC to get the headings of the GL/Accounts :
- ZZF_BFC_SETACCT
- Filter on familly « WC » and « CX »
- ZZF_BFC_SETACCT
- Then we retrieve the types and subtypes from sets (GS03)
- Remark : A set may contain other sets (recursive)
Table ZZF_BFC_SETACCT
In the set :
In the header of the set :
- REC = Receivables
- 005 = Accruals and Revaluation
These data are managed by BFC team.
Contact name in the Master data team : Eliane Rubat - Confirm with Pierre
Assignment of the GBU
- Standardization of the structure of the group
- Before the IECRA for WP1
- AR from SD
- From material sales division + distribution channel => IECRA
- AR from FI
- Profit center from counterpart => IECRA
- Exceptions
- Business area : table ZZR_REPO_DIV_EXC
- Other : table ZWFAT205 at the item level
Credit Management
Colletion
5.0 Non-functional Descriptions
5.1 Usability
5.2 Regulatory Compliance
5.3 Security
5.4 Performance
5.5 Reliability
5.6 Scalability
5.7 Compatibility
5.8 Availability
5.9 Refresh of the Data
The loads for the ITC application are: Double check with Pierre
WP1: 7 times a day during closing, 3 times a day the rest of the month.
Others: 3 times a day.
CM master data: once a day.