cancel
Showing results for 
Search instead for 
Did you mean: 

Customized download data

Former Member
0 Kudos
56

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)

Marçal_Oliveras
Active Contributor
0 Kudos

Hi,

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.

Bob

Answers (0)