Tables to Link Internal Order to Vendors

[Former Member]

I am trying to view all vendors associated with an internal order. I am trying to use t-code SQVI to join tables to run a query to get this data. Which tables should I join? I would like to populate the internal order fields (known data) and request the vendors.

If this is not the most effective process, please share another way.

Thanks!

[ajaycwa1981]

Hi

How about trying report KOB1/KSB1 and refer the Off setting account there...??

br, Ajay M

[Former Member]

Hi,

You can use Table COEP CO Object: Line Items (by Period) or COEJ CO Object: Line Items (by Fiscal Year)

and refer to Table BSEG.

Regards,

Kiron Kumar T.