Hi guys,
I need your assistance to know the Table names and the corresponding keys for the following fields.
We want to develop a report that has the following fields(ABC) .
The report needs the following details in an Inquiry(A) ,if a Quotation exist for the same need the following Quotation detail(B) ,if Sales order Exist for the Quotation(C) ,need the Following Sales Doc. details.
A.Inquiry details .Fileds needed
1. Inquiry Date
2.created by
3.closing date/Due date
4.Estimated Value
5.Customer
6.Material.
B.Quotation.
1.Quotation date
2.Quotation Amount
3.Created by
4.Reason for Rejection/Status fo Quotation
C.Sales Document
1.Sales Order On.
2.Amount.
3.Status.
4.good delivered date
Regards.