"*Issue calculation for statistical value":*

[Former Member]

I have calculation for statistical value for Romania asked by my client, which is calculated on

Net value + Value of Freight material = Statistical Value

But if the value of the freight material is not there then I need to minus 300 euros form the net value for all Incoterms

I have created

1) Condition type ZCM1 For freight material with keys (Sales organization, Distribution channel and material)

2) Condition type Z007 for freight calculation (minus 300) (with keys Sales organization, Distribution channel, Country, Incoterm)

And I have also created a pricing routine, which says if the value of condition type ZCM1 is there ignores condition type Z007

The issue is when I am creating sales order for two line items one with stander material and one with freight material. The line item with stander material is trigging Z007, which I donu2019t want

• I have maintain the condition recorded of both the condition type. For ZCM1 freight material

Please help, how to take care of this requirement

Many Thanks

For your help

Krushna

[Former Member · Accepted solution]

Hi,

Try to find out a field (like material group etc) which is unique in Freight material and keep it in both the condition tables which you created. The fields which you selected are in general every where we can use.

And maintain the routine as it is to restrict any one condition type for freight material to execute.

Hope this will help you.

Venkat Cheedalla.

[Former Member]

The solution is to create the pricing routine and right below code. Thank you gus for your help

FORM KOBED_931.

*{ INSERT DCOK950387 1

*Check for ZCM1 and ZCM8, if they exist then you have to suppress Z007

CONSTANTS: lc_zcm1 TYPE kschl VALUE 'ZCM1',

lc_zcm8 TYPE kschl VALUE 'ZCM8'.

DATA: lw_konp TYPE ext_konp,

l_flag TYPE c,

l_set TYPE c VALUE 'X'.

LOOP AT xkonp INTO lw_konp WHERE ( konp-kschl EQ lc_zcm1 OR

konp-kschl EQ lc_zcm8 ).

l_flag = l_set.

EXIT.

ENDLOOP.

IF l_flag EQ l_set.

sy-subrc = 4.

ELSE.

sy-subrc = 0.

ENDIF.

*} INSERT

ENDFORM.

FORM KOBEV_931.

*{ INSERT DCOK950387 1

*Check for ZCM1 and ZCM8, if they exist then you have to suppress Z007

CONSTANTS: lc_zcm1 TYPE kschl VALUE 'ZCM1',

lc_zcm8 TYPE kschl VALUE 'ZCM8'.

DATA: lw_konp TYPE ext_konp,

l_flag TYPE c,

l_set TYPE c VALUE 'X'.

LOOP AT xkonp INTO lw_konp WHERE ( konp-kschl EQ lc_zcm1 OR

konp-kschl EQ lc_zcm8 ).

l_flag = l_set.

EXIT.

ENDLOOP.

IF l_flag EQ l_set.

sy-subrc = 4.

ELSE.

sy-subrc = 0.

ENDIF.

*} INSERT

ENDFORM.

[Former Member]

Add material as key field for z007 so that you can maintain cond record of z007 only for freight materials and the same need not to be maintained for std material.

[Former Member]

Thank you Guys for you answers,

Monalisha,

Actually my clientsu2019 requirement is when freight material is there in the sales order there is no need to add value condition type Z007, If freight material is not there then I need to minus the value of condition type Z007 from net price with out affecting the standard material (or line items)

Hence putting the material in the key field of Z007 would not solve my purpose

Thanks u

For your interest in the issue

Krushna

[Former Member]

Any othre answer please

Thanks

Krushna

[Former Member]

Please help with this issue

Thanks

Krushna