SAP Knowledge Base Article - Preview

2334759 - VAL-030183: Only table names from the current join pair and its preceding join pairs can be referenced in the ON condition – Data Services

Symptom

  • An inner join between two tables fails with the following error:
  • Error "VAL-030183 Only table names from the current join pair and its preceding join pairs can be referenced in the ON condition."
  • Values and column names referenced in the join are valid.
  • ATL export shows join as 

    SELECT UNIT_HISTORY_TEMP.UNIQUE_ID, UNIT_HISTORY_TEMP2.ENDDATE, UNIT_HISTORY_TEMP2.END_CSEC, 3
    FROM UNIT_HISTORY_TEMP2  __SAP_INNER_JOIN UNIT_HISTORY_TEMP2
     ON (UNIT_HISTORY_TEMP.UNIQUE_ID = UNIT_HISTORY_TEMP2.UNIQUE_ID)

Read more...

Environment

SAP Data Services

Product

SAP Data Services all versions

Keywords

KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

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

Search for additional results

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