Generic DataSource Extractor

[Former Member]

Hi:

I had a DataSource that was generated via a view. This view consists of 3 tables. Via RSA3 I tested it and things looked pretty good. But then I needed to add another field to the datasource. So, what I did was the following:

Deleted the datasource

Modified the View to add the new field

Re-created the datasource using the view and generate.

Then went to RSA6 and enhanced the data structure by added fields. Generated it again. Went back and unchecked the hidden fields and the user exit fields.

Modified CMOD to now reflect the new structure.

To test this, I ran RSA3 again and via debugging I discovered that the program that gets generated in function module RSA3_GEN_GET_DATA it still passing the old structure. Therefore my new field was not there and the data is no longer aligned. It seems that the new changes were not made aware to the function module.

Has anyone experience this? This sounds like an SAP bug??

Any ideas on this would be greatly appreciated!

Regards,

Helena

[Former Member · Accepted solution]

Helena ,

did you initialize the DS from BW ?

then go to BW

Replicate the datasource and recreate the Transfer structure , this might be the reason why the structure has not yet changed.

Arun

[Former Member · Accepted solution]

Hello Arun:

Thanks so much for your help! Once I replicated the datasource in BW the generated program in R/3 brought in the right Structure.

Regards,

Helena

[Former Member]

Hi Helena!

I do not think view can be enhanced.

That,i guess is the major problem.

I will make sure of it though.

Regards,

vinay.

[Former Member]

dear helena

if u are using the z view then it can accomodate new field form teh base tables (in these cases if u have not included keys in view, it leads to inconsistancy of view ) to fed data to datasource

then make sure views are consistent and displays the

data.

i think in such a case u can enhance extract structre by appending the structure with addded field and then save ur datasource in RSO2 and then go in RSA6 to generate ur datasource, and thereafter ther in RSA6 only u can do test extraction. Thsi makes sure ur datasource is active and delivering the data.

make sure there is data in R.3 for the field for which u are expecting teh data in datasource.

[Former Member]

Hi,

I think u didnt deleted the data in delta queue in rsa7, may be this is one reason.

U said that u r recreated the data source then what is the need of enhance the old one u can use new directly...

One more thing have u activated the datasource after enhancing... Check it once

Regards

Siddhu