Skip to Content
0
Former Member
Jan 12, 2011 at 10:42 AM

Tables in SD and the details

83 Views

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.