How to pull inquiry Sold to number wise

[Former Member]

Hi I am trying to pull some date ouf of the SAP wherein I can have SOLD TO numbers as a base and can have corresponding ORDER NUMBER, QUOTE NUMBER OR CONTRACT NUMBER for a time period.

Thanks

Neil~

[Former Member]

Hi,

You can try the following transactions:

VA15N - List of Inquiries

VA25N - List of quotations

VA05N - List of Sales orders

VA35N - List of Scheduling agreements

VA45N - List of contracts

Regards,

K Bharathi

[Former Member]

HI

You have to use these 2 tables VBAK and VBFA (for document flow)

In Se16n enter the VBFA table and press enter

in the field VBELV enter the quotation number and execute it will return with the required data

regards

Prashanth

[Former Member]

hi

by looking into your query its a simple report for which an ABAP query is sufficient.

in the selection screen you can have SOLD TO & ITS RANGES & FROM & TO DATES WITH RANGES.

you need to have only one table here called vbak.

if requriment is large go for Z report

hope this clears your issue.

balajia

[Former Member]

Hi,

Create a Quick viewer by transaction SQVI. In data source, select Table. In table/ view, enter VBAK. Enter. You will get all the fields available in table VBAK. Select the following fields as Selection fields as well as list fields; Sales document, Document date, Sales document type, Sold to party. Save the Quick viewer. If you execute this quick viewer for a particular sold to party, you will get all the sales documents. You can restrict by period. You have to differentiate the sales order, Quotation, Inquiry and contract by the document type.

Regards,

K Bharathi

[Lakshmipathi]

Have you tried in VA05 or VA05N ??

thanks

G. Lakshmipathi

[Former Member]

hi

by looking into your query its a simple report for which an ABAP query

in the selection screen you can have SOLD TO & ITS RANGES & FROM & TO DATES WITH RANGES.

you need to have only one table here called vbak.

if requriment is large go for Z report

hope this clears your issue.

balajia

[Former Member]

Thanks for the answer .

When I try to open VBAK , i get a mesage that it does not exist. Is there any special way to open that into the SAP.I log in SAP through B1P Customer Info.

Thanks

Neelancoholic

[Shiva_Ram]

Use tables VBAK and VBFA to develop an ABAP query to get the details.

Regards