FRE_MD_IF_DELETE SAP ABAP Report - Delete Entries from Interface Tables of MC/MC-Hierarchy Interface

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

FRE_MD_IF_DELETE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for All Objects sent to SAP F&R via the SAP F&R PRODUCT Inbound Interface are stored in the Central SAP R/3 PI Product Table FRE_MD_PRODUCT...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 FRE_MD_IF_DELETE into the relevant SAP transactions such as SE38 or SE80

Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

FRE31 - Maintenance of Interface Tables MD4

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 FRE_MD_IF_DELETE. "Basic submit
SUBMIT FRE_MD_IF_DELETE AND RETURN. "Return to original report after report execution complete
SUBMIT FRE_MD_IF_DELETE 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: P_ARH = Deletion of Article Hierarchy
Selection Text: P_DIRECT = Access F&R by RFC
Selection Text: P_HIERID = Article Hierarchy ID
Selection Text: P_MC = Deletion of Merch.Categ.
Selection Text: P_MCH = Deletion of MC Hierarchy
Selection Text: P_PROD1 = Merchandize Categories
Selection Text: P_PROD2 = Merch. Categ. Hierarchies
Selection Text: S_PROD3 = Article Hierarchy Node
Title: Delete Entries from Interface Tables of MC/MC-Hierarchy Interface
Text Symbol: 001 = Merchandize Category Selection
Text Symbol: 002 = Merchandize Category Hierarchy Nodes Selection
Text Symbol: 003 = Deletion of Merchandize Categories from IF-Tables
Text Symbol: 004 = Deletion of MC-Hierarchy Nodes from IF-Tables
Text Symbol: 005 = Deletion of Data from IF-Tables
Text Symbol: 006 = Do you really want to proceed?
Text Symbol: 007 = Article Hierarchy Nodes selection
Text Symbol: 008 = Deletion of Article Hierarchy Nodes
Text Symbol: 009 = F&R Access
Text Symbol: 010 = Access F&R direct
Text Symbol: E06 = Authority Check failed.
Text Symbol: E07 = No Authorization to execute Report.

INCLUDES used within this REPORT FRE_MD_IF_DELETE

INCLUDE FRE_CONSTANTS.

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:

ENQUEUE_E_FRE_MD_PRODUCT CALL FUNCTION 'ENQUEUE_E_FRE_MD_PRODUCT' EXPORTING mode_fre_md_product = 'E' mandt = sy-mandt fre_prodt = '99' fre_product = 'FRE_MD_IF_DELETE' x_fre_prodt = ' ' x_fre_product = ' ' _scope = '2' _wait = ' ' _collect = ' ' EXCEPTIONS foreign_lock = 1 system_failure = 2 OTHERS = 3.

DEQUEUE_E_FRE_MD_PRODUCT CALL FUNCTION 'DEQUEUE_E_FRE_MD_PRODUCT' EXPORTING mode_fre_md_product = 'E' mandt = sy-mandt fre_prodt = prodt fre_product = prod * x_fre_prodt = ' ' * x_fre_product = ' ' _scope = '3' _synchron = ' ' _collect = ' '.

POPUP_TO_CONFIRM
  CALL FUNCTION 'POPUP_TO_CONFIRM'
    EXPORTING
     titlebar                    = text-005
      text_question               = text-006
*   TEXT_BUTTON_1               = 'Ja'(001)
*   ICON_BUTTON_1               = ' '
*   TEXT_BUTTON_2               = 'Nein'(002)
*   ICON_BUTTON_2               = ' '
*   DEFAULT_BUTTON              = '1'
*   DISPLAY_CANCEL_BUTTON       = 'X'
*   USERDEFINED_F1_HELP         = ' '
*   START_COLUMN                = 25
*   START_ROW                   = 6
*   POPUP_TYPE                  =
*   IV_QUICKINFO_BUTTON_1       = ' '
*   IV_QUICKINFO_BUTTON_2       = ' '
   IMPORTING
     answer                      = lv_handle
* TABLES
*   PARAMETER                   =
   EXCEPTIONS
     text_not_found              = 0
     OTHERS                      = 0
            .

FRE_MESSAGE_DB
      CALL FUNCTION 'FRE_MESSAGE_DB'
        EXPORTING
          mode           = 'I'
        TABLES
          messages       = it_messages[]
        EXCEPTIONS
          database_error = 0
          wrong_mode     = 0
          foreign_lock   = 0
          OTHERS         = 0.

FRE_MC_MCH_IF_MODIFY CALL FUNCTION 'FRE_MC_MCH_IF_MODIFY' EXPORTING modus = 'D' * INITIAL_LOAD = ' ' TABLES lt_klah = lt_klah lt_swor = lt_swor lt_kssk = lt_kssk EXCEPTIONS database_error = 1 nothing_done = 2 OTHERS = 3 .

FRE_MESSAGE_DB CALL FUNCTION 'FRE_MESSAGE_DB' EXPORTING mode = 'I' TABLES messages = it_messages[] EXCEPTIONS database_error = 0 wrong_mode = 0 foreign_lock = 0 OTHERS = 0.

FRE_PROD_BADI_CALL CALL FUNCTION 'FRE_PROD_BADI_CALL' EXPORTING prod_type = prod_type TABLES product_mod = lt_prod_mod EXCEPTIONS no_conversion = 1 conversion_error = 2 OTHERS = 3.

FRE_MESSAGE_DB CALL FUNCTION 'FRE_MESSAGE_DB' EXPORTING mode = 'I' TABLES messages = it_messages[] EXCEPTIONS database_error = 0 wrong_mode = 0 foreign_lock = 0 OTHERS = 0.

FRE_MD_PRODUCT_MODIFY CALL FUNCTION 'FRE_MD_PRODUCT_MODIFY' EXPORTING caller = prod_type modus = 'D' TABLES it_fre_md_product = lt_product EXCEPTIONS database_error = 1 duplicate_key = 0 OTHERS = 0.

FRE_MESSAGE_DB CALL FUNCTION 'FRE_MESSAGE_DB' EXPORTING mode = 'I' TABLES messages = it_messages[] EXCEPTIONS database_error = 0 wrong_mode = 0 foreign_lock = 0 OTHERS = 0.

AIC0_OWN_LOGSYSTEM_GET CALL FUNCTION 'AIC0_OWN_LOGSYSTEM_GET' IMPORTING e_own_logsystem = sender EXCEPTIONS own_logsystem_not_defined = 1 OTHERS = 2.

FRE_MD_PRODUCT_SEND CALL FUNCTION 'FRE_MD_PRODUCT_SEND' EXPORTING p_ref_id = session p_direct = p_direct ps_send_option = ls_send_option IMPORTING e_msg_txt = msg_txt TABLES it_fre_bif_matkey_iso = lt_matkey it_fre_bif_mattxt_iso = lt_mattxt it_fre_bif_marm_iso = lt_marm EXCEPTIONS communication_failure = 1 system_failure = 2 OTHERS = 3.

FRE_MD_PRODH_SEND CALL FUNCTION 'FRE_MD_PRODH_SEND' EXPORTING p_ref_id = session p_direct = p_direct ps_send_option = ls_send_option IMPORTING e_msg_txt = msg_txt TABLES it_fre_bif_prodh = lt_prodh EXCEPTIONS communication_failure = 1 system_failure = 2 OTHERS = 3.

FRE_DATASET_READ_WRITE_DELETE

CALL FUNCTION 'FRE_DATASET_READ_WRITE_DELETE' EXPORTING filename = filename path_to_file = ls_send_option-logical_path_md modus = 'I' caller = 'MD4' error = error session_id = session * Correction Note 889053 is_send_option = ls_send_option * Correction Note 889053 TABLES matkey_iso_tty = lt_matkey mattxt_iso_tty = lt_mattxt marm_iso_tty = lt_marm prodh = lt_prodh EXCEPTIONS path_not_found = 1 file_not_found = 0 no_file_created = 3 OTHERS = 0.

FRE_MESSAGE_DB
    CALL FUNCTION 'FRE_MESSAGE_DB'
      EXPORTING
        mode           = 'I'
      TABLES
        messages       = it_messages[]
      EXCEPTIONS
        database_error = 0
        wrong_mode     = 0
        foreign_lock   = 0
        OTHERS         = 0.

DEQUEUE_E_FRE_MD_PRODUCT CALL FUNCTION 'DEQUEUE_E_FRE_MD_PRODUCT' EXPORTING mode_fre_md_product = 'E' mandt = sy-mandt fre_prodt = '99' fre_product = 'FRE_MD_IF_DELETE' x_fre_prodt = ' ' x_fre_product = ' ' _scope = '3' _synchron = ' ' _collect = ' '.

DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = tabn langu = sy-langu TABLES dfies_tab = field_tab EXCEPTIONS not_found = 0 internal_error = 0 OTHERS = 0.

F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = fieldn dynpprog = sy-repid dynpnr = '1000' dynprofield = p_dynprofield value_org = 'S' TABLES value_tab = fre_key field_tab = field_tab EXCEPTIONS parameter_error = 0 no_values_found = 0 OTHERS = 0.

DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = tabn langu = sy-langu TABLES dfies_tab = field_tab EXCEPTIONS not_found = 0 internal_error = 0 OTHERS = 0.

F4IF_INT_TABLE_VALUE_REQUEST CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST' EXPORTING retfield = fieldn dynpprog = sy-repid dynpnr = '1000' dynprofield = p_dynprofield value_org = 'S' TABLES value_tab = lt_klah field_tab = field_tab EXCEPTIONS parameter_error = 0 no_values_found = 0 OTHERS = 0.

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

FRE_MD_IF_DELETE - Delete Entries from Interface Tables of MC/MC-Hierarchy Interface
FRE_MD_IF_DELETE - Delete Entries from Interface Tables of MC/MC-Hierarchy Interface
FRE_LOCGRP_INIT_LOAD_TOP - Include FRE_LOCGRP_INIT_LOAD_TOP
FRE_LOCGRP_INIT_LOAD_F02 - Include FRE_LOCGRP_INIT_LOAD_F02
FRE_LOCGRP_INIT_LOAD_F01 - Include FRE_LOCGRP_INIT_LOAD_F01
FRE_LOCGRP_INIT_LOAD - Transfer Reference Site Assignment to F&R

FGLETE09

FOPC_10_SP13_TL_UPGRADE

FGBBDD03

FRE_CHECK_LAYOUT_MOD_FORMS_GEN