topic Re: Code within Infoset in Application Development and Automation Discussions

Code within Infoset

Former Member — Thu, 17 Mar 2011 18:00:35 GMT

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.

Re: Code within Infoset

Former Member — Thu, 17 Mar 2011 21:52:21 GMT

Suggestions anyone?

Re: Code within Infoset

Former Member — Fri, 18 Mar 2011 00:12:56 GMT

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

Re: Code within Infoset

Former Member — Fri, 18 Mar 2011 14:39:16 GMT

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