0FI_GL_4 selection enhancment and wrong result in RSA3

[Former Member]

Hello,

I have a need to add aditional selections to the 0FI_GL_4. By default it has FiscalYear/Period and Company Code.

I wrote a program to update the the table ROOSFIELD so that the selection field for this dataSourece are enabled for G/L account and Controlling area.

The data source now looks good in RSA3. I can see G/L account and Controlling area as selection. However these 2 new selections are not recognized. I mean the retured records are not restricted with either of these 2 new selections.

Any help would be appreicated. Regards.

Shaurya

[Former Member]

Hi Oliver,

perhaps I don't explain very good or I don't understan what you are talking about .I mean that If you extract values for a new fields, these fields have to been added in the extrac estructure (append ) , and when you add this fields that you are going to load for example using an exit, by default these fields are set as "Hide field" in the data source mantaince.

[Former Member]

Hi Carolina,

I understand your point but it looks like the fields are showing up in the RSA3 selection screen but by entering a value, the selection is not taken into account and the extractor fetches all the records.

In any case, being given the implementaion of the extractor (first header then items), those two fields are not supported for selective extraction.

hasta luego,

Olivier.

[leticial_locatelli]

Hi Olivier!

I'm having a very similar problem with the 0FI_AA_11 source.

I needed to mark 2 fields for selection so in this source so they were abailable for criteria selection in the infopackage.

First I tryed to make these changes with RSA6 transaction, but the fields BWASL and FISCPER were grayed out and I couldn't flagged them for selection.

I found this post (and very similar others) with the suggestion to make manual updates in the ROOSFIELD table.

I did so, and I set "X" for the 2 fields in the ROOSFIELD table. Now with RSA6 I see the flag set for selection and I also can see the 2 fields in the RSA3 selection screen. However, when I execute the extractor my criteria selection ir not taken into account.

Do you know if I have to make other settings to make this work?

Thanks a lot!

Leticia

[Former Member]

Hi,

this is not supported.

The datasource mechanism to extract the data is as follows: the system will first read BKPF with the supported selections. Then it will loop thorugh the accounting documents selected from BKPF and gather the corresponding data from BSEG.

Since HKONT and KOKRS aren't stored in BKPF, any selection on these fields is simply ignored.

If you explain further your requirement we could perhaps advise further...

Olivier.

[Former Member]

Hi,

when you include a new file for a datasource the system set by the default the field "Hide field" in RSA6 Tcode. Have you looked if this field in RSA6 is set?

I hope this can help you

[jaya_mogali]

Hi Shaurya,

Check oss 551044. There is Program mentioned here to make company code as selection criteria. Not sure If this helps.

Jaya.

[Former Member]

Hello Jaya,

The Company Code is available as selection criteria by default (I mean activating the DataSource from RSA5). It is however not working. (the result set from RSA3 does not restrict by the company code I provide. RSA3 just dumps all the records.

Regards,

Shaurya

[leticial_locatelli]

Hi Shaurya!

Did you find a solution to this matter? I'm having just the same problem you mention: RSA3 ignores the new fields I've updated in the ROOSFIELD table.

Any idea would help! Thanks,

Leticia

[jaya_mogali]

Hi Shaurya

Check Note 795093 - Selection for fiscal year/period is incorrect

Jaya

[Former Member]

Hello Jaya,

Thanks for your response. Unfortunately that note is not applicable to me as the selection for FiscalYrPeriod is working correctly for me. Aditionally we are on PI support pack SAPKIPZI4C (PI 2004_1_46C: patch 0012)

I did further testing and found that even the standard selection field Company Code (BUKRS), the selection is not working.

I did some debugging in debug mode and found out that RSA3 does pass the selection to the actual extraction function Module BWFID_GET_FIGL_ITEM but this Module is ignoring it.

Any help...

Regards,

Shaurya