ISU_DB_EADRSTRTGRID_SINGLE SAP Function module - INTERNAL: Read EADRSTRTGRID (Direct Access)

ISU_DB_EADRSTRTGRID_SINGLE 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_EADRSTRTGRID_SINGLE into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: ER01
Released Date: Not Released
Processing type: Normal fucntion module

Pattern for FM ISU_DB_EADRSTRTGRID_SINGLE - ISU DB EADRSTRTGRID SINGLE

CALL FUNCTION 'ISU_DB_EADRSTRTGRID_SINGLE' "INTERNAL: Read EADRSTRTGRID (Direct Access)
  EXPORTING
    x_country =                 " adrstreet-country  Country Key
    x_strt_code =               " adrstreet-strt_code  Street Number
    x_house_num1 =              " adrc-house_num1
*   x_housenum = 0              " eadrstrtgrid-housenum_h
*   x_hsn_supp = SPACE          " eadrstrtgrid-hsn_supp_h  House number affix
    x_spebene =                 " spebene       Division
  IMPORTING
    y_eadrstrtgrid =            " eadrstrtgrid  Allocation of Grid to Street
  EXCEPTIONS
    NOT_FOUND = 1               "               Record does not exist
    .  "  ISU_DB_EADRSTRTGRID_SINGLE

ABAP code example for Function Module ISU_DB_EADRSTRTGRID_SINGLE

The ABAP code below is a full code listing to execute function module ISU_DB_EADRSTRTGRID_SINGLE 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:
ld_y_eadrstrtgrid  
 
 TYPE EADRSTRTGRID
.

 

SELECT single COUNTRY 
  FROM ADRSTREET 
  INTO @DATA(ld_x_country).

 

SELECT single STRT_CODE 
  FROM ADRSTREET 
  INTO @DATA(ld_x_strt_code).

 

SELECT single HOUSE_NUM1 
  FROM ADRC 
  INTO @DATA(ld_x_house_num1).

 

SELECT single HOUSENUM_H 
  FROM EADRSTRTGRID 
  INTO @DATA(ld_x_housenum).

 

SELECT single HSN_SUPP_H 
  FROM EADRSTRTGRID 
  INTO @DATA(ld_x_hsn_supp).


DATA(ld_x_spebene) = 'Check type of data required'.
.

CALL FUNCTION 'ISU_DB_EADRSTRTGRID_SINGLE'
  EXPORTING
    x_country =                  ld_x_country
    x_strt_code =                ld_x_strt_code
    x_house_num1 =               ld_x_house_num1
*   x_housenum =                 ld_x_housenum
*   x_hsn_supp =                 ld_x_hsn_supp
    x_spebene =                  ld_x_spebene
  IMPORTING
    y_eadrstrtgrid =             ld_y_eadrstrtgrid
  EXCEPTIONS
    NOT_FOUND =                  1
    .  "  ISU_DB_EADRSTRTGRID_SINGLE

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "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_y_eadrstrtgrid
 
 TYPE EADRSTRTGRID ,
ld_x_country
 
 TYPE ADRSTREET-COUNTRY ,
ld_x_strt_code
 
 TYPE ADRSTREET-STRT_CODE ,
ld_x_house_num1
 
 TYPE ADRC-HOUSE_NUM1 ,
ld_x_housenum
 
 TYPE EADRSTRTGRID-HOUSENUM_H ,
ld_x_hsn_supp
 
 TYPE EADRSTRTGRID-HSN_SUPP_H ,
ld_x_spebene
 
 TYPE SPEBENE .



SELECT single COUNTRY 
  FROM ADRSTREET 
  INTO ld_x_country.


SELECT single STRT_CODE 
  FROM ADRSTREET 
  INTO ld_x_strt_code.


SELECT single HOUSE_NUM1 
  FROM ADRC 
  INTO ld_x_house_num1.


SELECT single HOUSENUM_H 
  FROM EADRSTRTGRID 
  INTO ld_x_housenum.


SELECT single HSN_SUPP_H 
  FROM EADRSTRTGRID 
  INTO ld_x_hsn_supp.

ld_x_spebene = 'Check type of data required'.