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

Build a report through SQVI but not working

Dear Expert,

Kindly help me on this issue.

I tied to build a report using SQVI to output vendor details.

Below is the table I linked.

LFA1 -> ADRC -> ADR6

LFA1 -> LFM1

LFA1 -> LFB1

LFB1 -> LFBK -> BNKA

LFB1 -> LFZA

LFB1 -> LFBW

Once I executed the report, i got message "no data was selected".

What could be wrong?

Please help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Feb 03, 2012 at 07:54 AM

    Proper link might have not built.

    It is very important to link the tables with proper link, otherwise, the values will not be shown.

    Check the link once again and show it to your ABAPER.

    So that ABAPER can help you

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 08:15 AM

    Hi,

    Please use "left outer join". then try again.

    If still no data, you'd better to check them one by one (test two table link, if ok, add one more table to test......, until all table involved). The reason could be found in this way.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 03, 2012 at 08:16 AM

    Where is the link between LFA1 and LFB1????

    First insert LFA1 table and then insert LFB1 and subsequent tables....

    each set of tables must have comman fields to inner join / outer join

    create a new quick viewer cinsidering the above

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 08:43 AM

    Hi Expert,

    In T-Code: SQVI - We can see the relationship between Tables with Fields.

    Here you may find the Primary Key for each table, which plays a major role in linking Table to Table.

    Better, take the help of Technical (ABAP) Consultant, while Building a report through T-Code: SQVI.

    Regards,

    GK

    SAP

    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.