Code within Infoset

[Former Member]

Experts,

I'm not an ABAPPER but need help extracting data from an infoset I've built based on a logical datasource.

My infoset was created using 'BRM' logical database. I'm pulling fields from BSEG and BKPF.

I need to restrict the result set to a specific GL account range (BSEG-HKONT) and Reference Transaction type (BKPF-AWTYP)

How do I do this? I tried putting select statement in the "extra" section. It doesn't appear to work. In addition, I've created an ECC datasource which will be used to bring data into BW.

Please help.

[Former Member]

Suggestions anyone?

[Former Member]

Tiffani:

Extras / Selections TAB / Create icon

Put a name like BR_HKONT

Pick Selection criterion and OK,

Write a description and then FORMAT FOR = bseg-hkont

The same procedure for each field that you want to add.

Regards.

Eguiluz

[Former Member]

Thanks for the response.

I tried that and was able to do it successfully. However, I need to filter the data in ECC before bringing it into BW.

When creating the selection crit, and replicating the datasource in BW, it performing an external sort on BKPF when I execute the extractor. This is hammering performance of the extractor. Basis advised me to make the selection inside ECC then bring the filtered data into BW.

How do I populate the Sel Crit I created within the infoset?

thanks