Getting Price from KONV table for Purchase Order

[Former Member]

Hi All,

I have to use the KONV table to get the Net Price for the Purchase Order Line Item. I am confused over the field KONV-KBETR because for Currency 'JPY' it shown a wrong figure. This is how I read the KONV table;

SELECT SINGLE KBETR

INTO ITAB-KBETR

FROM KONV

WHERE KNUMV = EKKO-KNUMV and

KPOSN = EKPO-EBELP and

KSCHL IN ('PBXX', 'PB00').

The Correct figure should be 3,000 but it shows 30. For all other currencies it works fine. What should I do to arrive at 3,000 simply I could always multiply KONV-KBETR by 100. But this would affect for other currencies.

Thanks,

Kishan

[Former Member]

check for currency , if it is 'JPY', MULTIPLY IT WITH 100, for other currencies let the price be same.

it seems that this currency is showing percentaage price.

[Former Member]

Hi Venkat,

Thanks your points awarded. Only your solution could be implemented.

[former_member181962]

Try to retrieve the value KWERT and see.

Regards,

ravi

[Former Member]

Hi Sri,

I think, for PO line item, you need to check the amount in KONP table.

Regards

Chandra.

[Former Member]

hi sri , check this

SELECT SINGLE kbetr INTO i_konpc-kbetr

FROM konp

WHERE knumh EQ -knumh AND

kappl EQ -kappl AND

kschl EQ -kschl AND

loevm_ko NE 'X'.

remember in pricing u need to exclude the deleted line items ..

loevm_ko ne 'X' this is very important ..

may be u need put a converting factor for JPN

regards,

Vijay