Requirement for Quotation Report.

[Former Member]

Dear Experts,

I have a requirement for Report for Quotation.

In the Report Client wants to see for Particular Quotation Inquiry Number, Inquiry Value, Sales Order and Sales Order Value.

I have checked in VBFA Table if the Sales Order is Open for that Quotation it doesnt gets updated in the VBFA Table.

Is there any other way I could capture the Sales Order Number for that particular Quotation.

Please suggest the way out.

Thanks.

Parag.

[Former Member · Accepted solution]

Hi,

The logic would be

Give the input value as quotation number.

Pass quotation number into VBAK- VBELN and get VBAK-VGBEL to get Inquiry number

Pass quotaion number into VBAK-VGBEL and get VBAK- VBELN Sale order number

subsequently pass these Inquiry and quotation numbers and get the relevant details of Inquiry and Quaotation

check this logic using t.code:SE16n

Hope this helps.

Regards,

Sharan