SAP Reports / Programs

comments icon Comments

SAPDBR0L SAP ABAP Report - documentation and ABAP source code







SAPDBR0L is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The data base selects transfer order headers 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 SAPDBR0L 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 SAPDBR0L. "Basic submit
SUBMIT SAPDBR0L AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBR0L 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: R0_LGNUM = Warehouse number
Selection Text: R0_TANUM = TO number
Text Symbol: 001 = Archive selection


INCLUDES used within this REPORT SAPDBR0L

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_TA
       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 SAPDBR0L or its description.


   
 

SAPDBR0L - documentation and ABAP source code
SAPDBQUERYTESTLDB - Log. Database QUERYTESTLDB : Database Program
SAPDBQTQ - Logical database inspection methods
SAPDBQNQ - 'QNQ' Logical Database
SAPDBQMQ - Logical Database for Master Inspection Characteristics
SAPDBQMI - PM Notifications Logical Database