General presentation

Objective of the application

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

Then data are consumed by Dynasys application by generated flat file.

Tool Leader: Lei Shen

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

Reporting Coordinator: Lei Shen

Usage information

Number of users: tbd

Critical period: none

Geographical perimeter: worldwide

InfoArea:

History

This application is linked to a need of Dynasy Tool. Every month a manually extract is done of BOM Data from ERP SAP system. The goal is to extract these data from SAP to BW and generate automaticaly BOM data level by level by flat file and send this file to Dynasys for import.

Roles & Access

Roles and access

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

Authorization objects

List of autorisation objects mandatory for the application.

Dataflow overview

Reporting documentation drive folder:

https://drive.google.com/drive/folders/18VbVRgRTsredyh89a_qSECY7E0yzSKJJ

Dataflow overview :

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Specification Document for Dynasys flat file

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 WP1 SAP source system => View ZBW_V_MAST_STKO

In view ZBW_V_MAST_STKO, we keep only entries from STKO with BOM Status (STLST) is not equal to 2 (inactive BOM) and BOM usage (STLAN from MAST) is equal to '1' (Production).

There are 2 fields used to filter data during extraction and loading on BW : 

• AEDAT (STKO)
• ANDAT (MAST)

For more explanations, see part Data Loading.

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.

There are 2 fields used to filter data during extraction and loading on BW : 

• AEDAT (STPO)
• ANDAT (STPO)

For more explanations, see part Data Loading.

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 WP1 source system : DTS_ZBW_MAST_BOM_LEVEL.

There are 2 fields used to filter data during extraction and loading on BW : 

• AEDAT (STPO)
• ANDAT (STPO)

For more explanations, see part Data Loading.

The extractor is based on view ZBW_V_MAST and in particular from 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 view ZBW_V_MAST, we keep only entries from STKO with BOM Usage (STLTY) = M (Material) and BOM Status (STLST) is not equal to 2 (inactive BOM).

In the class, we use 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. We filter records from MAST to have only data with BOM usage (STLAN) is equal to '1' (Production).

Today we only explode BOM at level 1 (Master material and its components at first level).

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 :

• BMEIN - Base unit of Measure of BOM : It correponds to the Base unit of measure of the main product exploded (MATNR) linked to the main BOM (STLNR).
• BMENG - 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.

• ZZMAT - BOM Head : If there is only 1 Product Level, Bom Head is equal to the main Product (MATNR). If there is several Product Level, BOM Head is equal to the component exploded (from previous level)
• ZZSTLNR - Bill of Material :  is equal to the BOM linked to the BOM Head material.
• ZZSTLAL - Alternative BOM : Alternative BOM linked to ZZSTLNR
• ZZIDNRK - BOM Component : Component of the BOM Head Material
• ZZPOSNR - BOM Item : BOM Item linked to BOM Component
• ZZSTUFE - Product Level : is equal to 1 when we are at component level of the master product exploded, we increment this level when we are at component level and for each new product (BOM Head) exploded
• ZZMENGE - Component Quantity : Component quantity is converted on Base Unit of Measure of the component
• ZZMMEIN - Component Base Unit of Measure : Base Unit of measure of the component
• ZZFMENG - Fixed Quantity : This field is equal to X when the component is flagged as "Fixed quantity"
  
  

Quantities conversion and recalculation

BOM quantities and component quantities are converted in KG between propagation and business layer.

Moreover, quantities are recalculated in order to have a BOM Base quantity equal to 1 KG, Component quantities are updated accordingly.

Fields with system extension

There are 3 fields stored in BOM Propagation and Business ADSO with a system extension :

• C_DYN_001 : Plant with System Extension
• C_DYN_005 : Material with System Extension
• C_DYN_052 : Component with System Extension

For more explanations see : BW OTC - Supply Chain- DPS (WBP)

Dependencies with other applications

BOM data are used by Dynasys tool (consumed by generated flat file).

ADSO ABDPDY50 is loaded by composite provider CPPPBO01.

Dynasys flat file is generated by reading ABDPDY50 data.

Data loadings

Info providers and objects loaded

Loading frequency

Daily loading.

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

Extract BOM data from PF1 SAP source system.