Skip to Content
Author's profile photo Vikas Ohri

SAP HCI-DS (HANA Cloud Integration for data services) Extract Data from SAP/ECC system using Custom ABAP

HANA Cloud Integration for Data services can read data from various information systems  including SAP ECC & BW, using Datastores configuration which represent connection configurations between the software/databases or applications with HCI. Datastore configurations allow access  to metadata  as well read (write) data access from SAP ECC .

Other  commonly used applications in DataStores are Flat File system ,Web services & HCI supports several other databases & applications.

Data Extraction from SAP ERP ECC system can be achieved by using ECC Tables , SAP Data Extractors and Functions.

“ABAP query” and “ABAP aggregation” Transforms are most often used methods for extracting  data from SAP ERP  / ECC or any ABAP based application system .

Joins & Transforms on source Tables result in generation  or creation of ABAP program. This ABAP program runs on the source SAP system and data filters and data projections and lookup selections happen in ABAP system. HCI relies on SAP RFC functions  for handshakes of data exchange between run time execution of this ABAP Program and mapping it to the transform fields in the  data flow task. SAP Data Extractors are based over standard BW Extractors , ideal for delta data loads if delta Q tables are set up in ECC system.

However there can be situations when extracting  data from Standard Tables or Extractors may not easily meet requirements , instead a standard BAPI or SAP Function is available or some application logic needs to be maintained in ABAP system . Instead of putting any customized application logic in dataflows , we may use Standard SAP functions & application logic , insulating dataflow changes whenever underlying SAP system configuration changes or when any SAP system enhancement or upgrade is performed.

For all such cases or simply if you like ABAP,  you may use  Transform type “Custom ABAP”  option which is available when defining the Data flow  fora HCI Task.

You can create ABAP Program which can read data from SAP BAPI or from SAP Tables ,  save it to a text file. It also allows to use another alternative to HCI generated ABAP code,  and an opportunity  to improve  generated code for any performance optimization needs. Example to read Plants in a custom ABAP is shared  below.


Next create HCI Task in your project folder.  Select & Identify the Source & Target Systems from the configured Data stores. In the Dataflow design definition choose Transform Type Custom ABAP and in the details section Type the path to the ABAP file on the server where the Data Services Agent is running. Create Output columns for the Transform Name with corresponding details for fields Name1, werks, regio & nodetype  & this transform map table will be available as input to subsequent & final target query transform types.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Vikas,


      Is it possible to fetch only delta changes from a specific key figure (i.e. demand plan quantity) in APO demand planning through HCI or BODS?


      The delta data will be fetched from time series livecache.

      Author's profile photo Vikas Ohri
      Vikas Ohri
      Blog Post Author

      Hi Aditya,


      HCI (&BODS) supports Data (& Delta) Extraction through SAP Extractors  (get "native" access without going through BW ) utilizing the same functionality of BW Extractors.

      Author's profile photo Former Member
      Former Member

      Hi Vikas,


      Trying to simplify the process:

      The custom ABAP prog will be copied in notepad and saved with extension .aba on the server where HCI DS is installed?


      Note: Directory will be the one which is part of white list in HCI DS config right?



      Author's profile photo Vikas Kumar Singh
      Vikas Kumar Singh

      Hi ,


      Is it possible to user BAPI/RFC with HCI DS. ?


      I want to WebService Call kind of thing with RFC, where the XMLMap hits RFC and then puts response to next XML Map to TargetQuery?


      Is the above possible?




      Author's profile photo RS sharma
      RS sharma

      Hi Vikas,
      I have a requirement.
      I want to bring in the text attached to Sales Orders. The Text is available in STXH and STXL tables in ECC. Any idea how can I achieve that with or without ABAP?
      Any help would be highly appreciable.

      Author's profile photo Former Member
      Former Member

      Hi Vikas,

      Is it possible to connect to ECC at receiver side i mean, For example IBP or FIle from source to ECC

      If possible kindly let me know.


      Author's profile photo Former Member
      Former Member

      Hi Vijay,

      Yes, you do that in HCI-DS through webservice, either SOAP or REST service.

      You can expose any RFC FM through webservice and then you post to that webservice to load IBP or flat file into ECC.

      Author's profile photo Former Member
      Former Member


      If I wanted to have real-time data from SCP to EWM System.

      Please advice.






      Author's profile photo Raghu N
      Raghu N

      Hi Vikas,

      Would it be possible to share us some exmaples ( ff –> ECC) using REST or SOAP via HCI-DS? or a blog that explain the scenario?

      Appreicate your time,

      Thank you!