SAP Function Modules

comments icon Comments

NOR3_READ_TABLE SAP Function module - Read Table in Core System







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

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


Pattern for FM NOR3_READ_TABLE - NOR3 READ TABLE 





CALL FUNCTION 'NOR3_READ_TABLE' "Read Table in Core System
  EXPORTING
    query_table =               " dd02l-tabname
*   delimiter = SPACE           " sonv-flag
*   no_data = SPACE             " sonv-flag
*   rowskips = '0'              " soid-accnt
*   rowcount = '0'              " soid-accnt
  TABLES
    options =                   " rfc_db_opt
    fields =                    " rfc_db_fld
    data =                      " tab512
*   control_record =            " bbp_control_record
    .  "  NOR3_READ_TABLE

ABAP code example for Function Module NOR3_READ_TABLE





The ABAP code below is a full code listing to execute function module NOR3_READ_TABLE 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_options    TYPE STANDARD TABLE OF RFC_DB_OPT,"TABLES PARAM
wa_options  LIKE LINE OF it_options
,
it_fields    TYPE STANDARD TABLE OF RFC_DB_FLD,"TABLES PARAM
wa_fields  LIKE LINE OF it_fields
,
it_data    TYPE STANDARD TABLE OF TAB512,"TABLES PARAM
wa_data  LIKE LINE OF it_data
,
it_control_record    TYPE STANDARD TABLE OF BBP_CONTROL_RECORD,"TABLES PARAM
wa_control_record  LIKE LINE OF it_control_record
.



 

SELECT single TABNAME 
  FROM DD02L 
  INTO @DATA(ld_query_table).



DATA(ld_delimiter) = some text here


DATA(ld_no_data) = some text here
 

SELECT single ACCNT 
  FROM SOID 
  INTO @DATA(ld_rowskips).

 

SELECT single ACCNT 
  FROM SOID 
  INTO @DATA(ld_rowcount).

 

"populate fields of struture and append to itab
append wa_options to it_options.
 

"populate fields of struture and append to itab
append wa_fields to it_fields.
 

"populate fields of struture and append to itab
append wa_data to it_data.
 

"populate fields of struture and append to itab
append wa_control_record to it_control_record.
.

CALL FUNCTION 'NOR3_READ_TABLE'
  EXPORTING
    query_table =                ld_query_table
*   delimiter =                  ld_delimiter
*   no_data =                    ld_no_data
*   rowskips =                   ld_rowskips
*   rowcount =                   ld_rowcount
  TABLES
    options =                    it_options
    fields =                     it_fields
    data =                       it_data
*   control_record =             it_control_record
    .  "  NOR3_READ_TABLE

IF SY-SUBRC EQ 0.
  "All OK
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_query_table  TYPE DD02L-TABNAME ,
it_options  TYPE STANDARD TABLE OF RFC_DB_OPT ,
wa_options  LIKE LINE OF it_options,
ld_delimiter  TYPE SONV-FLAG ,
it_fields  TYPE STANDARD TABLE OF RFC_DB_FLD ,
wa_fields  LIKE LINE OF it_fields,
ld_no_data  TYPE SONV-FLAG ,
it_data  TYPE STANDARD TABLE OF TAB512 ,
wa_data  LIKE LINE OF it_data,
ld_rowskips  TYPE SOID-ACCNT ,
it_control_record  TYPE STANDARD TABLE OF BBP_CONTROL_RECORD ,
wa_control_record  LIKE LINE OF it_control_record,
ld_rowcount  TYPE SOID-ACCNT .





SELECT single TABNAME 
  FROM DD02L 
  INTO ld_query_table.
 

"populate fields of struture and append to itab
append wa_options to it_options.

ld_delimiter = some text here 

"populate fields of struture and append to itab
append wa_fields to it_fields.

ld_no_data = some text here 

"populate fields of struture and append to itab
append wa_data to it_data.

SELECT single ACCNT 
  FROM SOID 
  INTO ld_rowskips.
 

"populate fields of struture and append to itab
append wa_control_record to it_control_record.

SELECT single ACCNT 
  FROM SOID 
  INTO ld_rowcount.

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


   
 

NOR3_READ_TABLE - Read Table in Core System
NOR3_PURCHASE_GET_STATUS - Backend Interface for Reservation
NOR3_PSPROJECT_GET_LIST_DUMMY - Get PM/CS Order List
NOR3_PSPROJECT_GET_LIST - Get PM/CS Order List
NOR3_PO_READ_ITEMS_INVOICE_BE - Read PO items for Invoice entry in the backend system
NOR3_PO_GETRELINFO - Display purchase order release information