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

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)

 

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…

 

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

Tips and techniques to smoothly and seamlessly transfer data between SAP APO and SAP ERP, leveraging the core interface (CIF)

Master Data Exits — SAP APO

Business Add-Ins (BAdIs) and customer exits

  • Exist for each publication type
  • Can be used to interrupt the program flow during the sending phase of direct and periodic sending

Master data exits

  • Inbound processing: Location — APOCF001 EXIT_/SAPAPO/SAPLCIF_LOC_001
  • Inbound processing: Resource — APOCF008  EXIT_/SAPAPO/SAPLCIF_RES_001
  • Inbound processing: Products — APOCF005   EXIT_/SAPAPO/SAPLCIF_PROD_001
  • Inbound processing: PPM — APOCF012   EXIT_/SAPAPO/SAPLCIF_PPM_001
  • BAdI: PPDS PDS — /SAPAPO/CURTO_CREATE
  • BAdI: SNP PDS — /SAPAPO/CURTO_SNP
  • Inbound processing: Source of supply — APOCF032EXIT_/SAPAPO/SAPLCIF_TPSRC_001

Transaction Data Exits — SAP APO

  • Inbound processing: Stock — APOCF011 EXIT_/SAPAPO/SAPLCIF_STOCK_001
  • Inbound processing: Production orders and planned orders — APOCF004 EXIT_/SAPAPO/SAPLCIF_ORD_001
  • Outbound processing: Production orders and planned orders — APOCF013 EXIT_/SAPAPO/SAPLCIF_ORD_002 (before send user exit)
  • Inbound processing: Purchase order documents — APOCF006 EXIT_/SAPAPO/SAPLCIF_PU_001
  • Inbound processing: Sales and distribution document — APOCF010 EXIT_/SAPAPO/SAPLCIF_SLS_001

SAP R/3 Exits

Customer exits in SAP R/3 for the publication types:

  • CIFORD03: Change Order Data
    • To change orders that are transferred from SAP APO to SAP R/3 in R/3 inbound queue
  • CIFORD01: Change Object Type and Order Data
    • To change order data that is transferred from SAP APO to SAP R/3 and is already in SAP R/3 format in R/3 inbound queue
  • PPAPO002: Influence Order Data after the Transfer from SAP APO
    • To influence the data that was transferred from SAP APO to SAP R/3 for a manufacturing order before it is transferred to the SAP R/3 manufacturing order
  • PPAPO008: Override Order Type for Planned Order Conversi on
    • To manually influence the order type of a manufacturing order generated by conversion from SAP APO (customer exit EXIT_SAPLCOXT_002)
  • PPAPO004: Re-Explode BOMs for Planned Order Conversion
    • To force the re-explosion of a BOM (customer exit EXIT_SAPLCOXT_001)
  • PPAPO009: Add Components and Items
    • To run own checks when components are added to a manufacturing order from SAP APO
  • PPAPO007: Override Checkbox Fields for Manufacturing Orders, SAP APO ® SAP R/3
    • To override checkbox fields for manufacturing orders on transfer from SAP APO to SAP R/3
  • Material master — CIFMAT01  EXIT_SAPLCMAT_001
    • To add new fields in the material master that are in SAP APO but not in SAP R/3 (for SAP R/3 to be the material master system of record, this user exit is necessary to add the new fields)
  • PDS transfer — CUSLNTRTO_ADDIN_SAP
    • To influence values and change fields on the PDS that are transferred to SAP APO from SAP R/3
  • CIFPUR01 (enhancement for the transmission of customer-specific purchase order fields)
    • To change purchasing data from purchase requisitions, POs, scheduling agreement schedule lines (OLTP scheduling agreement), and confirmations/shipping notifications (for SAP APO and OLTP scheduling agreements)
  • CIFPUR02 (enhancement PO interface — inbound)
    • To change PO data from SAP APO before a purchase req, scheduling agreement schedule line, or a PO is created in the OLTP system

Additional Exits

Customer exits for orders and manufacturing orders in SAP APO

  • APOCF020 — User-specific fields in the order interface (after posting in SAP liveCache or to the database)
  • APOCFPIP — Publication of in-house production orders (planned orders, manufacturing orders)

BAdIs

  • /SAPAPO/CL_EX_CIF_IP — Comparison of APO data and CIF data
    • To control if and when the activity dates planned in SAP APO should be rescheduled, or if a change to the order quantity in SAP R/3 leads to a proportional change to receipt and requirement quantities

Trouver des Users-Exit

Proceed in this sequence

  • Previous knowledge of existing exits 
  •  Customizing

 image003

  • SAP Notes. I normally look for the application component (LO something in this case), I restrict by consulting, FAQ notes and search by “BADI or User Exit”
  • CSN
  • Debugging the affected program or transaction (this is very time consuming, but sometimes there are not other option…)