Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Doubt in Cluster table

Former Member
0 Kudos

Hi Experts,

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

Thanx in advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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>

2 REPLIES 2

Former Member
0 Kudos

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>

Former Member
0 Kudos

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 ..