1.0 Overview




The BW PP Production Planning application regroups all the reports that are based on the inventory data and MRP elements in SAP and more particularly :

  • The inventory movements (MM documents)
  • The future elements (MRP)
  • The capacities analysis

Reports are usually used by production and supply chain.

Describe the key User profiles that exist for the application. 

General role/Viewer role:

Approver role:

Target Users:

As examples: Controllers / Accountants

Access to the application in the WBP Server is provided by Company Code. You can have access to one, several or all company codes. 

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

dd.mm.yyyy

<Insert name>

Initial draft










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



MRP:

The main function of the Material Requirement Planning (MRP) is to guarantee the availability of the finished product, this means calculating the components needed (semi-finished / packaging / raw material) to make a product. It consists of several steps : taking inventory of the materials and components on hand, identifying which additional ones are needed and then scheduling their production or procurement.

The Material Requirement Planning tries to conciliate as much as possible the 3 following objectives 

  • Optimize the Service Level rate by delivering On Time In Full (OTIF) 
  • Optimize inventory 
  • Improve day-to-day operational efficiency 

Site Planner Role:

The Site planner is a local leader for the planning activities, an efficient scheduling process can ensure quick respond to changes in demand, supply while taking into consideration of available resources. A skilled site planner plays a key role in optimizing performance at the site


Planner Workflow



3.0 Application Feature Overview


Information about the existent Workbooks and the respective BW queries.


ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name

















Reporting

Query

Description

BW_QRY_APD_MPR_IC001_0037BW - EHS - Movement Production to APD for SVT RO (Core Query
BW_QRY_APD_MPR_IC001_0037_JBABW - EHS - Movement Production Check
BW_QRY_CUB_IC002_6001BW - Inventory Movements Report
BW_QRY_CUB_IC002_VS_0001BW - Production by Materials As is - Detail Analysis (Core)
BW_QRY_CUB_PP02_0001BW - MRP Elements in the past (Core Query)
BW_QRY_CUB_PP02_0002BW - Production Planning (8 weeks) (Core Query)
BW_QRY_CUB_PP02_QVRCSKPI_0002BW - Production Planning (8 weeks) (QV)
BW_QRY_MPR_IC001_0001BW - Inventory Aging Report (Core Query)
BW_QRY_MPR_IC001_0001_BINBW - Inventory Aging Report Storage bin
BW_QRY_MPR_IC001_0001_POLANDBW - Inventory Aging Report (JMALBORSKA)
BW_QRY_MPR_IC001_0002BW - Projected Stocks 60 days (Core Query)
BW_QRY_MPR_IC001_0003BW - Assistance cleaning of the material (Core Query)
BW_QRY_MPR_IC001_0006BW - DYNASYS - Stock evolution (APD Export Query)
BW_QRY_MPR_IC001_0013BW - Stock Movement Production (Core query)
BW_QRY_MPR_IC001_0013_EHSBW - Stock Movement Production (EHS query)
BW_QRY_MPR_IC001_0013_JHILAIREBW_QRY_MPR_IC001_0013_JHILAIRE
BW_QRY_MPR_IC001_0013_JHILAIREBW - Stock Movement Production-JHILAIRE(Core query)
BW_QRY_MPR_IC001_0013BBW - Stock Movement Production - Comm Choice (Core)
BW_QRY_MPR_IC001_0014BW - Stock Movement All Types (Core query)
BW_QRY_MPR_IC001_0014_EHSBW - Stock Movement All Types (EHS query)
BW_QRY_MPR_IC001_0016BW - Stock Movement Production Neutralized by zone (Core que
BW_QRY_MPR_IC001_0017BW - Stock and Planning report (Core query)
BW_QRY_MPR_IC001_0017BBW - Stock and Planning Month Snapshot (Core query)
BW_QRY_MPR_IC001_0017B_GR01BW - Stock and Planning Month Snapshot (Core query) - GR
BW_QRY_MPR_IC001_0018BW - Stock and Planning Month Snapshot (Core query) - GR
BW_QRY_MPR_IC001_0020BW - Stocks by Profit Center (Core Query)
BW_QRY_MPR_IC001_0026BW - Movements value/qty evolution (Core Query)
BW_QRY_MPR_IC001_0026_EPBW - Stocks Evolution EP (Specific)
BW_QRY_MPR_IC001_0026_EP2BW - Stocks Evolution EP (Specific 2)
BW_QRY_MPR_IC001_0026_GSVBW_QRY_MPR_IC001_0026_GSV
BW_QRY_MPR_IC001_0027BW - Average Turn - 3 month (Core Query)
BW_QRY_MPR_IC001_0028BW - Turn Evolution - 3 month (Core Query)
BW_QRY_MPR_IC001_0029BW - Turn - 91 days (Core Query)
BW_QRY_MPR_IC001_0031BW - Stock evolution (Core Query)
BW_QRY_MPR_IC001_0031_BCASTBW - Stock evolution (BROADCAST)
BW_QRY_MPR_IC001_0031_BCAST02BW - Stock evolution M-1 (BCAST02)
BW_QRY_MPR_IC001_0031_BCAST03BW - Stock evolution 12 last months (BCAST03)
BW_QRY_MPR_IC001_0031_BCAST04BW - Stock evolution current month (BCAST04)
BW_QRY_MPR_IC001_0031_BCASTMBW - Stock evolution M M-1 (BROADCAST)
BW_QRY_MPR_IC001_0031FRANCOBW - Stock evolution
BW_QRY_MPR_IC001_0033BW - Actual stock VS Safety stock Comparaison (Core Query)
BW_QRY_MPR_IC001_0034BW - Inventory level for AROMA dashboard - SCREEN (QV Query)
BW_QRY_MPR_IC001_0035BW - Movement Prodution to APD (Core Query)
BW_QRY_MPR_IC001_0036BW - Movement Production to APD for REACH (Core Query)
BW_QRY_MPR_IC001_0051BW - Stock Values and Quantities (Core Query)
BW_QRY_MPR_IC001_0059BW - Homogation Stock (Dynasys Extract)
BW_QRY_MPR_IC001_0060BW - Consignment Stock (Dynasys Extract)
BW_QRY_MPR_IC001_0061BW - Blocked Stock (Dynasys Extract)
BW_QRY_MPR_IC001_0062BW - Stock evolution with conversion (Core Query)
BW_QRY_MPR_IC001_0062_BCASTBW - Stock evolution with conversion (BROADCAST)
BW_QRY_MPR_IC001_0062_BHBW - Stock evolution with conversion light (spec BH)
BW_QRY_MPR_IC001_0062_BH2BW - Stock evolution with conversion light (spec BH BATCH)
BW_QRY_MPR_IC001_0062_BH3BW - Stock evolution with conversion light (spec BH INVENTOR
BW_QRY_MPR_IC001_0062_NABW - Stock evolution with conversion (NA)
BW_QRY_MPR_IC001_0062_NABW - Stock evolution with conversion (NA) (Core query)
BW_QRY_MPR_IC001_0062_NA2BW - Stock evolution with conversion (NA) (Core query)
BW_QRY_MPR_IC001_0063BW - Stock Mmvt with conversion (Core query)
BW_QRY_MPR_IC001_0065BW - Value stream production (Core query)
BW_QRY_MPR_IC001_0066BW - Stock Mmvt in base/prompt/active unit (Core Query)
BW_QRY_MPR_IC001_0067BW - Turn Evolution - 1 year (Core Query)
BW_QRY_MPR_IC001_0068BW - Stock and Planning report by week (Core query)
BW_QRY_MPR_IC001_0072BW - Vendor Consignment Stock (Dynasys Extract)
BW_QRY_MPR_IC001_0073BW - Restricted Use Stock (Dynasys Extract)
BW_QRY_MPR_IC001_0074BW - Inventory End of Month RCS (Dynasys Extract)
BW_QRY_MPR_IC001_0128BW - Physical inventory coverage rate - MPR_IC001
BW_QRY_MPR_IC001_063BW - EHS - Neutralized  Production Other data for EHS
BW_QRY_MPR_IC001_064BW - EHS - Neutralized  Production Japan data for EHS
BW_QRY_MPR_IC001_065BW - EHS - Neutralized  Production Australia data for EHS
BW_QRY_MPR_IC001_066BW - EHS - Neutralized  Production data for EHS (Hana Flow)
BW_QRY_MPR_IC001_6068Rhodia UK Stock Report (Core Query)
BW_QRY_MPR_IC001_75BW - Customer Inventory End of Month RCS (Dynasys Extract)
BW_QRY_MPR_IC001_76BW - Unrestricted Stock RCS in the future (Dynasys Extract)
BW_QRY_MPR_IC001_9000BW - Inventory Value (Core query)
BW_QRY_MPR_IC001_9003BW - Spare Parts Movements AVG (LA Specific)
BW_QRY_MPR_IC001_9003_KWCBW - Spare Parts Movements AVG (LA Sp kwc)
BW_QRY_MPR_IC001_9004BW - Spare Parts Free Stocks (LA Specific)
BW_QRY_MPR_IC001_9005BW - Spare Parts Unit Price (LA Specific)
BW_QRY_MPR_IC001_9099BW - Inventory Value (BROADCAST)
BW_QRY_MPR_IC001_BCAST_001BW_QRY_MPR_IC001_BCAST_001
BW_QRY_MPR_IC001_SYNTH_0273Prod Ventes Stocks - Valence (core query)
BW_QRY_MPR_IC001_VS_0001BW - Production by Materials As is - Detail Analysis (Core)
QV_BW_QRY_MPR_IC001_0013QV-BW- Stock Movement Production (QV)
QVEPSC_BW_QRY_MPR_IC001_0062BW - Stock Evolution with Conversion (QV-EP-SC)
QVNVSC_BW_QRY_MPR_IC001_0001BW - Inventory Aging Report (QVNVSC Core Query)
QVNVSC_BW_QRY_MPR_IC001_0001BBW - Inventory Aging Report (QVNVSC Core Query)
QVNVSC_BW_QRY_MPR_IC001_0002BW - Inventory Aging Report (QVNVSC Core Query)
QVNVSC_BW_QRY_MPR_IC001_0002BW - Inventory Aging Report (QV Query)
QVNVSC_BW_QRY_MPR_IC001_0002DZLDZ - Inventory Aging Report (QVNVSC Core Query)
QVNVSC_BW_QRY_MPR_IC001_0003BW - Inventory Aging Report (QVNVSC Core Query)
QVNVSC_BW_QRY_MPR_IC001_0016BW - Stock Movement Production Neutralized by zone (Core que
QVNVSC_BW_QRY_MPR_IC001_0026BW - Movements value/qty evolution (QV Query)
QVNVSC_BW_QRY_MPR_IC001_0063BW - Stock Mmvt with conversion (QV)
QVNVSC_BW_QRY_MPR_IC001_0065BW - Value stream production (QV query)
QVNVSC_BW_QRY_MPR_IC001_0071BW - Stock evolution with conversion (Core Query) for Qlikvi
QVSBS_BW_QRY_MPR_IC001_0001BW - Stock Movement All Types (Core query) Qlik
QVSBS_BW_QRY_MPR_IC001_0002BW - Stock Movement All Types (Core query) Qlik
QVSBS_BW_QRY_MPR_IC001_0003QV - Stock Movement All Types (Core query) Qlik
QVSBS_BW_QRY_MPR_IC001_0004QV - Stock Movement All Types (Core query) Qlik
QVSBS_BW_QRY_MPR_IC001_0014BW - Stock Movement All Types (Core query) Qlick
QVSBS_BW_QRY_MPR_IC001_0051BW - Stock Values and Quantities (Core Query)

4.0 Functional Specification


4.1 General Data/Calculations 

This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.

Could be specific fields, closing activities, additional information to work and understand the reports.


4.2 Process Detail 

4.2.1.  Report/Process Definition 

Domain<insert name>
Application>insert name>
Provider<insert name>
Existing Documentation

<insert link>


This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.



ATEGORYBW CORE QUERY NAMEBW TECHNICAL NAME
Production


BW - MRP Elements in the past (Core Query)BW_QRY_CUB_PP02_0001
BW - Projected Stocks 60 days (Core Query)BW_QRY_MPR_IC001_0002
BW - Stock Movement Production (core query)BW_QRY_MPR_IC001_0013
BW - Value stream production (core query)BW_QRY_MPR_IC001_0065
Planning





BW - Capacity planning - Monthly (Core Query)BW_QRY_CUB_CAPM_0001
BW - Capacity planning - Weekly (Core Query)BW_QRY_CUB_CAP_0001
BW - Material - Production Program Follow Up (Core Query)BW_QRY_CUB_STSA_0003
BW - Material - Scheduling Adherence (Core Query)BW_QRY_CUB_STSA_0001
BW - Production Planning (8 weeks) (Core Query)BW_QRY_CUB_PP02_0002
BW - Stock and Planning Month Snapshot (Core query)BW_QRY_MPR_IC001_0017B
BW - Stock and Planning report by week (Core query)BW_QRY_MPR_IC001_0068


5.0 Non-functional Descriptions 


Please populate the relevant section and delete those that are not applicable.

5.1 Usability

Usability is about the ease with which a User can learn to start using the solution and the ease with which they can use the system.  In addition to ease of learning and ease of use, usability also includes areas such as ease of recall, error avoidance and handling, accessibility among others e.g., 99% of metadata entry Users who have use the Maintenance Dashboard should be able to change filters, extract etc., when required.  Maintenance data will be centrally stored in the Google Cloud platform, which will be available to other applications e.g., and Dashboards if needed.

5.2 Regulatory Compliance

Software systems must comply with legal and regulatory e.g., GDPR requirements, this can change depending on country, organisation industry and / or region.  The software systems must be secure from unauthorized access.  The Maintenance Dashboard will comply with Solvay’s regulations and compliance e.g., access only granted to authorized Users.

5.3 Security

Security refers to essential aspects that assure a solution and its components will be protected against unauthorized access or malware attacks.  Important considerations related to security aspects of a system are User authentication, User authorization or User access privileges, data theft, malware attacks, data encryption, and maintaining audit trails, e.g., only Users with administrator access shall be able to create new accounts and assign data access privileges to the new accounts e.g.,

  • All data will be encrypted in the dashboard
  • Only authorised Users / Administrative Users will be able to access data.
  • Maintenance data will be split between either SCO or ECO, and Users will only have authority to one Entity data.

5.4 Performance

Performance defines how fast a software system or a particular section of it responds to certain User actions under a certain workload.  In most cases, this metric explains how long a User must wait before the target operation happens e.g., the page renders, a transaction is processed, etc., given the overall number of Users now.  Performance requirements may describe background processes invisible to Users, e.g., backup and speed of data transfers. 

5.5 Reliability

Reliability is the ability of a solution or its component to perform its required functions without failure under predefined conditions for a specified time / period.  Reliability can possibly be specified in terms of average time system runs before failure occurs, percentage of operations completed successfully within a time / period, maximum acceptable failure probability, or number of failures within a period.  Reliability aspects are in reference to (but not limited to) evaluation of the system to be considered as reliable, classification of reliability defining failures vs. regular failures, and the impact of failure on business operations.  The Maintenance Dashboard will display data from the previous refresh of data.   

5.6 Scalability

Scalability refers to the degree to which a solution can evolve to handle increased amounts of work.  The increased amount of work could be in terms of the user base, transactions, data, network traffic, or other factors e.g., the system should be able to handle an additional load of a maximum of 5,000 Users every month for the next 6 months without any noticeable performance impacts.  

5.7 Compatibility

Interoperability is the degree to which the solution is compatible with other components.  It is a measure of how effectively the system interoperates with other software systems and how easily it integrates with external hardware devices.

Interoperability aspects to be discussed during elicitation are in reference to (but not limited to) software systems to be interfaced with along with data / messages to be exchanged and any standard data formats, hardware components to be integrated with, and any standard communication protocols to be followed e.g., Order Management system will push the order file into a secured file transfer protocol server from where it will be loaded into the system through a daily job.  To guarantee between Google Cloud platform and SAP BW Queries e.g., BW_QRY_MVPMOR01_0002, Solvay has introduced a new tool called Xtract (Xtract).

5.8 Availability

Availability is the degree to which the solution is operable and accessible when required. It is a measure of time during which the system is fully operational e.g., available for use and sometimes included as a Service Level Agreement (SLA) considering its criticality to the business, e.g., the system shall be at least 99% available on weekdays between 09:00 to 18:30 Central European Time (CET).

5.9 Refresh of the Data

Frequency, data, and time of the data refresh in the data product.