Data quality metrics for Performance Measurement

Introduction The data quality can be measured through metrics which in turn helps to identify the issue and helps the performance engineer to create the data or modify the data to adhere to the quality. Data quality depends on type of application, type of tables/views used in the...

Continue reading

Manufacturer Part Profile in QM

• 
• 
• 
• 
• 
• 
• 

PrevNext

Purpose: The Materials Management (MM) component supports the procurement of manufacturer-specific parts or materials from different vendors. If you implement the functions for manufacturer part number (MPN) processing, you can also process goods receipt inspections for manufacturer-specific parts or materials in the Quality Management (QM) component. We Can...

Continue reading

Using Temporal Join in Composite Provider in BW/4HANA

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

Introduction ◉ From SAP BW 7.4 and in BW/4HANA new Composite Providers are the main objects for define unions / joins of existing persistent or virtual data models. ◉ Composite Providers are successors of MultiProviders and BW InfoSets. In classic BW Warehouse only BW InfoSet were responsible for SQL...

Continue reading

Submission Targets in BW Workspace

• 
• 
• 
• 
• 
• 
• 

PrevNext

With a usual approach in data loading with minimal cleansing operation, a user has to create a transformation and data transfer process(DTP) for cleansing and loading the data. But, With 750 SP04 on HANA, a new agile feature: Submittable providers in BW Workspace was introduced, Where the cleansing...

Continue reading

Multiple attribute values for one line of data: how to avoid infosets in BW without HANA

• 
• 
• 

PrevNext

Introduction I’d like to share my experience and to analyze possible solutions for a BW task which I’ve met on several retail projects. I think this problem is quite interesting because it’s one of the examples of the general idea: how can we avoid using joins (infosets) on...

Continue reading

Routines in SAP BW 7.x

• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

There are different types of Routines available to write (ABAP) in SAP BW for data modification/population at different levels. Routines helps us to implement Business Rules or setup better Data Model which is not available in standard way. This document will cover below routines in SAP BW (7.x)....

Continue reading

PPDS on S/4HANA

• 
• 
• 
• 
• 

PrevNext

Introduction to PPDS (Production Planning and Detailed Scheduling) Production Planning and Detailed Scheduling(PPDS) on SAP S/4HANA is the product running on SAP S/4HANA.  Production planning and detailed scheduling is a tool in APO(Advanced Planning and Optimization) which takes care of planning and scheduling considering the capacities of various...

Continue reading