SAP Knowledge Base Article - Preview

3233174 - Error:" VAL-30160 LOAD (Target_Query)><XXX>. Change the name of the column or add a new column to the target table." happens in task with IBP target - SAP Cloud Integration for data services

Symptom

  • Task fails with IBP target.
  • Change the name of the column or add a new column to the target table
  • Failed error: VAL-30160 LOAD (Target_Query)><IBP_target_name>. Change the name of the column or add a new column to the target table.  
  • Failed error: Column <column_name_A> in query <Target_Query> must have the same name as column <column_name_B> in target table.
  • VAL-30160       |SESSION TASKNAME|DATAFLOW TASKNAME_DF_KF_XXX|STATEMENT <GUID::'XXX' LOAD TABLE XXX."".SOPDD_STAGING_KFTAB_XXX INPUT(Map_To_Target)>Column <XXX> in query <Map_To_Target> must have the same name as column <XXX> in target table                 <SOPDD_STAGING_KFTAB_XXX>. Change the name of the column or add a new column to the target table.


. Change the name of the column or add a new column to the target table." happens in task with IBP target - SAP Cloud Integration for data services"> Read more...

Environment

  • SAP Cloud Integration for Data Services (CI-DS)
  • SAP Integrated Business Planning for Supply Chain (SAP IBP)

Product

SAP Cloud Integration for data services 1.0

Keywords

CPIDS, IBP, re-import, VAL-30160, Change the name of the column, Difference in the Column mapping from the source to Target table, Add a new Column to Target table, Column <XXX>, Promote Task, Import Object, Import tables, Websocket RFC, Switch to Websocket RFC, CI-DS,CI-DS Agent,<MSGID> , <BATCHID>,Column <MSGID>,column <BATCHID>,  <Target_Query>, Change the name of the column or add a new column to the target table, target table , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , SCM-IBP-INT-TS-DS , CPI-DS Integration , 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.