Page tree


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

Compare with Current View Page History

« Previous Version 12 Next »

1.0 Overview




Business Context and Application Overview

The Stock Margin Elimination is more a process then a report, it's a step for the closing process each month all the companies have to eliminate the internal margin for the stock. This is using data from the P&L Integrated margins to have the calculations for this Stock Margin elimination (for WP1) mainly from the SAP CO (Controlling) module .

Application User Profile

For this Application the access is provided based on the BW menu "MS - Stock Margin Elimination (Model S)" 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 "MS - Stock Margin Elimination (Model S)"

Target Users:

As examples: Controllers / Accountants

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

24.10.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




3.0 Application Feature Overview


For this application find below all the workbooks available:


ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name
Stock Margin elimination report

Mandatory:

  • Calendar year/month;

Optional:

  • Auth Scope on Comp. Code;
  • BFC GBU;
  • PRS Company Code;
  • Mngt zone;
  • Company Code;
  • Plant;
  • Material;
  • Source System;
BW_WBK_MS_0001BW_QRY_CPCOMS01_0002

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.


Logistic Stock

→ The quantities that are effectively in stock at the plant level, we call it Logistic Stock.

Stock in Transit

→ The quantities that are being shipped to the plant . These items are not present in the factory but are its property, we call it STOCK IN TRANSIT





4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainFinance
ApplicationBW reports under MS - Model S
Provider




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