va02

[former_member188827]

hi

im making a report in which i hav to print rate per unit from va02.when i get technical info it is the amount field of line item(komv-kbetr) which is a structure. i need to know da table which contains dis value...can ny help....

points 'll b rewarded.

rgds

Message was edited by:

abapuser

[Former Member]

HI,

Take the Value of KNUMV field from VBAK for that order. and Go to KONV table, pass that KNUMV to it and you will get the RATE field value in KBETR field.

Regards,

Anji

[former_member188827]

hi

i followed wat u said but da rate i get is 332 whereas on va02 it is 8...

can u suggest wat da problem cud b?

[Former Member]

Hi,

in KONV the Values will be stores based on Condition Types(KSCHL) field.

So for a single Value of KNUMV you will get multiple entries/records in KONV table. So enter the Item No(KPOSN) which is nothing but (VBAP-POSNR) and the Condition Type(KSCHL) field also.

Check all the records whether any record have KBETR value equal to 8...

Regards,

Anji

[Former Member]

Try VBAP-NETPR field.

[Former Member]

hi

First u get the document number from VBRK- KNUMV

Second u get values,from KONV or KONP

Rewards point it helps

[Former Member]

table is KONV .

did u tried anji reddys solution .

take a sales order number .

take the VBAK -KNUMV field of that so

<b>submit it to KONV-KNUMV and KONV-KBETR is per unit price .</b>

parallely open a SO in VA03 and check the same

see the unit price multiplied by the net quantity is the net price for that item .

regards,

vijay.