Skip to Content
author's profile photo Former Member
0
Former Member

archieve data issue - BKPF

Posted on Mar 30, 2011 at 05:13 AM 175 Views

Hi Experts,

My Z report is picking records from BKPF table and showing in ALV display. There are some document numbers which are archieved and Z report is not picking those. Client has requirement to show archieved records also.

Can anyone help me with the procedure to read archieved records. Other words how to establish link between archieved records.

Thanks in Advance !

Regards,

Mayank

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Klaus Babl
    Klaus Babl
    Posted on Mar 30, 2011 at 05:43 AM
    0

    Hi,

    you can find a list of archived documents in table ARIX_BKPF.

    You can read it from archive with

    call function 'FI_DOCUMENT_READ_SINGLE'

    This should work upt to SAP Release 4.7.

    In ECC there is a new technology. Which SAP Release do you have?

    Regards,

    Klaus

    Edited by: Klaus Babl on Mar 30, 2011 7:50 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Thomas Zloch
    Thomas Zloch
    Posted on Mar 30, 2011 at 07:07 AM
    0

    That's what standard report RFBUEB00 does, why are you re-inventing the wheel?

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2011 at 08:36 AM
    0

    Thanks for reply !

    I am using 4.6 version. I want to filter records based on selection criteria provided by user. These records should also fetch archieved records.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2011 at 01:09 PM
    0

    Hi Klaus,

    I tried checking ARIX_BKPF table but it doesnt have document number I am looking for. Still it does have same year other document number. Is there any possibility of settings where some company code are not stored in this table.

    The FM will fetch one record at a time which is not useful in this case as I need to get all the records which are archieved.

    any other possibility ?

    Add a comment
    10|10000 characters needed characters exceeded

    • Brad Bohn
      Mar 30, 2011 at 02:11 PM

      Use a custom archive infostructure for a fast read of all fields in a custom program. This increases data storage but storage is cheap these days. You'll need access to the archived records in order to fill the info structure. The records that go into any infostructure can be filtered.

      Also, your access to the archived data should be fast with ARIX_BKPF if you have used the correct selection criteria because a pointer will exist in the standard infostructure if it's populated.

      Edited by: Brad Bohn on Mar 30, 2011 9:12 AM

  • author's profile photo Former Member
    Former Member
    Posted on May 05, 2011 at 01:52 PM
    0

    Hi Guys,

    I discovered that our system using 3rd party software PBS for archieving. We can fetch the records which are archieved by using following method.

    CALL FUNCTION '/PBS/SELECT_INTO_TABLE'

    EXPORTING

    ARCHIV = 'CFI'

    OPTION = ''

    TABNAME = 'BKPF'

    SCHL1_NAME = 'BUKRS'

    SCHL1_VON = so_bukrs-low

    SCHL1_BIS = so_bukrs-high

    SCHL2_NAME = 'BLDAT'

    SCHL2_VON = SO_BLDAT-LOW

    SCHL2_BIS = SO_BLDAT-HIGH

    TABLES

    I_TABELLE = ITBKPF

    EXCEPTIONS

    EOF = 4

    OTHERS = 2.

    Where as BKPF is table name. ARCHIV is the file name. For FI it will be CFI, for MM CMM etc.

    Add a comment
    10|10000 characters needed characters exceeded

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.