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

Query Properties in APD

Hi experts,

I'm using an APD to create a file from a query.

I need a routine between the extraction and the file's creation.

The query has specified some properties, for example the zero omission and the representation of zero as empty.

These properties are respected only if I don't insert the routine, as I can see in the intermediate result.

Is there any way to resolve this situation without writing lots of ABAP code?

Thanks in advice

Matteo

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 30, 2016 at 08:42 AM

    Check this,

    Flatfile formating related issues in APD

    Thanks,

    Bhavin Vyas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 31, 2016 at 03:55 AM

    Hi Matteo,

    You can try using filter also put filter between file and query and filter keyfigures.

    Regards,

    Ganesh Bothe

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2016 at 12:24 PM

    Just an integration

    If you don't want to represent some column values in the query, they however appears after the extractions in the following APD's steps (filtes, routines, aggregations, link) and you can have wrong valorizations.
    To bypass this problem, I choose to put these columns in the last positions of the column structure.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.