SAP Reports / Programs
SAPDBTPI SAP ABAP Report - Logical Database TPI
SAPDBTPI is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The TPI database provides the following
If you would like to execute this report or see the full code listing simply enter SAPDBTPI 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 SAPDBTPI. "Basic submit
SUBMIT SAPDBTPI AND RETURN. "Return to original report after report execution complete
SUBMIT SAPDBTPI 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: STRNO = D Functional location
Selection Text: SELSCHEM = D Selection profile
Selection Text: DY_PARVW = D Partner function
Selection Text: DY_PARNR = D Partners
Selection Text: DY_ALKEY = D Labeling system
Selection Text: DY_ADRFL = Address selection
Selection Text: DATUV = D From date
Selection Text: DATUB = D To date
Title: Logical Database TPI
Text Symbol: AD1 = Address Search Active
Text Symbol: AD0 = Address Search Inactive
Text Symbol: 100 = No time interval, no free parameters
Text Symbol: 010 = FunctLocation selection
Text Symbol: 005 = Address
Text Symbol: 004 = Class
Text Symbol: 003 = to
Text Symbol: 002 = Period
Text Symbol: 001 = Partners
INCLUDES used within this REPORT SAPDBTPI
INCLUDE DBAFIF01.
INCLUDE DBEQIF01.
INCLUDE DBQMIF01.
INCLUDE DBQMIF02.
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:
ILOX_ITOBCUST_READ CALL FUNCTION 'ILOX_ITOBCUST_READ' IMPORTING e_itobcust = l_itobcust EXCEPTIONS not_maintained = 1 OTHERS = 2.
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.
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_tplnr_tab EXCEPTIONS invalid_shlpname = 1 invalid_values_table = 2 internal_error = 3 OTHERS = 4.
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.
CONVERSION_EXIT_ALPHA_INPUT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT' EXPORTING input = f_parnr_in IMPORTING output = f_parnr_in.
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' TABLES i_strno_tab = strno e_tplnr_tab = l_tplnr EXCEPTIONS not_found = 1 OTHERS = 2.
STATUS_PRE_READ CALL FUNCTION 'STATUS_PRE_READ' TABLES jsto_pre_tab = lt_objnr.
STATUS_CHECK_BY_SELSCHEM CALL FUNCTION 'STATUS_CHECK_BY_SELSCHEM' EXPORTING objnr = iflo-objnr selid = selschem IMPORTING fullfill = h_fullfill.
PM_DB_FILL_DIIFLO CALL FUNCTION 'PM_DB_FILL_DIIFLO' EXPORTING i_iflo = iflo io_ldb = go_eam_tob_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_tob_services IMPORTING e_diequi = ls_diequi.
PM_DB_FILL_DIEQUZ CALL FUNCTION 'PM_DB_FILL_DIEQUZ' EXPORTING i_equz = equz i_iloa = iloa IMPORTING e_diequz = diequz.
PM_DB_FILL_DIIHPA CALL FUNCTION 'PM_DB_FILL_DIIHPA' EXPORTING i_ihpa = ls_ihpa IMPORTING e_diihpa = diihpa.
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 = h_viqmel io_ldb = go_eam_tob_services IMPORTING e_diqmel = diqmel.
CR_WORKCENTER_PRE_READ CALL FUNCTION 'CR_WORKCENTER_PRE_READ' TABLES tarbid = l_tarbid.
CALL FUNCTION 'STATUS_PRE_READ' TABLES jsto_pre_tab = l_jsto_pre_tab.
PMSDO_PRE_READ CALL FUNCTION 'PMSDO_PRE_READ' TABLES ti_objnr = l_jsto_pre_tab.
PM_DB_FILL_DIAUFK CALL FUNCTION 'PM_DB_FILL_DIAUFK' EXPORTING i_viaufks = h_viaufks 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 = 'IFLOT' 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 = 'IFLOT' inherited_char = 'X' TABLES t_class = h_class t_objectdata = g_clobjdat EXCEPTIONS no_classification = 01 * no_classtypes = 02. "971763
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.
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.
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.
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.
OBJECT_KEY_GET CALL FUNCTION 'OBJECT_KEY_GET' EXPORTING i_objnr = h_objnr_tab-objnr IMPORTING e_ionra = h_ionra EXCEPTIONS OTHERS = 1.
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 SAPDBTPI or its description.