SAP Reports / Programs

comments icon Comments

SAPDBR3L SAP ABAP Report - Log.Database for Reading Archived System Inventory Records







SAPDBR3L is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The database selects system inventory records and items from the archive...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter SAPDBR3L into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT SAPDBR3L. "Basic submit
SUBMIT SAPDBR3L AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBR3L VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: R3_IVNUM = Physical inventory number
Selection Text: R3_LGNUM = Warehouse number
Title: Log.Database for Reading Archived System Inventory Records
Text Symbol: 001 = Archive selection


INCLUDES used within this REPORT SAPDBR3L

INCLUDE MLLVSKON.


TABLES used within REPORT and the associated SELECT statement:





No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

ARCHIVE_OPEN_FOR_READ
  CALL FUNCTION 'ARCHIVE_OPEN_FOR_READ'
       EXPORTING
            OBJECT             = RL_LINKP
       IMPORTING
            ARCHIVE_HANDLE     = HANDLE
       EXCEPTIONS
            INTERNAL_ERROR     = 01
            NO_FILES_AVAILABLE = 02
            OBJECT_NOT_FOUND   = 03
            OPEN_ERROR         = 04.

ARCHIVE_GET_NEXT_OBJECT
      CALL FUNCTION 'ARCHIVE_GET_NEXT_OBJECT'
           EXPORTING
                ARCHIVE_HANDLE          = HANDLE
           EXCEPTIONS
                END_OF_FILE             = 01
                INTERNAL_ERROR          = 02
                OPEN_ERROR              = 03
                WRONG_ACCESS_TO_ARCHIVE = 04.

ARCHIVE_GET_NEXT_RECORD
        CALL FUNCTION 'ARCHIVE_GET_NEXT_RECORD'
             EXPORTING
                  ARCHIVE_HANDLE          = HANDLE
             IMPORTING
                  RECORD_STRUCTURE        = ARC_BUFFER-RNAME
                  RECORD                  = ARC_BUFFER-SEGMENT
             EXCEPTIONS
                  END_OF_OBJECT           = 01
                  INTERNAL_ERROR          = 02
                  WRONG_ACCESS_TO_ARCHIVE = 04.

ARCHIVE_CLOSE_FILE
    CALL FUNCTION 'ARCHIVE_CLOSE_FILE'
         EXPORTING
              ARCHIVE_HANDLE = HANDLE.


Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.







The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SAPDBR3L or its description.


   
 

SAPDBR3L - Log.Database for Reading Archived System Inventory Records
SAPDBR2L - documentation and ABAP source code
SAPDBR1L - Read Transfer Requirements from the Archive
SAPDBR0L - documentation and ABAP source code
SAPDBQUERYTESTLDB - Log. Database QUERYTESTLDB : Database Program
SAPDBQTQ - Logical database inspection methods