topic Re: Accessing data from a cluster table in Application Development and Automation Discussions

Accessing data from a cluster table

Former Member — Mon, 25 May 2009 09:18:37 GMT

HI,

I have tried accessing data from a cluster table but was unable to do it. I tired using the statement IMPORT but, every time i run it, the staement fails and i am not able to work with it.

I even tried using the example in the keyword help, but was of little use.

Can some one help me on this front.

Regards,

Rishav

Re: Accessing data from a cluster table

Former Member — Mon, 25 May 2009 09:27:35 GMT

Dear Rishav,

If you are working with Cluster table e.g. BSEG then its not possible to select only once at the time of data selection. you need to select data from cluster table in a loop and use accordingly. If this is not possible for you then find alternative transeparent table.

Feel free to ask if you have any doubt.

Regards,

Vijay

Re: Accessing data from a cluster table

Former Member — Mon, 25 May 2009 09:33:32 GMT

Hi Vijay,

I am not using BSEG but a table SMW3_BDOC2 and still i am not able to access the data.

TABLES : SMW3_BDOC2.

DATA : ls_rawdata TYPE /1CRMG0/BUPA_MAIN.

DATA : lv_bdoc_id TYPE SMOG_TID.

get the data id----

SELECT SINGLE BDOC_ID FROM SMW3_BDOC INTO lv_bdoc_id WHERE BDOC_TYPE = 'BUPA_MAIN'.

IF sy-subrc = 0.

select data from the cluster----

IMPORT /1CRMG0/BUPA_MAIN TO LS_rawdata FROM DATABASE SMW3_BDOC2(10) ID lv_bdoc_id.

ElSE.

WRITE : 'Data not retrieved'.

ENDIF.

Could you please tell me how to use the statement.

Re: Accessing data from a cluster table

Former Member — Mon, 25 May 2009 09:47:58 GMT

Hi,

Check this code. Even this is failing

TYPES:

BEGIN OF tab,

col1 TYPE i,

col2 TYPE i,

END OF tab.

DATA:

wa_indx TYPE indx,

wa_itab TYPE tab,

cl TYPE mandt VALUE '800',

itab TYPE STANDARD TABLE OF tab.

IMPORT tab = itab

FROM DATABASE indx(10)

TO wa_indx

CLIENT cl

ID 'TABLE'.

WRITE: wa_indx-aedat, wa_indx-usera, wa_indx-pgmid.

ULINE.

LOOP AT itab INTO wa_itab.

WRITE: / wa_itab-col1, wa_itab-col2.

ENDLOOP.

Re: Accessing data from a cluster table

Former Member — Thu, 23 Jul 2009 17:17:06 GMT

Hi Vijay,

I wanna read the cluster table how to do that, I have come across some FM HR_FORMS_TIM_GET_B2_RESULTS which will read the B2 cluster which I require, But I don't know how to access that data.

can you please put some code for the same.

Thanks in Advance,

Gaurav Patwari

Re: Accessing data from a cluster table

former_member585060 — Thu, 23 Jul 2009 18:36:17 GMT

Hi,



" To post data to cluster

EXPORT tab = itab
  TO DATABASE indx(XY) 
  ID 'TABLE'.

'or

EXPORT itab TO DATABASE indx(xy) ID ' TABLE'.


' To access data from cluster table

IMPORT tab = itab        " here itab should the internal table with same structure as the cluster table else data will not get download
  FROM DATABASE indx(xy) 
  ID 'TABLE'.                           " ID should be the same when passing with the EXPORT same


or 

'you can use this way

IMPORT itab FROM DATABASE indx(xy) ID 'TABLE'.

Regards

Bala Krishna

Re: Accessing data from a cluster table

Former Member — Fri, 24 Jul 2009 02:52:37 GMT

the problem of reading the cluster is solved.

We actually need to know the Type of cluster we want to import.

Eg:

IMPORT tab = itab

FROM DATABASE indx(10)

TO wa_indx

CLIENT cl

ID 'TABLE'.

The Tab marked in Bold and underlied must be known to the person who is importung the data.

then we mention the Database name and then the ID(in the database table ) required to fetch the data.

Re: Accessing data from a cluster table

Former Member — Tue, 28 Apr 2015 12:32:31 GMT

Hi,

how can you know the structure of the tab ??

This is where I am stuck. can anyone throw some light on this please..?

Thanks,

Saikat

Re: Accessing data from a cluster table

Former Member — Tue, 28 Apr 2015 18:57:35 GMT

Hi Saikat,

You need to figure out where the EXPORT TO DATABASE is done and look at that code to see what the structure of the cluster data is. You can't tell by looking at the data, only the programs that use the table will show you.

Jim

Re: Accessing data from a cluster table

Former Member — Thu, 07 May 2015 10:40:45 GMT

Thanks Jim, but we took a different approach for the requirement. But yes, your answer is spot on.

Regards,

Saikat