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.

/wp-content/uploads/2014/04/image4_436304.jpg

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.

/wp-content/uploads/2014/04/image1_435488.jpg/wp-content/uploads/2014/04/image2_436305.jpg

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Aditya Gupta

    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.

    (0) 
    1. Vikas Ohri 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.

      (0) 
  2. Purav Mehta

    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?

     

    Thanks,
    Purav

    (0) 
  3. 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?

     

    Regards,

    Vikas

    (0) 
  4. 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.
    Thanks
    RS
     

    (0) 
  5. vijay kumar

    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.

    Regards,
    Vijay

    (0) 
  6. Vijay Sahadevan

    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.

    (0) 

Leave a Reply