SAP Function Modules

ISU_DB_INNERJOIN_ERCHO_SELECT SAP Function module - INTERNAL: Select Billing Outsorting by Diverse Parameters







ISU_DB_INNERJOIN_ERCHO_SELECT is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name ISU_DB_INNERJOIN_ERCHO_SELECT into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: EVDB
Released Date: Not Released
Processing type: Normal fucntion module
Normal function module settings


Pattern for FM ISU_DB_INNERJOIN_ERCHO_SELECT - ISU DB INNERJOIN ERCHO SELECT





CALL FUNCTION 'ISU_DB_INNERJOIN_ERCHO_SELECT' "INTERNAL: Select Billing Outsorting by Diverse Parameters
* EXPORTING
*   x_released = ''             " regen-kennzx
*   x_cancelled = ''            " regen-kennzx
*   x_simulation = ''           " erch-simulation  Simulation Type
*   x_maxhits = 0               " rseumod-tbmaxsel  Maximum Number of Hits
* TABLES
*   t_belnr =                   " isu20_ranges_12
*   t_bukrs =                   " acc_s_ra_bukrs
*   t_sparte =                  " spart_ran
*   t_gpartner =                " isu20_ranges_10
*   t_vkont =                   " isu20_ranges_12  Selected Contract Accounts
*   t_vertrag =                 " isu20_ranges_10
*   t_portion =                 " isu20_ranges_8
*   t_ableinh =                 " isu20_ranges_8
*   t_billingrunno =            " isu20_ranges_12
*   t_valid =                   " isu20_ranges_10
*   t_manotsrt =                " isu20_ranges_8
*   t_v_ercho =                 " v_ercho       Result of Selection
  EXCEPTIONS
    NOT_FOUND = 1               "               No Entry Found
    SYSTEM_ERROR = 2            "
    .  "  ISU_DB_INNERJOIN_ERCHO_SELECT

ABAP code example for Function Module ISU_DB_INNERJOIN_ERCHO_SELECT

The ABAP code below is a full code listing to execute function module ISU_DB_INNERJOIN_ERCHO_SELECT including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).

DATA:
it_t_belnr  TYPE STANDARD TABLE OF ISU20_RANGES_12,"TABLES PARAM
wa_t_belnr  LIKE LINE OF it_t_belnr ,
it_t_bukrs  TYPE STANDARD TABLE OF ACC_S_RA_BUKRS,"TABLES PARAM
wa_t_bukrs  LIKE LINE OF it_t_bukrs ,
it_t_sparte  TYPE STANDARD TABLE OF SPART_RAN,"TABLES PARAM
wa_t_sparte  LIKE LINE OF it_t_sparte ,
it_t_gpartner  TYPE STANDARD TABLE OF ISU20_RANGES_10,"TABLES PARAM
wa_t_gpartner  LIKE LINE OF it_t_gpartner ,
it_t_vkont  TYPE STANDARD TABLE OF ISU20_RANGES_12,"TABLES PARAM
wa_t_vkont  LIKE LINE OF it_t_vkont ,
it_t_vertrag  TYPE STANDARD TABLE OF ISU20_RANGES_10,"TABLES PARAM
wa_t_vertrag  LIKE LINE OF it_t_vertrag ,
it_t_portion  TYPE STANDARD TABLE OF ISU20_RANGES_8,"TABLES PARAM
wa_t_portion  LIKE LINE OF it_t_portion ,
it_t_ableinh  TYPE STANDARD TABLE OF ISU20_RANGES_8,"TABLES PARAM
wa_t_ableinh  LIKE LINE OF it_t_ableinh ,
it_t_billingrunno  TYPE STANDARD TABLE OF ISU20_RANGES_12,"TABLES PARAM
wa_t_billingrunno  LIKE LINE OF it_t_billingrunno ,
it_t_valid  TYPE STANDARD TABLE OF ISU20_RANGES_10,"TABLES PARAM
wa_t_valid  LIKE LINE OF it_t_valid ,
it_t_manotsrt  TYPE STANDARD TABLE OF ISU20_RANGES_8,"TABLES PARAM
wa_t_manotsrt  LIKE LINE OF it_t_manotsrt ,
it_t_v_ercho  TYPE STANDARD TABLE OF V_ERCHO,"TABLES PARAM
wa_t_v_ercho  LIKE LINE OF it_t_v_ercho .


DATA(ld_x_released) = some text here

DATA(ld_x_cancelled) = some text here

SELECT single SIMULATION
FROM ERCH
INTO @DATA(ld_x_simulation).


SELECT single TBMAXSEL
FROM RSEUMOD
INTO @DATA(ld_x_maxhits).


"populate fields of struture and append to itab
append wa_t_belnr to it_t_belnr.

"populate fields of struture and append to itab
append wa_t_bukrs to it_t_bukrs.

"populate fields of struture and append to itab
append wa_t_sparte to it_t_sparte.

"populate fields of struture and append to itab
append wa_t_gpartner to it_t_gpartner.

"populate fields of struture and append to itab
append wa_t_vkont to it_t_vkont.

"populate fields of struture and append to itab
append wa_t_vertrag to it_t_vertrag.

"populate fields of struture and append to itab
append wa_t_portion to it_t_portion.

"populate fields of struture and append to itab
append wa_t_ableinh to it_t_ableinh.

"populate fields of struture and append to itab
append wa_t_billingrunno to it_t_billingrunno.

"populate fields of struture and append to itab
append wa_t_valid to it_t_valid.

"populate fields of struture and append to itab
append wa_t_manotsrt to it_t_manotsrt.

"populate fields of struture and append to itab
append wa_t_v_ercho to it_t_v_ercho. . CALL FUNCTION 'ISU_DB_INNERJOIN_ERCHO_SELECT' * EXPORTING * x_released = ld_x_released * x_cancelled = ld_x_cancelled * x_simulation = ld_x_simulation * x_maxhits = ld_x_maxhits * TABLES * t_belnr = it_t_belnr * t_bukrs = it_t_bukrs * t_sparte = it_t_sparte * t_gpartner = it_t_gpartner * t_vkont = it_t_vkont * t_vertrag = it_t_vertrag * t_portion = it_t_portion * t_ableinh = it_t_ableinh * t_billingrunno = it_t_billingrunno * t_valid = it_t_valid * t_manotsrt = it_t_manotsrt * t_v_ercho = it_t_v_ercho EXCEPTIONS NOT_FOUND = 1 SYSTEM_ERROR = 2 . " ISU_DB_INNERJOIN_ERCHO_SELECT
IF SY-SUBRC EQ 0. "All OK ELSEIF SY-SUBRC EQ 1. "Exception "Add code for exception here ELSEIF SY-SUBRC EQ 2. "Exception "Add code for exception here ENDIF.




ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:
ld_x_released  TYPE REGEN-KENNZX ,
it_t_belnr  TYPE STANDARD TABLE OF ISU20_RANGES_12 ,
wa_t_belnr  LIKE LINE OF it_t_belnr,
ld_x_cancelled  TYPE REGEN-KENNZX ,
it_t_bukrs  TYPE STANDARD TABLE OF ACC_S_RA_BUKRS ,
wa_t_bukrs  LIKE LINE OF it_t_bukrs,
ld_x_simulation  TYPE ERCH-SIMULATION ,
it_t_sparte  TYPE STANDARD TABLE OF SPART_RAN ,
wa_t_sparte  LIKE LINE OF it_t_sparte,
ld_x_maxhits  TYPE RSEUMOD-TBMAXSEL ,
it_t_gpartner  TYPE STANDARD TABLE OF ISU20_RANGES_10 ,
wa_t_gpartner  LIKE LINE OF it_t_gpartner,
it_t_vkont  TYPE STANDARD TABLE OF ISU20_RANGES_12 ,
wa_t_vkont  LIKE LINE OF it_t_vkont,
it_t_vertrag  TYPE STANDARD TABLE OF ISU20_RANGES_10 ,
wa_t_vertrag  LIKE LINE OF it_t_vertrag,
it_t_portion  TYPE STANDARD TABLE OF ISU20_RANGES_8 ,
wa_t_portion  LIKE LINE OF it_t_portion,
it_t_ableinh  TYPE STANDARD TABLE OF ISU20_RANGES_8 ,
wa_t_ableinh  LIKE LINE OF it_t_ableinh,
it_t_billingrunno  TYPE STANDARD TABLE OF ISU20_RANGES_12 ,
wa_t_billingrunno  LIKE LINE OF it_t_billingrunno,
it_t_valid  TYPE STANDARD TABLE OF ISU20_RANGES_10 ,
wa_t_valid  LIKE LINE OF it_t_valid,
it_t_manotsrt  TYPE STANDARD TABLE OF ISU20_RANGES_8 ,
wa_t_manotsrt  LIKE LINE OF it_t_manotsrt,
it_t_v_ercho  TYPE STANDARD TABLE OF V_ERCHO ,
wa_t_v_ercho  LIKE LINE OF it_t_v_ercho.


ld_x_released = some text here

"populate fields of struture and append to itab
append wa_t_belnr to it_t_belnr.

ld_x_cancelled = some text here

"populate fields of struture and append to itab
append wa_t_bukrs to it_t_bukrs.

SELECT single SIMULATION
FROM ERCH
INTO ld_x_simulation.


"populate fields of struture and append to itab
append wa_t_sparte to it_t_sparte.

SELECT single TBMAXSEL
FROM RSEUMOD
INTO ld_x_maxhits.


"populate fields of struture and append to itab
append wa_t_gpartner to it_t_gpartner.

"populate fields of struture and append to itab
append wa_t_vkont to it_t_vkont.

"populate fields of struture and append to itab
append wa_t_vertrag to it_t_vertrag.

"populate fields of struture and append to itab
append wa_t_portion to it_t_portion.

"populate fields of struture and append to itab
append wa_t_ableinh to it_t_ableinh.

"populate fields of struture and append to itab
append wa_t_billingrunno to it_t_billingrunno.

"populate fields of struture and append to itab
append wa_t_valid to it_t_valid.

"populate fields of struture and append to itab
append wa_t_manotsrt to it_t_manotsrt.

"populate fields of struture and append to itab
append wa_t_v_ercho to it_t_v_ercho.

Contribute (Add Comments)

Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name ISU_DB_INNERJOIN_ERCHO_SELECT or its description.