Skip to Content

0FI_GL_14 Enhancement - adding new selection field

Hi Everyone

We have implemented 0FI_GL_14 for extracting New-GL data and have been using it for last 6 years.

Now we want to re-extract the data for some business reason. When we extract the data based on just Company Code, Fiscal Year, Posting Period and Ledger, it fails to extract data simply because this selection criteria doesn't use any Table Indexes available on table FAGLFLEXA.

We decided following 2 options:

1. Create required Secondary Index ( your comments please)

2. Extract data based on GL Accounts since secondary index based on this selection field is already available.

Option 1: avoiding this option since it will take up sizeable space in ECC system. Also might have adverse effect on day-to-day transactions involving FAGLFLEXA. already it has crossed 1TB size.

Option 2: Since GL Accounts (HKONT) field is not available for selection, we might need to enhance the datasource for this purpose. Please tell me whether this enhancement affect our ongoing Delta Queue. Also SAP doesn't support such enhancement, whether this is good option.

Please suggest other option which we have missed.


Deepak Salokhe

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2016 at 05:10 AM

    What do you mean by fail to extract?? Please post the error message.

    Option1 : you can create it for 2 week and once the load is done(full for BW). You can delete the index.

    Option 2 solution

    It should not impact Delta queue. This change might overwrite in any upgrade in ECC(not sure).



    Add a comment
    10|10000 characters needed characters exceeded

    • sorry for delay...

      I think I was not able to explain my issue correctly.

      I am aware of how to enable datasource field for selection. We can anytime go ahead and make the field as selection enabled. What I wanted to know is how will this activity affect the Delta queue of this datasource. Will the delta queue remain intact or delta queue will be invalidated due to introduction of new selection field.


      Deepak Salokhe

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.