SQL:
select SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ERROR_MESSAGE,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_DATE,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".DOCUMENT_NUMBER,
SAPHANADB.LIKP.VBELN,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_TIME,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".STATUS,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".MANDT,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ZPARAMETER
from SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw"
inner join SAPHANADB.LIKP on
Right(SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".DOCUMENT_NUMBER,6)
=
Right(SAPHANADB.LIKP.VBELN ,6)
where SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ERROR_MESSAGE not Like '%Error {40%'
and
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_DATE >= '20221123'
--and
--SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_TIME > '152059'
Query works fine. Try to go to Visual Query Builder and get Invalid SELECT Statement. Unexpected Token "Right" as line 11 pos 1.
