Consistency check for dependent demands

[gunnar_humpert]

Hi gurus,<br><br> we have a huge number of obsolete dependent demands in APO.<br><br> Example:<br> <table border=0 cellpadding=0 cellspacing=0 width=584 style='border-collapse: collapse;table-layout:fixed;width:438pt'> <col width=64 span=3 style='width:48pt'> <col width=113 style='mso-width-source:userset;mso-width-alt:4132;width:85pt'> <col width=64 span=2 style='width:48pt'> <col width=87 style='mso-width-source:userset;mso-width-alt:3181;width:65pt'> <col width=64 style='width:48pt'> <tr height=17 style='height:12.75pt'> <td height=17 width=64 style='height:12.75pt;width:48pt'>DatTimAlrt</td> <td width=64 style='width:48pt'>Qty Alert</td> <td width=64 style='width:48pt'>Avail/ReqD</td> <td width=113 style='width:85pt'>Avail/Re... Category</td> <td width=64 style='width:48pt'>Receipt/Rq<span style='display:none'>mt. Elemt. Rec/Req...</span></td> <td width=64 style='width:48pt'>Conf. Q...</td> <td width=87 style='width:65pt'>Availa... P... C...</td> <td width=64 style='width:48pt'>... Start<span style='mso-spacerun:yes'> </span></td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.08</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>70</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.08</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>56</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.15</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>42</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.15</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>28</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.16</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>14</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.17</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>0</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.22</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>14-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.23</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>28-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.23</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>42-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.28</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>56-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.29</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>70-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.09.29</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>84-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.10.05</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>98-</td> <td align=right>2</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 style='height:12.75pt'></td> <td>2010.10.05</td> <td class=xl65 align=right>07:00:00</td> <td>DepDmd</td> <td>14-</td> <td>14-</td> <td class=xl66>112-</td> <td align=right>2</td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=113 style='width:85pt'></td> <td width=64 style='width:48pt'></td> <td width=64 style='width:48pt'></td> <td width=87 style='width:65pt'></td> <td width=64 style='width:48pt'></td> </tr> <![endif]> </table><br><br> I've tried to align the system by:<br><br> 1. running TC /SAPAPO/CCR comparison report<br> 2. executing report /SAPAPO/SDORDER_DEL<br> 3. using some of the reports mentioned in the <a href="https://websmp104.sap-ag.de/~sapidb/011000358700000792732008E"><span style='mso-ansi-font-size:12.0pt;mso-bidi-font-size:12.0pt'>SAP best practice: internal and external consistency for SAP APO (3.x) and SAP SCM (4.x, 5.x)</span></a><br><br> Nothing worked so far. Any suggestions? It is possible to delete the data via the report /SAPAPO/OM_DELETE_INCON_ORDERS but this is not good option, since we are having the problem for 3000+ materials.<br><br> Best regards,<br>

Gunnar

[Former Member]

Hi,

I would write a z program, define a parameter to handover objects to be deleted, loop over all parameter entry (products in question), and call the program /SAPAPO/OM_DELETE_INCON_ORDERS in loop statement.

This should work

Regards

Aban

[rupesh_brahmankar]

Dear,

Before planning, use the CIF delta report (transaction /SAPAPO/CCR) to perform an inconsistency check and eliminate any inconsistencies that arise.

The inconsistencies may also be detected by planning.If you want to perform these checks, create an implementation for the '/SAPAPO/CDPS_SIMCTRL' BAdI.

The 'SIMULATION_CONTROL' Badi method is called before the planning data is saved and reads the ORDMAP of orders for the delete events written in planning.If this table contains a production order whose current ORDKEY entry displays an inconsistency.

Hope it will help you.

Regards,

R.Brahmankar