topic Re: Reading Cluster Tables in Application Development and Automation Discussions

Reading Cluster Tables

Former Member — Tue, 11 Sep 2007 06:57:31 GMT

How to read Cluster Tables.

amit_khare — Tue, 11 Sep 2007 07:05:50 GMT

Check out if any FM is there otherwise use Select and try to pass all the Keys in where Clause.

Regards,

Amit

Reward all helpful replies.

Former Member — Tue, 11 Sep 2007 07:07:56 GMT

I think u can using FM "HR_TIME_RESULTS_GET" to read data from Table Cluster B2. Here the sample code:

data: saldo like pc2b5 occurs 0 with header line.

call function 'HR_TIME_RESULTS_GET'

exporting

get_pernr = pernr

get_pabrj = pabrj

get_pabrp = pabrp

tables

get_saldo = saldo

exceptions

no_period_specified = 1

wrong_cluster_version = 2

no_read_authority = 3

cluster_archived = 4

technical_error = 5

others = 6.

Former Member — Tue, 11 Sep 2007 07:08:45 GMT

Sample program

Import and export to database is used in two programs and not in the same program.

ZPROGRAM1.

tables : indx.

Data : SALDO type i,

indxkey LIKE indx-srtfd VALUE 'ZAB1'.

indx-aedat = sy-datum.

indx-usera = sy-uname.

indx-pgmid = sy-repid.

EXPORT SALDO TO DATABASE indx(zc) ID indxkey.

In another program,