Logic to write routine

[Former Member]

One more query i have in same pricing procedure ...

Beloe is my Pricing procedure :

Condition Type Description Amount Reference KE24
ZTAG Tag Price 1,200 Tag Price
ZDIV Normal Discount -840 Trade Discount 
PR00 Price 360 Revenue
ZDIR Discount rate  
RP00 Repair Charges 100 Repair Charges
RDIV Repair Charges - Discounts -20 Repair Chgs - Discount
ZNRA Free Goods -90 Free Goods
Net Value 1 350 
ZHA0 Additional Discount (%) -20 Spl Offer Discount
ZHB0 Volume Discount  -50 Material Discount
Gross Value  280 
ZH01 Freight Charge 30 DSC Frieght 
ZH02 Insurance Charge 45 DSC Insurance
ZH03 Packing Charge 30 DSC Packing
ZH04 Courier Cost 25 DSC Frieght 
ZH05 Miscellaneous Charges 20 DSC Misc Charges
Net Value 2 430 
MWST Output Tax 30 
Total 460 
VPRS Internal Price 180 Stock Value
Net Difference 280 
Gross Margin 100 
Gross Margin % 36% 

1:- ANet Difference: bove is my requirment where in NET difference is : Total(460) - VPRS (180) = 280, to get this    value i have created another condition type ZVRS (copy of VPRS) and maintained condition records as      -100%  (To get value of VPRS as Negative)  BUT THIS LOGIC IS NOT WORKING.

2:- Gross Margin: Gross Value (280) - VPRS (Internal price-180) = 100.Kindly provide the logic.

3:- Gross Margin % : Gross Margine/ Gross value .

Thanks & Regards,

Geeta Singh.

Contact number: +919820051350

[eduardo_hinojosa]

Hi

Avoid use VPRS as a basis for further pricing (see note 1365939). Define ZVRS as a formula. For instance, it's so complex but I suggest you to see the pricing procedure  RVAAAR for Argentina (TCODE V/08). You have the conditions (see them in V/06) J1AU for taxes and J1AX where it's calculated again using the formula 333 (see it in VOFM). Use this example as a template.

I hope this helps you

Regards

Eduardo

[Former Member]

Hi,

Client required condition VPRS and that is done my query is below.

Step    CType     FM    TO     Subtotal    Reqmt   CalType

150       ZHA0     110     149                                            

160       ZHB0

          Gross      110      160       5 -Subtotal

.                                                           

.                                                                

.

450      VPRS                                                   4-Req

452      ZVRS          450              6-SubTotal

520     Gross Margin        210     450                                   81-CType

530     Gross Margin %    ----?

I need gross margin in %  Step No 530 =Gross margin step no  520/ step no 210 that is gross value

and step 210 is already assigned SubTotal 5.

Please help.

Regards,

Geeta Singh.

[Former Member]

Hi Geeta,

To fullfill your requirement, you supposed to follow below steps:

1) Infront of step 520 enter subtotal as D

2) Add the Alternative calculation routine infront of line item 530 and enter logic as

Form frm_kondi_wert_9**

if xworkd ne 0

xkwert = xworkd * 100 / KOMP-KZWI5

else

xkwert = 0.

endif.

endform

Abve logic suppose to work to calculate the gross Margin in %. Please let me know, whether it is working or not?

Regards,
Amit

[Former Member]

Hi Geetha,

Do you require any more information in this then please let me know.

Regards,
Amit