Inner Join not allowed

[Former Member]

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]

Use the FM is CHANGEDOCUMENT_READ*

Also refer the help:

http://help.sap.com/saphelp_47x200/helpdata/en/2a/fa01d0493111d182b70000e829fbfe/frameset.htm

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.