Proportion Allocation of stock in GATP Check

[Former Member]

Dear collegues

We have a requirment in GATP.We are currently using Product Allocation and ATP Check.

We have TWO group of Customers, Grp 1 and Grp 2.We have a single Storage Location, we need to check the stock in the storage location based on proportions.(Proportions would be maintained by the Users in Custom table)

Purpose of using the Proportions:

To ensure that Stock is consumed by the both customer Groups based on proportions.

As per the ATP, system will consume the ATP Quantity as per first in and first out.

Scenario:

For MaterialA , Stock = 1000, Proportions maintained for the Group 1 = 60% and Group 2 = 40%

When we perform GATP Check, system need to show the Available stock as 600 to the Grp1 Customers and Available stock as 400 to the Grp2 Customers.

Please kindly advice me if we have standard method to acheive above requirment or any user exit.

Thanks in advance.

BR

Kanth

[pavan_verma2]

HI Kanth,

In Product allocation you need to map the stock with allocated key figure example KCQTY (allocated quantity) as mentioned by Rishi ((/SAPAPO/LCOUT).

Let us assume your Total allocated quantity is 1000 so in planning book key figure KCQTY = 1000

Group A KCQTY (allocated qty) = 60% of total = 600

One way of doing is : This can be done using macros

Group B KCQTY = 400 then based upon your Storage Buckets Profile example daily the customer group can consume the allocation. The other factor is check date example MBDAT (material availability date)

If for Monday , customer Group A has consumed 600 pcs , then group A customer will get nothing.

customer Group B has consumed 300 pcs , then group B customer will have 100 pcs left.

Thanks

Pavan Verma

[Former Member]

Hi Kanth

In general product allocations are used to set an upper limit on demand - how much a customer/ customer group can order in a period, usually based on a forecast or allocation planning process.

What you are trying to do, is to set an upper limit on demand based on available supply. This is far more complicated because supply changes dynamically based on goods receipts, issues, etc. In theory what you could do is to get supply as a keyfigure into the Allocation Planning book. This can be done either through a ECC --> BI -->APO BI -->GATP Allocation Planning Book feed or converting APO order livecache data into time series (/SAPAPO/LCOUT). Remember that neither of these approaches are real time.

A better approach is to use Parameter Dependent Safety Stock (PASS) functionality - this allows you to hold back a certain portion of inventory depending on order parameters. Unfortunately, officially SAP supports this only for orders taken through CRM not ECC. Google up PASS and you may find a workaround. Needs prototyping and extensive testing.

As DB49 put it, you really need to think through all business scenarios across all functions - who sets the percentages, how will it impact delivery processing, how will backorder processing work, etc.

Rishi Menon

Edited by: Rishi Menon on Mar 29, 2011 10:17 AM

[Former Member]

Kanth,

I wonder if you have fully thought out this scenario, including consideration of continuous receipts into stock. What happens if customer from group 1 orders his 600, and then enters another order tomorrow? Does he get 60% of the remainder? What happens when newly received product appears in stock? How do you calculate what his 'share' of the new stock will be? What happens if customers from group 2 don't place an order?

Standard Allocation does not keep track of receipts, it only keeps track of confirmations. So, 60% of 'what' figure?

Standard allocation sets fixed maximum limits for the amount of stock that a customer or group of customers may receive a confirmation for in a given time period. These numbers are stated in terms of absolute quantities, rather than relative proportions. You may set these maximum limits proportionally, e.g. group 1 600 widgets, group 2 400 widgets, per period. In the long haul, the customers will be served according to your proportions. Short term (within a period), it may be that one customer gets more or less than his proportion would allow.

I am not aware of any standard functionality within allocation that will meet your requirements. There are allocation enhancements that might assist you, but you will have to map out all possible scenarios before you design the solution.

Good Luck & Best Regards,

DB49