SQ01 - Customize the output with 'No data'

[rohitsharma198136]

Dear Experts, I am trying to fetch vendor information details from LFA1, LFB1, LFBK and BNKA tables. But I realized that if vendor does not have the bank information then record does not display in the output at all. The reason for this is if vendor does have bank information then there will not be any record in LFBK and table cannot be joined with others. I tried with left join as well but no luck.

Question: Is there a way if I want all the vendors in my output even if there is no bank information? For missing bank information we can display "No data" in the columns.

Many thanks in advance.

[RaymondGiuseppi]

Basically you would require a left join from LFA1 to LFBK and then another left join from LFBK to BNKA and this is not SQL compliant.

You could create an infoset with SQ02 and move the select from BNKA from table join to code section redefining BNKA as a structure, there you could also provide the 'No data' value for fields of BNKA. (or build a small actual Abap report program of course)

[rohitsharma198136]

Thanks Raymond! I deleted my previous comment.

Could you please guide me how I can move the select from BNKA to code section? I am new to SAP queries and this is something new to me.