Report - SO which is having particular discount pricing condition type.

[pranaysap]

Hello Friends,

Requirement:

Our client wants to know all the sales order (in particular month) which is having particular discount pricing condition type

Query:

Is there any standard report is available for the above requirement from our client

Alternative:

If there is no standard report available, please find below our plan to create a Z report.

Please input your valuable suggestion on this

Step 1:

Select the field Doc. Condition (VBAK- KNUMV).

Step 2:

Input the results into field# Doc. Condition (KNUMV-KONV) in table#KONV along with the field#condition type (KONV- KSCHL).

So that we could get the list of sales orders which is having the particular condition types as per client requirement.

Thanks in advance.

[Lakshmipathi · Accepted solution]

No customized report is required. Execute SQVI, Data source should be Logical database and finally input VAV against Table/view and execute. All SD tables would be joined by doing so where you select KSCHL as both input and output parameters. You can also set any other fields like VKORG, VBELN etc as an input parameter.

[pranaysap · Accepted solution]

Thanks Lakshmipathi.