Build a report through SQVI but not working

[Former Member]

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.

[former_member765905]

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

[former_member220489]

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

[Former Member]

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.

[narasimhulu_konnipati]

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