SCM systemcopy: Livecache copy or initialisation ?

[uta_hedemann]

We are planning to refresh quality assurance(Q/A) systems  of ERP landscape and SCM 7.0(APO) landscape with the productive systems

(Have done on ERP on regular basis, now APO landscape was also built up and is productive, too)

I have read a lot of documents, but still have some  doubts about the best method:

Best Practise Documents systemcopy (http://service.sap.com/solutionmanagerbp) + note 88543 copy of system landscapes)

Note 457425 - Homogeneous liveCache copy using backup/restore

Note 886103 - System Landscape Copy for SAP SCM

Note 1015489 - Connection problems after system copy

Note 1030857 - Report for additional update after system copy

According note 886103, livecache is normally also copied with SCM system.

Question 1) Could we also only copy the  SCM-PROD system to SCM Q/A and then initialise the Q/A livecache (after having changed tables in SCM system, which points to the right livecache on Q/A livecache server). I would appreciate getting experience from other customers.

If we copy the livecache, too:

We could use the method with backup/restore from note 457425.

In Bestpractise Dok  Checklist for Recovery of SAP APO liveCache >= 7.4 I found:

APO/SCM only
Do not select “Restore database until a specified time.” If the liveCache instance is not completely
recovered, inconsistencies might occur between the APO database and liveCache. SAP does not
support synchronization using time stamps.

Question 2: I am wondering if this is still valid (dokument is from 2005...) ?

Normally we copy the systems with flashcopy/online backup method, so that the source systems are online always. We deactivate rfc connections, jobs etc on target system before starting the system

If livecache doesn't support point in time recovery, how can we solve that ?  The SCM (APO) system should have the data of the same timestamp as ERP system. I would normally restore ERP, SCM and probably livecache to same timestamp, but if it is not possible to restore to a time stamp..... ?

Question 3 to Note 886103:

To adapt the liveCache table /sapapo/ordmap, you need to open a command prompt on the liveCache server and start xquery. Alternatively you could useSQL Studio.
Enter: username/password/system name (sapr3/../LC-Target)
Command: select LOGSYS, count(*) from "SAPR3"."/SAPAPO/ORDMAP" group by logsys
For each LOGSYS that is displayed, the same mapping / changes have to be done as in BDLS. For example <APO-SOURCE>M001 => <APO-TARGET>M001
Command: update "SAPR3"."/SAPAPO/ORDMAP" set logsys='<APOTARGET>M001'where logsys='<APO-SOURCE>M001'
This will change the logical system name in /sapapo/ordmap to the target system.

I only found an empty table SAPSR3./SAPAPO/ORDMAP in the SCM system but not in the livecache server.  Iis there a SAPR3 (or SAPSR3) schema  in the livecache ? I haven't found this user with the dbmgui....

Any ideas are welcome...

[former_member229109]

Hello Uta,

Q1. It's dependant on what liveCache data you have on your source system. If you have the transaction data in liveCache, like TS data or orders ..., then I don't recommend this option.

The initial transfer from the connected R/3 system and/or backup/load the TS data to/from Infocudes took longer time to compare the procedure recommended in the Note 886103 - System Landscape Copy for SAP SCM

Q2. You should create the backups of  ERP, SCM database and liveCache in sync on source system

      and restore those backups to the target databases.

      And you could use the databackup and logbackups to perfirm a liveCache copy.

Q3. The liveCache user is the owner of the liveCache application table ./SAPAPO/ORDMAP in liveCache.

You could connect to your liveCache instance using SQLStudio, DB studio or dbmcli tool, for example, to run the SQL statements.

First check who is the owner of this table:

dbmcli -d <LC-name> -u control,<pwd>

<enter>

sql_connect superdba,<pwd>

<enter>

sql_execute select * from tables where TABLENAME = '/SAPAPO/ORDMAP'

< the second value in output is OWNER of this table, the liveCache user >

sql_release

sql_connect <liveCache-user>,<pwd>

sql_execute  select LOGSYS, count(*) from "<liveCache-user>"."/SAPAPO/ORDMAP" group by logsys

< You need to connect as OWNER of the application table to be able to see or update this table's entries in liveCache >

exit

****

"Any ideas are welcome." =>

Create the SAP message and get SAP support.

Regards, Natalia Khlopina

[Former Member]

Hi Natalia,

I have to do a system copy of EHP2 for SCM 7.0.

We do NOT need the Live Cache Data from production into the target system.

Is there a way to avoid the live cache data copy ?

I was going through the system copy guide and it recommends using the Software Provisioning Manager 1.0.

Regards,

hasnain