Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

values in table

Former Member
0 Likes
508

Hi

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

4 REPLIES 4
Read only

Former Member
0 Likes
478

konp-kbetr (price)

Read only

Former Member
0 Likes
478

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.

Read only

Former Member
0 Likes
478

Hi,

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

Regards,

Sankar.

Read only

Former Member
0 Likes
478

hi check the table..KONP

fields are

Sales Price VKKAL

Cumulative guaranteed discount FKWRT

regards,

venkat