BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Vistex Billback Datasources in SAP BI

Introduction

Vistex is a third-party tool provided by Vistex Inc. It is an add-on to the ECC server. In other words, it sits on top of ECC. It is best suited to handle complex calculation like processing rebates, sales commissions, Bill backs, chargeback in ECC. It has a different set of objects and tables. Vistex provides valuable solutions to organization that operates in one of the following sectors:

  • Wholesale Distribution
  • Consumer and Commercial Products
  • Pharmaceutical and Medical Devices
  • Industrial Machinery and Components
  • High Tech and Electronics
  • Process Manufacturing
  • Retail

Landscape Overview with Integration of ECC and Vistex:

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Billback Definition

A billback is the process of a manufacturer validating claims for compensation from one of its channel partners. One main example is the amount paid by a manufacturer or vendor to a distributor for the difference between the distributor’s initial acquisition price and the actual agreed upon price for products/services sold to a specific end customer or partner. Another example is a claim for performed activities, such as a marketing event or sales to an end customer.

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

There are three data sources for Billback applications. The three data source includes datasource for header data, item data and condition data.

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Namespace Maintenance in BI

Before replicating the Vistex data sources in BI, we have to maintain the namespace for Vistex. The system will not allow activating the data source if namespace is not maintained in BI. The namespace for Vistex is“/IRM/”. Namespace ‘/IRM/’ must be entered in both the BI table RSNSPACE and the basic table TRSNSPACE or the view V_TRNSPACE. Namespace maintenance in ECC is taken care during Vistex installation. Below is the screenshot of the view “V_TRNSPACE” in which Vistex namespace is maintained.

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Maintenance of Number Range

Before running the setup for Vistex data sources, we have to maintain number range in ECC as follows:

  1. Execute transaction: SNRO
  2. Maintain the settings for object “/IRM/MCEX” as shown in the below screenshots

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Maintain “Number Range Interval” as shown below

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Customizing Billback Datasources using Logistics Cockpit (LBWE).

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

We can add / remove fields from data source using maintenance as shown above

Process of Full load Data from Billback Datasources

Similar to LO data sources we want to delete and load the setup tables, when we are loading initially.

Deletion of setup tables program for Billbacks : /IRM/MCIPBB_SETUP_DELETE

Execute above program using SE38 transaction code.

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Loading setup tables program for Billbacks: /IRM/MCIPBB_SETUP_LOAD

Choose the appropriate selections and execute the program as shown below

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Setting up Delta Extraction for Billback Data Sources

Vistex provides different delta programs to extract delta from ECC. After executing initialization from BW, we have to schedule the delta programs in order to schedule the delta infopackages.

For Billback Delta Extraction we use program /IRM/MCIPBB_DELTA

Enhancements to Billback Item Datasource

Open billback item extract structure using RSA6 transaction code

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Click on the append structure and add your custom fields as shown below.

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Create / Use a Project in CMOD to fill the custom added fields above, using the custom logic in the highlighted function exit.

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Call custom program from the function exit wherein we write the logic to fill custom fields as shown below

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

ECC Billback Tables

Billback header table

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Billback item table

BW Data Modeling (WHM), BW (SAP Business Warehouse), SAP BI

Leave a Reply

Your email address will not be published. Required fields are marked *