topic Re: infoset query in Application Development and Automation Discussions

infoset query

Former Member — Mon, 29 Jun 2009 09:26:26 GMT

Hi All,

Can we create an infoset query on BSEG (cluster) and COSP(Transparent) table.

If yes then pls tell how??

Regards

Shweta

Sandeep_Panghal — Mon, 29 Jun 2009 09:39:45 GMT

NO you can not use BSEG ==>The chosen table is a pool or cluster table. These tables may not be used in a table join.

Former Member — Mon, 29 Jun 2009 10:06:19 GMT

You cannot join BSEG and COSP.

But there is a way out.

You can create the infoset with base table as BSEG.

For the fields which you want to retreive data from COSP you can write the additional SELECT statement for Table COSP.

Former Member — Mon, 29 Jun 2009 10:33:51 GMT

Hi,

Can u pls explain it in detail ?

Regards

Shweta

Former Member — Mon, 29 Jun 2009 10:44:38 GMT

Hi Shweta,

While creating the Infoset in t-code SQ02 select the radio button for 'Direct read of table' and provide table name BSEG.

There are severals ways to get the fields of COSP.

1) In the 'Extra' tab create the fields for COSP table. For each field write the SELECT statement to fetch the fields from COSP.

2) In the Code Table you can select either START-OF-SELECTION Event or Record Processing.

Then fill an internal table from table COSP.

Use the data in internal table in the logic of Extra fields.