Skip to Content
author's profile photo Former Member
Former Member


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."

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!


Leandro Fonseca

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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)

    After that

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


    • 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


    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?