0 Replies Latest reply: Nov 7, 2013 6:56 AM by Joe Hosiene RSS

    SAP Connector - For pooled tables, cluster tables and projection views, JOIN is not allowed

    Joe Hosiene

      I have some code but it moans that CDPOS is a Clustered or Pooled table so I can not link.  Is there a way to do this or ?

       

       

       

       

      My Code is

       

      SQL SELECT CDHDR~OBJECTCLAS CDHDR~OBJECTID CDHDR~CHANGENR CDHDR~UDATE PCDPOS~CHANGENR PCDPOS~VALUE_NEW

      FROM CDHDR JOIN PCDPOS

      ON CDHDR~CHANGENR = PCDPOS~CHANGENR

      WHERE (CDHDR~OBJECTCLAS = 'MATERIAL') AND (CDHDR~UDATE >= '20131101');

       

       

      Result

       

      /QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 For pooled tables, cluster tables and projection views, JOIN is not allowed: "PCDPOS".)

      SQL SELECT CDHDR~OBJECTCLAS CDHDR~OBJECTID CDHDR~CHANGENR CDHDR~UDATE PCDPOS~CHANGENR PCDPOS~VALUE_NEW

      FROM CDHDR JOIN PCDPOS

      ON CDHDR~CHANGENR = PCDPOS~CHANGENR

       

      WHERE (CDHDR~OBJECTCLAS = 'MATERIAL') AND (CDHDR~UDATE >= '20131101')