Showing results for 
Search instead for 
Did you mean: 

Customized download data

Former Member
0 Kudos

I have a MBO (SUP2.1) derived from SAP BAPI, Customer.GetList and am trying to use SQL statement in synchronization tab by clicking 'Customized download data' to limit columns. Original and modified SQL looked like:

SELECT x.* FROM GetList x WHERE ( (x.CITY=:sp_city ) )

SELECT x.CUSTOMER, x.NAME, x.CITY FROM GetList x WHERE ( (x.CITY=:sp_city ) )

If I deploy project with modified SQL, it just fails saying 'Delpoy error' not giving any details.

Can anyone enlighten me?

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


I think you can't limit the columns here, just apply different where clause. But I can't confirm this.

Former Member
0 Kudos

Thanks for the reply Marshal,

So SUP does allow limiting rows by WHERE clause but there is no way to limit columns once it is cached.

Anyone who finds different, please correct me.


Answers (0)