Product allocation

[Former Member]

Guys,

I am asked to do product allocation at customer heirarchy 4 and 5 levels. the sales order created for level 4 and 5 customers should be populated in gatp planning area in sales order quantity field to calculate open allocation which is done at 4 and 5 levels

i have done this for ship to and sold to successfully. But when we talk abt 4 and 5 levels there will be many customers in a level. Will the sales order for these levels can be transferred to GATP planning area? Pls confirm

Thanks

Shruthi

[Former Member · Accepted solution]

Shruthi

Check table /SAPAPO/KOMGO for the standard list of fields that are transferred from ECC to APO during the ATP check. All of these fields can be used for product allocation.

If the field you want is not in this list, you can extend the field catalog using instructions in OSS Note 179469.

Rishi Menon

[Former Member · Accepted solution]

Thanks Rishi,

product allocation is done for customer heirarchy 4 and 5. based on the allocation when i create the sale order i want the sale order quantity to be published in gatp planning area key figure. only then i can calculate the open allocation. pls advise

Cheers

Shruths

[rajkj · Accepted solution]

Hi Shruthi,

Pl check the following procedure.

1. Maintain your product allocation group with required characteristics to represent your customer hierarchy.

2. Ensure that your planning area (PA) consists of all the characteristics that you maintained for prod allocation group (PAG)

3. Establish connection between PAG and PA and map the characteristics as well as key fig

4. You can either copy valid characteristic value combinations (CVC) from PAG to PA or create them using t.code /SAPAPO/MC62

5. Transfer data (incoming order quantity and prod allocations) to PA. The data will be copied at defined level, however, it will be rolled up appropriately at higher levels based on the active CVCs.

6. Using the planning book associated with your PA and selection profile, you can access the sales order quantity at any required level (from top to detailed). Based on your CVC, the quantity will be aggregated and displayed.

7. If you want to plan the product allocations at higher levels than the defined level, maintain the key figure settings (calculation type and time-based disaggregation) for your PA appropriately so as to disaggregate the planned prod allocations at detailed levels (i.e. defined CVC level).

8. Transfer the product allocations back to your PAG (the active CVC will influence the data receipt).

You are transferring SO quantity at detailed level, but the system rolls up the data into required higher levels in the PA. It allows you to plan the product allocations  at higher levels and transferred back to the PAG at detailed level.

Thanks,
Rajesh

[Former Member · Accepted solution]

Rajesh,

Thank u soo much for ur guidance. My doubt is,Allocation happends at cust heirarchy 2, 3 levels. But sales order is created for sold to and ship to levels. Now if i want the sales order quantity to be published in the planning area by transaction code /SAPAPO/ATPQ_PAREA_R. Will i get the sales order quantity exactly in the key figure dedicated on customer heirarch level 3 allocation. Let me know if there are suitable user exits.

Thanks

Shruthi s

[Former Member · Accepted solution]

Rajesh,

To be more precise, The allocation itself is done at customer heirarchy level 2 and 3. But sales orders are created at level 6 which is sold to party. So when the sale order is created it needs to check allocation for 2 and 3 levels and consume at the same level. I hope its clear.

Thanks

[Former Member · Accepted solution]

Shruthi

Like I said before, check if customer hierarchy 2 & 3 fields are available in /SAPAPO/KOMGO table. If they are, it means its part of the field catalog - the set of fields that ECC 'sends' to APO for the ATP check.

If its not available there you can extend the field catalog using instructions in OSS Note 179469. SAP provides a user exit by which you can look up the customer hierarchy 2/3 at run time when the sales order is taken and transfer that to GATP.

Rishi

[rajkj · Accepted solution]

Shruthi,

Assume, there is a simple allocation procedure with one step associated with a PAG consisting of required characteristics that represent your top customer hierarchy levels (for instance, top 3 levels namely customer group, national customer, and regional customer) and defined with valid consumption periods. If field catalog does not consist of the required parameter, you need to follow Rishi's suggestion to enhance your catalog. This allocation procedure is associated with (location) product masters in APO. This PAG is also connected to a valid planning area (as explained in the previous post) and maintained product allocations for the active CVC (i.e. combinations of customer group, national, and regional).

The ATP check of a sales order (that is created at sold-to level) triggers check method execution in APO. In case of product allocation, it first check the (location) product master record to retrieve the allocation procedure and associated PAG. Based on the mapping between field catalog and characteristics, the  product allocation (that you planned in DP planning area and transferred to PAG) is retrieved and checked against the sales order quantity and subsequently the product allocation is consumed.

Thanks,
Rajesh

[former_member209769 · Accepted solution]

Hi Shruthi,

I think you are not clear about the settings for aggregation and disaggregation. Let me try to explain.

If you maintain allocations for certain values of hier 2, 3 levels, that means you maintain it for the relevant CVCs having that particular selection of hier2, 3 values. If your CVCs contain Hier4, 5 or 6, automatically the allcoation is now available for hier4, 5 or 6 also, since they are available in the CVCs which contain hier 2, 3.

Assume you have 3 CVCs like below (Assuming a simple example having only hier2 & hier4 to explain the concept):

Hier 2    Hier4

H21       H41

H21       H42

H22       H43

Assume that you maintain allocations against hier2 value H21 for 20. Then this 20 is available for the 2 CVCs H21-H41 and H21-H42. If you had pro-rata disaggregation and initially the values of allocations were zero, then for both the CVCs, you would have 10 allocation maintained.

So, for H21-H41, allocation = 10, and for H21-H42, allocation = 10.

If you maintain an allocations against H22 for 20, it's available against the CVC H22-H43. So, for H22-H43, allocation = 20.

When your incoming sales order would provide the hier 4 value as H42, then allocation consumption would happen against the allocation of 10, and it would get reduced as per your confirmation.

Similarly, when a Sales Order would come with Hier 4 value as H43, it has 20 quantity available as allocation.

Hope this helps in explaining the concept of CVC, and aggregation/disaggregation.

Other experts already mentioned settings for GATP, so if you now understood the way Key Figure data is stored against CVC, I hope you shouldn't have any more doubts.

Thanks - Pawan

[Former Member · Accepted solution]

Thanks Rajesh,

The field catalogue for all levels are maintained.

So u mean to say, In the location master if i maintain step sequence which i have maintained in the config.. it should consume and work the way i want.. Let me test this and get back to you. i have allocation group and procedure at all levels of heirarchy and step sequence is from heirarchy 4 to 2. I'll test this and get back to you soon thanks

Shruthi

[rajkj · Accepted solution]

Shruthi,

To start with, consider using a simple allocation procedure with just one step and PAG associated with required characteristics only.

Thanks,
Rajesh

[Former Member · Accepted solution]

Rajesh,

I tried product allocation with 1 step. i have assigned in the product master cannel allocation procedure and in the step i have defined customer level 4. Now allocation is working fine for channel but it is not allocating to any of the avove steps i am getting an error message as follows.

Characteristics combination for item 051Mim7o7j6bjNUNyUpZL0/ was not found

Message no. /SAPAPO/ATP201

Can u throw some light pls

[Former Member · Accepted solution]

Anu user exits to link customer heirarchy to sales order doc.?

Thanks

shruths

[Former Member · Accepted solution]

Hi Shruthi,

Pls see following User Exits:

APOQT011  Product Allocations: Compare Parameters Tra
APOQT012  Product Allocations: Check Product Allocati
APOQT014  Product Allocations: Compare Product Alloca
APOQT018  Product Allocations: Check/Find Characteris
APOQT021  Product Allocations: Check Product Allocati
APOQT022  Product Alloc.: Check Consumption and Start
APOQT023  Product Allocations: Check Consumption and
APOQT024  Product Allocations: Compare Consumption
APOQT032  Product Allocations: Results Check
APOQT033  Product Allocations: Check Seq. of Product
APOQT034  Product Allocations: Compare Results Check
APOCF007  Inbound Processing: Product Allocations
APOQT035  Compare Sequence of Product Allocations Procedures
APOMD004  User Exit: Output of Customer-Specific Fields, Location
APODM002	Generate Planning-Relevant Characteristic Combination
APOCFPCO  Enhancement: Sales Order Publishing
APOCF025  User-Specific Enhancements: Sales Orders
APOCF010  Inbound Processing: Sales Orde
APOBP008  Enhancement for Sales Order BAPIs (BUS10501)

[rajkj · Accepted solution]

Shruthi,

1. Characteristics check:

Have you checked your PAG characteristics in the structure /SAPAPO/KOMGO? The fields of this structure are populated by incoming sales order. If not available, you can enhance that structure as described in the following SAP note.

https://service.sap.com/sap/support/notes/385039

2. Collective characteristics

Please ensure you have collective characteristics in your PAG (t.code /SAPAPO/ATPQ_COLLECT)

3. PAG active characteristics

Use t.code /SAPAPO/ATPQ_CHKCHAR to verify the active characteristics combination

If the problem still exists, please provide screenshots and characteristics used. 

Thanks,

Rajesh