Getting started with SAP

This article is a abstract of Stambia SAP connector. It will present you all global features but will not go into details.

To get more information, please refers to : Stambia DI for SAP

Features

Stambia SAP connector can reverse 4 kinds of metadata :

1. Table: a classic database table, similar to SQL table
2. IDoc: an document format, similar to XML
3. BAPI/RFC: a service that can be used by external system, similar to PL/SQL procedure or WebService
4. DataSource: a read-only structured data, used for BI or customer reports

Setup

SAP server

To be able to connect Stambia to SAP, we first need to parametrize the SAP server:

• All Stambia custom ABAP is in the dedicated ZSTB_PACKAGE package and ZSTB_FUNCTION_GROUP function group
• For each kind of metadata, there a dedicated setup :
  • To query a table, use ZSTB_RFC_READ_QUERY
    
  • To query a DataSource, use ZSTB_RFC_READ_DATA_SOURCE
  • To manipulate IDoc, there is no RFC but network must be configured
  • to call a BAPI/RFC, just ensured it is remote enable

Stambia Designer

Once SAP server is up-to-date, we can work on Stambia designer :

• In both your "c:/windows/system32" and "[DESIGNER_INTALLATION_FOLDER]\stambiaRuntime\lib\addons\sap" directories, copy/past SAP JCO libraries
  Be aware those file are provided by SAP, not by Stambia.
• In your "[DESIGNER_INTALLATION_FOLDER]\dropins\plugins" directory, copy/past the Stambia connector
• In your Stambia Designer, add SAP template in your templates project

Usage

SAP can be used for mapping like any other technology. Here are some tips.

Reverse

Choose the kind of objects you want to reverse :

BAPI/RFC

Input data are in the "ImportParameters" node and output in the "ExportParameters" one.

"Tables" node is available for both input or output.

Tables

SAP tables are not different than SQL ones

You can read SAP table :

 

And you can write into SAP table :

IDocs

SAP IDocs can be handle like XML file (even for writing).

DataSource

A SAP DataSource is an extension from SAP BW.

A DataSource is a set of fields that provide the data for a business unit for data transfer into BI.

 

It is a read only strutured data, but a delta mode is available to only load updated information:

First initialize a load with Mode=C. It will make a full load and reset counters.

 

Then, run a delta load with Mode=D. It will only get new data.