Changes to the View are not reflecting in the Extract Structure of my generic datasource

[sasidhar_pannala]

Hi BWer's,

           In order to extract PR Data i created a Generic Data source which uses Delta Queue on the top of a VIEW. I went in the following way
1.) Created a View on the top of EBAN table

2.) Created a Generic Datasource on the top of the view

3.) Created a PROGRAM in ABAP Editor to change the delta type of the datasource and executed it and successfully changed the delta type to 'AIM'

4.) Identified the BTE for the Purchase Requisition, Created a product for the hooking between the FM and the BTE

5) Written the Function Module for the delta capture

Everything went well. I replicated the datasource to BW, created an INFOPACKAGE with DELTAINIT and ran it to get the full load. Even the DELTA got initialised for my generic datasource and i,m able to see an entry for it in RSA7.

Right now i thought of adding some more fields to my view from the same table EBAN itself. So i changed the view and added some more fields into my view, but i'm not able to see them in the extract structure of my Generic datasource.

1.) Changed the view and activated it

2.) Deleted the DELTA INITIALIZATION for this datasource in BW

3.) came back and Activated the datasource in ECC

But unfortunately i'm not able to see the changes to its extract structure.

1.) Is it possible to reflect the changes of the view into an extract structure or Do i have to go with entirely new components again to fulfill my desired requirement ?

Please help me. Its very urgent.

Thanks in advance

[sasidhar_pannala · Accepted solution]

Dear Guys,

       It got solved.

If we change the view after activating the data source, we have to add the fields manually to the extract structure also along with the view (In this scenario the data source wont automatically import the fields into its extract structure).

1.) Goto RSO2,

2.) Double click on the extract structure,

3.) TURN ON the CHANGE Mode

4.) Add the fields manually which u have added in the view (Manually u have to mention the references for the newly added fields in the CURRENCY/QUANTITY tab, if any)

Then while activating the extract structure, system will check whether both the view and extract structure are in sync.

         Then if u goto RSA6, there u can find the newly added fields with the HIDEFIELD option Checked and you have to unhide them.

Thats it...

Thanks for u'r earliest responses.

Regards

Sasidhar

[Former Member · Accepted solution]

Hi Sasidhar,

Right now we're pulling full records from EBAN table. could you please share logic/code to enable delta?

Thanks,

Ajay

[former_member182346]

Hi,

After saving and activating the view in ECC, replicate the datasource in BW, you will be able to see the added fields.

Thank-You.

Regards,

VB

[sasidhar_pannala]

Hi Vinod,

         If it gets replicated on the BW side, then even it should be visible @ECC side right ?
Even then, as u said, i tried vinod, but disappointed to see the same old one without any added fields

Thanks & regards

Sasidhar

[former_member182346]

hi

check this thread 1991977 in scn and see if it is useful, talks about updating the ROOSOURCE table for the added fields.

Let us know if it works.

Thank-You.

Regards,

VB

[Former Member]

Hi Sasidhar,

Goto RSA6 - Click on the daasource.

Edit pencil on the top & check if your new selected fields are hiden.

If yes, unhide them & then they will be available in extract structure.

Regards,

Chitra

[sasidhar_pannala]

Hi chitra,

           thanks for u'r reply,

I'm not at all able to see the fields in RSA6 or RSO2.

Had there been the fields present, I would have did the unhide activity...

Thanks & regards

Sasidhar

[RamanKorrapati]

Hi,

Can you try to regenerate your data source at RSA6.

Later check it.

Thanks

[sasidhar_pannala]

Hi Raman,

             Thanks for u'r quick reply,

What do you mean by regeneration of datasource ?
Actually i went into RSO2 and activated the extract structure, But it didn't turnout to be something +ve.

I'm able to see my added fields in the View/Table section in RSO2 but not in the extract structure section just below it...

My doubt is "Do i have to deliberately add the fields in the extract structure also after adding them in the view" ???

Regards

Sasidhar

[RamanKorrapati]

Hi,

Regenerate - Need to Generate data source. so while generating it may collect your source(view and added fields) and make them as part of it.

As i know while we create generic data source based table/view - extract structure generated by automatically. so you can't add them by manual. so try to generate data source.

if not in that case then again create new data source with same view and see.

Thanks