topic Re: va02 in Application Development and Automation Discussions

va02

former_member188827 — Wed, 14 Feb 2007 09:00:02 GMT

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

Re: va02

Former Member — Wed, 14 Feb 2007 09:03:05 GMT

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

Re: va02

Former Member — Wed, 14 Feb 2007 09:03:49 GMT

Try VBAP-NETPR field.

Re: va02

Former Member — Wed, 14 Feb 2007 09:07:22 GMT

First u get the document number from VBRK- KNUMV

Second u get values,from KONV or KONP

Rewards point it helps

Re: va02

former_member188827 — Wed, 14 Feb 2007 09:49:10 GMT

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?

Re: va02

Former Member — Wed, 14 Feb 2007 10:02:40 GMT

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

Re: va02

Former Member — Wed, 14 Feb 2007 10:05:57 GMT

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.