SAP Knowledge Base Article - Preview

3762613 - IBP: export from SAC to IBP fails when mapping version/scenario default value with "invalid column name: scnid" (http 500, cx_sql_exception)

Symptom

  • Export from SAP Analytics Cloud to SAP Integrated Business Planning fails when the target dimension Version/Scenario is set as a fixed default value in the mapping.
  • HTTP status: 500.
  • Error code: CX_SQL_EXCEPTION.
  • Error text: invalid column name: SCNID.
  • Response from external server has status code 500 during export using /IBP/EXTRACT_ODATA_SRV.


Read more...

Environment

  • Product: SAP Integrated Business Planning
  • IBP Master Data and Transactional Data API services

Product

SAP Integrated Business Planning all versions

Keywords

sac to ibp export, version/scenario mapping, scnid, invalid column name scnid, http 500, cx_sql_exception, extract_odata_srv, odata integration, base version, scenario not supported, export mapping default value, integration error, key figure data export, planning area mapping, ibp api , KBA , SCM-IBP-INT-ODT , IBP Master Data and Transactional Data API services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.