Report to display Sales orders based on pricing condition type

[nairharsha]

Hi Experts,
Please let me know if there is any standard report available to display pricing condition types for Sales orders. The requirement is to have a report similar to VA05 or enhance VA05 with additional selection field criteria to filter Sales orders line items having a particular pricing condition type.

I tried creating a pricing report in V/LA, using selection table 089 and also with table 099. However the custom pricing report is not displaying any result. This is the first time I am using V/LA, Please guide on how to proceed with this requirement, We are using SAP S/4HANA Extended Edition 1909 platform

[Lakshmipathi · Accepted solution]

Go to VBAK, Pass Sale order reference in VBELN to get KNUMV value. Next go to KONV and do the following

1. Pass KNUMV taken from VBAK to KNUMV
2. Input the pricing condition type in KSCHL

to get KBETR value which is your selling rate

With the above logic, you can develop a report, also considering VBAP, where the input parameters be Sales Org / Condition type and whatever fields you wanted

[yogananda]

nairharsha

Unfortunately, there is no standard report available to display pricing condition types for Sales orders. However, you could create a custom report to filter Sales orders line items based on the pricing condition type. You could use the pricing condition type from the Sales Document Condition table (VBAK-KONP) to create the report. Additionally, you could also add the selection field criteria to filter the Sales orders line items as per your requirement.