Skip to Content
author's profile photo Former Member
Former Member

error in generic datasource

Hi all,

I have a generic datasource extracting data from a DB table.

I wanted to enhance the datasource by adding an extra field, which is not in the DB table, fill it with the customer exit and make it selectable in the datasource but when I tried to extract data selecting according to the new added field, the following short dump occurs: "SAPSQL_INVALID_FIELDNAME".

The dump only happen if I enter some value in the new added field to use it as selection, if not, the field is populated correctly and no dump happens.

My understanding is that if the extraction mode is through a DB table, it will be only possible to use as selection fields those fields available in the table, but I am not 100% sure and I would like to know if this is true or I am doing something wrong in the enhacement of my datasource.

Any input would be really appreciate.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 10:53 AM

    Hi,

    Whenever your datasource extracts the data its does the extract not considering your enhanced fields. Once the standard extraction is over your Z fields value is filled based on the logic that you have written in customer exit.

    Hope this answers's your querys!!!

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:26 PM

    Hi Elena,

    Since the field you enhanced is not in the DB table, you can not use it as a selection field. You can have the field in the extractor and populate it with whatever values in the user exit but, when you try to use it as a selection field, there is nothing at the database level where it is connected. Hence, it gives a dump. If you want to use a field for selection, it should be a database field. Hope this helps.

    Thanks and Regards

    Subray Hegde

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Elena,

      if the the fields are enhanced fields, you can't enable those for selection.

      Reason: when these added fields will be filled?

      1. first tables fields will be extracted(once it done completely and successfully).

      2, then it will call Customer exit.

      you populating values for addded fields using table fields as reference.

      all the best.

      Regards,

      Nagesh Ganisetti.