Live Cache anchor

[Former Member]

what is the livecache anchor ? can any one explain in details how it works?

thanks &regards

ravi

[Former Member · Accepted solution]

Hi Ravi,

pls fine these links related to live catch.

http://help.sap.com/saphelp_nw70/helpdata/en/42/db70ae3f382cede10000000a1553f7/content.htm

https://www.sdn.sap.com/irj/sdn/livecache

Regards,

Madhu.

[Former Member]

Anchor tables contain mappings between external(SAP R/3) and internal (SAP APO) identifiers.

APO system uses internal global unique identifiers (GUIDs) as object keys. Anchor tables contain mappings between these internal object keys and the external ones used in the linked OLTP system.

SQL tables /SAPAPO/ORDKEY and /SAPAPO/ORDMAP are two special anchor tables for transactional data (order headers). They are stored in liveCache. /SAPAPO/ORDMAP contains the conversion from APO internal key to external order key for every order and /SAPAPO/ORDKEY contains a record for every order in the liveCache that was received from or sent to the OLTP system. Report /SAPAPO/DELETE_LC_ANCHORS must be executed every time after liveCache is initialized. This report ensures the integrity of the APO DB and liveCache data

[Former Member]

Hi Chowdary thanks for your reply.

Is it required live cache initialization demand planning scenario ? i think its required in snp .

regards

ravi

[former_member229109]

Hello,

1)

"Report /SAPAPO/DELETE_LC_ANCHORS must be executed every time after liveCache is initialized. This report ensures the integrity of the APO DB and liveCache data"

It's wrong statement.

For example, the liveCache will be initialized during the version update, when you are using the LCUPDATE tool from the liveCache upgrade CD, but the Report /SAPAPO/DELETE_LC_ANCHORS

should NOT run during the system upgrade. You should NOT run the /SAPAPO/DELETE_LC_ANCHORS program during upload/download procedure (for details, see Note 632357) and when you upgrade to a higher SCM release, since otherwise a loss of data occurs.

Also please pay attention to the SAP note :: 640107 Using program /sapapo/delete_lc_anchors in APO 3.0 or higher.

In the SAP note 640107 is written about steps performed by /sapapo/delete_lc_anchors report.

As it was written in the note, that the /sapapo/delete_lc_anchors program has to be called automatically after the liveCache is initialized in LC10 transaction, if it's required. Therefore, you must NOT call the /sapapo/delete_lc_anchors program manually again using transaction LC10 after the liveCache has been initialized.

2)

For SAP liveCache documentation see the SAP note 767598 .

Before to run or recommend the liveCache initialization in LC10 please read the SAP note 640107 <!! > & the SAP document "Checklist for Initialization of SAP APO liveCache" at service.sap.com/scm -> Technology

-> Information on SCM 4.1 and prior releases

Information on SCM 4.1 and prior releases you will find here. < click on here > -> Backup and Recovery

3)

There are tables in the APO-database which contain references to liveCache-objects. The tables having references to liveCache-objects are called anchor-tables.

Thank you and best regards, Natalia Khlopina