J_3GBEST is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Stock List "Historical Stock" for Equipment and Materials You can use this report to dispay a list of "historical stock"...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 J_3GBEST into the relevant SAP transactions such as SE38 or SE80
Below is a list of transaction codes which are relevant to this SAP report
J3G` - Overview of Stock with History
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: P_GRID = Grid display
Selection Text: P_KZBEST = Only unrestricted-use stock
Selection Text: P_MATN = Material stock
Selection Text: P_PERS = Available personnel
Selection Text: P_RESSOU = Human resources
Selection Text: S_AGEXT = Sold-to party
Selection Text: S_BFART = Inventory management type
Selection Text: S_DBER = MRP Area
Selection Text: S_EIFR = Own/external indicator
Selection Text: S_EMPFAE = Recipient
Selection Text: S_EQART = Object Type
Selection Text: S_EQKTX = Equipment description
Selection Text: S_ETYP = Recipient type
Selection Text: S_KATNRC = Number in catalog
Selection Text: S_KZMENG = Equi. item / multipart equi.
Selection Text: S_LVART = Activity type
Selection Text: S_MAKTX = Material description
Selection Text: S_MATKL = Material group
Selection Text: S_MATNR = Material number
Selection Text: S_NACHN = Last name
Selection Text: S_SERGE = Manufacturer serial number
Selection Text: S_SERNR = Serial number
Selection Text: S_TPLKZ = Catalog code
Selection Text: S_TYPBZ = Model identification
Selection Text: S_VERWAL = Administrator
Selection Text: S_WEEXT = External ship-to party
Selection Text: P_EQUI = Equipment stock
Selection Text: P_DATVON = Key date
Selection Text: M_VARI = Layout
Selection Text: M_RESSOU = Material
Selection Text: E_VARI = Layout
Selection Text: E_RESSOU = Equipment
Title: Stock List "Historical Stock"
Text Symbol: 006 = Layout
Text Symbol: 010 = Available stock on key date:
Text Symbol: 011 = Started:
Text Symbol: 020 = Description not created
Text Symbol: 030 = Customer not found
INCLUDE J_3GBESTTOP.
INCLUDE J_3GHBESTAND_SELOPT.
INCLUDE J_3GHBESTAND_ON_SEL_SCREEN.
No SAP DATABASE tables are accessed within this REPORT code!
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = gt_list_top_of_page.
/SAPCEM/DD_DTEL_GET CALL FUNCTION '/SAPCEM/DD_DTEL_GET' EXPORTING typ = typ data_element = data_element IMPORTING eltext = eltext ellaenge = ellaenge EXCEPTIONS not_found = 1 wrong_type = 2 OTHERS = 3.
J_3G_ALV_HIERSEQ_LIST_DISPLAY CALL FUNCTION 'J_3G_ALV_HIERSEQ_LIST_DISPLAY' EXPORTING i_callback_program = repid i_callback_user_command = 'USER_COMMAND_FORM' is_layout = gs_layout it_fieldcat = gt_fieldcat it_sort = xsort i_default = 'X' i_tabname_header = g_tabname_header i_tabname_item = g_tabname_item is_keyinfo = gs_keyinfo it_events = gt_events TABLES t_outtab_header = xheader t_outtab_item = ausgabe EXCEPTIONS program_error = 1 OTHERS = 2.
REUSE_ALV_EVENTS_GET CALL FUNCTION 'REUSE_ALV_EVENTS_GET' EXPORTING i_list_type = 0 IMPORTING et_events = p_lt_events.
J_3G_ALV_LIST_DISPLAY CALL FUNCTION 'J_3G_ALV_LIST_DISPLAY' EXPORTING i_callback_program = repid i_callback_user_command = 'USER_COMMAND_FORM' is_layout = gs_layout it_fieldcat = gt_fieldcat it_sort = xsort it_events = gt_events is_variant = i_variant i_no_default_check = hlp_default_check
***Start of Alv Coding by C5063311 on 24-02-2005*** is_print = ls_print ***End of Alv Coding by C5063311 on 24-02-2005***
TABLES t_outtab = ausgabe EXCEPTIONS program_error = 1 OTHERS = 2.
REUSE_ALV_POPUP_TO_SELECT CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT' EXPORTING i_selection = p_select i_screen_start_column = 1 i_screen_start_line = 3 i_screen_end_column = 140 i_screen_end_line = 35 i_checkbox_fieldname = 'MARK' i_tabname = 'AUSGABE' it_fieldcat = gt_fieldcat i_callback_program = repid i_callback_user_command = 'USER_COMMAND_FORM' TABLES t_outtab = ausgabe EXCEPTIONS program_error = 1 OTHERS = 2.
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = 'J_3GBEST' i_internal_tabname = 'AUSGABE' i_structure_name = '/SAPCEM/AUSGABEH' i_client_never_display = 'X' * i_inclname = CHANGING ct_fieldcat = gt_fieldcat EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.
/SAPCEM/HBEST_TBEST_MERGE CALL FUNCTION '/SAPCEM/HBEST_TBEST_MERGE' EXPORTING i_cdate = p_datvon i_cequi = 'X' it_empfa = xempfae[] it_agext = s_agext[] it_weext = s_weext[] it_requi = resso_wa[] IMPORTING et_hbest = lt_hbest[] EXCEPTIONS OTHERS = 1.
/SAPCEM/HBEST_TBEST_MERGE CALL FUNCTION '/SAPCEM/HBEST_TBEST_MERGE' EXPORTING i_cdate = p_datvon i_cmatn = 'X' it_empfa = xempfae[] it_agext = s_agext[] it_weext = s_weext[] it_rmatn = resso_wa[] IMPORTING et_hbest = lt_hbest[] EXCEPTIONS OTHERS = 1.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = repid i_callback_user_command = 'USER_COMMAND_FORM' * it_list_commentary = gt_list_top_of_page i_callback_top_of_page = 'TOP_OF_PAGE' is_layout = gs_layout it_fieldcat = gt_fieldcat it_sort = xsort
***Start of Alv Coding by C5063311 on 24-02-2005*** * is_print = ls_print ***End of Alv Coding by C5063311 on 24-02-2005***
* it_events = gt_events is_variant = i_variant i_save = 'A' TABLES t_outtab = ausgabe EXCEPTIONS program_error = 1 OTHERS = 2.
MGV_SELOP_AFTER_INITIALIZATION CALL FUNCTION 'MGV_SELOP_AFTER_INITIALIZATION' EXPORTING program = mgv_matnr_prog TABLES selop = mgv_matnr_selopt_tab EXCEPTIONS no_programname = 1 OTHERS = 2.
MGV_SELOP_AFTER_START_OF_SEL CALL FUNCTION 'MGV_SELOP_AFTER_START_OF_SEL' EXPORTING selopt_name = mgv_matnr_selopt_tab-name TABLES range =
.
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 J_3GBEST or its description.