Delivery report in sap sd

[Former Member]

what is the standared T.code to see the list of deliveries with the following fields.

Sales order No,

Sales order date,

sales order quntity,

Delivery quntity,

DELIVERY DT

SOLD TO PARTY

DESCRIPTION

TYPE OF ORDER

Thanks,

Tulasi

[Former Member]

Hi All,

Thanks for the solution.

[Former Member]

Did You try out VA05 ?

you can go for changes in the layouts, where majority of the fields can be fetched from.

Thanks & Regards

Ilango

[od_manikandan]

Hai Tulasi,

Try SQVI report creation

and assign T CODE to the program.

It will give all the details and the report will be created immediate.

In General SQVi should start from reverse order

Delivery item LIPS - DO header LIKP - SO header VBAK - SO item VBAP

in case if you have a sales order and two deliveries then reverse order only will give the proper data.

Else the data will be duplicated.

Regards,

Mani

[Former Member]

You can create it via sq01, or you can creat it via se39 to write some code with inner join table function.

[madhu_vadlamani]

Hi TUlasi,

There is no standard report with all these fields. Better to go for custom report .

Regards,

Madhu.

[former_member209761]

Dear Tulasi,

for more input on query, check my reply in the following thread.

Thanks & Regards,

Hegal K Charles

[moazzam_ali]

There is no such standard report in SAP SD. You can create your own by using VBAK,LIKP,LIPS tables in SQVI. Its easy to use

[former_member209761]

Hello,

You can try using VLO60

Sales order No= Reference document

Sales order date,

sales order quntity,

Delivery quntity,

DELIVERY DT

SOLD TO PARTY

DESCRIPTION

TYPE OF ORDER

and you will get most of the data except sales order date , sales order qty, sales order type and decription

It is better you create a query in sqvi combining tables (table joint) LIKP , VBFA, VBAK tables

if you need more help , revert back.

Thanks & Regards,

Hegal K Charles