APD Keyfigure sequence is not same in the query

[Former Member]

Hi All,

I have a requirement to generate the output in a CSV file from Bex Query using APD. So i created the APD and ran the APD. But key figures sequence is not in a order in output file as in the Bex query.

Please suggest me...

[Former Member]

Hi Prasanna,

This is due to hidden keyfigures in your query. Make sure all key figures are set to display.

Regards,

Dae Jin

[ravishanker_cheedepudi]

Did u mapped query directly to file output? Use aggregate data or routine functions to get the proper formatted file.

Routine u can define target field order

Ravi

[Former Member]

Modify the name of the fields in the query to have numbers in front of it, like 1plant, 2material, 3quantity, 4value...

This should work.

Good luck,

Vijay