cancel
Showing results for 
Search instead for 
Did you mean: 

Error during Network Planning (SAPSQL_INVALID_FIELDNAME)

0 Kudos

Hi,

During Interactive planning in SNP when releasing the forecast to network (thru transacction /sapapo/snp01) we are getting an runtime error "SAPSQL_INVALID_FIELDNAME"

Please help. Error analysis appearing in dump is mentioned below

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was

not caught in

procedure "SELID_GET" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

An Open SQL clause was specified dynamically. The contained field name

"SEL_9AACTNAME" does not exist in any of the database tables from the FROM

clause.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Please check if following SAP notes are applicable for you

Note 1516088 - Error SAPSQL_INVALID_FIELDNAME in /SAPAPO/TSCUBE

Note 1118456 - error SAPSQL_INVALID_FIELDNAME in /sapapo/tscube

Thanks

Amol

aparna_ranganathan
Active Contributor
0 Kudos

Hi Gajinkar

I do not understand your question. Am i missing something ? /sapapo/snp01 is transaction used for running SNP heuristics . How can the forecast be released with that transaction ?

The forecast has to be released from DP time series live cache to SNP order series live cache using tcode /n/sapapo/mc90 or using release profile /n/sapapo/mc8s.

Thanks

Aparna

0 Kudos

Hi Aparna,

Yes you are right. The forecast is already released to SNP and the team is now doing network planning. We are facing the error here.

Our technical person has done the analysis and it seems that its due to some Local objectcs that are implemented in system.

Will update once the issue is resolved.

Thanks

Former Member
0 Kudos

Hi

It looks like some internal SAP error. I will suggest you to contact SAP by opening OSS message for the help.

Thanks

Amol