Skip to Content
author's profile photo Former Member
Former Member

Add a new field to exisitng generic Datasource in source: Table join source

Good day

I need guidance please?

Requirement: Add a new field to source and SAP BW for reporting purposes.

I need to add a debtors field from source table VBPA to an exisitng generic datasource in a source. The exisitng database view has several join conditions to different tables.

What are the step-by-step procedure to get a field added to this database view, using join conditions?

Thanks in advance

Cj

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2011 at 02:38 PM

    Hi,

    You can follow the below given procedure,

    1) First Check in which table you are going to add the new field.

    2) Once you modify the field in the table, you might not need to change the join condition as your table will be already in the existing join condition.

    3) On the fields tab, click on the button "Table Fields" and select the required field from table.

    4) Now the field will be available in your Data source.

    5) Check your data source extraction in RSA3.

    6) Replicate your data source in BW.

    7) After that you can use this field further in BW.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2011 at 05:26 AM

    Hi,

    In RSA6 you will find your data souce select that data source then click on enhane strucutre you can append your field to that extract structure then write the the code in CMOd based on you logic then replicate the your data souce R/3 to BI.

    Hope it's helps you.

    Thanks and Regards,

    Venkat.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2011 at 01:27 PM

    Good Day.

    I understood that you want to extract the data for both the partner type ZR and RG.

    As mentioned you are already have some selections in the view.

    VBFA VBTYP_N EQ 'G' AND

    VBFA POSNN EQ '000000' AND

    VBPA PARVW EQ 'ZR' OR

    VBPA PARVW EQ 'RG'

    Please add the last condition in your selection.

    Thanks,

    Prabhakar Kilaru

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi There. thanks for the information.

      I am very lost at this point. I still do not know exactly how to add this field to the join tables? Perhaps I do not understand how it works. I will try all the advise out, thanks

      Cj

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.