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
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
That's what standard report RFBUEB00 does, why are you re-inventing the wheel?
Thomas
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 ?
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