SAP SPFLI Table: Flight schedule

The WHERE clause restricts the number of rows selected by specifying conditions that must be met.

"This example selects flight data from SFLIGHT for all connections for which the column CITYFROM in table SPFLI has the value NEWYORK. You could also use a join in the FROM clause to select the same data in a single SELECT statement."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/cfae740a0a21455dbe6e510c2d86e36a/fceb3a1f358411d1829f0000e829fbfe.html

In some cases, the information that a data source supplies is insufficient. In such cases, new information could be gained by making simple calculations. If, for example, the maximum number of seats and the number of bookings for a particular flight are known, the number of unoccupied seats can be calculated easily. Such information can be useful for different query evaluations.

https://help.sap.com/docs/SAP_NETWEAVER_740/40d2cb3a4f9249d58e9bbc95f4dbaff8/4e4c13fc7e1f6d30e10000000a15822b.html

The INTO clause defines the target area into which the selection from the SELECT clause is written. Suitable target areas are variables whose data type is compatible with or convertible into that of the selection in the SELECTclause.

"This example uses a flat structure with the same data type as the database table SPFLI as the target area in a SELECT loop. Within the loop, it is possible to address the contents of the individual columns."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/cfae740a0a21455dbe6e510c2d86e36a/fceb39eb358411d1829f0000e829fbfe.html

The FROM clause determines the database tables from which the data specified in the SELECT clause is read. You can specify either a single table or more than one table, linked using inner or outer joins. The names of database tables may be specified statically or dynamically, and you can use alias names. You can also use the FROM clause to bypass the SAP buffer and restrict the number of lines to be read from the database.

"This example links the columns CARRID, CONNID, FLDATE, and BOOKID of the table SPFLI, SFLIGHT, and SBOOK, and creates a list of booking numbers for all flights from Frankfurt to New York that are not fully booked. An alias name is assigned to each table."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/cfae740a0a21455dbe6e510c2d86e36a/fceb39c4358411d1829f0000e829fbfe.html

The SELECT clause defines the structure of the result set (selection) that you want to read from the database.

"SINGLE in the SELECTclause means that the statement reads a single entry from the database table SPFLI where the primary key fields CARRID and CONNID have the values specified in the WHERE clause. The columns specified in the SELECT clause are transferred to the identically-named components of the structure wa."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/cfae740a0a21455dbe6e510c2d86e36a/fceb3990358411d1829f0000e829fbfe.html

In the normal SELECT statement, the data from the selection is always read directly into the target area specified in the INTO clause during the SELECT statement. When you use a cursor to read data, you decouple the process from the SELECT statement. To do this, you must open a cursor for a SELECT statement. Afterwards, you can place the lines from the selection into a flat target area.

"The database table SPFLI is read using two cursors, each with different conditions.. The selected lines are read alternately in a DO loop."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/cfae740a0a21455dbe6e510c2d86e36a/fceb3b23358411d1829f0000e829fbfe.html

Double-click on a table that you want to assign to an additional table and choose the function Extras .

"In logical database F1S, which is used for examples in this handbook, two fields exist in the table SPFLI for departure and arrival airport. Both fields contain a key for the table SAIRPORT, which contains the long texts for airports. In a case like this, you should buffer the additional table internally, since it is safe to assume that records in SAIRPORT will be read multiple times."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/40d2cb3a4f9249d58e9bbc95f4dbaff8/4e501c8895f54dace10000000a42189b.html

You can call dialog modules in the POV event using the event keyword PROCESS ON VALUE-REQUEST.

"For the Flight number field, the POV module value_connection is called. The function module DYNP_VALUE_READ transports the value of the screen field carrier into the program. The program then reads the corresponding values from the database table SPFLI into the internal table values_tab using a SELECT statement, and passes the internal table to F4IF_INT_TABLE_VALUE_REQUEST. This displays the internal table as input help, and places the user's selection into the screen field connection."

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/f68e489816e043f1add91d69a6842931/4a439fcb5a503f04e10000000a421937.html

As well as input help, which appears in separate dialog boxes, you can also define input/output fields as dropdown boxes. A dropdown box offers the user a predefined set of input values from which to choose. It is not possible to type a entry into a dropdown box, instead, the user must use one of the values from the list. When the user chooses a value, the PAI event can be triggered simultaneously. If you use a dropdown box for a field, you cannot at the same time use the input help button.

https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/f68e489816e043f1add91d69a6842931/4a420dd1402c0451e10000000a421937.html

Within Screen Painter, two types of input help can be defined on the dynpro:

"For the Flight Number field, the flow logic displays the selected entries from the database table SPFLI and places the selected line in the input field."

https://help.sap.com/docs/SAP_NETWEAVER_740/f68e489816e043f1add91d69a6842931/4a439f485a503f04e10000000a421937.html

View the full list of resources, SAP Help/Wiki pages and Q&A for SPFLI