Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG Vistex Billback Datasources in SAP BI

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,079
Tepki puanı
6
Abstract


This whitepaper provides an insight into Vistex configuration for Bill back datasources in SAP BI.

Target Audience: BI Associates and Vistex Associates

Authors: Ashok Nannuri

Contents

Vistex Billback Datasources in SAP BI 1

Abstract. 1

Introduction. 2

Billback Definition. 3

Namespace Maintenance in BI 3

Customizing Billback Datasources using Logistics Cockpit (LBWE). 5

Process of Full load Data from Billback Datasources. 6

Setting up Delta Extraction for Billback Data Sources. 7

Enhancements to Billback Item Datasource. 8

ECC Billback Tables. 11

Related Content. 12



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:

aaa.jpg




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.

a.png


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

aa.png


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.

aaaa.png


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

1-30.png






Maintain “Number Range Interval” as shown below

2-21.png


Customizing Billback Datasources using Logistics Cockpit (LBWE).


3-21.png


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.

4-19.png




Loading setup tables program for Billbacks: /IRM/MCIPBB_SETUP_LOAD



Choose the appropriate selections and execute the program as shown below

5-15.png


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

11-11.png


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

12-14.png


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

13-8.png


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

14-13.png


ECC Billback Tables


Billback header table

16-9.png




Billback item table

17-8.png


Related Content




Vistex

Vistex BW Extractors for IP Module

For more information, visit the Business Intelligence homepage

Okumaya devam et...
 
Üst