SAP SELECT_EINE_ALL_FIELDS_FOR Function Module for Select all fields from EINE for given parameters









SELECT_EINE_ALL_FIELDS_FOR is a standard select eine all fields for SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Select all fields from EINE for given 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 select eine all fields for FM, simply by entering the name SELECT_EINE_ALL_FIELDS_FOR into the relevant SAP transaction such as SE37 or SE38.

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



Function SELECT_EINE_ALL_FIELDS_FOR 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 'SELECT_EINE_ALL_FIELDS_FOR'"Select all fields from EINE for given parameters
EXPORTING
* I_SELECT_TYPE = '0' "Kind of select : standard (0), single (1), for update (2), distinct (3)
* I_REALLY_EXIST = "General flag
* I_BYPASS = "General flag
* IS_INFNR = "General flag
* I_INFNR = "Number of purchasing info record
* IS_EKORG = "General flag
* I_EKORG = "Purchasing organization
* IS_ESOKZ = "General flag
* I_ESOKZ = "Purchasing info record category
* IS_WERKS = "General flag
* I_WERKS = "Site

CHANGING
* DB_COUNT = "DB operations, number of table lines processed

TABLES
* T_WHERE_CLAUSE_IN = "Line for WHERE clauses (dynamic selections)
T_EINE = "Purchasing Info Record: Purchasing Organization Data

EXCEPTIONS
NOT_FOUND = 1 ERROR_IN_SELECT = 2
.



IMPORTING Parameters details for SELECT_EINE_ALL_FIELDS_FOR

I_SELECT_TYPE - Kind of select : standard (0), single (1), for update (2), distinct (3)

Data type: C
Default: '0'
Optional: Yes
Call by Reference: Yes

I_REALLY_EXIST - General flag

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

I_BYPASS - General flag

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

IS_INFNR - General flag

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

I_INFNR - Number of purchasing info record

Data type: EINE-INFNR
Optional: Yes
Call by Reference: Yes

IS_EKORG - General flag

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

I_EKORG - Purchasing organization

Data type: EINE-EKORG
Optional: Yes
Call by Reference: Yes

IS_ESOKZ - General flag

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

I_ESOKZ - Purchasing info record category

Data type: EINE-ESOKZ
Optional: Yes
Call by Reference: Yes

IS_WERKS - General flag

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

I_WERKS - Site

Data type: EINE-WERKS
Optional: Yes
Call by Reference: Yes

CHANGING Parameters details for SELECT_EINE_ALL_FIELDS_FOR

DB_COUNT - DB operations, number of table lines processed

Data type: SY-DBCNT
Optional: Yes
Call by Reference: Yes

TABLES Parameters details for SELECT_EINE_ALL_FIELDS_FOR

T_WHERE_CLAUSE_IN - Line for WHERE clauses (dynamic selections)

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

T_EINE - Purchasing Info Record: Purchasing Organization Data

Data type: EINE
Optional: No
Call by Reference: Yes

EXCEPTIONS details

NOT_FOUND - No record found for given parameters

Data type:
Optional: No
Call by Reference: Yes

ERROR_IN_SELECT - Incorrect select statement

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for SELECT_EINE_ALL_FIELDS_FOR 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:
lv_db_count  TYPE SY-DBCNT, "   
lv_not_found  TYPE SY, "   
lv_i_select_type  TYPE C, "   '0'
lt_t_where_clause_in  TYPE STANDARD TABLE OF RSDSWHERE, "   
lv_i_really_exist  TYPE FLAG, "   
lv_i_bypass  TYPE FLAG, "   
lt_t_eine  TYPE STANDARD TABLE OF EINE, "   
lv_is_infnr  TYPE FLAG, "   
lv_error_in_select  TYPE FLAG, "   
lv_i_infnr  TYPE EINE-INFNR, "   
lv_is_ekorg  TYPE FLAG, "   
lv_i_ekorg  TYPE EINE-EKORG, "   
lv_is_esokz  TYPE FLAG, "   
lv_i_esokz  TYPE EINE-ESOKZ, "   
lv_is_werks  TYPE FLAG, "   
lv_i_werks  TYPE EINE-WERKS. "   

  CALL FUNCTION 'SELECT_EINE_ALL_FIELDS_FOR'  "Select all fields from EINE for given parameters
    EXPORTING
         I_SELECT_TYPE = lv_i_select_type
         I_REALLY_EXIST = lv_i_really_exist
         I_BYPASS = lv_i_bypass
         IS_INFNR = lv_is_infnr
         I_INFNR = lv_i_infnr
         IS_EKORG = lv_is_ekorg
         I_EKORG = lv_i_ekorg
         IS_ESOKZ = lv_is_esokz
         I_ESOKZ = lv_i_esokz
         IS_WERKS = lv_is_werks
         I_WERKS = lv_i_werks
    CHANGING
         DB_COUNT = lv_db_count
    TABLES
         T_WHERE_CLAUSE_IN = lt_t_where_clause_in
         T_EINE = lt_t_eine
    EXCEPTIONS
        NOT_FOUND = 1
        ERROR_IN_SELECT = 2
. " SELECT_EINE_ALL_FIELDS_FOR




ABAP code using 7.40 inline data declarations to call FM SELECT_EINE_ALL_FIELDS_FOR

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 DBCNT FROM SY INTO @DATA(ld_db_count).
 
 
DATA(ld_i_select_type) = '0'.
 
 
 
 
 
 
 
"SELECT single INFNR FROM EINE INTO @DATA(ld_i_infnr).
 
 
"SELECT single EKORG FROM EINE INTO @DATA(ld_i_ekorg).
 
 
"SELECT single ESOKZ FROM EINE INTO @DATA(ld_i_esokz).
 
 
"SELECT single WERKS FROM EINE INTO @DATA(ld_i_werks).
 


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!