Ansicht
Dokumentation
SE16N_INTERFACE - Display table as full screen
CL_GUI_FRONTEND_SERVICES - Frontend Services ABAP Short ReferenceThis documentation is copyright by SAP AG.
Functionality
You can use this module to start the selection on the database table or of a view, and to display the data in the same way as in transaction SE16N from one program.
The authorization checks made in transaction SE16N (S_TABU_DIS and S_TABU_NAM) are also made in the module, thus ensuring the user can only see the data for which he is authorized.
Example
Straightforward examples can be found in the following programs:
RKSE16N_DEMO1 SE16N: Demo Report Simple Call of SE16N_INTERFACE
RKSE16N_DEMO2 SE16N: Demo Report Call SE16N_INTERFACE with Return of Data
RKSE16N_DEMO3 SE16N: Demo Report Selection with Two 'Or' Connections
RKSE16N_DEMO4 SE16N: Demo Report Grouping, Totaling, Sorting SE16H
Notes
Please also see the documentation for module SE16N_EXTERNAL_CALL.
In addition, SAP Note 2140924 describes the basis function of SE16N.
The following SAP Notes describe other functions that are available when you use this interface:
1636416
1743309
1775082
Further information
Overview of the Parameters:
I_TAB: Here either the table to be selected or the view needs to be transferred (obligatory field).
I_EDIT: If the table or view can be changed, you can activate the change mode using this indicator ('X' = modifiable, space = not modifiable).
I_SAP_EDIT: Internal use
I_NO_TXT: Output made without text table.
I_MAX_LINES: Maximum number of hits (default value 500).
I_LINE_DET: If this indicator is set to X, the numer of lines found is calculated and returned to the person calling the program. If I_DISPLAY is set to X, the number of lines is shown in a popup.
I_DISPLAY: With X the result is output in ALV. In the case of space, a pointer to the data found is returned in export parameter E_DREF, so that the results can be processed in a separate program.
I_CLNT_SPEZ: Internal use
I_CLNT_DEP: 'X' = Table is client-dependent, space = table is not client-dependent. If the indicator if not correctly transferred, the output may contain the client.
I_VARIANT: Layout structure for the ALV output.
I_OLD_ALV: Obsolete
I_CHECKKEY: X deactivates the ALV foreign key check. This may be important in the case of modifiable tables.
I_TECH_NAMES: Column headers are output as a technical name.
I_CWIDTH_OPT_OFF: Switch off ALV column optimization.
I_SCROLL: Make key columns scrollable.
I_NO_CONVEXIT: No conversion of the field contents for the output.
I_LAYOUT_GET: When you exit the results list, the current layout is automatically saved user-specific.
I_ADD_FIELD: Internal use
I_ADD_FIELDS_ON: Internal use
I_UNAME: The user, only required for extract management (see SAP Note 2115916 - SE16N gives you the option of saving read values in an extract in the background, that you can later display online.)
I_HANA_ACTIVE: X means that SE16H has been started.
I_DBCON: Alternative database connection (definition in transaction DBCON). You only need this parameter if the data is to be read from a different database (for instance, if a parallel SAP HANA database is being used).
I_OJKEY: Name of the Outer Join Definition for the separate reading of dependent data.
I_DISPLAY_ALL: Selection of all records, not dependent on I_MAX_LINES (I_MAX_LINES is ignored).
I_TEMPERATURE: Temperature (date) for Data Aging (see SAP Note 2117537)
I_TEMPERATURE_COLD: X = read all data, even cold data. Space = only read current data.
I_SESSION_CONTROL: Session control for Data Aging (if used this has to be set by the user).
I_EXTRACT_READ, I_EXTRACT_WRITE, I_EXTRACT_NAME, I_EXTRACT_UNAME: Internal use for extract management (see I_UNAME).
-----------------------------------------------------------------------------------------------------------------------------
E_LINE_NR: The number of entries found is returned to the user.
E_DREF: Pointer to the data found, if this is not being displayed
ET_FIELDCAT: Field catalog for the field string generated for the table of hits. Please note that SE16N internal fields are generated in addition at the end of the field catalog.
-----------------------------------------------------------------------------------------------------------------------------
IT_SELFIELDS: There are several options for transferring selection criteria. IT_SELFIELDS is the most straightforward. The structure corresponds to FIELD-SIGN-OPTION-LOW-HIGH.
IT_OUTPUT_FIELDS: You specify the fields you want to be output here. If the table is empty, all of the fields are output.
IT_OR_SELFIELDS: This transfer corresponds to the transfer of IT_SELFIELDS with an 'OR‘ connection for the individual table rows. This enables you to map Or connections for multi-dimensional data sets.
IT_CALLBACK_EVENTS: Transfer table for callback events (see documentation for module SE16N_EXTERNAL_CALL)
IT_ADD_UP_CURR_FIELDS: SE16N gives you the option of adding up several currency fields in a row. The result is stored in a field created in addition at the end of the field catalog. If you would like to use this function, fill all of the fields to be added in this table. Please note that the amounts are added together without taking into account the unit!
IT_ADD_UP_QUAN_FIELDS: SE16N gives you the option of adding up several quantity fields in a row. The result is stored in a field created in addition at the end of the field catalog. If you would like to use this function, fill all of the fields to be added in this table. Please note that the quantities are added together without taking into account the unit!
IT_SUM_UP_FIELDS: Fill the field names in this table that should use the total function of SE16H. For these fields a SUM() function is carried out on the database.
IT_GROUP_BY_FIELDS: Fill the field names in this table that should use the group function of SE16H. For these fields a GROUP BY is carried out on the database.
IT_ORDER_BY_FIELDS: Fill the field names in this table that should use the sort function of SE16H. For these fields a ORDER BY is carried out on the database. The ORDER BY is carried out according to the sequence in which the fields occur in the field catalog.
IT_AGGREGATE_FIELDS: Fill the field names in this table that should use the aggregate functions (MAX Maximum, MIN Minimum, AVG Average). The logic is that in the FIELD field you define the field name, and in the LOW field the aggregate function (MAX, MIN or AVG).
IT_TOPLOW_FIELDS: In this table you can specify the sort type (ascending or descending). The logic is that in the FIELD field you define the field name, and in the LOW field the sort type (ASC for ascending and DES for descending).
IT_SORTORDER_FIELDS: In this table you can determine the sort sequence of the fields should these differ from how they occur in the field string. For FIELD enter the field name, and for LOW a two digit number from 01 to 99 (the smaller number is sorted first).
-----------------------------------------------------------------------------------------------------------------------------
IT_AND_SELFIELDS: This is the most complex form of the selection criteria transfer. You can connect several tables of type IT_OR_SELFIELDS with AND.
Parameters
ET_FIELDCATE_DREF
E_LINE_NR
IT_ADD_UP_CURR_FIELDS
IT_ADD_UP_QUAN_FIELDS
IT_AGGREGATE_FIELDS
IT_AND_SELFIELDS
IT_CALLBACK_EVENTS
IT_GROUP_BY_FIELDS
IT_HAVING_FIELDS
IT_ORDER_BY_FIELDS
IT_OR_SELFIELDS
IT_OUTPUT_FIELDS
IT_PARAMETER_FIELDS
IT_SELFIELDS
IT_SORTORDER_FIELDS
IT_SUM_UP_FIELDS
IT_TOPLOW_FIELDS
I_ADD_FIELD
I_ADD_FIELDS_ON
I_CHECKKEY
I_CLNT_DEP
I_CLNT_SPEZ
I_CWIDTH_OPT_OFF
I_DBCON
I_DISPLAY
I_DISPLAY_ALL
I_EDIT
I_EXTRACT_NAME
I_EXTRACT_READ
I_EXTRACT_UNAME
I_EXTRACT_WRITE
I_FDA
I_FORMULA_NAME
I_HANA_ACTIVE
I_LAYOUT_GET
I_LINE_DET
I_MAX_LINES
I_MINCNT
I_NO_CONVEXIT
I_NO_TXT
I_OJKEY
I_OLD_ALV
I_SAPEDIT
I_SCROLL
I_SESSION_CONTROL
I_TAB
I_TECH_NAMES
I_TEMPERATURE
I_TEMPERATURE_COLD
I_UNAME
I_VARIANT
Exceptions
NO_VALUESFunction Group
SE16NBAL_S_LOG - Application Log: Log header data ROGBILLS - Synchronize billing plans
This documentation is copyright by SAP AG.
Length: 9119 Date: 20240523 Time: 082248 sap01-206 ( 153 ms )
