1. Id like to create a csv file from a query which is working fine (it is printed as a table in order to mix KF and Chars)
2. But the flat file is not recorded in the same column order, Ive tried creating views but flat file still doesnt respect the querys order.
Branch(Char)__Supplier(Char)__Item(Char)__Quantity(KF)__Reception Date(Char) <- Query
Branch(Char)__Supplier(Char)__Item(Char)__Reception Date(Char)__Quantity(KF) <- Flat File
4. The processes which will take this flat file need the Quantity before Reception Date.
5. Ive tried with Infospoke but there is no Scheduling nor flexible selection.
Is there a way to change the flat file or column order via RSCRM_BAPI?
Is there another way to get it?
What about RSCRMBW_REPORT?
Im using BW 3.5 and BEx (no Web). Ill appreciate you help. Thanks in advanced.