Change default option to read archive files

[former_member199412]

Hello all!!

i would like to ask you all a question and maybe someone can help me!!

We have some data archived with fi_documnt and we can read the data from different transactions without problems.

But, i would like to know if there is any possibility to change the default value when we select the data source.

For example, we want to read some data wich is archived. In fbl3n transaction, we click on "data sources" and a pop-up appears.

We select then "archive" and two more options appears.

"Archive information system" and "Select files manually".

The problem is the the option "Select files manually" is marked and default, and we would like to change it to the other option by default.

Is there any way to do that???

Many thanks in advance and best regards,

Gonzalo.

[Former Member]

Make an entry in table ASDATASRC1 with USE_INFSYS='X'.

Edited by: Mylène Dorias on Jul 27, 2010 5:29 PM

____________________________________________________________

Not sure, if I absolutely have to mention it, but you might want to seach in SMP with keyword ASDATASRC1, there's interesting notes like 596895

[former_member199412]

Hello Mylène,

Many thanks for your help. I have tried it this morning but no luck...

This is my ASDATASRC1 table:

100 RE FAGL_ACCOUNT_ITEMS_GL X

100 RE FBL3 X

100 RE FBL3N X

100 RE RFBELJ00 X

100 RE RFEPOJ00 X

100 RE RFITEMAP X

100 RE RFITEMAR X

100 RE RFITEMGL X

100 RE RFKKET00 X

100 RE RFKLET00 X

100 RE RFUSVB10 X

100 RE RFUSVS10 X

100 TR FAGL_ACCOUNT_ITEMS_GL X

100 TR FBL3 X

100 TR FBL3N X

100 TR RFBELJ00 X

100 TR RFEPOJ00 X

100 TR RFITEMAP X

100 TR RFITEMAR X

100 TR RFITEMGL X

100 TR RFKKET00 X

100 TR RFKLET00 X

100 TR RFUSVB10 X

100 TR RFUSVS10 X

I have tried with ReportTyp "RE" and "TR"....but in fbl3 transaction there is not active the "archive information system" option by default.

We have an NW 7.0 SP 20 system.

Thanks in advance and best regards,

Gonzalo.

[Former Member]

Good Morning, Gonzalo!

first, I apologise: I had a typo in that note number I gave you. The correct number is [note 596865|https://service.sap.com/sap/support/notes/596865]. Please read it - it has some specific information (on prerequesites, for example) - you might get more clues where to look ...

... other than that I can only say: ECC 5.0/NW 640/SP 19 - it works for us with FBL3N.

[Former Member]

Gonzalo,

something else ... I have just tried in another system and here I get a popup in FBL3N which says:

Report RFITEMGL is not intended for archiving object FI_DOCUMNT

    Message no. AS_DATASOURCE006

Diagnosis

    You want to use report RFITEMGL to read data for the archiving object
    FI_DOCUMNT, but report RFITEMGL is not intended to read data for this
    archiving object.

System response

    Running this report will probably not produce the desired results.
    However, this message is merely a warning, because it could still make
    sense for you to run the report for an archiving object that is not, or
    has not yet been assigned to this report.

Procedure

    Use F4 to select an appropriate archiving object. The F4 help list only
    contains archiving objects that can be used with this report.

    You can also run report RFITEMGL with archiving object FI_DOCUMNT.
    However, running the report might produce either no data or incorrect
    data.

Procedure for System Administration

    If you are sure that running report RFITEMGL together with archiving
    object FI_DOCUMNT produces meaningful data, you can enter the combination
    in Customizing. Use transaction SM30 to enter the following data into        <--------
    table ARCH_REPOW:                                                            <--------
         FI_DOCUMNT    RFITEMGL
    This will have the following results:
    o  This message will not appear again.
    o  Archiving object FI_DOCUMNT appears in the input help list (F4) of the
       data source dialog.
    o  Report RFITEMGL appears in the list of the Archive Administration
       (transaction SARA) read program.

The arrows point to the interesting bits. Please check in your system.

[Former Member]

Gonzalo,

I have been debugging AS_DATASOURCE_DEFAULT_GET.

the solution is - in table asdatasrc1 the entry should look like this:

Type   Report        USE_INFSYS
blank  RFITEMGL      X

[former_member199412]

Good morning Mylène!!

Many thanks!! I have checked it in my system and there was a mistake in the ASDATASRC1 table.

In 596865 note, there is an example for the ASDATASRC1 table:

001 RFITEMAP X

001 RFITEMAR X

001 RFITEMGL X

If you realize, the field "ReportTyp" is not maintained.

I have deleted this field for all the entries in the table and now it works. We have both datasources options selected by default.

But, this is not exactly what we want. The problem is that if you select both "Database" and "Archive", the system first reads the archived items and then the items from the database. So, if you are looking for some info about a fiscal year that is not archived, the system first of all tries to read the info for the archive information system and then for the database, so if there are not information in the archive information system for this year...the response time in bigger...

We want that only the "Database" datasource is selected by default, but, when the user select the "archive" datasource option, the "archive information system" appears by default instead of "select manually".

I gonna look for a workaround!!

Many thanks and bes regards,

Gonzalo.

[Former Member]

I think you can only solve this with a modification ... I am still debugging a bit and here I am in SAPLAS_DATASOURCE, LAS_DATASOURCEU01:

       CALL FUNCTION 'AS_DATASOURCE_DEFAULT_GET'
         EXPORTING
           i_report      = i_report
           i_reporttype  = i_reporttype
         IMPORTING
           e_use_infosys = l_use_infosys.
       IF l_use_infosys = 'X'.                          <---------
     *.....Parameter für automatischen Zugriff über AS setzen
         e_use_database = 'X'.             <-----------
         e_use_archive = 'X'.               <------------
         CLEAR e_archobj.
         e_use_infosys = 'X'.
         EXIT.
       ENDIF.

This seems to indicate that if you want to use the infosystem, both -the database-read and the archive-read - are flagged. Why this should be a logical path eludes me completely 🐵

If you were to make a very small modification at this point, it would be minimal invasive ... just an idea.

Have a nice week.

[former_member199412]

The problem is that we should modify the program in each support packages upgrade...

Anyway, many many thanks for your help!!!

Kind regards,

Gonzalo.