Page tree


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

1.0 Overview




Business Context and Application Overview

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.

Application User Profile

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









Application Type


Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Others <specify the name of the source> 

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


Information about the existent Workbooks and the respective BW queries.


ReportsDefinitionPromptsBW Workbook QueryQuery 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:

  • Actual values for all months of the year selected in Local and Target Currency;
  • YtD data until the period selected in Local and Target Currency;
  • Total amount for previous year in Local and Target Currency.. 

Mandatory:

  • Conso. View;
  • Fiscal year/Period;

Optional:

  • Auth. scope based on Comp. Code;
  • Target Curr. for conversion;
  • Order Type;
  • Company Code;
  • Cost Element;
  • Mngt country;
  • Mngt zone;
  • Order;
  • Source system;
  • 2 - CE grouping;
  • 3 - CE grouping.
BW_WBK_ER_0002BW_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:

  • Selected Quarter - show the values until the quarter based on the period selected for actuals and actual from CO area, YtD for the year selected and previous year and we also have the measure for commitments in Local and CO area currency;
  • Periodic - show the actual values in Local currency and the actuals from CO area, YtD for the year selected and previous year and we also have the measure for commitments in Local and CO area currency;
  • Quarterly - show the actual values by quarter in Local currency and the actuals from CO area by quarter until the end of the year selected, YtD for the year selected and previous year and we also have the measure for commitments in Local and CO area currency;

Mandatory:

  • Conso. View;
  • Fiscal year/Period;

Optional:

  • Auth. scope based on Comp. Code;
  • Target Curr. for conversion;
  • Order Type;
  • Company Code;
  • Cost Element;
  • Mngt country;
  • Mngt zone;
  • Object Class;
  • Order;
  • Source system;
  • Vendor;
  • 2 - CE grouping;
  • 3 - CE grouping.
BW_WBK_ER_0001BW_QRY_MVCOOP01_0001

4.0 Functional Specification


4.1 General Data/Calculations 

Consolidation View

The query takes the integration rate of the company and the partner from a table managed by GAR.

  • If Conso method = 50 (Equity) , 20 (Not Conso.) or 60 (Not Equity), Rate = 0%;
  • If Conso method = 10 (Fully Conso), Rate = 100%;
  • If Conso method = 30 (Prop), Rate = Integration percentage

In this way, the user has 4 options:

  • Option 0 - Legal view: No intercompany eliminations are taking into account;
  • Option 1 - Consolidated view (for Solvay group): Takes into account the intercompany eliminations (using company code master data);
  • Option 2 - same logic as option 1 but the data is the consolidated view for Eco Companies
  • Option 3 - same logic as option 1 but the data is the consolidated view for Sco Companies
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 siteOrder attribute entered as External number in SAP
Ex.: LIVOU, HALIF, LILLE…
NB: relevant for authorizations
OrdersPosted 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 classOrder attribute entered in SAP to distinguish CAPEX (invest.) from OPEX
Ex.: OC
Cost elementPosted 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 groupingHierarchy 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…
PeriodDerived from Posting date (Actual) or Scheduled delivery date (Commitments) in SAP CO document
Ex.: 1, 2…  
PO number/itemNumber of PO document and item in SAP, including text of item
Ex.: 4502341051/20 Zone I site investig, 4201086557/20 PINCEL RETROPROJ PT…
Profit CenterOrder 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 centerOrder 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 
VendorVendor 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 

4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainFinance
ApplicationBW reports under ER - Environmental & Rehabilition expenses analysis
ProviderMVCOOP01

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.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 data load is once per day in the early morning..