Skip to Content
avatar image
Former Member

HCI-DS ABAP Query

Hi HCI-DS gurus,

Anyone knows how to use ABAP Query as Transformation Type?

I searched SAP Help but it only has this brief description:

"Retrieves a data set from an SAP Applications source and optionally transforms the data inside the SAP application according to the conditions that you specify. The transformed data is returned to SAP Cloud Platform Integration."

https://help.sap.com/viewer/dab65b1584e04026a132a06a711e3f5a/latest/en-US/be2b7a49306f4c868f8654e9bedee72b.html

In Transformation Details, there is an option Job Name and Program Name, but I couldn't find a sample program anywhere.

Any one used it already?


Thanks very much!

Regards,

Leandro Fonseca

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 31, 2017 at 08:55 PM

    Hi Leandro,

    • First you must need make your configuration like "Generate and Execute"
    • Run the task
    • Verify that the flat file was created in Agent machine (The name is the same the Task)
    C:\ProgramData\SAP\DataServicesAgent\abap\FLATFILE.Aba

    After that

    • Go toTask and rename in the "ABAP Options" the Abap program name

    Finally

    • Create the ABAP program in SE38
    • Chage the configuration from "Generate and execute" to "Execute preloaded"
    • Run task again

    For another environment, transport the abap program

    Regards

    Hector Contreras F.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Hector,

      I have a dataflow developed in CPI DS,and it uses ABAP Query.When executed the Dataflow,it creates <<Dataflowname_timestamp>>.aba file on the agent machine.

      Could you please help with the following queries

      -->Does the .aba filename has any relevance which is created on target machine?

      -->Why do we need to change the "Abap program name" after the .aba file is created?Is it mandatory?

      --> Does the name of the ABAP program(created by SE38) should match with the name given in ABAP options config tab?

      Regards,

      Siva