Symptom
You want to replicate SCM APO planning data related to location
products, resources and CVCs to SAP HANA in order to use the Supply
Chain Info Center 1.0 SP04 or use the SCM Virtual Data Model in SAP
HANA.
If you have Supply Chain Info Center 1.0 lower than SP04 please refer to note 1854279
If you have Supply Chain Info Center 1.0 lower than SP04 please refer to note 1854279
Other Terms
Replication Model, HANA Replication, HANA Based Analytics, HANA Live
Reason and Prerequisites
The needed data replication tools are delivered with this note.
If you want to use navigation to SAP APO, check note 1929737.
Check note 1938555 to learn about the performance behavior of SAP Fiori Apps for APO on SAP HANA Live.
Check note 1916739 if you want to use the Uncovered Sales Order Fiori app. This note helps you to create a key figure in your planning book for uncovered sales orders.
For delta replication, make sure you have at least SAP liveCache 10.0 LCA build 10 (see also note 1784335).
If you want to use navigation to SAP APO, check note 1929737.
Check note 1938555 to learn about the performance behavior of SAP Fiori Apps for APO on SAP HANA Live.
Check note 1916739 if you want to use the Uncovered Sales Order Fiori app. This note helps you to create a key figure in your planning book for uncovered sales orders.
For delta replication, make sure you have at least SAP liveCache 10.0 LCA build 10 (see also note 1784335).
Solution
If you have SCM 7.0 Enhancement Package 3 SP01 installed:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live.
2) Implement attached correction instructions.
3) Furthermore implement the following notes:
If you have SCM 7.0 Enhancement Package 3 SP02 installed:
1) Implement the following notes
If you have SCM 7.0 Enhancement Package 2 Powered by HANA SP03 installed:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instructions
3) Furthermore implement the following notes:
If you have SCM 7.0 Enhancement Package 2 Powered by HANA SP04 installed:
- Implement the following notes:
If you have SCM 7.0 Enhancement Package 2 SP08 installed:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instruction
3) Furthermore implement the following notes:
If you have SCM 7.0 Enhancement Package 2 SP09 installed:
Implement the following notes:
If you have SCM 7.0 Enhancement Package 1 SP11 installed:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instruction
3) Implement the following notes:
If you have SCM 7.0 SP14 installed:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instruction
3) Implement the following notes:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live.
2) Implement attached correction instructions.
3) Furthermore implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
1) Implement the following notes
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instructions
3) Furthermore implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
- Implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instruction
3) Furthermore implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
Implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instruction
3) Implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
If you have SCM 7.0 SP14 installed:
1) Implement notes listed in note 1863896 Data replication from SCM APO to SAP HANA Live
2) Implement attached correction instruction
3) Implement the following notes:
| 1) 1913944 View generation correction for SCIC |
| 2) 1923749 SCM HANA Data Replication: Deadlock |
| 3) 1920400 SCIC: Translatable key figures and selections |
| 4) 1925585 SCIC: Support of insight-to-action via OBN |
| 5) 1923096 Data replication performance for resource data |
| 6) 1924536 Delta replication does not replicate changed DP objects |
| 7) 1927989 Consistency check of Replication Model does not work |
------------------------------------------------------------------------
|Manual Pre-Implement. |
------------------------------------------------------------------------
|VALID FOR |
|Software Component SCMAPO |
| Release 713 SAPK-71301INSCMAPO - SAPK-71301INSCMAPO |
------------------------------------------------------------------------
These manual steps will
1. Create structure /SAPAPO/S_REPL_VIEW_TAG
2. Create Table Type /SAPAPO/T_REPL_VIEW_TAG
3. Extend the structure /SAPAPO/S_REPL_HANA_VIEWS
4, Add fixed values to the domain /SAPAPO/REPL_SEMANTICS
5, Create the transformation /SAPAPO/REPL_MODEL_SNPUNCOVSO
------------------------------------------------------------
1,
You can create structure in transaction SE11 if you select radiobutton "Data type".
- Structure: /SAPAPO/S_REPL_VIEW_TAG
- short description: "Tag for HANA View"
- package: /SAPAPO/APO_REPLICATION_BO
Add the following components on Components tab:
Component Typing Method Component Type
------------------------------------------------------
TAG Types STRING
VALUE Types STRING
Save and Activate
2,
You can create Table Type in transaction SE11 if you select radiobutton "Data type".
- Table Type: /SAPAPO/T_REPL_VIEW_TAG
- short description: "Tag for HANA View"
- package: /SAPAPO/APO_REPLICATION_BO
- LineType: /SAPAPO/T_REPL_VIEW_TAG
Save and Activate
3,
Add the following component (on Components tab) in the structure /SAPAPO/S_REPL_HANA_VIEWS:
Component Typing Method Component Type
------------------------------------------------------
HANA_VIEW_TAGS Types /SAPAPO/T_REPL_VIEW_TAG
Save and Activate
4,
Add fixed values SNP_TOTR, SNP_SO and SNP_SOUNCO to domain /SAPAPO/REPL_SEMANTICS. Do the following steps:
In transaction SE11:
- choose radiobutton Domain
- domain name is /SAPAPO/REPL_SEMANTICS
- press Change button
- press tab Value Range
- add the following three single values:
Fix.Val Short Descript.
------------------------------------------------
SNP_SO Sales Order
SNP_SOUNCO Uncovered Sales Order
SNP_TOTR Total Receipts
- finally save your changes and activate the domain
5,
Download text files attached to note
Start transaction STRANS
- Type transformation name /SAPAPO/REPL_MODEL_SNPUNCOVSO
- Choose "Create" button
- Short description: SNP SCIC Uncovered Sales Order (Query View)
- Transformation Type: Simple Transformation
- Package is /SAPAPO/APO_REPLICATION_BO
- Copy source code of transformation with content of corresponding downloaded text file. File name same as name of transformation without namespace /SAPAPO/
Save and activate your changes
------------------------------------------------------------------------
|Manual Pre-Implement. |
------------------------------------------------------------------------
|VALID FOR |
|Software Component SCM SCM (Supply Cha...|
| Release 700 SAPKY70014 - SAPKY70014 |
| Release 701 SAPKY70111 - SAPKY70111 |
| Release 702 SAPKY70208 - SAPKY70209 |
| Release 712 SAPKY71203 - SAPKY71204 |
------------------------------------------------------------------------
These manual steps will
1, Add fixed values to the domain /SAPAPO/REPL_SEMANTICS
2, Create the transformation /SAPAPO/REPL_MODEL_SNPUNCOVSO
------------------------------------------------------------
1,
Add fixed values SNP_TOTR, SNP_SO and SNP_SOUNCO to domain /SAPAPO/REPL_SEMANTICS. Do the following steps:
In transaction SE11:
- choose radiobutton Domain
- domain name is /SAPAPO/REPL_SEMANTICS
- press Change button
- press tab Value Range
- add the following three single values:
Fix.Val Short Descript.
------------------------------------------------
SNP_SO Sales Order
SNP_SOUNCO Uncovered Sales Order
SNP_TOTR Total Receipts
- finally save your changes and activate the domain
2,
Download text files attached to note
Start transaction STRANS
- Type transformation name /SAPAPO/REPL_MODEL_SNPUNCOVSO
- Choose "Create" button
- Short description: SNP SCIC Uncovered Sales Order (Query View)
- Transformation Type: Simple Transformation
- Package is /SAPAPO/APO_REPLICATION_BO
- Copy source code of transformation with content of corresponding downloaded text file. File name same as name of transformation without namespace /SAPAPO/
Save and activate your changes
Header Data
| Released On | 18.04.2014 11:16:51 |
| Release Status | Released for Customer |
| Component | SCM-APO-ANA-REP Supply Chain Info Center - Data Replication |
| Priority | Correction with low priority |
| Category | Program error |
Cool Post on SAP Domain.
ReplyDeleteSAP Training in Chennai
SAP ABAP Training in Chennai
SAP FICO Training in Chennai
SAP MM Training in Chennai
SAP SD Training in Chennai
Thanks for sharing this Information. SAP SCM Training in Gurgaon
ReplyDeleteThank you for your post. This is excellent information. It is amazing and wonderful to visit your site. And I would like to share some information about virtue solutions. www.virtuesolutionsonline.com
ReplyDeleteThanks for sharing this Information. SAP SCM Course in Gurgaon
ReplyDeleteNice article. Read about Data Replication.
ReplyDeleteReally you have done a good job. Thanks for sharing this valuable information....
ReplyDeleteInformatica MDM Training in Chennai
informatica MDM Training Center Chennai
informatica MDM Training Institute in Chennai
Corporate Training in Chennai
Corporate Training Companies in Chennai
Corporate Training Institute in Chennai
ReplyDeleteSAP HCM Training in Noida