writing custom code for enhancing the generic data source

[Former Member]

Hi,

I need to create a generic extractor from two main tables ( Header and detail) by creating the extractor based on a view of these two tables. However I also need to include information/fields ( both header as well as detail level) form a host of ther tables in the data source.

I would like to know where to find the the extractor program and/or user exit to write the custom code for populating the fields, after appending additional fields the append structure manually.

Also want to know whether the entire data source extended this way should be delta enabled?

If there are other ways to do this, example function module etc.. I would like to know.

Thanks in advance for the help and I would reward with appropriate points

Arunava

[edwin_harpino]

hi Anurava,

create generic extraction, see

http://help.sap.com/saphelp_nw04/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/frameset.htm

the way we enhance generic datasource is just same as business content, enhancement RSAP0001 is used.

yes, it should be delta-enabled, check doc how to generic delta

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b06...

http://help.sap.com/saphelp_nw04/helpdata/en/37/4f3ca8b672a34082ab3085d3c22145/frameset.htm

generic extraction using function module, take a look Siggi's weblog

/people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

http://help.sap.com/saphelp_nw04/helpdata/en/86/1c8c3e94243446e10000000a114084/frameset.htm

sample code can see in RSAX_BIW_GET_DATA_SIMPLE

hope this helps.

[Former Member]

Hi Anurava,

so you already have to define a generic datasource. In this case I would recommend to go with a function module directly instead of using the table/view extraction and enhancing it via the exit.

regards

Siggi

[Former Member]

Hi,

I am having issues with making the appended field visible in the data source.

Here is what I have done

1> using tran 'Maintain generic data source' I have created a data source from a view and after that I have appended another striucture ( containing some fields) into the extraction structure of the data source and activated both.

But when I return to the data source, those fields are always greed out.

Please let me know the step by step procedure to enable those( uncheck the hide checkbox)

[edwin_harpino]

hi Anurava,

to uncheck the hidden checkbox for these new added fields,

transaction rso2, type in your generic datasource, click 'edit', in next screen, you need to click 'save', it will bring you to datasource edit, here scroll the screen down, you will see the new fields in last rows, remove 'hide field' checkmark for these fields.

and click 'save' again.

hope this helps.

[Former Member]

Hi AHP,

That is the issue.

when I do rso2> change> save ... only the fields that the view contains appear for the selection. However the field enhancement that I have done with the extract structure never appears. However if instead of 'Save' If I select the 'Display Field list (F7)' It should show the appended fields but in this case it would all be greyed out and I won't be able to 'Unhide' those fields.

This is a peculiar situation, Please help.

Thanks

Arunava

[Former Member]

Siggy,

Can you please send me a step by step procedue of creating a generic extractor out of a header and detail table( Please note that I need an extractor for not only combining the header and detail fields but a lot of other table both at the header as well as detail table lever. Also please let me know whether all the fields should be delta enabled for the extractor, irrectpective of which table the field is coming from.

In the generic extractor for the view method, I find only one field in the entire extractor can be delta enabled. This, I think is a mazor limitation.

Thanks

Arunava