Delivery ticket

Former Member — Mon, 23 Jul 2007 16:36:58 GMT

HI,

This is my requirement,

Issue 1...Min Days

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

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.

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

Issue2...Min Charge

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 ????

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

Issue3 ...Add’l Day Charges

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...

Re: Delivery ticket

Former Member — Mon, 23 Jul 2007 17:03:45 GMT

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

where knumh = itab1-knumh.

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

Reward points for useful Answers

Regards

Anji

topic Delivery ticket in Application Development and Automation Discussions

Delivery ticket

Re: Delivery ticket