Qlik Community

QlikView Connectors

Not applicable

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

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')

Community Browser