Extraction of plan data from S&OP HANA (on-premise)

[Former Member]

Hi Experts,

We are integrating S&OP on-premise (source) with CRM (target) application for sales forecasting, can you guide as to which table to extract plan data from?

Regards,

Aditya G

[Former Member]

Are you attempting to extract calculated key figure data or stored key figure data. The latter will be much easier due to the construct of the system. Stored key figure data can be found in the 'timeseries' table.

Stored data surfaces from the join of three main tables.

xxx represents your planning area name

### represents your time profile #

Note schema and table names might not be exactly as written below, since I'm going off memory.

SAPSOPG.SOPDM.PLOBJECT_xxx

SAPSOPG.SOPDM.TIMESERIES_xxx

SAPSOPG.SOPDM.TIMEPROFILE_###

Conversely the stored data can be extracted using the generated hana analytic view for your planningrp area. I don't recall the exact path to that view from memory.

Calculated key figure data extraction would require extra prescriptions that I'll defer to an expert to better explain.

[Former Member]

Hi,

Thanks for your response JJ Watson.

You meant this right?

"SAPSOPG"."SOPDD_PLANOBJECT_xxx"

"SAPSOPG"."SOPDD_TIMESERIES_xxx"

"SAPSOPG"."SOPDD_TIMEPERIOD_###"

Do you have the logic of the join among the above tables?

More then 50% of the key figures are calculated in this implementation, thereby eager to understand how to extract the same.

Regards,

Aditya G