Vendor address and account group

[Former Member]

Hi experts, could you tell me where can I find the vendor address and account group as well. So I need one table or transaction which contains all the data which I need.

Thanks in advance.

[Former Member · Accepted solution]

Hi

You can use a Query transaction code is SQVI

select table join

Select table LFA1 and LFB1

join the table on field LIFNR

Your will get the desired output.

If the answer resolve kindly assing points

Thanks & regards

Mahesh

[Former Member]

Hi,

Use LFA1 table

Regards,

Krishna Mohan

[Former Member]

Hi Krishna, I need bukrs also, do you know such table or report which gives me this information all in one

[Former Member]

Hi White,

Try using report MKVZ.

vendor and company code data will be available from LFB1 table.

Other tables realted to Vendor are

LFB5 Vendor dunning data

LFM1 Purchasing organization data

LFM2 Purchasing data

LFBK Bank details

Regards,

Krishna Mohan