Customized download data

[Former Member]

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?

[Marçal_Oliveras · Accepted solution]

Hi,

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

[Former Member · Accepted solution]

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.

Bob