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

[Former Member]

Hi Siggy and AHP.

I have been able to write the function module extractor ( quite a complex on involving many tables, header, detail and other tables both at the header, detail level). I agree with Siggy, that in this case the FM option is the best one.

However I haven't tried the delta with this option and I really need most of the fields ( can come from any of the four tables mentioned above) to be anabled in delta.

When I go to do the generic delta, it only allow me to enable only one field. Does that mean that changes to only that field will trigger the delta extraction?

What about changes to the other fields?

Please let me know.,

Arunava

[edwin_harpino]

hi Anurava,

try to force remove 'hide field'

tables ROOSFIELD.

Update ROOSFIELD set NOTEXREL = 'Y' where

OLTPSOURCE = '[datasource name]' and

FIELD = '[fieldname]' and objvers = 'A'.

if need to enable selection

Update ROOSFIELD set SELECTION = 'X' where

OLTPSOURCE = '[datasource name]' and

FIELD = '[fieldname]' and objvers = 'A'.

many fields for delta, you may need one new field,

and let's wait Siggi's reply

[Former Member]

Hi Arunava,

well you only need to have one field for the generic delta. This field will be passed to the fm. In the fm you can use it to select from different tables using different dates (creation date, change date). E.g. you defined a field ZDATE as THE generic delta field. Within the extractor you get that field in table

s_s_if-t_select. From there you put it into a range table or a fm-internal date field (defined as global or static). Then you do a select like this:

select * from header_table

where ( erdat >= g_zdate

or aedat >= g_zdate ).

select * from item_table

where ( erdat >= g_zdate

or aedat >= g_zdate ).

Additionally you can join header and item table to do the select or open a cursor ....

Check out /people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module for some more information.

regards

Siggi

[Former Member]

Siggi,

This doesn't work for me, the system indicated error when I specify ZDATE for the generic delta. the system indicates that the field can only be selected from the 'Delta Specific Field ' Field nm F4 value, This only comes from the field of the data extractor structure.

As per your sugesstion it seemed that I can define my own field ( ZDATE) which need not be present in the extraction structure.

Thanks

[Former Member]

Hi,

As far as i understand, you will be able to define a 'zfield' in the FM only if you have the field already appended to the extract structure of the datasource. If not, the FM will not identify the field.

Regards