Showing results for 
Search instead for 
Did you mean: 

APD Keyfigure sequence is not same in the query

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Prasanna,

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


Dae Jin

Active Participant
0 Kudos

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


Former Member
0 Kudos

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,