SAP Reports / Programs

comments icon Comments

SAPDBAFI SAP ABAP Report - Order Selections







SAPDBAFI is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The logical database is not released ..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 SAPDBAFI 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 SAPDBAFI. "Basic submit
SUBMIT SAPDBAFI AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBAFI 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: WAERS = D .
Selection Text: VAWRK = D .
Selection Text: STRNO = D .
Selection Text: SERMAT = D .
Selection Text: SERIALNR = D .
Selection Text: SELSCHEM = D .
Selection Text: QMNUM = D .
Selection Text: GEWRK = D .
Selection Text: EQUNR = D .
Selection Text: DY_PARVW = D .
Selection Text: DY_PARNR = D .
Selection Text: DY_OFN = D .
Selection Text: DY_MAB = D .
Selection Text: DY_IAR = D .
Selection Text: DY_HIS = D .
Selection Text: DEVICEID = D .
Selection Text: DATUV = D .
Selection Text: DATUB = D .
Selection Text: AUFNR = D .
Selection Text: AUART = D .
Title: Order Selections
Text Symbol: V01 = No free parameters
Text Symbol: CU3 = CU Design
Text Symbol: CU2 = Construction Measure
Text Symbol: CU1 = Compatible Unit Data
Text Symbol: AD1 = Address Search Active
Text Symbol: AD0 = Address Search Inactive
Text Symbol: 011 = Partners
Text Symbol: 010 = Addr.
Text Symbol: 009 = to
Text Symbol: 008 = Period
Text Symbol: 007 = Order selection
Text Symbol: 006 = Order status
Text Symbol: 005 = Sel.profile
Text Symbol: 004 = Historical
Text Symbol: 003 = Completed
Text Symbol: 002 = In process
Text Symbol: 001 = Outstanding





INCLUDES used within this REPORT SAPDBAFI

INCLUDE DBAFIF01.
INCLUDE DBQMIF01.
INCLUDE DBQMIF02.
INCLUDE DBQMIF03.
INCLUDE MIOLXF65.
INCLUDE MIOLXF67.
INCLUDE MIOLXF90. "FOR TIME ZONE FUNCTIONALITY
INCLUDE MIHIXF92. "FOR TIME ZONE FUNCTIONALITY
INCLUDE MIHIXF95. "FOR TIME ZONE FUNCTIONALITY


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:

PM_PARTNER_LENGTH
      CALL FUNCTION 'PM_PARTNER_LENGTH'
        EXPORTING
          parnr_imp              = h_parnr
          parvw                  = h_parvw
*         NRART                  =
        IMPORTING
          parnr_exp              = h_parnr
*         NRART_EXP              =
        EXCEPTIONS
          parvw_and_nrart_inital = 01
          invalid_parvw          = 02.

PM_PARTNER_VALUE_REQUEST
  CALL FUNCTION 'PM_PARTNER_VALUE_REQUEST'
    EXPORTING
      parnr_imp = dy_parnr
      repid     = h_repid
    IMPORTING
      parnr_exp = dy_parnr.

IREP1_LOCATION_CONVERSION
*  call function 'IREP1_LOCATION_CONVERSION'
*       exporting
*            check_maxcount   = 'X'
*       tables
*            i_strno_tab      = strno
*            e_tplnr_tab      = tplnr
*       exceptions
*            not_found        = 1
*            too_many_entries = 2
*            others           = 3.

CR_WORKCENTER_PRE_READ
  CALL FUNCTION 'CR_WORKCENTER_PRE_READ'
    TABLES
      tarbid = h_tarbid.

STATUS_BUFFER_REFRESH
    CALL FUNCTION 'STATUS_BUFFER_REFRESH'.

STATUS_PRE_READ
    CALL FUNCTION 'STATUS_PRE_READ'
      TABLES
        jsto_pre_tab = h_objnr_tab.

PMSDO_PRE_READ
  CALL FUNCTION 'PMSDO_PRE_READ'
    TABLES
      ti_objnr = h_objnr_tab.

STATUS_CHECK_BY_SELSCHEM
      CALL FUNCTION 'STATUS_CHECK_BY_SELSCHEM'
        EXPORTING
          objnr    = h_viaufks-objnr
          selid    = selschem
        IMPORTING
          fullfill = h_fullfill.

PM_DB_FILL_DIAUFK
    CALL FUNCTION 'PM_DB_FILL_DIAUFK'
      EXPORTING
        i_viaufks = h_viaufks
      IMPORTING
        e_diaufk  = diaufk.

CR_WORKCENTER_PRE_READ
  CALL FUNCTION 'CR_WORKCENTER_PRE_READ'
    TABLES
      tarbid = h_tarbid.

STATUS_BUFFER_REFRESH
    CALL FUNCTION 'STATUS_BUFFER_REFRESH'.

STATUS_PRE_READ
    CALL FUNCTION 'STATUS_PRE_READ'
      TABLES
        jsto_pre_tab = h_objnr_tab.

PMSDO_PRE_READ
  CALL FUNCTION 'PMSDO_PRE_READ'
    TABLES
      ti_objnr = h_objnr_tab.

PM_DB_FILL_DIAUFK_PMHI
    CALL FUNCTION 'PM_DB_FILL_DIAUFK_PMHI'
      EXPORTING
        i_hikola = h_hikola
      IMPORTING
        e_diaufk = diaufk.






PM_DB_FILL_DIIHPA
    CALL FUNCTION 'PM_DB_FILL_DIIHPA'
      EXPORTING
        i_ihpa   = ls_ihpa
      IMPORTING
        e_diihpa = diihpa.

PM_DB_FILL_DIAUFKU
      CALL FUNCTION 'PM_DB_FILL_DIAUFKU'
        EXPORTING
          i_viaufks = transa
          i_level   = subord-ord_level
          io_ldb    = go_eam_afi_services
        IMPORTING
          e_diaufku = diaufku.

PM_DB_FILL_DIAUFK_PMHI
      CALL FUNCTION 'PM_DB_FILL_DIAUFK_PMHI'
        EXPORTING
          i_hikola = transa_h
        IMPORTING
          e_diaufk = diaufk.

PM_DB_FILL_DIQMEL
    CALL FUNCTION 'PM_DB_FILL_DIQMEL'
      EXPORTING
        i_viqmel = 
        io_ldb   = go_eam_afi_services
      IMPORTING
        e_diqmel = diqmel.

PM_DB_FILL_DIIFLO
  CALL FUNCTION 'PM_DB_FILL_DIIFLO'
    EXPORTING
      i_iflo   = iflo
      io_ldb   = go_eam_afi_services
    IMPORTING
      e_diiflo = diiflo.

PM_DB_FILL_DIEQUI
  CALL FUNCTION 'PM_DB_FILL_DIEQUI'
    EXPORTING
      i_equi   = equi
      i_eqkt   = eqkt
      io_ldb   = go_eam_afi_services
    IMPORTING
      e_diequi = diequi.

CR_WORKSTATION_READ
        CALL FUNCTION 'CR_WORKSTATION_READ'
          EXPORTING
            id        = diafvc-arbid
            msgty     = 'S'
          IMPORTING
            arbpl     = diafvc-gewrk
          EXCEPTIONS
            not_found = 01.

HR_INTEGRATION_CHECK
          CALL FUNCTION 'HR_INTEGRATION_CHECK'
            IMPORTING
              plvar = plvar.

RH_READ_OBJECT
        CALL FUNCTION 'RH_READ_OBJECT'
          EXPORTING
            plvar           = plvar
            otype           = 'P'
            objid           = diafvc-pernr
            begda           = diafvc-fssad
            endda           = diafvc-fssad
            langu           = sy-langu
            ointerval       = ' '
            store           = 'X' "/ BUFFERING IS ON!
            check_stru_auth = ' '
            read_db         = ' '
          IMPORTING
            short           = diafvc-short
            stext           = diafvc-stext
          EXCEPTIONS
            not_found       = 1
            OTHERS          = 2.

PM_DB_FILL_DIAFVC
      CALL FUNCTION 'PM_DB_FILL_DIAFVC'
        EXPORTING
          i_viafvc = h_vornr_tab
          io_ldb   = go_eam_afi_services
        IMPORTING
          e_diafvc = diafvc.

PM_DB_FILL_DIAFVC
        CALL FUNCTION 'PM_DB_FILL_DIAFVC'
          EXPORTING
            i_viafvc = h_uvorn_tab
            io_ldb   = go_eam_afi_services
          IMPORTING
            e_diafvc = diafvc.

HR_INTEGRATION_CHECK
    CALL FUNCTION 'HR_INTEGRATION_CHECK'
      IMPORTING
        plvar = plvar.

RH_READ_OBJECT
      CALL FUNCTION 'RH_READ_OBJECT'
        EXPORTING
          plvar           = plvar
          otype           = -otype
          objid           = -pernr
          begda           = -fstad
          endda           = -fstad
          langu           = sy-langu
          ointerval       = ' '
          store           = 'X'  "/ BUFFERING IS ON!
          check_stru_auth = ' '
          read_db         = ' '
        IMPORTING
          short           = -short
          stext           = -stext
        EXCEPTIONS
          not_found       = 1
          OTHERS          = 2.

CO_ZF_CHECK_DBSKZ
        CALL FUNCTION 'CO_ZF_CHECK_DBSKZ'
          EXPORTING
            postyp = g_resbd_tab-postp
          IMPORTING
            dbskz  = g_resbd_tab-dbskz.

CO_BC_RESB_PRE_READ
      CALL FUNCTION 'CO_BC_RESB_PRE_READ'
        EXPORTING
          trtyp_imp         = 'A'
        TABLES
          rsnum_pre_tab     = h_rsnum_tab
        EXCEPTIONS
          release_no_change = 01.

CO_BC_RESBBT_GET
      CALL FUNCTION 'CO_BC_RESBBT_GET'
        EXPORTING
          aufnr_imp  = diaufk-aufnr
        TABLES
          resbbt_exp = g_resbd_tab.

STATUS_CHECK
      CALL FUNCTION 'STATUS_CHECK'
        EXPORTING
          objnr             = g_resbd_tab-objnr
          status            = 'I0013'
        EXCEPTIONS
          object_not_found  = 1
          status_not_active = 2
          OTHERS            = 3.

CF_BT_CO_FHM_FROM_AFFH_FILL
    CALL FUNCTION 'CF_BT_CO_FHM_FROM_AFFH_FILL'
      EXPORTING
        affh_imp             = h_affh_tab
      IMPORTING
*       AFFHD_EXP            = DIAFFH  " FLG_STATX_IMP = 'X'
        affhd_exp            = affhd
      EXCEPTIONS
        fhm_master_not_found = 01.

STATUS_CHECK
    CALL FUNCTION 'STATUS_CHECK'
      EXPORTING
        objnr             = affhd-objnr
        status            = 'I0013'
      EXCEPTIONS
        status_not_active = 1
        object_not_found  = 0
        OTHERS            = 0.

PM_DB_FILL_DIAFRU






    
    
    
    
  







    CALL FUNCTION 'PM_DB_FILL_DIAFRU'
      EXPORTING
        i_afru   = ls_afru
      IMPORTING
        e_diafru = diafru.

CR_WORKCENTER_PRE_READ
  CALL FUNCTION 'CR_WORKCENTER_PRE_READ'
    TABLES
      tarbid = h_tarbid.

PM_DB_FILL_DIAFAB
    CALL FUNCTION 'PM_DB_FILL_DIAFAB'
      EXPORTING
        i_afab   = h_afab_tab
      IMPORTING
        e_diafab = diafab.

PM_DB_FILL_DIOBJK
      CALL FUNCTION 'PM_DB_FILL_DIOBJK'
        EXPORTING
          i_objk   = h_objk
        IMPORTING
          e_diobjk = diobjk.

PM_DB_FILL_DIQMEL
    CALL FUNCTION 'PM_DB_FILL_DIQMEL'
      EXPORTING
        i_viqmel = 
        io_ldb   = go_eam_afi_services
      IMPORTING
        e_diqmel = ls_diqmel.

PM_DB_FILL_DIIFLO
      CALL FUNCTION 'PM_DB_FILL_DIIFLO'
        EXPORTING
          i_iflo   = ls_iflo
          io_ldb   = go_eam_afi_services
        IMPORTING
          e_diiflo = ls_diiflo.

PM_DB_FILL_DIIFLO
    CALL FUNCTION 'PM_DB_FILL_DIIFLO'
      EXPORTING
        i_iflo   = iflo
        io_ldb   = go_eam_afi_services
      IMPORTING
        e_diiflo = ls_diiflo.

PM_DB_FILL_DIEQUI
    CALL FUNCTION 'PM_DB_FILL_DIEQUI'
      EXPORTING
        i_equi   = equi
        i_eqkt   = eqkt
        io_ldb   = go_eam_afi_services
      IMPORTING
        e_diequi = ls_diequi.

INST_AUTHORITY_CHECK_ALL
  CALL FUNCTION 'INST_AUTHORITY_CHECK_ALL'
    EXPORTING
      begrp                    = lv_begru
      iwerk                    = is_diaufk-iwerk
      swerk                    = is_diaufk-swerk
      tcode                    = 'IW33'
      auart                    = is_diaufk-auart
      ingrp                    = is_diaufk-ingpr
*     AKTTYP                   = ' '
      kokrs                    = is_diaufk-kokrs
      kostl                    = is_diaufk-kostl
    EXCEPTIONS
      keine_berechtigung_begrp = 1
      keine_berechtigung_iwerk = 2
      keine_berechtigung_swerk = 3
      keine_berechtigung_auart = 4
      keine_berechtigung_ingrp = 5
      keine_berechtigung_kostl = 6
      OTHERS                   = 7.

INST_AUTHORITY_CHECK_ALL
  CALL FUNCTION 'INST_AUTHORITY_CHECK_ALL'
    EXPORTING
      qmart                    = diqmel-qmart
      iwerk                    = diqmel-iwerk
      swerk                    = diqmel-swerk
      tcode                    = h_tcode
      ingrp                    = diqmel-ingrp
      kokrs                    = diqmel-kokrs
      kostl                    = diqmel-kostl
    EXCEPTIONS
      keine_berechtigung_begrp = 1
      keine_berechtigung_iwerk = 2
      keine_berechtigung_swerk = 3
      keine_berechtigung_auart = 4
      keine_berechtigung_ingrp = 5
      keine_berechtigung_kostl = 6
      OTHERS                   = 7.

OBJECT_KEY_GET
    CALL FUNCTION 'OBJECT_KEY_GET'
      EXPORTING
        i_objnr = g_objnr_tab-objnr
      IMPORTING
        e_ionra = h_ionra
      EXCEPTIONS
        OTHERS  = 1.

HELP_AUART
  CALL FUNCTION 'HELP_AUART'
    EXPORTING
      autyp             = 30
      display           = ' '
    IMPORTING
      select_auart      = auart-low
    EXCEPTIONS
      no_auart_to_autyp = 1
      OTHERS            = 2.

HELP_AUART
  CALL FUNCTION 'HELP_AUART'
    EXPORTING
      autyp             = 30
      display           = ' '
    IMPORTING
      select_auart      = auart-high
    EXCEPTIONS
      no_auart_to_autyp = 1
      OTHERS            = 2.

F4_SELECT_FROM_SEARCH_HELP
  CALL FUNCTION 'F4_SELECT_FROM_SEARCH_HELP'
    EXPORTING
      shlp                 = g_shlp
    TABLES
      selopt_tab           = g_selopt_tab
      fields               = h_field_tab
      values               = g_adrnr_tab
    EXCEPTIONS
      invalid_shlpname     = 1
      invalid_values_table = 2
      internal_error       = 3
      OTHERS               = 4.


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


   
 

SAPDBAFI - Order Selections
SAPDBADA - Logical Database FI-AA
SAPDBACE_SOP_LDBPS - Log. Database ACEPS_003 : Database Program
SAPDBACE_SOP_LDBDS - Logical Database ACEDS_003: Database Program
SAPDBACE_FILA_LDBPS - Log. Database ACEPS_003 : Database Program
SAPDBACE_FILA_LDBDS - Logical Database ACEDS_003: Database Program