topic Re: Doubt in Cluster table in Application Development and Automation Discussions

Doubt in Cluster table

Former Member — Wed, 10 Jan 2007 09:45:24 GMT

Hi Experts,

Can You plz tell How to import/read data from cluster table? Plz give me the syntaxes also..

Thanx in advance.

Re: Doubt in Cluster table

Former Member — Wed, 10 Jan 2007 09:48:18 GMT

use read statement i don't think in cluster table there is any restruction for read and select u can use open sql but not join in cluster table .

Database table defined in the ABAP Dictionary, whose version on the database is not only assigned to one table defined in the ABAP Dictionary. Several cluster tables are assigned to a table cluster in the database. The intersection of the key fields of the cluster tables forms the primary key of the table cluster. The other columns of the cluster tables are stored in compressed form in a single column VARDATA of the table cluster. <b>You can access cluster tables only via Open SQL, and only without using joins.</b>

Re: Doubt in Cluster table

Former Member — Wed, 10 Jan 2007 09:58:03 GMT

If U want to read PCL2(for payroll results)

U need to pass these values .. Pernr and seq. no (this U get it from FM

CU_READ_RGDIR)

rx-key-pernr = i_pernr-pernr.

UNPACK rgdir-seqnr TO rx-key-seqno.

rp-imp-c2-ru.

After this U have a no. of structures filled in like rt , crt , bt , wpbp , tcrt ...

U can loop thru them and get the results ..