Skip to Content
author's profile photo
Former Member

0FI_GL_4 selection enhancment and wrong result in RSA3

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Posted on Nov 02, 2006 at 10:29 PM

    Hi Shaurya

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

    Jaya

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Nov 02, 2006 at 11:09 PM

    Hi Shaurya,

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

    Jaya.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 07:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 07:29 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 07:43 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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