topic Inner Join not allowed in Application Development and Automation Discussions

Inner Join not allowed

Former Member — Wed, 26 May 2010 10:39:44 GMT

Hi all,

Iam making a select statement as follows:

SELECT cdhdr_{username cdhdr}udate cdpos_{changeid cdpos}valuenew

cdpos_{valueold cdpos}tabname cdpos_{feldname cdpos}tabkey INTO

CORRESPONDING FIELDS OF TABLE gt_cditab

FROM cdhdr INNER JOIN cdpos

ON cdhdr_{objectclas = cdpos}objectclas

AND cdhdr_{changenr = cdpos}changenr

WHERE cdhdr_{objectclas = 'stue' AND cdhdr}udate IN so_date

AND cdpos~tabname = 'stpo'

It gives me an error that For Pool-Tables,Cluster-tables and projection-views JOIN not allowed: "CDPOS".

Cant I get data from "CDPOS" using inner join?

What is the best and performant way to get data from these tables now.

Use "For ALL ENTRIES" .

Any suggestions are welcome.

Thanks

Koh

Former Member — Wed, 26 May 2010 10:56:57 GMT

Use the FM is CHANGEDOCUMENT_READ*

Also refer the help:

Former Member — Wed, 26 May 2010 11:25:45 GMT

This message was moderated.

Former Member — Wed, 26 May 2010 11:28:08 GMT

This message was moderated.