What are the settings for Collective Product Allocation?

[Piyush]

Dear All,

In my project there is a specific requirement,

'In the given financial year any customer can't purchase more than prescribed volume [in ML] of particular group of products. This is a legal requirement.'

Moreover the products belonging to this particular group are having different volume [packing size].

I am trying to map this requirement through Collective Product Allocation. I have performed the following steps-

1. Created the Prodcut Allocation Object.

2. Created the Product Allocation Group with following characteristics -

    a. Prod.allocation obj.  - KONOB

    b. Customer - KUNNR

    c. Materail Group - MATKL

3. Created Product Allocation Procedure with the 'Step Sequence' having Wild Charactersitic as '#' for the Product Allocation Group created in    

    the point no. 2. I have maintained the Product Allocation object in the 'Control'.

4. I have created MPOS with the following characteristics -

    a. 9AKONOB Prod.  - Alloc. Object

    b. 9ASOPRDGRP - Product Group

    c. CUST - Customer

5. Maintain the CVC in MC62 for - Alloca. Obj. + Product Group + Customer

6. Created the new storage bucket profile [Monthly]

7. Created the Planning area using new storage bucket profile and MPOS. I had maintained the key figures as

    9AOCUSTDMD - Open Customer Demand

    9AVINVQLTY - 9AVINVQLTY

8. Created a new planning book having the planning area created in the point no. 7 with the key figures and characteristics which were used in the

    point no.7 and 4, respectively.

9. Maintained the connection to the planning area, created in point no. 7 with the Product allocation group, created in the point no. 2.

10. In the interactive demand planning I had maintained the planning data for the combination of Customer and Product group.

11. Performed the step of 'Transfer Characteristics combination from Planning Area'

12. Performed the step of 'Copy Data from Planning Area'

13. Maintain the Product Allocation Procedure in the Master Master in the ATP view for Cross Location for 2 materials.

14. Both the materials are having same Base UoM [EA], Check Mode and Checking group. Maintained Alternate UoM as ML.

15. Checked the Product Allocation Settings. No inconsistencies were found.

16. Checked the product Allocation situation for the Product Allocation Object, Customer and Product group. It is same as maintained in SDP94.

17. Ran the transaction /SAPAPO/ATPQ_COLLECT for collective product allocation.

Now when I am creating the sales order for the first material then it performs the allocation based availability check. But the check box 'Collective Product Allocation' is not checked.

So when I am entering the second line item then no Allocation based availability check is performed.

Can anybody help me to perform the Collective product allocation?

Thanks & Rgeards

Piyush Ranpura

[babu_kilari4]

Hello Piyush,

When we integrate the collective product allocations to DP, you need to have the CVC created for the wildcard character ( # ) as well. Unlike the traditional DP application, the downside of collective allocations is that you would not be able to do the aggregation here.

So, the aggregate ideally should be loaded at # # # level ( usually called as Catch all CVC ).

On top of this, usually if you have to force the allocation quantity to be set at intermediate level say customer 1, in this case you should load the Product allocation quantity in the planning book and use "fixing" of CVC keyfigure data.

Once setting up all these, you need to bring down the data to Product Allocation Group and make sure that the allocation figures are getting displayed correctly in //AC42 transaction code.

Last but not the least, I hope that you have added the wild card character in RSKC transaction code in APO.

Hope this information helps and please get back to us with a screenshot for any other questions. That helps us to see what is going wrong

Thanks & Best Regards,

Babu Kilari

[sourabh_jain66]

Hi Piyush,

The steps you mentioned are sufficient for collective product allocation to work, however you might want to check the sequence of steps.

Try using following sequence and check;

1. Performed the step of 'Transfer Characteristics combination from Planning Area'

2. Ran the transaction /SAPAPO/ATPQ_COLLECT for collective product allocation.

3. Check characteristics combination in product allocation group using transaction /SAPAPO/ATPQ_CHKCHAR - Characteristic Combinations (all characteristics combinations should be active including CVCs for collective product allocation)

4. In the interactive demand planning I had maintained the planning data for the combination of Customer and Product group. Make sure you maintain data for CVCs with wild card.

12. Performed the step of 'Copy Data from Planning Area' now as you will be having all the CVCs available in your planning area.

13. Maintain the Product Allocation Procedure in the Master Master in the ATP view for Cross Location for 2 materials.

14. Both the materials are having same Base UoM [EA], Check Mode and Checking group. Maintained Alternate UoM as ML.

15. Checked the Product Allocation Settings. No inconsistencies were found.

16. Checked the product Allocation situation for the Product Allocation Object, Customer and Product group. It is same as maintained in SDP94.

Please let me know if this helps, also if you still face some issue.

Rgds

Sourabh

[frank_horlacher]

Hi Piyush,

we describe the configuration of product allocation in the SAP Global ATP Check rapid-deployment solution.

http://scn.sap.com/rds-GATP

Have a look at the confguration guide

S63: Product Allocation for Global ATP

For detailed information on the installation order of our building blocks, refer to the               Prerequisites Matrix.

BR Frank

[satish_waghmare3]

Hello Piyush

For Collective Product Allocation to work as expected a key is how you define your CVCs.

Based on the details which you have mentioned, Is your CVCs look like below? Please check

ALLOC-OBJECT-NAME,  PROD-GRP1, CUST1

ALLOC-OBJECT-NAME,  PROD-GRP1, CUST2

ALLOC-OBJECT-NAME,  PROD-GRP1, ######

Let us say you have total availability for Product-Grp#1 = 1000 Qty  [ EA ],  and you have distributed allocations in following manner -
Cust#1 -                Alloc Qty has 300

Cust#2 -                Alloc Qty has 200

WildCard(####) -  Alloc Qty will be 500.  (All these allocation qty needs to be entered into the pbook and then transfer into PAG).

The remaining allocation qty(entered for wildcard # customer) of 500 can be availed by any customer (including Cust#1 and Cust#2)

This is the purpose of Collective Product Allocation.

I suggest you to use Tcode: /SAPAPO/AC42 and there you have a button "Collective Product Allocation. Please see what allocation quantity you see at collective level. Also please check this table /SAPAPO/QTTAB and verify Prod Alloc Qty and Incoming Ord Qty details for your CVCs.

SAP Help Link :

Characteristics Combinations for Collective Product Allocations - Product Allocation - SAP Library

Hope this will help.

Thank you

Satish Waghmare

[Piyush]

Hi Satish,

Thanks for your reply.

I am not at all distributing the quantity among different materials or customers.

Scenario is that Customer [here 0000000011] is entitled to buy total 120 litres of
materials GATP10 and GATP11 during the financial year. Both the materials are
having the same Base UoM and same material group. So in other words customer
can buy 120 litres of material group ‘xxxxxxxxxxx’. There could be any
combinations of GATP10 and GATP11

Like

   100 Litres   – GATP10 and 20 Litres          – GATP11

     45  Litres  – GATP10 and 75 Litres          – GATP11

0.250 Litre    – GATP10 and 119.750 Litres – GATP11

… and so on.

As per your mail, I have changed the CVCs. Now it comprises of material also.

My CVCs are -

PRD ALCN. OBJ                     Material                       Material Group            Customer

API_COL_PAO                        # [40 times #]             511097474                    0000000011

API_COL_PAO                        GATP10                       # [18 times #]             0000000011

API_COL_PAO                        GATP11                       # [18 times #]             0000000011

I have maintained the planning data at

API_COL_PAO                        # [40 times #]             511097474                    0000000011

[For material, I have maintained the wild card]

I have transferred the Characteristics combinations as well as copied the data from
Planning area.

I have maintained the Characteristics of collective product allocation.

Now when I am creating the sales order, for the first line item system works correctly. It
checks the Product Allocation as the Product allocation is appearing. Moreover the check box ‘Collective Product Allocation is flagged correctly. But when I am entering the second line item, the Product allocation is not happening. There is no product allocation data available. Whereas the check box ‘Collective Product Allocation' is flagged correctly for second line item.

I had also tested the same by repeating the same material in the second line item. Result
is same. It is not performing the Allocation check for the second line item.

Any idea, what could be going wrong?

Thanks & Regards

Piyush Ranpura

[Former Member]

Piyush,

Unless you wish to maintain sub-allocations for GATP10 and GATP11, it is not necessary to have 'Product' exist as a characteristic in your CVCs.  It is only necessary that

1.  Allocation has been configured and all data and CVCs appear in the Allocation Group.

2.  Allocation is activated in the appropriate Product Masters

3.  The product is a member of the Material Group

4.  The Characteristic (Material group) exists in the Sales document during the ATP check.

If you only wish to allocate by Material group plus customer, then the you only need three characteristics in your CVCs.  Wild cards are not necessary, and collective product allocation is not necessary.

So, assuming that both GATP10 and GATP11 both belong to Material Group 511097474, your CVCs would be

PRD ALCN. OBJ         Material Group                 Customer

API_COL_PAO               511097474                    0000000011

API_COL_PAO               511097474                    0000000012

API_COL_PAO               511097474                    0000000013   etc.

for multiple customers.   In general, one row per customer.  You would need to establish quantities for each customer that you allocate.  Other customers (customers that you don't establish an allocation) would then get zero confirmations for this material group.

As I recall, both Material Group and Material are by default contained in the Allocation field catalogue.  They can be expected to therefore exist in the Sales docs during ATP (my rule 4 above).  The relationship between Material and Material Group is defined in the R/3 Material Master. 

So when I am entering the second line item then no Allocation based availability check is performed.

According to your screen shot, your statement has slightly mischaracterized the actual results.  Allocation availability check was performed, but the system could not find any allocation available, so it would not confirm the order.  This implies that the second item (I guess this is GATP11?) found an allocation that was completely consumed, or it could not find any open allocation CVC at all.

Can you please display the results of the second ATP check (the one that fails)?  In particular, I need to see the Allocation situation that was searched and found/not found. This will display the characteristics that were used to find the allocation quantities.

Best Regards,

DB49

[Piyush]

Hi DB,

Thanks for your reply.

Inititally I had done without wild character also.

But I was facing the same issue which I am facing now.

So I had tried to the same using the collective allocation.

But there is issue for the confirmation for second line item.

First line item - GATP11

Second line item - GATP10

Thanks & Regards

Piyush Ranpura

[Former Member]

Piyush,

Your display indicates that there is sufficient allocation to confirm the order item.

Please display your check instructions and ATP for the failed material.  I suspect that allocation is not the problem, but that the confirmation is failing for another reason.

Best Regards,

DB49

[Piyush]

Hi DB,

The screen shot of ATP check and Check Instruction shows no error.

Any idea for the issue?

Thanks & Regards

Piyush Ranpura

[babu_kilari4]

Hi Piyush,

From the screenshot of the ATP, it looks like the confirmation from ATP is not being met. See the "Simulated requirements" item, there is no confirmed quantity against 25 EAs though you have an ATP of 2500 EAs. May I know if the Sales Unit of Measure in the sales document line item is same as the Base Unit of Measure in the APO system ? May be rounding is happening and that could be the reason you are unable to see the confirmation.

Since, ATP could not give any confirmation, the second step allocation check gets called with requested quantity as 0 (for allocation check).

Babu Kilari

[Piyush]

Dear Babu,

The issue has been resolved.

I had raised an OSS for the same.

SAP has reverted with an SAP note to be applied.

1845196 - Confirmation too high or low, assignmts in unexpct. periods.

It has been applied in the SCM system.

Contributions from the SCM community is really appreciated.

Thanks & Regards

Piyush Ranpura