topic Re: values in table in Application Development and Automation Discussions

values in table

Former Member — Sat, 29 Mar 2008 08:34:05 GMT

I have order no , Keeping this how we can access the

List Price , discount , Unit Price from the table KONV or KONP

table

Is there any other table to pickup the above details

Thanks in advance

Re: values in table

Former Member — Sat, 29 Mar 2008 08:37:40 GMT

konp-kbetr (price)

Re: values in table

Former Member — Sat, 29 Mar 2008 08:39:39 GMT

Hi,

do the following code.

data : kbetr like konv-kbetr.

select single * from vbap where vbeln = orderno.
if sy-subrc eq 0.
select * from vbap where vbeln  =  vbak-vbeln.
select single * from konv where KNUMV = vbak-knumv and
                                              kposn = vbap-posnr and
                                              kschl = dis_type.
kbetr  =  konv-kbetr / 100.

endif.
endif.

Regards,

Morris Bond.

Reward Points if Helpful.

Re: values in table

Former Member — Sat, 29 Mar 2008 08:41:13 GMT

Hi,

Just go to the order table and find the field as KNUMV. Then table into the table KONP,KONV.

Regards,

Sankar.

Re: values in table

Former Member — Sat, 29 Mar 2008 08:42:01 GMT

hi check the table..KONP

fields are

Sales Price VKKAL

Cumulative guaranteed discount FKWRT

regards,

venkat