This application is part of the Finance domain and its based on SAP CO Order postings, including Actual postings and Commitments from 2015 and describe the Environmental & Rehabilitation (ER) expenses. |
For these queries the access is provided based on the BW menu and it's done via Service one. |
Target Users: Solvay resources (~140 users) |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 15.09.2023 | Inês Vilares | Initial draft |
|
Capture the business process that the application supports . This can be describe through a process diagram or a business capability model
Information about the existent Workbooks and the respective BW queries.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
BW - Environ. & Rehab. database (Core Workbook) | This report contains all the information regarding this scope as a database where the users can check for the specific order types for the following measures/values:
| Mandatory:
Optional:
| BW_WBK_ER_0002 | BW_QRY_MVCOOP01_0002 |
| BW - Environ. & Rehabilition expenses analysis (Core Workbook) | This workbook contains the same information as the "BW - Environ. & Rehab. database (Core Workbook)" but splitted by sheets:
| Mandatory:
Optional:
| BW_WBK_ER_0001 | BW_QRY_MVCOOP01_0001 |
| Consolidation View | The query takes the integration rate of the company and the partner from a table managed by GAR.
In this way, the user has 4 options:
|
|---|---|
| GBU Assignment | The concept for GBU doesn't exist in SAP but it’s a requirement to have in BW since in BFC we have this definition. This GBU assignment is different for WP1 and PF1 and it will be explain in detail in the Process Definition section. |
| PRS Concept | The PRS is one dedicated SAP environment (based on PF1) whose aim is to unify some structural information as Master Data information for customers, vendors, company codes, etc. For this, depending on each master data we are referring to, we have specific tables created to maintain the data and have the configuration from source systems to BFC definition and alignment. |
| BFC site | Order attribute entered as External number in SAP Ex.: LIVOU, HALIF, LILLE… NB: relevant for authorizations |
| Orders | Posted object in SAP CO document Ex.: 900100 CUBAT-BIOSOL PROJECT (WP1), 5900160 THOROF-GROUNDWATER (PF1)… NB: codification is quite different between WP1 and PF1 areas |
| Order Type | Are used to categorize various cost objects and represent specific business processes within the Controlling module. These order types are used for cost tracking, budgeting, and monitoring purposes. For this scope the order attribute entered in SAP to distinguish Recurring (Y998) and Non Recurring (Y999) Environmental Cash-out orders. |
| Object class | Order attribute entered in SAP to distinguish CAPEX (invest.) from OPEX Ex.: OC |
| Cost element | Posted P&L account in SAP CO document Ex.: 98300207 MAINTENANCE (WP1), 6122040000 Waste treatment (PF1) NB: codification is quite different between WP1 and PF1 areas |
| 1/2/3 - CE grouping | Hierarchy based on Cost elements and Object class combinations: 1 - CE grouping: ER (Environmental & Rehabilitation) 2 - CE grouping: Z-ENVEXP (expenses) and Z-ENVREV (revenues) 3 - CE grouping: Z-DISMT, Z-ENVLEG, Z-REMEDO… |
| Period | Derived from Posting date (Actual) or Scheduled delivery date (Commitments) in SAP CO document Ex.: 1, 2… |
| PO number/item | Number of PO document and item in SAP, including text of item Ex.: 4502341051/20 Zone I site investig, 4201086557/20 PINCEL RETROPROJ PT… |
| Profit Center | Order attribute entered in SAP (to determine GBU in WP1 area) Ex.: 8090-I0534 0087 Silica (WP1), CBLT 5835 - Bollate com (PF1)… NB: codification is quite different between WP1 and PF1 areas |
| Resp. cost center | Order attribute entered in SAP Ex.: 6068-4886 Environmental Provis (WP1), XF14700000 REGULATORY ENVIR.SAF (PF1)… NB: codification is quite different between WP1 and PF1 areas |
| Vendor | Vendor entered in SAP PO header Ex.: 55171 ETABLISSEMENTS KAISER (WP1), 2110192 THE BRIGGS COMPANY (PF1)… NB: codification is quite different between WP1 and PF1 areas |
| Domain | Finance |
|---|---|
| Application | BW reports under ER - Environmental & Rehabilition expenses analysis |
| Provider | MVCOOP01 |
For this scope to analyze the data it's only relevant the orders with type Y998 (Environmental cash-out (Recurring) and Y999 (Environmental cash-out (Non-Recurring). |
5.6 Scalability
5.7 Compatibility
5.8 Availability
5.9 Refresh of the Data
The data load is once per day in the early morning..