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:
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | dd.mm.yyyy | <Insert name> | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
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.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
Reporting
Query | Description |
|---|---|
| BW_QRY_APD_MPR_IC001_0037 | BW - EHS - Movement Production to APD for SVT RO (Core Query |
| BW_QRY_APD_MPR_IC001_0037_JBA | BW - EHS - Movement Production Check |
| BW_QRY_CUB_IC002_6001 | BW - Inventory Movements Report |
| BW_QRY_CUB_IC002_VS_0001 | BW - Production by Materials As is - Detail Analysis (Core) |
| BW_QRY_CUB_PP02_0001 | BW - MRP Elements in the past (Core Query) |
| BW_QRY_CUB_PP02_0002 | BW - Production Planning (8 weeks) (Core Query) |
| BW_QRY_CUB_PP02_QVRCSKPI_0002 | BW - Production Planning (8 weeks) (QV) |
| BW_QRY_MPR_IC001_0001 | BW - Inventory Aging Report (Core Query) |
| BW_QRY_MPR_IC001_0001_BIN | BW - Inventory Aging Report Storage bin |
| BW_QRY_MPR_IC001_0001_POLAND | BW - Inventory Aging Report (JMALBORSKA) |
| BW_QRY_MPR_IC001_0002 | BW - Projected Stocks 60 days (Core Query) |
| BW_QRY_MPR_IC001_0003 | BW - Assistance cleaning of the material (Core Query) |
| BW_QRY_MPR_IC001_0006 | BW - DYNASYS - Stock evolution (APD Export Query) |
| BW_QRY_MPR_IC001_0013 | BW - Stock Movement Production (Core query) |
| BW_QRY_MPR_IC001_0013_EHS | BW - Stock Movement Production (EHS query) |
| BW_QRY_MPR_IC001_0013_JHILAIRE | BW_QRY_MPR_IC001_0013_JHILAIRE |
| BW_QRY_MPR_IC001_0013_JHILAIRE | BW - Stock Movement Production-JHILAIRE(Core query) |
| BW_QRY_MPR_IC001_0013B | BW - Stock Movement Production - Comm Choice (Core) |
| BW_QRY_MPR_IC001_0014 | BW - Stock Movement All Types (Core query) |
| BW_QRY_MPR_IC001_0014_EHS | BW - Stock Movement All Types (EHS query) |
| BW_QRY_MPR_IC001_0016 | BW - Stock Movement Production Neutralized by zone (Core que |
| BW_QRY_MPR_IC001_0017 | BW - Stock and Planning report (Core query) |
| BW_QRY_MPR_IC001_0017B | BW - Stock and Planning Month Snapshot (Core query) |
| BW_QRY_MPR_IC001_0017B_GR01 | BW - Stock and Planning Month Snapshot (Core query) - GR |
| BW_QRY_MPR_IC001_0018 | BW - Stock and Planning Month Snapshot (Core query) - GR |
| BW_QRY_MPR_IC001_0020 | BW - Stocks by Profit Center (Core Query) |
| BW_QRY_MPR_IC001_0026 | BW - Movements value/qty evolution (Core Query) |
| BW_QRY_MPR_IC001_0026_EP | BW - Stocks Evolution EP (Specific) |
| BW_QRY_MPR_IC001_0026_EP2 | BW - Stocks Evolution EP (Specific 2) |
| BW_QRY_MPR_IC001_0026_GSV | BW_QRY_MPR_IC001_0026_GSV |
| BW_QRY_MPR_IC001_0027 | BW - Average Turn - 3 month (Core Query) |
| BW_QRY_MPR_IC001_0028 | BW - Turn Evolution - 3 month (Core Query) |
| BW_QRY_MPR_IC001_0029 | BW - Turn - 91 days (Core Query) |
| BW_QRY_MPR_IC001_0031 | BW - Stock evolution (Core Query) |
| BW_QRY_MPR_IC001_0031_BCAST | BW - Stock evolution (BROADCAST) |
| BW_QRY_MPR_IC001_0031_BCAST02 | BW - Stock evolution M-1 (BCAST02) |
| BW_QRY_MPR_IC001_0031_BCAST03 | BW - Stock evolution 12 last months (BCAST03) |
| BW_QRY_MPR_IC001_0031_BCAST04 | BW - Stock evolution current month (BCAST04) |
| BW_QRY_MPR_IC001_0031_BCASTM | BW - Stock evolution M M-1 (BROADCAST) |
| BW_QRY_MPR_IC001_0031FRANCO | BW - Stock evolution |
| BW_QRY_MPR_IC001_0033 | BW - Actual stock VS Safety stock Comparaison (Core Query) |
| BW_QRY_MPR_IC001_0034 | BW - Inventory level for AROMA dashboard - SCREEN (QV Query) |
| BW_QRY_MPR_IC001_0035 | BW - Movement Prodution to APD (Core Query) |
| BW_QRY_MPR_IC001_0036 | BW - Movement Production to APD for REACH (Core Query) |
| BW_QRY_MPR_IC001_0051 | BW - Stock Values and Quantities (Core Query) |
| BW_QRY_MPR_IC001_0059 | BW - Homogation Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0060 | BW - Consignment Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0061 | BW - Blocked Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0062 | BW - Stock evolution with conversion (Core Query) |
| BW_QRY_MPR_IC001_0062_BCAST | BW - Stock evolution with conversion (BROADCAST) |
| BW_QRY_MPR_IC001_0062_BH | BW - Stock evolution with conversion light (spec BH) |
| BW_QRY_MPR_IC001_0062_BH2 | BW - Stock evolution with conversion light (spec BH BATCH) |
| BW_QRY_MPR_IC001_0062_BH3 | BW - Stock evolution with conversion light (spec BH INVENTOR |
| BW_QRY_MPR_IC001_0062_NA | BW - Stock evolution with conversion (NA) |
| BW_QRY_MPR_IC001_0062_NA | BW - Stock evolution with conversion (NA) (Core query) |
| BW_QRY_MPR_IC001_0062_NA2 | BW - Stock evolution with conversion (NA) (Core query) |
| BW_QRY_MPR_IC001_0063 | BW - Stock Mmvt with conversion (Core query) |
| BW_QRY_MPR_IC001_0065 | BW - Value stream production (Core query) |
| BW_QRY_MPR_IC001_0066 | BW - Stock Mmvt in base/prompt/active unit (Core Query) |
| BW_QRY_MPR_IC001_0067 | BW - Turn Evolution - 1 year (Core Query) |
| BW_QRY_MPR_IC001_0068 | BW - Stock and Planning report by week (Core query) |
| BW_QRY_MPR_IC001_0072 | BW - Vendor Consignment Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0073 | BW - Restricted Use Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0074 | BW - Inventory End of Month RCS (Dynasys Extract) |
| BW_QRY_MPR_IC001_0128 | BW - Physical inventory coverage rate - MPR_IC001 |
| BW_QRY_MPR_IC001_063 | BW - EHS - Neutralized Production Other data for EHS |
| BW_QRY_MPR_IC001_064 | BW - EHS - Neutralized Production Japan data for EHS |
| BW_QRY_MPR_IC001_065 | BW - EHS - Neutralized Production Australia data for EHS |
| BW_QRY_MPR_IC001_066 | BW - EHS - Neutralized Production data for EHS (Hana Flow) |
| BW_QRY_MPR_IC001_6068 | Rhodia UK Stock Report (Core Query) |
| BW_QRY_MPR_IC001_75 | BW - Customer Inventory End of Month RCS (Dynasys Extract) |
| BW_QRY_MPR_IC001_76 | BW - Unrestricted Stock RCS in the future (Dynasys Extract) |
| BW_QRY_MPR_IC001_9000 | BW - Inventory Value (Core query) |
| BW_QRY_MPR_IC001_9003 | BW - Spare Parts Movements AVG (LA Specific) |
| BW_QRY_MPR_IC001_9003_KWC | BW - Spare Parts Movements AVG (LA Sp kwc) |
| BW_QRY_MPR_IC001_9004 | BW - Spare Parts Free Stocks (LA Specific) |
| BW_QRY_MPR_IC001_9005 | BW - Spare Parts Unit Price (LA Specific) |
| BW_QRY_MPR_IC001_9099 | BW - Inventory Value (BROADCAST) |
| BW_QRY_MPR_IC001_BCAST_001 | BW_QRY_MPR_IC001_BCAST_001 |
| BW_QRY_MPR_IC001_SYNTH_0273 | Prod Ventes Stocks - Valence (core query) |
| BW_QRY_MPR_IC001_VS_0001 | BW - Production by Materials As is - Detail Analysis (Core) |
| QV_BW_QRY_MPR_IC001_0013 | QV-BW- Stock Movement Production (QV) |
| QVEPSC_BW_QRY_MPR_IC001_0062 | BW - Stock Evolution with Conversion (QV-EP-SC) |
| QVNVSC_BW_QRY_MPR_IC001_0001 | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0001B | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0002 | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0002 | BW - Inventory Aging Report (QV Query) |
| QVNVSC_BW_QRY_MPR_IC001_0002DZ | LDZ - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0003 | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0016 | BW - Stock Movement Production Neutralized by zone (Core que |
| QVNVSC_BW_QRY_MPR_IC001_0026 | BW - Movements value/qty evolution (QV Query) |
| QVNVSC_BW_QRY_MPR_IC001_0063 | BW - Stock Mmvt with conversion (QV) |
| QVNVSC_BW_QRY_MPR_IC001_0065 | BW - Value stream production (QV query) |
| QVNVSC_BW_QRY_MPR_IC001_0071 | BW - Stock evolution with conversion (Core Query) for Qlikvi |
| QVSBS_BW_QRY_MPR_IC001_0001 | BW - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0002 | BW - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0003 | QV - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0004 | QV - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0014 | BW - Stock Movement All Types (Core query) Qlick |
| QVSBS_BW_QRY_MPR_IC001_0051 | BW - 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.
| ATEGORY | BW CORE QUERY NAME | BW 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.


