Tables in SD and the details

[Former Member]

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.

[Former Member]

hi

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

All ABove you can get in VBAP table

C.Sales Document

1.Sales Order On. - VBAK

2.Amount. - VBAK / VBAP

3.Status. What status you are looking for?

4.good delivered date - VBEP