Vendor Master data table

[Former Member]

Is there a way to get a list of vendor master data by account group in company codes. Table LFA1 shows vendors and account groups and table LFB1 shows vendors and company code. But I have not found a table that shows both.

[Former Member]

Dear,

You can not have one table with blend of two tables.....

I do not know what exactly your requirement is.........but you can try below report...

S_ALR_87012086

By executing above transaction, select Dynamic Selection in this screen and drag the account group in....now execute the report with selecting fields you need in Further selction....

Regards,

Chintan Joshi

[Former Member]

I will check out S_ALR_87012086. Is there any other way to pull out vendors per account group in particular company codes.

[former_member182098]

Hello,

Check LFA1 table (include KTOKK field in the list selection). You will see the list of vendors by account group.

Thanks,

Ravi

[dominic_holdstock]

Hi,

you can use SQVI (Quick Viewer) to Join the tables and create your own List/Query.

Kind regards