Skip to Content
Former Member
Nov 25, 2005 at 12:53 PM

Extraction method 'View' - Delta Fails



We are using a business content data-source which has been enhanced for a Z-field.The full upload / init with data-transfer works fine. However, the delta method fails with a short dump in R/3. Details -

'One of the field names in the SELECT clause was not recognized.'

Upon investigation it appears that form "FETCH_GEN_DELTA" looks for the Z-field in the R/3-source table (as it is a view based extraction) which ends up with 'SAPSQL_INVALID_FIELDNAME' short-dump.

However, thre should be someway for the system to know that it is an add-on customer field which is filled in customer exit. system works it out in Init / Full loads, but for some reason not in Delta.

We have chkd that ALE change pointer is active and there are change docs created (BDCP).

Any ideas of where exactly the error is?