SAPDBEQI is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The EQI database provides the following
If you would like to execute this report or see the full code listing simply enter SAPDBEQI into the relevant SAP transactions such as SE38 or SE80
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.
Selection Text: SERNR = D Serial number
Selection Text: SELSCHEM = D Selection Profile
Selection Text: MATNR = D Material
Selection Text: EQUNR = D Equipment
Selection Text: EQKTX = D Equipment description
Selection Text: DY_PARVW = D Partner function
Selection Text: DY_PARNR = D Partners
Selection Text: DY_ADRFL = Address selection
Selection Text: DATUV = D From date
Selection Text: DATUB = D To date
Selection Text: ADRNR = D Address number
Selection Text: ADRMCO = D
Title: Logical Database EQI
Text Symbol: V02 = Serial number selection
Text Symbol: V01 = No free parameters
Text Symbol: AD1 = Address Search Active
Text Symbol: AD0 = Address Search Inactive
Text Symbol: 010 = Equipment selection
Text Symbol: 006 = from
Text Symbol: 005 = Address
Text Symbol: 004 = Classes
Text Symbol: 003 = to
Text Symbol: 002 = Period
Text Symbol: 001 = Partners
INCLUDE DBAFIF01.
INCLUDE DBEQIF01.
INCLUDE DBQMIF01.
INCLUDE MIOLXF67.
INCLUDE MIOLXF90. "FOR TIME ZONE FUNCTIONALITY
INCLUDE MIHIXF92. "FOR TIME ZONE FUNCTIONALITY
INCLUDE MIHIXF95. "FOR TIME ZONE FUNCTIONALITY
No SAP DATABASE tables are accessed within this REPORT code!
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.
CLCA_GET_CLASSTYPES_FROM_TABLE CALL FUNCTION 'CLCA_GET_CLASSTYPES_FROM_TABLE' EXPORTING spras = sy-langu table = h_table with_text = ' ' TABLES iklart = h_iklart EXCEPTIONS no_classtype_found = 01.
CLSC_SELECT_OBJECTS_FROM_CLASS CALL FUNCTION 'CLSC_SELECT_OBJECTS_FROM_CLASS' EXPORTING klart = h_iklart-klart table = h_table result_no_display = h_no_disp TABLES objects = clobj_tab EXCEPTIONS pf03 = 01 pf12 = 02 pf15 = 03.
PM_PARTNER_VALUE_REQUEST CALL FUNCTION 'PM_PARTNER_VALUE_REQUEST' EXPORTING parnr_imp = dy_parnr repid = h_repid IMPORTING parnr_exp = dy_parnr.
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 = h_equnr_tab EXCEPTIONS invalid_shlpname = 1 invalid_values_table = 2 internal_error = 3 OTHERS = 4.
STATUS_CHECK_BY_SELSCHEM CALL FUNCTION 'STATUS_CHECK_BY_SELSCHEM' EXPORTING objnr = v_equi_s-objnr selid = selschem IMPORTING fullfill = h_fullfill.
PM_DB_FILL_DIEQUI CALL FUNCTION 'PM_DB_FILL_DIEQUI' EXPORTING i_equi = equi i_eqkt = eqkt io_ldb = go_eam_tob_services IMPORTING e_diequi = diequi.
PM_DB_FILL_DIIHPA CALL FUNCTION 'PM_DB_FILL_DIIHPA' EXPORTING i_ihpa = ls_ihpa IMPORTING e_diihpa = diihpa.
PM_DB_FILL_DIEQUZ CALL FUNCTION 'PM_DB_FILL_DIEQUZ' EXPORTING i_equz = equz i_iloa = iloa IMPORTING e_diequz = diequz.
PM_DB_FILL_DIIFLO CALL FUNCTION 'PM_DB_FILL_DIIFLO' EXPORTING i_iflo = iflo io_ldb = go_eam_tob_services IMPORTING e_diiflo = diiflo.
CR_WORKCENTER_PRE_READ CALL FUNCTION 'CR_WORKCENTER_PRE_READ' TABLES tarbid = l_tarbid.
STATUS_PRE_READ CALL FUNCTION 'STATUS_PRE_READ' TABLES jsto_pre_tab = l_jsto_pre_tab.
PM_DB_FILL_DIQMEL CALL FUNCTION 'PM_DB_FILL_DIQMEL' EXPORTING i_viqmel = g_viqmel_tab io_ldb = go_eam_tob_services IMPORTING e_diqmel = diqmel.
PM_DB_FILL_DIQMEL CALL FUNCTION 'PM_DB_FILL_DIQMEL' EXPORTING i_viqmel = g_viqmel_tab io_ldb = go_eam_tob_services IMPORTING e_diqmel = diqmel.
CR_WORKCENTER_PRE_READ CALL FUNCTION 'CR_WORKCENTER_PRE_READ' TABLES tarbid = l_tarbid.
STATUS_PRE_READ CALL FUNCTION 'STATUS_PRE_READ' TABLES jsto_pre_tab = l_jsto_pre_tab.
PM_DB_FILL_DIAUFK CALL FUNCTION 'PM_DB_FILL_DIAUFK' EXPORTING i_viaufks = g_viaufks_tab io_ldb = go_eam_tob_services IMPORTING e_diaufk = diaufk.
CLCA_GET_CLASSTYPES_FROM_TABLE CALL FUNCTION 'CLCA_GET_CLASSTYPES_FROM_TABLE' EXPORTING spras = sy-langu table = h_table with_text = ' ' TABLES iklart = h_iklart EXCEPTIONS no_classtype_found = 01.
CLAF_CLASSIFICATION_OF_OBJECTS
CALL FUNCTION 'CLAF_CLASSIFICATION_OF_OBJECTS' EXPORTING classtype = h_iklart-klart features = ' ' object = h_object objecttable = 'EQUI' TABLES t_class = g_class t_objectdata = g_clobjdat EXCEPTIONS no_classification = 01 * no_classtypes = 02. "971763
CLAF_CLASSIFICATION_OF_OBJECTS CALL FUNCTION 'CLAF_CLASSIFICATION_OF_OBJECTS' EXPORTING classtype = diclass-klart clint = diclass-clint features = 'X' object = h_object objecttable = 'EQUI' inherited_char = 'X' TABLES t_class = h_class t_objectdata = g_clobjdat EXCEPTIONS no_classification = 01 * no_classtypes = 02. "971763
AUTHORITY_CHECK_EQUI CALL FUNCTION 'AUTHORITY_CHECK_EQUI' EXPORTING w_equi = ls_equi * W_EQUZ = * W_ILOA = tcode = 'IE03' i_tcode_check = ' ' i_call_badi = 'X' EXCEPTIONS no_authority_tcode = 1 no_authority_begrp = 2 no_authority_iwerk = 3 no_authority_ingrp = 4 no_authority_swerk = 5 no_authority_kostl = 6 no_profile_in_user_master_data = 7 error_in_user_master_data = 8 no_authority_badi = 9 OTHERS = 10.
AUTHORITY_CHECK_EQUI CALL FUNCTION 'AUTHORITY_CHECK_EQUI' EXPORTING w_equi = ls_equi w_equz = ls_equz w_iloa = ls_iloa tcode = 'IE03' i_tcode_check = ' ' i_call_badi = 'X' EXCEPTIONS no_authority_tcode = 1 no_authority_begrp = 2 no_authority_iwerk = 3 no_authority_ingrp = 4 no_authority_swerk = 5 no_authority_kostl = 6 no_profile_in_user_master_data = 7 error_in_user_master_data = 8 no_authority_badi = 9 OTHERS = 10.
INST_AUTHORITY_CHECK_ALL CALL FUNCTION 'INST_AUTHORITY_CHECK_ALL' EXPORTING qmart = diqmel-qmart iwerk = diqmel-iwerk swerk = diqmel-swerk tcode = h_tcode EXCEPTIONS keine_berechtigung_iwerk = 02 keine_berechtigung_swerk = 03 OTHERS = 09.
INST_AUTHORITY_CHECK_ALL CALL FUNCTION 'INST_AUTHORITY_CHECK_ALL' EXPORTING auart = diaufk-auart iwerk = diaufk-iwerk swerk = diaufk-swerk tcode = 'IW33' EXCEPTIONS keine_berechtigung_iwerk = 02 keine_berechtigung_swerk = 03 OTHERS = 09.
AUTHORITY_CHECK_IFLO CALL FUNCTION 'AUTHORITY_CHECK_IFLO' EXPORTING iflo_wa = ls_iflo tcode = 'IL03' i_tcode_check = ' ' i_call_badi = 'X' EXCEPTIONS no_authority_tcode = 1 no_authority_begrp = 2 no_authority_iwerk = 3 no_authority_ingrp = 4 no_authority_swerk = 5 no_authority_kostl = 6 no_profile_in_user_master_data = 7 error_in_user_master_data = 8 no_authority_badi = 9 OTHERS = 10.
IREP1_WARRANTY_PRE_READ CALL FUNCTION 'IREP1_WARRANTY_PRE_READ' TABLES ti_objnr = l_jsto_pre_tab EXCEPTIONS no_data_selected = 1 OTHERS = 2.
STATUS_PRE_READ CALL FUNCTION 'STATUS_PRE_READ' TABLES jsto_pre_tab = l_jsto_pre_tab.
OBJECT_KEY_GET CALL FUNCTION 'OBJECT_KEY_GET' EXPORTING i_objnr = h_objnr_tab-objnr IMPORTING e_ionra = h_ionra EXCEPTIONS OTHERS = 1.
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 SAPDBEQI or its description.