How to create New condtion type

[Former Member]

Hi,

This is First project to me,

Bussiness requirment is : want to control & moniter the Minimum price for the material which they are selling, Sales people will maintain the FINAL price manually in the sales order.

How: while creatiion of the sales order thier should be a POP-UP, whether user is entered lower price for the material,

1) Need to create One condtion type ZMFB ( Mnimum FOB price) in sales order this condtion (new) will maintain month wise.

If the entered price in the sales order above ZMFB NO problem, if its less than ZMFB POP Up should be displayed.

2) Need to create another condtion which need to show difference of the price, of the ZMFB and enterded price ( positive or negative.

3) need to create a Z report to check the sales for monitering basis. whether our sales order is maintaing properly or not ( below the price/ above the price.

please expedite how to achive above scenarios in detail.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

1) Need to create One condtion type ZMFB ( Mnimum FOB price) in sales order this condtion (new) will maintain month wise.

You can create the CONDITION TYPE ZFMB in the transaction code V/06

In that condition type check the Condition type as Surcharge/disocount (A)

and check the Item condition

Now while assigning to the Pricing procedure maintain the alternative calculation type as 15 which will suite to your requirement

Means if the Base price condition has not reached the minimum value then the price will be de activated and ZFMB will be your price

If the Base price has reached to the Minimum price, then ZFMB will be deactivated and your normal condition will be in active

Need to create another condtion which need to show difference of the price, of the ZMFB and enterded price ( positive or negative

.

For this, you have to write a routine to show the difference price as Negative or positive.

Assign this to the newly created Condition type in the Alternative calculation type

Please check these two and revert back if you need more clarifications

regards,

santosh

[Former Member]

Dear All,

thanks for your response,

i will try your postings, and update when it finish

thanks again your valuable time spent on this issue.

Still

you can post your inputs for the above issue.

[Former Member]

Dear All,

Thanks to All who contributed,

Developed with ABAP.

[former_member318371]

Hi,

You can manage this with a single condition type only.

When you maintain a condition record using VK11 , after maintaining the basic details you press F6 or click on the details screen. There you can maintain the Lower Limit for this condition record. This activity can be dont on monthly basis.

Also you will have to maintain the routine 15 in alternate calculation type in the pricing procedure against this condition type.

The system will do automatic check ...Try doing this and post your testing results.

For reporting purpose explore the standard pricing reports available.

Regards,

Abhilash

[Former Member]

hi,

this is to inform you that,

this can be achieved by an ABAPER.

when ever your price comes lower than the rate which you want to sell then system will throw an error message that

MINIMUM PRICE CHECK IS LOW.

for difference you can use DIFF - condition type with 16, 13, 4 - routines - change as per your requriment.

then it will be very easy to create a Z report for the same.

please check with your ABAPER and confirm

balajia

[sushil_taneja]

pls see below some direction to each of your queries. for details (How for each required config node) I recommend you to go through the inline help and some references on the SDN itself.

1) Need to create One condtion type ZMFB ( Mnimum FOB price) in sales order this condtion (new) will maintain month wise.

If the entered price in the sales order above ZMFB NO problem, if its less than ZMFB POP Up should be displayed.

ST>> A condition type is linked to an Access Sequence, Condition table. to identify if the existing condition table can be used, you first have to identify the dimensions (apart from period) on which the price will be maintained. e.g. different price for different Product, Organization, etc... Then based on that you either chose to use existing condition table or create a new one.

After the condition type has been maintained, your users have to define the master data for this condition where the price will be defined for each month for which they expect to make the transactions (enter sales order).

In the sales order configuration, the pricing procedure should be modified to show this condition type.

Do some ABAP in the Order save user exit. read all the condition values (using the standard API or availabel parameters in the exit) of the current sales order and accordingly show the popup and through error to not to allow saving the document.

2) Need to create another condtion which need to show difference of the price, of the ZMFB and enterded price ( positive or negative.

ST>> to show the different in the pricing screen, this can be done within the pricing procedure configuration. you can assign rule and use internal variables to calculate the difference and show it in one of the line on the pricing screen.

3) need to create a Z report to check the sales for monitering basis. whether our sales order is maintaing properly or not ( below the price/ above the price.

ST>> if "1" and "2" are achieved, then this would be simple as you have to just read the existing orders and their pricing details.

based on the ZMFB price and the actual price in the document, you can show the relevant messages.

Strongly suggest you to first go through the pricing configuration (condition technique) documentation before you touch the above.

rgds,