General presentation

Objective of the application

The objective of the application is to extract from SAP Vault source system Bill of Material data and explode BOM level by level with components data.

Then these data are used for the application BW - DPS - Forecast Vs Booking / Component.

Tool Leader: Lei Shen

IT leader of the application: Lei Shen (PP), Craig Wanamaker (BW)

Name of project: Solstice

PMO Project: 8612 Solstice AERO

Reporting Coordinator: Lei Shen

Usage information

Number of users: tbd

Critical period: none

Geographical perimeter: worldwide

InfoArea:

History

This application is linked to the Solstice global project and this specific need was named "DEV47- Other MiniBW request for planning team".

MiniBW (CPX) dedicated platform was created for Aero Requirements about Solstice project.

Roles & Access

Roles and access

List of application role + menu role and explanation if we have several applications role with specials rules.

Role Code	Role Description	Explanation

Authorization objects

List of autorisation objects mandatory for the application.

Authorization object	Explanation

Dataflow overview

Reporting documentation drive folder

https://drive.google.com/drive/folders/1Y2OmoBqD6VWwpmUPnuiQ6ZFm0hwlPruA

Dataflow overview

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Specification Document

Sheet "Dim_BOM" :

BOM Master Data

BOM Number master data (C_BOMNUM) is loaded by the datasource DTS_ZBW_V_MAST_STKO.

The Datasource is based on table MAST (Material to BOM Link) and STKO (BOM Header) from SAP Vault source system.

BOM Item Master Data

BOM Item master data (C_BOMITM) is loaded by the datasource DTS_ZBW_EXTRACT_BOM_ITEM.

The datasource is based on specific function module ZBW_EXTRACT_BOM_ITEM.

In this function module we call the standard function CSAP_MAT_BOM_ITEM_SELECT to extract each item for a given material/plant.

BOM Level determination

The most important need of this dataflow is to extract (and explode) all BOM items and components for a given product.

A specific BW extractor has been developed to build the Bill of Material from SAP Vault source system : DTS_ZBW_MAST_BOM_LEVEL.

The extractor is based on MAST table to keep all Bill of material to explode and the class ZDTS_ZBW_MAST_BOM_LEVEL is used to extand the datasource adding new fields.

In the class, we are using the standard function module 'CS_BOM_EXPL_MAT_V2' to build the Bill of material and BOM level. The function module is used as recursive function, as long as BOM exists and have to be explode.

The equivalent to explode BOM level by level on SAP side is T-CODE CS11.

See below, main fields determined or calculated in the class :

Product Level : is equal to 1 when we are at component level of the master product exploded, we increment this level whan we are at component level and for each new product (BOM Head) exploded
BOM Level : is equal to 1 when we are at header level, is equal to 2 when we are at component level.
BOM Quantity : BOM quantity is converted on Base Unit of Measure of product exploded. The quantity is duplicated of each component line linked to this product.
Component Quantity : Component quantity is converted on Base Unit of Measure of the component

Taking the following example for the material 157473 :

Line in yellow is the header line of BOM Head 157473. Product Level = 1 because BOM Head = Product = 157473.

In blue, there are all components of BOM Head 157473, we increment BOM Level and Product Level.

In pink, the previous component 157193 of BOM head 157473 become the BOM Head, we incremente the Product Level.

In brown, it's the header line of BOM Head 157193, BOM Level =1. Others lines corresponds to components of BOM Head 157193, BOM Level = 2.

RSA3 on extractor DTS_ZBW_MAST_BOM_LEVEL for the same example : 157473

Dependencies with other applications

BOM data are used in application BW - DPS - Forecast Vs Booking / Component.

Data loadings

Info providers and objects loaded

Master Data

BOM Number & BOM Item Master Data are loaded by the process chain PC_PP_05.

BOM usage Master Data is loaded by the process chain PC_PP_06.

Transactionnal Data

There are 2 process chain :

Acquisition Layer : PC_PP_08
Propagation Layer : PC_PP_09

They are part of process chain PC_PP_04 :

PC_PP_04 is part of global RSP_DAILY :

Loading frequency

Daily loading

Average performance

Key Figure	Estimation
~ Average Process Chain Runtime
~ Average nb of rows loaded per load
~ Total nb of rows loaded (if full)
~ Average Runtime for 10k lines

Record Keeping

Reporting

Queries End User Documentation

Main queries

There is a query BW_QRY_CPPPBO01_0001 (BOM Data Reporting) based on composite provider CPPPBO01 (BOM Item Data - Virtual).

This query was used for testing data coming from SAP Vault source system but it is not used and accessible by key users.