Hi Team,
When I click on create reports, my NI report for Catalogart table TQ15 is not getting created. The rule DDL is mossing join on keys. Please see the below error status:
The jobqueue step failed: Incorrect syntax near the keyword 'AND'.
------------------
CREATE VIEW [dbo].CCG_QPGR_T_RPT_KATALOGART_NI_TQ15 AS
SELECT T.ZSOURCE, T.ZDEPLOY, T.ZLEGACYKATALOGART, T.ZLEGACYCODEGRUPPE, T.KATALOGART
FROM [dbo].CCG_QPGR_T T LEFT OUTER JOIN [dbo].TQ15_S4H C ON
<------------------------This is missing-------------------->
AND
WHERE C.KATALOGART IS NULL
AND ISNULL(T.KATALOGART,N'') <> N''
Kindly check and support to resolve this issue.
Thanks.
Regards,
Garima Jain
Comments
0 comments