Conditions in Sales Document (Item)

[Former Member]

Hello, SAP Gurus,

Is there any standard SAP report i could use to make a query on:

A group of sales orders, and showing me the values for 1 condition type for items in those orders?

Due to considerable order amount, we do need such report instead of check the order one by one.

This is used for shipping cost (Z condition type) validation purposes.

Many thanks,

Vincent

[Former Member · Accepted solution]

hello, friend.

try tcode SQVI. link tables VBAK and KONV. the linking field between these tables would be KNUMV.

so, if you have a group of sales orders, #315 to 350, each order in will have it's own KNUMV. the query will then look for a KONV record with the matching KNUMVs.

you specify the condition type in field KSCHL, let's say PR00.

when you execute the query, the system will generate a report for your sales orders, with condition type PR00 for a given number of materials.

regards.

[Former Member]

Hello,

This is a good answer. I think the only way to have this informatoin is via Query then.

No way to use SE16 for a structure or other comparable workaround, coreect?

Best regards,

Vincent