Skip to Content

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Mar 24, 2015 at 12:24 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 24, 2015 at 11:20 AM

    Hi,

    Can you try to regenerate your data source at RSA6.

    Later check it.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2015 at 11:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 24, 2015 at 11:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.