- 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)
SAP Data Services
SAP Data Services all versions
KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem
About this pageThis 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.