topic Re: Cluster Table in Application Development and Automation Discussions

Cluster Table

RahulKeshav — Mon, 24 Dec 2007 07:44:24 GMT

Hi All

I want to use Cluster table ......following are the Query...

"Read CLSTR table b2, read sub table ZL looking for wagetype (LGART)= 9001. Cumulate field ANZHL for each entry where LGART=9001 for last 365 days including system date at runtime (system date and prior 364 days)"

i didnt work on cluster table...

Plz help me in solving this query..

Thnx

Rohit

Re: Cluster Table

Former Member — Mon, 24 Dec 2007 07:57:25 GMT

just write the select query as u write for transparent tables.

and please make your requirement clear.

Regards

ANUPAM

Re: Cluster Table

RahulKeshav — Mon, 24 Dec 2007 08:20:11 GMT

use pa0000-pernr to read CLSTR table b2..........

Re: Cluster Table

Former Member — Mon, 24 Dec 2007 09:15:20 GMT

Hi,

Your requirement in not clear, what ever may be your requirement u have to write select statement. But don’t use select * because in Pool/cluster tale large number of data is present. So u need to write select single * and access to that particular field don’t give loop when u r accessing to Pool/cluster table.

Re: Cluster Table

RahulKeshav — Mon, 24 Dec 2007 09:45:45 GMT

my requirement is to calculate 'No. of Hours worked in the Previous 12 months'......and the provided me above said...logic...

Re: Cluster Table

Former Member — Mon, 24 Dec 2007 10:17:43 GMT

Hi rohit,

Retreving cluster data r little bit different comparing to ordinary reports, we do it using LDBS,.

first specify the ldb name in when ur creating the program,

then specify the root node of ldb which ur using and also infotypes.

here is the example shown.

TABLES PERNR.

INFOTYPES: 0001,0006.

To retrieve the data from this infotypes using macros or funcitons modules.

EXAMPLE ON MACROS:

RP-READ-INFOTYPE PERNR-PERNR 0006 P0006 PN-BEGPS PN-ENDPS. or

Using function module HR_READ_INFOTYPE'

Re: Cluster Table

RahulKeshav — Mon, 24 Dec 2007 12:54:49 GMT

Hi Anil

Thnx for ur suggestion...

I did tht already....

its a part of HR report so all the infotypes, Ldb has been declared...appropriatetly......i had to fatch 38 fields out of then this one is lil complicated ,i have doen with other fields....bt no one used cluster tables...thts y i m in problem...dude...

so any help plzz.....let me know...

Re: Cluster Table

Former Member — Wed, 26 Dec 2007 09:53:34 GMT

Hi Rohit,

Try to apply the concept described below in your program.

May be it will help..

Am assuming you already have other fields appended in ITAB.

You can copy the cluster table data in one internal table say itab_qave and follow the logic as seen below.

LOOP AT ITAB.

READ TABLE ITAB_QAVE WITH KEY PRUEFLOS = ITAB-PRUEFLOS.

IF SY-SUBRC = 0.

ITAB-INSPDT = ITAB_QAVE-VAEDATUM.

ITAB-INSPBY = ITAB_QAVE-VAENAME.

MODIFY ITAB.

ENDIF.

ENDLOOP.

Reward points if useful.

-Bhavin P Shah

Re: Cluster Table

RahulKeshav — Fri, 28 Dec 2007 08:09:37 GMT

thnx