list of outbound delivery

[Former Member]

    Dear Experts,

      kindly help me to create report for the below details.

outbound delivery number

item code

description

quantity

selling price

total selling price

payer details

[former_member184881 · Accepted solution]

hi,

You can create a report by query builder (SQVI – SQ02& SQ01) by below joining structure:

table join:

VBAP-VBELN = LIPS-VGBEL (Left outer join)

LIPS-VBELN = LIKPVBELN (Inner Join)

Here you can select field for required field:

outbound delivery number  = LIPS-VBELN

item code                              = LIPS-MATNR

description                            = VBAP-ARKTX

quantity                                  = LIPS-LFIMG

selling price                          = VBAP-NETPR or for this field you can create extra field in sq02 by ABAB code (VBAP-NETWR/ LIPS-LFIMG)

total selling price                 = VBAP-NETWR or for this field you can create extra field in sq02 by ABAB code (LIPS-LFIMG * VBAP-NETPR)

payer details                         = SQ02 has extra additional text field you can find your required text filed for payer details.

thanks

Md. Enayet Hossain

[Former Member · Accepted solution]

Thank u Enayat  Hussain  u have given very useful deetails to me

[Former Member]

Hi,

Please check in the forum  - http://scn.sap.com/docs/DOC-32617

Regards

[siva_vasireddy2]

Hi,

  if you are having pricing at Delivery level you will get the Desired report.instead you can develope you own Report in T.code- SQVI by taking Logical Data base as VAV

you have Multiple Fields to select in your Report.

Shiva