MATP - Product availability check along with Allocation check

[former_member566355]

Hi,

The scenario is as below..

In check instructions of component ---

Product allocation check is maintained as step 1

Product availability check is step 2

Case 1 -

Component stock = 10

Allocation = 8

Sales order is created for header material = 12

In this case system is giving results as expected i.e. confirmed quantity = 8. Stock of 8 out of 10 is considered which is to the extent of allocations maintained.

Case 2 -

Component stock = 5

Allocation = 8

Sales order created for header material = 12

In this case system is putting entire quantity = 12 into missing parts list (i.e. component).

Why it is not confirming 5 based on receipt elements (i.e. stock) which is also within allocation quantity.

Same results are given even when check step are reversed i.e. product check as 1st step and allocation as 2nd step.

Regards,

RS

[former_member209769]

Hi RS,

Whether only stock would be considered as receipt also depends on your check control. It could have been possible that you also selected categories other than stock in check control, so the confirmation could be for a quantity higher than your stock. However, the allocation quantity should not be crossed in confirmation.

Check the following:

1) in SPRO, go to Advanced Planning and Optimization-> Global Available-to-Promise (Global ATP)-> Product Allocation-> Maintain Product Allocation Group.

2) Double-click on "consumption period" on left hand side.

3) See if some backward or forward consumption is maintained for the product allocation group that is being used in your product allocation check.

4) If you see a value maintained, then the product allocations available in the future or past (in periods as you see in product allocation group) would also be available for the Sales Order.

If this doesn't help you, then may be there is some data inconsistency, product allocations are not the same as what you think they are. First check the above and let me know if there are other allocations in future or past periods which could be used by Sales Order.

Thanks - Pawan

Edited by: Pawan Pathak on Dec 28, 2011 9:16 AM

[former_member566355]

Hi Pawan,

There are no allocations maintained in other periods (both past and future).

Allocation situation is correct in APO.

Also, though SNP planned order is also contained in check control along with stock as receipt elements, there are no planned orders in this case.

Also as given in case 1, system is confirming 8 units out of the stock as a receipt element. And this is to the limit of allocations maintained. Further, the consumption is correctly updated in product allocatio group (and subsequently displayed in planning area) in APO.

So what can be the reason for the component quantity being shown as missing parts in 2nd case?

Regards,

RS

[former_member209769]

Hi RS,

Sorry, my mistake. I missed above that you had mentioned that 12 is coming as missing.

As a cross-check, could you still check what is the product alloaction situation for your product allocation group?

This can be checked in /sapapo/ac42 for your product allocation group and material (along with other selections).

Also, go to /sapapo/ac06, and see if there are any temporary quantity assignments (TQA) against your product (both for product availability and product allocations). Give the "from" generation date as sufficient time in the past and give user name as blank (not *).

If some TQA exist, these should be deleted.

When you create the Sales Order, select the line item. Then click on "ATP check" and in the ATP check screen, click on "product allocations". This would show the product allocations situation for Sales Order. See if this matches the expectation.

Thanks - Pawan

[Former Member]

Hi RS

Could you please share Check Instruction config in terms of

1) Set-up under "Production" section

2) Set-up under MATP - Components Remaining Requirement, Conversion Mode

3) Do you have any rounding profile active (standard set-up or some custom logic)

Please check ATP Tree structure as well (GATP -> Environment -> Technical Monitors).

Thanks,

Prasun

[former_member566355]

Hi Pawan,

thanks. It was happening due to TQA. Results are correct after deleting TQAs through deletion of the ATP tree.

But I would like get clarification on the following 3 points,

1. Why the TQAs not getting deleted even after SAVING the sales order for the parent material because these are temporary assignments till the time sales orders is getting processed.

Is there any standard process to be followed in order to take care of this;may be like background job to delete TQAs?

2. Why in the 1st place, the ATP tree itself remains (showing as active) in APO even after CLOSING (through reason for rejection) the sales order ?

Because when sales order is deleted the stock reservered at component level should also be available (released) for other sales orders which is not happening because of TQAs.

3. Can we see sales order (which is for FG) wise stock (reservation) for the component ?

Awaiting your insights.

Regards,

RS

Edited by: sap_apo31 on Dec 29, 2011 6:34 AM

[former_member209769]

Hi RS,

Explanation as below:

1) In ideal scenario, TQA should not exist after the relevant processing for Sales Order is over, but sometimes the whole process doesn't complete successfully, and TQAs still remain. It's something like why SAP had to provide reconciliation report (CCR). In ideal scenario, one would not expect reconciliation to be run, and systems should always remain in sync. But still CCR is required almost everywhere with varying frequency depending on how robust your design is.

In our case, we have scheduled a job for program /SAPAPO/OM_DELTA_REMOVE_OLDER (corresponding to AC06). Selection options - product availability, product allocation, planning. type of temp qty assignment - all 4 types selected. Persistency indicator - non-persistent and post- persistent. We delete all TQA older than 8 hrs. And we have also selected the option " display deleted qty assignments" to keep a log in spool. Job runs once in a day. You could also use the same to avoid manual actions for TQA.

2) Explanation above. Sometimes the whole loop doesn't take place due to certain reasons.

3) I think the closest you would get is the "Display Availability" option. When you are in Sales order (VA01/02/03), select the Sales order item and choose the option "display availability". This is a button towards the bottom (in between "schedule lines" & "item availability"). This will give you an aggregated view. You can click on "single records" option on the top to see the confirmation for Sales Order/delivery at individual order level. GATP is real time, so it's possible that some order for later date would have got confirmed (if it was created earlier), but an order for earlier date was not confirmed (since it was confirmed late). If you want that orders should get confirmed by some criteria like customer priority, requirement date, etc, then you would need to consider BOP to make such changes. You could run such BOP daily or weekly at an appropriate time.

Hope this helps.

Thanks - Pawan