SPFLI is a standard ABAP Workbench, Java IDE and Infrastructure Transparent Table in SAP Basis application, which stores Flight schedule data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for SPFLI. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

SPFLI — Meta Data

Description: Flight schedule
Main Category: Basis
Sub Category: ABAP Workbench, Java IDE and Infrastructure
Table type: Transparent Table (TRANSP)

SPFLI — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 CARRID Airline Code X CHAR 3 SCARR
    3 CONNID Flight Connection Number X NUMC 4
    4 COUNTRYFR Country Key CHAR 3 SGEOCITY
    5 CITYFROM Departure city CHAR 20 SGEOCITY
    6 AIRPFROM Departure airport CHAR 3 SAIRPORT
    7 COUNTRYTO Country Key CHAR 3 SGEOCITY
    8 CITYTO Arrival city CHAR 20 SGEOCITY
    9 AIRPTO Destination airport CHAR 3 SAIRPORT
    10 FLTIME Single-Character Flag INT4 10
    11 DEPTIME Departure time TIMS 6
    12 ARRTIME Arrival time TIMS 6
    13 DISTANCE Distance (Meters) QUAN 9
    14 DISTID Single-Character Flag UNIT 3 *
    15 FLTYPE Single-Character Flag CHAR 1
    16 PERIOD Insured period INT1 3

SAP Help, Wiki Resources, and Forum Discussions on SPFLI


Related Tables

TABLE Description Functional Area
SFLIGHT Flight Basis - ABAP Workbench, Java IDE and Infrastructure
SCARR Airline Basis - ABAP Workbench, Java IDE and Infrastructure
ITAB Dummy structure for LOOP AT ... version BC - Number Range Management
SBOOK Single Flight Booking Basis - ABAP Workbench, Java IDE and Infrastructure
MARA General Material Data Logistics - Material Master
SCUSTOM Flight customers Basis - ABAP Workbench, Java IDE and Infrastructure
VBAK Sales Document: Header Data SD - Sales

Transaction Codes for SAP Table SPFLI

TCODE Description Functional Area
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE37 ABAP Function Modules Basis - Function Builder
DOBJ Def. of Data Destruction Objects Basis - Archiving Connector ABAP
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE38 ABAP Editor Basis - ABAP Editor
SM59 RFC Destinations (Display/Maintain) Basis - RFC
ABAPDOCU Display ABAP Documentation Basis - Syntax, Compiler, Runtime

FMs for SAP Table SPFLI

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
READ_SPFLI_INTO_TABLE Basis - Syntax, Compiler, Runtime
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
F4IF_INT_TABLE_VALUE_REQUEST F4 help also returning the value to be displayed in internal table Basis - F4 Help
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
DYNP_VALUES_READ Read screen field values before PAI field transport Basis - F1 Help

ABAP Reports for SAP Table SPFLI

ABAP REPORT Description Functional Area
DEMO_SELECTION_SCREEN_LDB_1 Demonstration for Selection Screen of a Logical Database Basis - Syntax, Compiler, Runtime
DEMO_ELEMENTARY_DATA_OBJECTS Demonstration of Elementary Data Objects Basis - Syntax, Compiler, Runtime
DEMO_DYNPRO_F4_HELP_MODULE Demonstration for F4 Help from Dialog Modules Basis - Syntax, Compiler, Runtime
DEMO_SEL_SCREEN_TABLES_RANGES Internal Selection Tables Basis - Syntax, Compiler, Runtime
DEMO_SELECT_INNER_JOIN Inner Join Basis - Syntax, Compiler, Runtime
MTZ10I01 Dialog Programming: Data Transport (PAI Modules) Basis - Workbench Tools: Editors, Painters, Modelers
DEMO_SELECT_CURSOR_2 Cursor as Parameter Basis - Syntax, Compiler, Runtime
MTZ10O01 Include MTZ10O01 Basis - Workbench Tools: Editors, Painters, Modelers

Authorization Objects for SAP Table SPFLI

AUTHORIZATION OBJECT Description Functional Area
S_CARRID Authorization Object for Airlines
P_PERNR HR: Master Data - Personnel Number Check

Most searched SAP Basis Components Tables