CO09- Cumulative ATP Quantity

[Former Member]

Dear Team,

I am refering the transaction CO09.

In the CO09 transaction, we have following fields. And i could not able to understand the values it ferlects these fields.

A - Receipts:

I understand this field refers to all the receipt elements of the material (Eg: Un-restricted stock, Future purchase orders, purchase requistions etc as maintained in OPJJ)

Is that right?

B- Issues:

I understand this field refers to all the issue elements of the material (Eg: Sale order(s) created for this material, Production order in which this material being used as BOM item, Manual reservation(S) created for the material etc as maintained in OPJJ)

Is that right?

C- Confirmed Issues:

I understand that total number of quantities is confirmed / committed for this material based pervious ATP Check.

Note: I am executing ATP check in COMAC

According to the below image, C  = D (Sum of all the line items of Colum "D")

E - Cumulative ATP Qty:

I am always getting values as ZERO in the column. What does this value mean? Suppose assume that if i get the value as ONE instead of ZERO, what  does it mean?

Could anyone help me to understand this field "E".

Thanks

[rupesh_brahmankar3 · Accepted solution]

Hello,

Please read OSS KBA  1893237 - Everything about transaction Co09

Question no 5 How is the cumulated atp quantity calculated?

Best Regards,

R.Brahmankar

[Former Member · Accepted solution]

Dear Brahmankar,

Really very good document. Thank you.

In the document, i am reading the statement as below.

"On 22.01.2014 there is a receipt of 200 and we have a confirmation of 100 for a sales order on 31.01.2014. 200 -100 = 100 -> 70 + 100 = 170. The cumulative atp quantity is raised by 100 to 170".

But when refer the screen shot in the document, its misleading to me. According to the screen shot on 31.01.2014, there is a requirement of 250 quantity for the sale order (sale order number: 14504).

Document Screen Shot:

So i am expecting the calculation as  below.

On 22.01.2014 there is a receipt of 200 and we have a confirmation of 100 250 for a sales order on 31.01.2014. 200 - 250 = - 50  -> 70 + (-50) = 20. The cumulative ATP quantity is raised  reduced to 20 to from 70".

Is my understanding right?

My another clarification is regarding the lock entry in the tables ATPENQ &LATP_ENQ.

In the table ATPENQ, there are some entries for about 1 week. Will the lock entries in this table affect the result of subsequent ATP  check when i do in COMAC?

I do  not have any lock entry in the table LATP_ENQ as of now.

Thanks

[rupesh_brahmankar3 · Accepted solution]

Hello,

Calculation in in KBA is correct ATP qty will be increased on the date of a receipt if the receipt is greater than the issues

On 22.01.2014 there is a receipt of 200 and we have a confirmation of 100 for a sales order on 31.01.2014.

200 -100 = 100 -> 70 + 100 = 170. The cumulative atp quantity is raised by 100 to 170.

I would suggest better test this in your system.

Table LATP_ENQ updated when you have lock entries mainly in case of Local ATP from CRM.

Obsolete lock entries in table ATPENQ  appear in transaction Co06 You can use Transaction SM12 to display and delete the locks.

Best Regards,

R.Brahmankar

[Former Member · Accepted solution]

Hi Brahmankar,

Sure. I will test in my system.

Could you please help me to understand this?

Why on 31.01.2014 only 100 quantity is confirmed for the sale order 14504 (Sale order quantity 250)?

I am expecting that the  full sale order quantity of 250 can be confirmed as on 31.01.2014 since i have cumulative ATP quantity of 70 ( as on 28.11.2013)  ( +  )  200 (as on 22.01.2014) = 270.

It will be very much appreciable for your feedback

Thanks

[kiran_kumar179 · Accepted solution]

Selva,

Your 22/01/2014 order is Planned order which is not confirmed receipt which may not be included in ATP calculation.

You can change this behavior through ATP configuration change in OVZ9 to Include Planned order.

Check your configuration and make changes to see the results.

BR
KK

[Former Member · Accepted solution]

Dear Kiran,

Q1: If you say that the planned order receipt (planned order number: 37719) of quantity 200 dated on 22.01.2014 is not confirmed receipt which may not be considered for ATP calculation means, this planned order element should not be displayed as receipt element in CO09 screen at all. Is that right?

Q2: And also if this planned order receipt is not considered for ATP calculation, we can ONLY able to confirm the quantity of 70 for the sale order 14504 (sale order quantity 250) dated on 31.01.2014. But in the screen shot of "SAP Note: 1893237" for the sale order 14504 the quantity of 100 has been confirmed as on 31.01.2014. (refer below screen shot). How the quantity of 100 is confirmed for the sale order 14504 on 31.01.2014 if the planned order receipt dated on 22.01.2014 is considered during ATP calculation?

Thanks

[former_member196530]

Hi ,

Please refer the below SDN documents which will solve most of your query -

Details of the CO09 -

http://scn.sap.com/docs/DOC-58040

ATP

http://scn.sap.com/docs/DOC-54181

Regards

JH

[kiran_kumar179]

Selva,

Generally Cumulative ATP is the available quantity which you can use or system takes in to consideration during ATP check for other orders.

Per your snap shots above it clearly says that you have 11736 stock available among which total 11736 has been confirmed in ATP with your other requirements so further you do not have any stock available to confirm with other requirements.

BR
KK