Report of condition types per line item in sales order

[Former Member]

Hi all,

Is there any report that can tell me all the price conditions that are allocated to a sales order line item? I am talking about the actual conditions relevant for a line item, not only conditions that have a condition record setup.

So I would like to key in sales order number, the line item and get a report of all conditions that are allocated to that line item in the specific sales order.

If there is no such standard report, does anyone know what tables to link?

Thanks in advance,

Lars

[Former Member · Accepted solution]

Hi,

You need to go to VBAK first then take down the Doc. Condition number {KNUMV field} from there, then again SE16 -> KONV -> execute... you will get as you asked for.

Hrishi

[Former Member]

Hi Lars,

In my current customer they had the same requirement and after almost 1 month of analysis we decided to build a custom report to execute this.

And as an enhancement we compare prices from the sales orders and the sap price records in order to check the differences.

First we need to find all the open lines (status and reason for rejection (ABGRU)), than loop KONV and select the KSCHL (condition types) you want, material text descriptions, etc.....of course a lot more in terms of coding.....;-)

This was the form I used :

FORM FIND_SO_PRICES.

LOOP AT IT_ITEM_REPORT.

REFRESH IT_PRICING.

SELECT KSCHL KBETR WAERS KPEIN KMEIN KUMZA KUMNE

INTO IT_PRICING

FROM KONV

WHERE KNUMV = IT_ITEM_REPORT-KNUMV

AND KPOSN = IT_ITEM_REPORT-POSNR

AND KINAK <> 'M'

AND KINAK <> 'X'.

APPEND IT_PRICING.

ENDSELECT.

READ TABLE IT_PRICING WITH KEY KSCHL = 'XXXX'. -

---

> My price condition

IF SY-SUBRC = 0.

IT_ITEM_REPORT-ZSP1 = IT_PRICING-KBETR.

MODIFY IT_ITEM_REPORT.

ENDIF.

READ TABLE IT_PRICING WITH KEY KSCHL = 'XXXX'. -

---

> My discount condition

IF SY-SUBRC = 0.

IT_ITEM_REPORT-ZSD1 = IT_PRICING-KBETR / -10.

MODIFY IT_ITEM_REPORT.

ENDIF.

IT_ITEM_REPORT-LIQ = IT_ITEM_REPORT-ZSP1 - ( IT_ITEM_REPORT-ZSP1 * (

IT_ITEM_REPORT-ZSD1 / 100 ) ).

MODIFY IT_ITEM_REPORT.

ENDLOOP.

ENDFORM. " FIND_SO_PRICES

Please tell me if this helped you,

Regards,

Alcides Fialho

[Former Member]

Hi,

My requirement is to fetche the condition types for a line item in IPC Java userexit code.

I am developing a Java userexit of type Group Key Formula.

I need to check whether the item condition type is ZPPG or ZPWS.

However I am not able to fetch the condition types in my Java class.

Could any one please help me.

Gafar

[former_member217082]

Hi lara

Maintain your own info tructure and in that take the inputs at item level (VBAP) and take the outputs from item level in the case of pricing asper your requirement. Then your problem can be solved .

Another option is create a pricing report (V/LA) and then check wheather in the outcome you are getting your result or not

Regards

Srinath