cancel
Showing results for 
Search instead for 
Did you mean: 

List Sales Order

Former Member
0 Kudos

Hi

How do i list the sales orders which contains a particular pricing condition type.

Any Table or Tcode ?

Thanks

<<MM>>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

No standard report available for this.

You can simply create a SQVI query for this.

Do below,

Link KONV table and VBAK table using KNUMV field.

VBAK / KNUMV = KONV / KNUMV

Then generate the report for KSCHL / KSCHL (your condition type)

Best regards,

Rahal

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear SAM-MM1,

you need a abap report for it. Even query does not work because KONV table is not a cluster table.

Kind Regards,

Shiva_Ram
Active Contributor
0 Kudos

Try with ABAP query with logical database table VAV.

Regards,

jignesh_mehta3
Active Contributor
0 Kudos

Not possible with SAP standard reports.

You will have to go for Z-Report development.

Hope this helps,

Thanks,

Jignesh Mehta

former_member184701
Active Contributor
0 Kudos

dear friend,

as far as i know there are no such starndard reports (sales doc number + conditions)

you can go to sales order (VA03) and go to Items , Conditions- Analysis

or

try abap or sap query

take VBAK-KNUMV and goto KONV

take VBAP-KNUMH and goto KONP, KONH

where VBAK-VBELN (vbap-vbeln) is your sales document

good luck!