UD Connect Generated SQL Statement

[former_member204618]

Hi All,

Can anyone tell me if it's possible to influence the generated SQL statement? We need to be able to use the order by clause so as to get the records in the correct order.

Any help much appreciated.

Thanks

Craig

[former_member181999 · Accepted solution]

Hi

Yes its possible in THIS WAY.

CASE-1

In UD Connect we have the DATA in a BASE TABLE. When we execite the under like DATASOURCE (UD-CONNECT). The dependant Info PACK brings the complete data to PSA. After the DATA LANDS in PSA. We can sort out in the same way how can SORT in the SQL Statement method. But to do this you have to PUT a Start routine at infopack level.

Case-2

You have to use a store procedure out side the SAP BI .

[former_member204618 · Accepted solution]

Sorry Helpful response but not what I was looking for.

Doesn't matter now anyway.

Cheers

Craig