Changes to the View are not reflecting in the Extract Structure of my generic datasource
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 replied
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.
Thanks for u'r earliest responses.