SAP ISU_DB_INNERJOIN_ERCHO_SELECT Function Module for INTERNAL: Select Billing Outsorting by Diverse Parameters









ISU_DB_INNERJOIN_ERCHO_SELECT is a standard isu db innerjoin ercho select SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for INTERNAL: Select Billing Outsorting by Diverse Parameters processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for isu db innerjoin ercho select FM, simply by entering the name ISU_DB_INNERJOIN_ERCHO_SELECT into the relevant SAP transaction such as SE37 or SE38.

Function Group: EVDB
Program Name: SAPLEVDB
Main Program: SAPLEVDB
Appliation area: E
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function ISU_DB_INNERJOIN_ERCHO_SELECT pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'ISU_DB_INNERJOIN_ERCHO_SELECT'"INTERNAL: Select Billing Outsorting by Diverse Parameters
EXPORTING
* X_RELEASED = '' "
* X_CANCELLED = '' "
* X_SIMULATION = '' "Simulation Type
* X_MAXHITS = 0 "Maximum Number of Hits

TABLES
* T_BELNR = "
* T_VALID = "
* T_MANOTSRT = "
* T_V_ERCHO = "Result of Selection
* T_BUKRS = "
* T_SPARTE = "
* T_GPARTNER = "
* T_VKONT = "Selected Contract Accounts
* T_VERTRAG = "
* T_PORTION = "
* T_ABLEINH = "
* T_BILLINGRUNNO = "

EXCEPTIONS
NOT_FOUND = 1 SYSTEM_ERROR = 2
.



IMPORTING Parameters details for ISU_DB_INNERJOIN_ERCHO_SELECT

X_RELEASED -

Data type: REGEN-KENNZX
Default: ''
Optional: Yes
Call by Reference: No ( called with pass by value option)

X_CANCELLED -

Data type: REGEN-KENNZX
Default: ''
Optional: Yes
Call by Reference: No ( called with pass by value option)

X_SIMULATION - Simulation Type

Data type: ERCH-SIMULATION
Default: ''
Optional: Yes
Call by Reference: No ( called with pass by value option)

X_MAXHITS - Maximum Number of Hits

Data type: RSEUMOD-TBMAXSEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for ISU_DB_INNERJOIN_ERCHO_SELECT

T_BELNR -

Data type: ISU20_RANGES_12
Optional: Yes
Call by Reference: Yes

T_VALID -

Data type: ISU20_RANGES_10
Optional: Yes
Call by Reference: Yes

T_MANOTSRT -

Data type: ISU20_RANGES_8
Optional: Yes
Call by Reference: Yes

T_V_ERCHO - Result of Selection

Data type: V_ERCHO
Optional: Yes
Call by Reference: No ( called with pass by value option)

T_BUKRS -

Data type: ACC_S_RA_BUKRS
Optional: Yes
Call by Reference: Yes

T_SPARTE -

Data type: SPART_RAN
Optional: Yes
Call by Reference: Yes

T_GPARTNER -

Data type: ISU20_RANGES_10
Optional: Yes
Call by Reference: Yes

T_VKONT - Selected Contract Accounts

Data type: ISU20_RANGES_12
Optional: Yes
Call by Reference: No ( called with pass by value option)

T_VERTRAG -

Data type: ISU20_RANGES_10
Optional: Yes
Call by Reference: No ( called with pass by value option)

T_PORTION -

Data type: ISU20_RANGES_8
Optional: Yes
Call by Reference: Yes

T_ABLEINH -

Data type: ISU20_RANGES_8
Optional: Yes
Call by Reference: Yes

T_BILLINGRUNNO -

Data type: ISU20_RANGES_12
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

NOT_FOUND - No Entry Found

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

SYSTEM_ERROR -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

Copy and paste ABAP code example for ISU_DB_INNERJOIN_ERCHO_SELECT Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than 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 newer method of declaring data variables on the fly. 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), which i why i have stuck to the origianl for this example.

DATA:
lt_t_belnr  TYPE STANDARD TABLE OF ISU20_RANGES_12, "   
lv_not_found  TYPE ISU20_RANGES_12, "   
lv_x_released  TYPE REGEN-KENNZX, "   ''
lt_t_valid  TYPE STANDARD TABLE OF ISU20_RANGES_10, "   
lt_t_manotsrt  TYPE STANDARD TABLE OF ISU20_RANGES_8, "   
lt_t_v_ercho  TYPE STANDARD TABLE OF V_ERCHO, "   
lt_t_bukrs  TYPE STANDARD TABLE OF ACC_S_RA_BUKRS, "   
lv_x_cancelled  TYPE REGEN-KENNZX, "   ''
lv_system_error  TYPE REGEN, "   
lt_t_sparte  TYPE STANDARD TABLE OF SPART_RAN, "   
lv_x_simulation  TYPE ERCH-SIMULATION, "   ''
lv_x_maxhits  TYPE RSEUMOD-TBMAXSEL, "   0
lt_t_gpartner  TYPE STANDARD TABLE OF ISU20_RANGES_10, "   
lt_t_vkont  TYPE STANDARD TABLE OF ISU20_RANGES_12, "   
lt_t_vertrag  TYPE STANDARD TABLE OF ISU20_RANGES_10, "   
lt_t_portion  TYPE STANDARD TABLE OF ISU20_RANGES_8, "   
lt_t_ableinh  TYPE STANDARD TABLE OF ISU20_RANGES_8, "   
lt_t_billingrunno  TYPE STANDARD TABLE OF ISU20_RANGES_12. "   

  CALL FUNCTION 'ISU_DB_INNERJOIN_ERCHO_SELECT'  "INTERNAL: Select Billing Outsorting by Diverse Parameters
    EXPORTING
         X_RELEASED = lv_x_released
         X_CANCELLED = lv_x_cancelled
         X_SIMULATION = lv_x_simulation
         X_MAXHITS = lv_x_maxhits
    TABLES
         T_BELNR = lt_t_belnr
         T_VALID = lt_t_valid
         T_MANOTSRT = lt_t_manotsrt
         T_V_ERCHO = lt_t_v_ercho
         T_BUKRS = lt_t_bukrs
         T_SPARTE = lt_t_sparte
         T_GPARTNER = lt_t_gpartner
         T_VKONT = lt_t_vkont
         T_VERTRAG = lt_t_vertrag
         T_PORTION = lt_t_portion
         T_ABLEINH = lt_t_ableinh
         T_BILLINGRUNNO = lt_t_billingrunno
    EXCEPTIONS
        NOT_FOUND = 1
        SYSTEM_ERROR = 2
. " ISU_DB_INNERJOIN_ERCHO_SELECT




ABAP code using 7.40 inline data declarations to call FM ISU_DB_INNERJOIN_ERCHO_SELECT

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
"SELECT single KENNZX FROM REGEN INTO @DATA(ld_x_released).
DATA(ld_x_released) = ''.
 
 
 
 
 
"SELECT single KENNZX FROM REGEN INTO @DATA(ld_x_cancelled).
DATA(ld_x_cancelled) = ''.
 
 
 
"SELECT single SIMULATION FROM ERCH INTO @DATA(ld_x_simulation).
DATA(ld_x_simulation) = ''.
 
"SELECT single TBMAXSEL FROM RSEUMOD INTO @DATA(ld_x_maxhits).
 
 
 
 
 
 
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!