infoset query

[Former Member]

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]

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]

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]

Hi,

Can u pls explain it in detail ?

Regards

Shweta

[Former Member]

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.