Application Development 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: 

Delivery ticket

Former Member
0 Kudos

HI,

This is my requirement,

<b>Issue 1...Min Days</b>

*********************************************************************************

1)Select KNUMV from VBAK where VBELN = Rental Order

2)Select KNUMH from KONV where KNUMV = Pricing Condition Record from Sales Document and KSCHL = “ZREN”

3)Select KSTBM from KONM where KNUMH = Condition Record from Condition Table where the Pricing Condition Record was selected from – Consider first record from the resulting selection

I could understand the 1st & 2nd statements,But i could not understand the 3rd condition.

I dono what to pass in the where condition.

*********************************************************************************

<b>Issue2...Min Charge</b>

Minimum daily rental amount to be charged for the Minimum number of days a Tool / Equipment is rented

Min Charge – KONM-KBETR

Refer to Min Days access and select KONM-KBETR

How to get min charge ????

********************************************************************

<b>Issue3 ...Add’l Day Charges</b>

Daily Rental Amount to be charged for each additional day if Tool / Equipment rented over the minimum number of days

Add’l Day Charges – KONM-KBETR

Consider second record when selecting from KONM

Refer to Min Days access and select KONM-KBETR

How to select second record from KONH???????

Could you guide me on that.

Regards,

Ashok...

1 REPLY 1

Former Member
0 Kudos

Hi

fetch the data as follows

select vbeln knumv from vbak into table itab where vbeln = p_vbeln.

if not itab[] is initial.

select knumv kposn kbetr kwert knumh from konv into table itab1

for all entries in itab

where knumv = itab-knumv.

endif.

if not itab1[] is initial.

select knumh kbetr kwert from konm into table itab2

for all entries in itab1

<b>where knumh = itab1-knumh.</b>

endif.

take the records from konm and sort the table entries by kbetr.

so take the record where the rate KBETR is less among all entries

<b>Reward points for useful Answers</b>

Regards

Anji