we have multi finance setup and tran.type/docno is shared

i want to generate a report on tran type/doc.no/date + company

I could select type/doc.no/date from tfgld017 table & able to print/display

how to get company?

our company code is as below

A10 - HYDERABAD
B10 PUNE
C10 AHMEDABAD
D10 NAGPUR

I want the report to executed from any one company or parrent company (A00)

Please assist

Dear baan999,

You may use table tfgld102 and tfgld106 to get the company number based on the transaction type and document no.

Dear Jitesh,

Thanks for the details.

I checked the tfgld106 it has type/docno/line and company/type/docno/date fields

I want against 1st 2 fields company number not original company(ocmp)

please assist

Dear baan999,

In this case, you may use table tfgld482 and use the 4th index for your requirement.

Regards,
Jitesh