Transfert IBP to ECC

https://blogs.sap.com/2020/06/03/sap-ibp-data-integration-via-cpi-ds-how-to-synchronize-data-from-sap-ibp-through-webservice/

SAP IBP Data Integration via CPI-DS – How to synchronize data from SAP IBP through webservice

FollowRSS feedLike2 Likes 1,148 View 1 Comment

In this blog, you will get an end to end case for how to synchronize data from SAP Integrated Business Planning for Supply Chain solution through webservice.

Let’s assume the following scenario: Planners want to maintenance some additional information in SAP IBP and send these data to SAP ERP Central Component (SAP ECC)’s Z-table. To implement this scenario, we need SAP Cloud Platform Integration for data services (CPI-DS) as a middleware to connect both SAP IBP and SAP ECC.  The data flow will be SAP IBP>>CPI-DS>>SAP ECC. Let’s have a look at how to complete this scenario step by step.

1. Webservice Part

Firstly, SAP ECC as a service provider need to publish a web service to receive the data which is sent by SAP IBP through CPI-DS. In this part, I will show you how to deal with these in SAP ECC side. If you have already known these steps, you can skip to CPI-DS part.

1.1 Define a Z-table and create an RFC to receive data.

We need to define a table to store the data sent from SAP IBP, in this example, table is named as ‘ZIBP_DATA_FLITER’. And then, we can use an RFC to receive the data.

1.2 Generate service definition

After the RFC ‘ZIBP_SET_DATA_FILTER’ have been created. We should create an enterprise service and follow the wizard to generate service definition.

1.3 Publish webservice

After that, you can use T-CODE: SOAMANAGER to publish webservice and get the WSDL URL.

Go to the web service configuration pageSelect your service definition ‘ZIBP_SRV_ECC_DATA_INBOUND’ and follow the wizard to create service.After you have created the service, you can use ‘open binding WSDL generation’ button to open binding page where you can get WSDL URL.You can use web browser to open this WSDL URL, like below. It means the service has been published.

Tips:

If you find that the web page occurrs 403 error, like this:That means you need to active some services through T-Code: SICF

Firstly, we need to get service path. You can right click and choose properties in the web page.Find the path under /bndg_url, for this example is /sap/bc/srt/rfc/sap/zibp_srv_ecc_data_inbound …Secondly, back to SAP GUI and use T-Code: SICF to find the service and active it.

Now we’ve finished service provide part. Let’s move to CPI-DS part.

2. CPI-DS Part

2.1 Import SAP IBP source table

CPI-DS need to know service consumer’s metadata, so we need to import SAP IBP source table for datastores first.

In SAP IBP side, the master data types which we want to synchronize to SAP ECC is like below:And we should import this table in CPI-DS. Let’s move to CPI-DS datastores sheet, find SAP IBP’s datastore and click ‘Import object’ button.Tips:

table name is SOPMD_<master data type ID> and folder name is your planning area ID.

SOPMD means S&OP master data. In this example, planning area ID is ‘INT’ and master data type ID is ‘FILTERCONFIG’, so we need to find table ‘SOPMD_ FILTERCONFIG’ which is under folder ‘INT’.

Now we’ve got the table in CPI-DS, and you can review table data in datastores

2.2 Create a web service datastore

After importing SAP IBP table, we should create a datastore to call the web service which we published.

In new datastores screen, we should choose datastore’s type as ‘SOAP Web Service’ and fill the WSDL URL which we got in step 1.3 in WSDL Path.

We also need to fill credentials info, for this example, it’s a http webservice and authentication with user ID/Password, so we should put the username and password which SAP ECC provided for integration.

Tips:

For the WSDL Path field, we can also use WSDL file’s address.

If you want to use this way, you need to download the webservice’s WSDL file and upload to Data Service Agent service’s file folder. After that, you can fill the WSDL file address in WSDL Path field.

For this example, Data Service Agent are installed in a windows server, the WSDL file address will like this:

C:\ProgramData\SAP\DataServicesAgent\workspace\wsdl\zibp_srv_ecc_data_inbound.wsdl

You can use test button to check datastores connection.

After our web service datastores passed connection test, we need to import web service metadata.Now we’ve finished both sides’ datastores configuration.

2.3 Create a task

From this step, Let’s move to CPI-DS project’s sheet to do the configuration.

Select the projects which you want to input new task and click ‘create task’ button.Follow the wizard to name the task, then select source/target datastores and save it.

Let’s open the task which we’ve just saved. We can check source/target datastores in connections sheet, edit data flows in data flows sheet and we can define some global variable for these data flows in execution properties sheet.

2.4 Create a data flow

After task has been created, we need to define movement and transformation of data from SAP IBP to SAP ECC, so we should create a data flow to handle it.

Use ‘Add target Object’ link to choose target object and create data flow

That’s a simple data flow, we just need 3 transform objects to deal with the work.Our data flow begins from source target ’SOPMD_FILTERCONFIG’ to the ‘output Loader’ which is to store web service response by xml file.

Firstly, use a Query transform to filter the fields which we need. If you want to define some field value levels’ filter, you can write some codes in filter sheet.Secondly, use an XML Map transform to map the fields between query and web service’s input.

If your web service supports inputting multiple rows of data, you need to define iteration rule for it. Use ‘propose rule’ button to choose the suitable object.Thirdly, use a web service call transform to call SAP ECC’s web service target. In this transform, we can use ‘select function’ button to choose web service input structure.After importing it, don’t forget to map these two structures.You can use ‘configure design time data viewer’ button to check each transform running status.

2.5 Create a process and test data flow

Select the projects which you want to input new process. And then click ‘create process’ button.Fill process name. Deselect the Load to SAP Integrated Business Planning (requires post-processing) box because our target datastores is web service.

Select the data flow which you want to test and drop it in the process pool.

Go back to project sheet, select the process and click ‘run now’And you can use ‘view history’ button to view the process log.Check SAP ECC’s Z-table whether it has received the data.

Hopefully, this article will help you better understand how to synchronize data from SAP IBP through webservice.

IBP – Utiliser l’Addon de connection ECC6 / IBP

  • Setup IBP as a destinatin (BD54 + NDV2)
  • Définir les modèles d’intégration : Divisions et MRP Profiles (Logistics – Central Functions – Supply chain Planning Interface – IBP – Integration Models – Define puis Transfer)
  • Setup change pointers collections :
    • BD61 – BD50 – BD52
  • Setup Live Masterdata collection (PDS/TLanes)

Manage Deletion in IBP

Mass Deletion through Excel input (From: Data Integration jobs) : Download template, then load. Only the Main Key is required, no values needed.

In Excel, use Masterdata Single and Delete.

Through a Job using the « Purge Masterdata » Template and setting how many days in Background

Publié dans IBP

IBP – Scheduling a job

2 tiles exist in the IBP Fiori front end : Application jobs & Application jobs template.

With Application Jobs, you can see what’s scheduled and schedule a new one. From this tile, you can either enter everything manually or call (and change) a template.

So here is the recommanded way :

1- Define building blocks with Application Jobs template

Ex: HCI Masterdata Integration

  • HCI Masterdata Integration
  • HCI Transac data Integration
  • Init KF
  • Copy KF
  • Update KF

Careful, as your small templates will then be copied in the master template, not linked (ie: If you add a step in HCI MasterData Integration, it will not add anything in the mastertemplate.

2- Create your master Template with Application jobs Template

Inside a template, you can add templates. Create one master template for your daily job including the 5 previous building Block, name it « Daily Process »

3- Schedule your job with « Application Jobs »

Create a new scheduled job and select your Master Template. Everything will be set directly according to the master template.

Careful, changing the master template don’t change anything inside the scheduled jobs. You will have to delete the current schedule and re-create it from the template.

Publié dans IBP

APO PPDS Reports

Very good source from this link :https://wiki.scn.sap.com/wiki/display/SCM/List+of+PPDS+Related+Reports

PP/DS Related Reports

ReportDescriptionNote
/SAPAPO/DM_PEGKEY_REORGCan be used to delete obsolete pegging areas from APO. For example, pegging areas without orders.
It can help to improve system performance. It is recommended that this report be executed periodically.
 
/SAPAPO/DELETE_PP_ORDERCan be used to delete receipts in PP/DS. It is not recommended for usage in productive environments,
it is more of a tool that can be used in order to clean up the system in the implementation phase. In general,
for order deletion, it is recommended to use an interactive transaction like the Receipts View or to delete the
orders with a BAPI. 
 
/SAPAPO/PT_DELETE_USERCan be used to delete the User Settings variant of the Product Planning Table which is currently assigned to a User 
/SAPAPO/PT_COPY_USERUsing this program you can copy user-specific settings for the Product Planning Table, Resource Planning Table, Detailed Scheduling Planning Board, Product View, so that they are available for other users. 
/SAPAPO/CRES_CAPACITY_LENGTHENThis report should be executed periodically in order to ensure that the time streams of the resources are up to date
in the liveCache. When the time streams are outdated in the liveCache, this can cause issues during order
scheduling (for example, an order is scheduled during a non-working time of the Resource) 
 
/SAPAPO/DMOPR_REORG_CTPIn a CTP scenario, if you terminate the Sales Order maintenance (VA01 / VA02) in ECC with /n, this may cause
database inconsistencies in the table /SAPAPO/OPR. Report /SAPAPO/DMOPR_REORG_CTP reorganizes
the operations table so that such inconsistencies are removed from the system. 
 
Z_ORDER_WO_OPR_SEARCHThis report can be used to search for orders which do not contain any operations in APO. It was provided in note
918648. Note 1426836 enhances the report so it works both for orders that exist only in APO and also for orders
that exist in both systems. 
918648 and 1426836
/SAPAPO/PEGAREA_LC_CREATECreates pegging areas for all Location-Products in a given Planning Version which do not have a pegging area yet.
If a pegging area is missing for a particular Location-Product in APO, it is preferable to execute transaction
/SAPAPO/RRP_NETCH with the option to create pegging area instead of executing this report.  
 
/SAPAPO/MATRIX_TO_LC_SENDUsed to regenerate the Setup Matrix in the liveCache. Can solve some setup matrix inconsistencies. 
/SAPAPO/ORDER_NETWORKThis report was provided in note 1633057. It can be used to view orders graphically. The report is already contained
in the newest releases and support packages. 
1633057
/SAPAPO/CDMS_DELSCHED_DELETEDeletion Report for Scheduling Agreement Releases and Confirmations 
/SAPAPO/CDMS_RECOVER_DDS_CONFRegenerate the SD Scheduling Agreements in the liveCache from the database tables. 
/SAPAPO/SETUP_GROUP_COPYCopies setup groups from one APO system to anotherSAP Help
/SAPAPO/SETUP_MATRIX_COPYCopies setup matrices from one APO system to anotherSAP Help

PP/DS Related liveCache Reports

ReportDescriptionNote
/SAPAPO/OM_DEFECT_PEGAREASFind Defect Pegging Areas 
/SAPAPO/OM_DEFECT_PEGAREAS_ALLFind Defect Pegging Areas (All Planning Versions) 
/SAPAPO/OM_DELETE_INCON_ORDERSThis report is a last resort for deletion of inconsistent order data from the liveCache.It is recommended not to run it without contacting SAP Support firstThe user has to know previously the order which he wants to delete – It is necessary to inform the OrderID
of the order to be deleted.It should not be used often or as a planning tool – if liveCache details for a given order
are deleted with this report and there are still some entries in non-liveCache APO tables
(like /SAPAPO/OPR or /SAPAPO/ORDFLDS), these will not be deleted, thus generating
inconsistencies in the system! It is not supported by SAP – for further details, check KBA 1867390
 
/SAPAPO/OM_ORDKEY_ORDMAP_CHECKCheck Consistency of Ordkey, Ordmap, and Order Objects. The report should only be executed
at times when there are no CIF activities occuring, because during order transfer there may be
temporary inconsistencies in the system which will be solved as soon as the queue gets processed,
thus making the result of the report unreliable otherwise. 
 

PP/DS Related Reports – Automotive

ReportDescriptionNote
ReportDescriptionNote
/SAPAPO/PPC0_PRC_SHOWPPC: Analysis report for the PRC future change records785481
RPM_CHECK_RTO_SUBTAB Analysis report for RPM runtime objects660257
/SAPAPO/PPC0_OCD Delete/Archive finally confirmed orders 

PP/DS Related Reports – Miscelaneous

ReportDescriptionNote
/SAPAPO/CONFR_PROD_CONSConsistency Check Product Master Classification/Configuration 
/SAPAPO/CONFR_CHECK_VARIANTSReport for APO and R/3 Consistency Check for Product Variants 
RCIFORDTThis report can be used in ECC side to make an initial transfer for a small selection of planned or
production orders. 
 
/SAPAPO/AMON_REORGReorganizes alerts and deletes obsolete entries from database table /SAPAPO/ALERT_HP1885008
ZZ_PCM_DEL_PCMHReport to delete from database table /SAPAPO/PCMH Production Campaigns which are marked
as deleted 
2203934
ZZ_SEARCH_COMPONENT_PARENTReport which checks for component with invalid references to parent materials (phantom
assemblies). The inconsistent orders found may be transferred from ECC to APO with
report RCIFORDT to fix the issue  
811785
Publié dans APO