APO SNP masterdata updates consistency jobs

Les master data sont stockés de façons redondantes dans SNP: MATKEY et MATLOC mais aussi dans /SAPAPO/TSQUEUE (liste d’attente des updates dans les time-series) et dans Queue level2 (mise à jour des agrégats => 1 table par agrégats).

Théoriquement, avant chaque utilisation de données SNP, il faut ré-initialiser la version pour garantir la cohérence des données. Cela implique de renvoyer les données des tables standard vers Lvl1, puis de lvl1 vers lvl2.

/SAPAPO/TS_QUEUE

/SAPAPO/TS_LCM_QUEUE_UPDATE

Reco : Programmer ces jobs quotidiennement.

 

Note 1331576 – Initialization and Delta Handling for SNP Master data

 

 

 

APO CIF Queues – Emergency procedure

In case of huge amount of Outbound queues

/SAPAPO/CQ – SMQ1 – SMQ2

The report for the emergency procedure is /SAPAPO/CIF_EMRG_QOUTSCHED. Before running the report, you have to  make and entry in SMQS adding ZZ to the destination you have the issue for.

You do not need to remove the original destination from SMQS (if fact, you should not).

 

APOCIFQUEUE

APO – Forecast consumtion by order

https://help.sap.com/saphelp_scm70/helpdata/en/47/9dd3a28b3b3c5ce10000000a421937/content.htm

https://help.sap.com/saphelp_scm50/helpdata/en/e6/28dadc939241469dd64f0eb925f328/content.htm

Le groupe de planification APO détermine :

  • Quel est l’objet modifié – Catégorie ATP pour la prévision et dans quel segment il est créé
  • Quel sont les catégories qui viennent consommer cette prévision (via un groupe de catégorie)
    • Attention à ne pas consommer par les commandes ET par les livraisons sans quoi la conso sera faite 2 fois (une livraison apparaît à la place de la commande, mais la commande existe toujours
  • Éventuellement dans quelle version de planification se fait la conso des prévisions (possibilité de consommer dans une version différente de 000)

 

 

 

Publié dans APO

Interfaces sortantes APO -> Systèmes tiers

APO est conçu pour que les données puissent être exportées vers des logiciels tiers via un Middleware déclaré.

  1. BD64 pour créer un modèle de transfert avec BAPI associée (sélectionnant les bonnes données)
  2. WE20 pour diriger le message vers le partenaire plus haut
  3. /SAPAPO/BP1 permet ensuite d’exporter les données altérablesvers le partenaire. Le partenaire appel la BAPI (définie dans BD64) et le message (défini dans WE20)

 

Transfert de ressources ECC->APO

Les ressources ne sont pas une donnée vraiment dynamique donc il n’est pas nécessaire de les inclure dans un modèle d’intégration quotidien.

Le plus simple est de les intégrer manuellement au besoin.

Pour que les gammes soient correctement intégrées, il faut que les ressources existent dans un modèle d’intégration actif. Cela n’est pas forcément possible si les ressources ont été modifées dans leurs dimensions dans APO. L’astuce est d’intégrer les ressources dans APO quitte à passer par des modèles séparés, puis de faire un modèle global et de l’activer en dialogue (pas en arrière plan). L’activation ne vas pas marcher et une queue inbound apo en transfert initial va se créer. La supprimer. Le modèle est activé, les ressources sont dans APO, tout est prêt pour la suite.

Publié dans APO | Marqué avec ,

CIF Delta report

/SAPAPO/CCR

(source : http://scn.sap.com/docs/DOC-43984)

RECONCILIATION Report

RECONCILIATION report is used to compare APO transaction data with ECC transaction data through active integration model.

Perquisites:

  • Check whether Integration model for the transaction data like Planned order , production order, Stock and etc. for the material are active or not
  • Check for saved queues in ECC for any queues stuck in ECC. (SMQ2 & SMQ3)
  • Check for saved queues in APO for any queues stuck in APO. (SMQ2 & SMQ3)
  • Now you can analyze the error in RECONCILIATION for getting the inconsistencies.

Most Common Root Cause:

  1. 1. When ‘someone’ deletes blocked queues, rather than first resolving the root cause and then re-processing the queues.
  2. 2. Inappropriate or missing master data
  3. 3.      When the connectivity between ECC and SCM fails.

Some More Important point:

 

In RECONCILIATION report it may be confused by seeing there some internal number issue and external number related issue.

 

Internal number = created in SCM, but not yet published to ECC.

External number = created in ECC, and published to SCM

 

Orders that are created within SCM (such as planned orders) initially are created with an internal order number, using an SCM number range.  If these orders are published to ECC, the order is then duplicated in ECC.  This new ECC order contains an order number generated by ECC, using an ECC number range. Once this order is bounced back to SCM, the original SCM order (with the internal number) is replaced by the new order that was created in ECC.

 

Change Pointers in RECONCILIATION:

  1. 1. Orders once deleted in APO will have change pointer-> R

 

  1. 2. Orders created in APO which has to flow to R3 will be having change pointers-> C

 

  1. 3. Orders newly created in APO which has to flow to R3 will be having change pointers-> N

Icons in RECONCILIATION Screen

  • Push to APO
  • Push to R/3
  • Delete in APO
  • Delete in R/3
  • Change pointer with symbol X

Types of RECONCILIATION Inconsistencies

  1. 1.      Not in integration model
  2. 2.      Missing in R/3 without external Key
  3. 3.      Not in R/3 with external key
  4. 4.      Not in APO
  5. 5.      Difference in content

Not in Integration Model

 

Cause- >

  1. 1. Selection condition of data not activate in integration model
  2. 2. Check for Active model exists or not for plant, material, PPM/PDS, Work center (CFM5)
  3. 3. Check active integration model exists for planned orders/ production orders, purchase orders/purchase requisitions etc
  4. 4. Try creating a manual orders in RRP3 transaction and check orders is getting populated.

Action:

  1. 1. Ask the Business user why they need forecast for those SKU as they are added in exclusion list.
  2. 2. If it is really needed for business, then add the object to the active IM.


Missing in R/3 Without External Key

 

Cause:

  1. 1. If Change pointers exist that means after Manual heuristic  run in APO, user have forgotten  to send the change pointers to R/3.( after heuristic C/5 has not done)
  2. 2. If change pointers not exist then there may be Queue stuck in R/3 inbound related to the transaction data (Check for Purchase /MRP views of SKU/ Accounting views) .

Action:

  1. 1. Select orders with change pointer C, select change pointer icon X and do the iteration. This will publish the orders in R3 and will return back to APO
  2. IF no change pointers nit exist then may be queue stuck, correct master data…

Missing in R/3 with External Key

 

Reason->

  1. 1. The deletion indicator have not moved to APO
  2. 2. Check whether the planned orders exist in R/3? They may have been manually deleted or goods movement process has already been done respect to the planned order.
  3. 3. Queue stuck in APO inbound related to the transaction data
  4.  

Action-> Press the deletion indicator to delete in APO

 

Missing in APO :

 

Root Cause:

  1. 1. Planned has been deleted after the heuristic run but stuck in the queue

Schedule line does not exist in APO. Ex:  the PR has been deleted and not passed to R/3 but at the mean time the system created another PR for the demand on the SKU.This error can occurred if PO stuck up in the inbound queue to R/3 system & RECONCILIATION process is not followed properly for sending PO to R/3

 

Action:

  1. 1. If planning has been done from APO side , then delete the orders from ECC. Don’t send the orders to APO.

Difference in Content

 

1. APO requirements quantity  different to ECC req. quantity .

2. APO requirements date  different to ECC req. date

 

Different types of error code different types of schedule lines , and different types of issue…

 

Supprimer un article/site de APO

Suppression du MATLOC (combinaison article/site) :

Delete MATLOC material location data from APO

it is not a plain thing to delete a product master/location product in a production system.You have  to carry out the following steps:

1.
a) Remove product from integration model
b) Delete all orders for this product-location which still exist in the APO system by running the reports /SAPAPO/RLCDELETE or /SAPAPO/DELETE_PP_ORDER (this report is not recommanded to be used in product system!!) or transactions /SAPAPO/RRP4 or /SAPAPO/RRP4.
c) Use transaction /sapapo/ccr to delete all objects in APO that are integrated with R/3. The /sapapo/ccr will show the orders as ‘Not in an active integration model’ and offers to delete the orders in APO
d) Delete the product from ATP tables by running the report /SAPAPO/SDORDER_DEL with the selection according to the product being deleted.
e) Delete all related product substitution and location product substitution using the transaction /SAPAPO/RBA04;
f) Delete the product from all PPMs through the transaction /SAPAPO/SCC05;
g) Remove the product from external procurement using the transaction /SAPAPO/PWBSRC2;
h) Remove the product from transportation lanes through the transaction /SAPAPO/SCC_TL1 or /SAPAPO/SCE; Note: If the lane was created with option ‘All products’, you should not care about this condition.
i) Remove the product from quota arrangement through the transaction /SAPAP/SCC_TQ1;
j) Remove references from the product master or the location product master using the transaction /SAPAPO/MAT1, tab ‘Classification’;
k) Remove the planning package from the location product master using the transaction /SAPAPO/MAT1, tab ‘PP/DS’;
l) Remove the product from RTO;
m) Remove the product from product split.

2.  Mark deletion flag
a) In transaction /SAPAPO/MAT1, select the product (and location in  case of location product);
b) In the menu bar, choose ‘Product’ and go to ‘Mark for deletion’ (Shift+F6);
c) In the popup ‘Set deletion Flag’ set a flag in the appropriate field: Leave the field ‘Product’ empty unless you want to delete the product master, i.e. in case a location product must be deleted, the flag has to be set on location only;
d) The deletion can be executed directly or be scheduled for another time.
I hope this helps.

Publié dans APO

Deleting data from APO

WUF : Cas d’emploi

First you deactivate the CIF interface between the ECC and SCM system.

Delete all the transaction data using transactions like /sapapo/rlcdel and programs like /sapapo/delete_pp_order, basically delete all the transaction data.

Delete all the dependent master data like Transportation lane, quota. PPM.

After deletion of all the dependent master and transaction data using MASSD transaction you can set the deletion flag for all the product location.

After the deletion flag is set use the program /SAPAPO/DELETE_PRODUCTS to delete all the product location for which deletion flag is set