topic Re: How to read data from cluster table. in Application Development and Automation Discussions

How to read data from cluster table.

Former Member — Thu, 28 Jun 2007 07:07:31 GMT

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.

Re: How to read data from cluster table.

Former Member — Thu, 28 Jun 2007 07:09:37 GMT

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

Re: How to read data from cluster table.

Former Member — Thu, 28 Jun 2007 07:09:37 GMT

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

Re: How to read data from cluster table.

Former Member — Thu, 28 Jun 2007 07:14:32 GMT

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.