Data storage in Live Cache

[Former Member]

Hi,

Can some1 explain me how the SNP data is stored in the live cache.

I know it's by series of order. But tell me is there any mapping involved in it?

Thanks,

Siva.

[somnath_manna]

Order series data is used by both SNP and PPDS.

While I do not know the exact way data is stored in liveCache the following helps me to explain and understand.

Each record in liveCache for Order Series data is stored as

Location Product combination-ATP Category-Quantity-Time Stamp.

Unlike Timeseries data CVC is replaced by a location product combination only, keyfigure is replaced by ATP Category (each kind of Order elements has its own ATP Category) and Time Bucket is replaced by actual Time Stamp (in UTC ddmmyyyyhhmmss format).

The mapping is essentially with ATP Category which maps to corresponding MRP elements in ECC or R/3.

In the SNP Planning Area for each keyfigure the Category Group defines the grouping of ATP Categories for which orderseries data will be displayed in that particular keyfigure.

Hope this helps.

Thanks,

Somnath