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


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

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