Standard report to display vendor master with bank details

[admire]

Hi Gurus

I'm trying to draw a report with a list of vendors and their bank data, i have tried to use S_ALR_87012086, but it doesnt dispay in an ALV Grid list, it displays in a report tree type of display. i want to display the report in a neater way such at the attached report. is there any other report is use that can display like this?

Thanks in advance

Precious

Vendor	NAME	Company Code	Country	Branch no.	Account number
100033	Armstrong Arttoneys	1150	BW	064967	9060001356203
100046	BDO Services	1150	BW	662867	0100180229900
100050	Botswana Power coorporation	1150	BW	281467	62301481818

[Sanjai]

Hi Precious, You can use the Transaction Code SQVI and generate the bank report. Enclosed below are steps.

1. Go to transaction Code SQVI

· Give View name Say Vendor Master

· Click on Create

· Give the Title say Vendor Bank Master

· Provide data source as Table

· Provide the Data from table/database view as LFBK

· *Select the Radio Button “Basis Mode”

*Basis Mode is used for simple form of reporting whereas layout mode is used for complex formatting etc

· Click on Tick to move to the next step

2. Field Selection –

Here you will select the output fields that appear in the report display

Select the fields in the right side of the screen and click on left arrow

3.Sort the Sequence of the output fields

Click on the Sort Sequence Tab

4.Select the Input Fields for the report

Click on the Selection Fields Tab

Select the fields on the “Possible Selection Fields”

Click on Insert Field

Click on Execute

5. Execute the Report

Thanks,

Sanjai

[former_member936095]

Hi,

I too tried to get vendor and his bank details w.r.t company code using ALV ,inner join but i couldnt get the o/p.

But created infoset query and got the o/p

vendor-details.jpgvendor-details1.jpg

[former_member192833]

Hi,

generate SAP Query report for it. OR LFBK table.

Regards

Atul

[Former Member]

Hi Precious,

As per my knowledge there is no other report for vendors bank details except which you tried.

You can find vendor bank details in table LFBK.

Create SAP QUERY report for this table through T-code SQ02, SQ03 & SQ01.

Regards,

Kalim