Scaling Problem in SD function Routine

[Former Member]

Hello Friends ,

I am using the below code for my req in order pricing.

Requierment is something like that : i have to find the quantity of order which not having some condtion types, after getting the quantity i have to find the scale % based on the quantity and pass the % into the field to meet req. For getting the scale % i am using select query .

can we use select in rountine if yes then the problem is that the same thing have to be apply in java IPC which not posbl, if no then can any one send me any soln.

xvakey(10) = xkomv-knumh.

xvakey+10(2) = xkomv-kposn.

xvakey+15(1) = 'X'.

xkomv-kmprs = 'X'.

clear l_discount.

read table tkomv into ls_komv

with key kposn = xkomv-kposn

kschl = 'ZPWS'.

if sy-subrc = 0.

xkomv-kbetr = l_discount.

exit.

endif.

read table tkomv into ls_komv

with key kposn = xkomv-kposn

kschl = 'ZPPG'.

if sy-subrc = 0.

xkomv-kbetr = l_discount.

exit.

endif.

clear l_ordqty.

loop at tkomp into ls_komp.

clear l_flag.

read table tkomv into ls_komv

with key kposn = ls_komp-kposn

kschl = 'ZPWS'.

if sy-subrc = 0.

l_flag = 'X'.

endif.

read table tkomv into ls_komv

with key kposn = ls_komp-kposn

kschl = 'ZPPG'.

if sy-subrc = 0.

l_flag = 'X'.

endif.

if l_flag is initial.

l_ordqty = l_ordqty + ls_komp-mglme.

endif.

endloop.

select single knumh

into l_knumh

from a512

where kappl = 'V'

and kschl = 'YVRD'

and vkorg = tkomk-vkorg

and vtweg = tkomk-vtweg

and matnr = tkomp-matnr

and datbi <= sy-datum.

select *

from konm

into table lt_konm

where knumh = l_knumh.

sort lt_konm by klfn1 descending.

clear l_discount.

loop at lt_konm into ls_konm.

if l_ordqty >= ls_konm-kstbm.

l_discount = ls_konm-kbetr.

exit.

endif.

endloop.

xkomv-kbetr = l_discount.

[JoffyJohn]

you can write select in routines

[Former Member]

Is there any other way to find scale rather using table.

[Former Member]

Shilpi..

In case you dont want to use tables..... then i think it would be better if you post this query

in SD section where SD experts might be able to give you little more insight....

Cheers..

[Former Member]

Hi,

It is not the best pratice to write select query's on the condition sequence tables to fetch the scaling values. Generally this job will be carried by the standard SAP code dynamically as the condition sequence (Eg A512 , A513.... ) may be changed in future.

You have to find the rouitne where in the the condition number and value will be visible in a routine for a particular condition type to meet your requirement.

With Regards,

Dwarakanath.S

[Former Member]

Is there any table for storing the condtion number . this is group condition rountine so there is no othr rountine for that,