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 , Job Execution , EIM-DS , Data 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.