topic Re: with konv,konp tables in Application Development and Automation Discussions

with konv,konp tables

Former Member — Fri, 18 Jul 2008 09:48:48 GMT

hi.

i am developin a smartform for credit note. in maiin window i suppossed to populate the price (MRP) based on the condition type VKPO. i need to retrieve the price for vbrk-vbeln.

can anyone help me , how to do that

Re: with konv,konp tables

Former Member — Fri, 18 Jul 2008 09:53:22 GMT

jyothsna,

use KNUMV and KPOSN field .KNUMV is available in VBRK and KONV both and comapre KPOSN with VBRP-POSNR.

Amit.

Re: with konv,konp tables

Former Member — Fri, 18 Jul 2008 09:56:39 GMT

hi,

get the KNUMV (Number of the document condition) from vbak for the credit note number .......then next go to KONP table

match the record with KNUMV and kschl = 'VKPO' and get the value

Re: with konv,konp tables

Former Member — Fri, 18 Jul 2008 10:03:15 GMT

Hi Jyothsna,

You need to consider line item also while retrieving the conditionproce, coz for every line item conditional value differs.

Please find the below sample code for your reference

Select vbeln posnr knumv from vbrk inner join vbrp

on condition vbrk_{vbeln = vbrp}vbeln

into table ivbrp where <condtion>

if ivbrp[] is not initial.

loop at ivbrp.

select knumv kposn kawrt kbetr from konv into w_konv

where knumv = ivbrp-knumv and

kposn = ivbrp-posnr and

kschl = 'VKPO'.

endloop.

endif.

Hope the above will help you.

Regards,

Sujatha

Edited by: Sujatha Reddy on Jul 18, 2008 12:49 PM

Re: with konv,konp tables

Former Member — Fri, 18 Jul 2008 10:08:12 GMT

thanks for ur reply sailaja.

from which field i should get the price. is there anu necessary to use the table A073. in which cases we use this table?

being an abap fresher i wold like to know the details clearly. can u explain

Re: with konv,konp tables

Former Member — Fri, 18 Jul 2008 11:12:49 GMT

Hi J ,

tables started with A* is for 'Z' condition tables , while creating the access sequence u will need to create a table, In case of Z conditions u need to get the data from these A* tables.

regards

Prabhu