Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question