report on sales orders

[Former Member]

hi all,

i need to develop a report which has Purchase order number, sold to party, sales order number, required delivery date and confirmed delivery date by system. i tried to to do this by sqvi, but here requirement is some group of users have to run this not restricted to single user, and when ever i use shedule line tables it is doubling the lines per schedule line, can we display that in just two columns as required delivery date and confirmed date by system.

Thank you gurus in advance,

Naga.

[Former Member]

thanks guys.

[Former Member]

Hi,

You can select schedule line = 1 on selection screen of your existing query. your problem may solve or you can create query using table vbkd, vbap & vbak.

Regards

San

[Former Member]

Hi

SAP1 & SAP2

theer r 2 stsndard report for Sales view as per ur requirement.

However u can go for SAP Query .

there u can joint two tables and field as per ur requirement and crete a infosat with respect to User.

T.code

SQ03-SQ02-SQ01

thanks

Mk

[Manoj_Mahajan78]

Hi..

Check with your ABAP person.

Take latest schedule line dates

Regds

MM