How to read data from cluster table.

[Former Member]

Hi experts.

CDPOS --- "Change document items" ... is a cluster table.

how to select data from it into an internal table....

please help..

i will award points for every help.

thanks

saurabh.

[Former Member]

Hi experts.

CDPOS --- "Change document items" ... is a cluster table.

how to select data from it into an internal table....

please help..

i will award points for every help.

thanks

saurabh.

[Former Member]

Hi

U need to use SELECT statament, just as for transparent table.

Anyway you can use the fm CHANGEDOCUMENT_READ_POSITIONS and CHANGEDOCUMENT_READ_HEADER (try to see the fms with the name beginning with CHANGEDOCUMENT_*)

Max

[Former Member]

Hi

It is similar to any other transparent tables data select only

only thing is that you can't join this cluster with other tables

and as this table consists of huge data we have to pass most of the key fields for all key fields

generally first write a select to CDHDR header tables and for all entries of that CDHDR we will write a selec statement for this CDPOS.

Reward points for useful Answers

Regards

Anji

[Former Member]

Hi Saurabh,

Use the foll. statement,

IMPORT <f1> [TO <g 1>] <f 2> [TO <g 2>] ... FROM MEMORY ID <key>.

For Eg,

IMPORT ITAB TO JTAB FROM MEMORY ID 'table'.

This code reads the internal table ITAB from the cluster "table" into the internal table JTAB.

Hope it helps.