SAP Reports / Programs

comments icon Comments

SAPDBS1L SAP ABAP Report - Access Routines for Database S1L







SAPDBS1L is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program SAPDBS1L contains the access routines for reports...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 SAPDBS1L 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 SAPDBS1L. "Basic submit
SUBMIT SAPDBS1L AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBS1L 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: S1_LGNUM = Warehouse number
Selection Text: S1_LGPLA = Storage bin
Selection Text: S1_LGTYP = Storage type
Title: Access Routines for Database S1L
Text Symbol: 001 = Data base limits for stock figures by storage bins
Text Symbol: 100 = Only one stor.ty.
Text Symbol: 101 = W/o bin location
Text Symbol: 102 = Only one storage type, no free selection criteria


INCLUDES used within this REPORT SAPDBS1L

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:

RS_SELSCREEN_VERSION
  call function 'RS_SELSCREEN_VERSION'
       importing
            p_version = gt_version
       exceptions
            others    = 1.

SELECT_OPTIONS_RESTRICT
    call function 'SELECT_OPTIONS_RESTRICT'
         exporting
              restriction            = restrict
              db                     = con_x
         exceptions
              too_late               = 1
              repeated               = 2
              selopt_without_options = 3
              selopt_without_signs   = 4
              invalid_sign           = 5
              empty_option_list      = 6
              invalid_kind           = 7
              repeated_kind_a        = 8
              others                 = 9.

MARA_ARRAY_READ
    call function 'MARA_ARRAY_READ'
         tables
              ipre03 = gt_matnr.

MARA_SINGLE_READ
  call function 'MARA_SINGLE_READ'
       exporting
            matnr = lqua-matnr
       importing
            wmara = mara.

MAKT_ARRAY_READ
    call function 'MAKT_ARRAY_READ'
         tables
              ipre09 = lt_pre09.

MAKT_SINGLE_READ
  call function 'MAKT_SINGLE_READ'
       exporting
            matnr      = mara-matnr
            spras      = sy-langu
       importing
            wmakt      = makt
       exceptions
            wrong_call = 1
            not_found  = 2
            others     = 3.

MLGN_ARRAY_READ
    call function 'MLGN_ARRAY_READ'
         tables
              ipre12 = lt_pre12.

MLGN_SINGLE_READ
  call function 'MLGN_SINGLE_READ'
       exporting
            matnr = makt-matnr
            lgnum = lqua-lgnum
       importing
            wmlgn = mlgn.

MARC_ARRAY_READ
    call function 'MARC_ARRAY_READ'
         tables
              ipre01 = lt_pre01.

MARC_SINGLE_READ
  call function 'MARC_SINGLE_READ'
       exporting
            matnr = makt-matnr
            werks = lqua-werks
       importing
            wmarc = marc.


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


   
 

SAPDBS1L - Access Routines for Database S1L
SAPDBRUL - Selection of Posting Change Notices for Archiving
SAPDBRTL - Selection of Transfer Orders for Archiving
SAPDBRNM - Access Program for Database RNM
SAPDBRMM - Access Program for Data Base RMM
SAPDBRLI - Log. RLI Database: Database Program