SNP Optimizer With Runtime Errors

[Former Member]

I am Trying to run SNP Optimizer.

The actions performed on SNP Interacive planing book is Selected the Product Locations in Selection window and When trying to load data or click optimizer it is giving a runtime error.

The Error Says: A table is refered to in a SAP open SQL statement that either does not exit or is unknown to the ABAP dictonary.

Table involved is /SAPAPO/STOCKANC.

Please , can anyone help me understand. What the error is and how to go about it?

That would be a great help.

Thanks

GAyatri

[former_member187488]

Hello,

Have you done any liveCache initialization or upgrade?

Tables like /SAPAPO/STOCKANC are created in the liveCache at the LC initialization by the follow up report /sapapo/delete_lc_anchors (in case of regular initialization, NOT upgrade) or by /SAPAPO/UPGRADE_LC_ANCHORS (in case of upgrade when transactional data is stored in APO). Either one of the reports has to be run to create the tables.

Please check whether you have performed the necessary steps correctly.

Best Regards,

Ada

[former_member209769]

Hi Gayatri,

Very first check is already mentioned in the error message.

Did you check that the table "/SAPAPO/STOCKANC" exists in your system? When you would dispplay the table in SE11, you should see against the table name that it should show up as "active".

Click on "check" and then "activate" button if the table is not active. This would make it active.

Alternatively take help from your ABAP colleagues.

(Table should have a description "Key and Descriptive Data for Stock". You should also try to find out if recently some OSS note was applied which is causing this kind of issue)

Thanks - Pawan