SFLIGHT is a standard ABAP Workbench, Java IDE and Infrastructure Transparent Table in SAP Basis application, which stores Flight 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 SFLIGHT. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

SFLIGHT — Meta Data

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

SFLIGHT — 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 SPFLI
    4 FLDATE Flight date X DATS 8
    5 PRICE Price CURR 15
    6 CURRENCY Currency Key CUKY 5 SCURX
    7 PLANETYPE Aircraft Type CHAR 10 SAPLANE
    8 SEATSMAX Maximum capacity in economy class INT4 10
    9 SEATSOCC Occupied seats in economy class INT4 10
    10 PAYMENTSUM Total of current bookings CURR 17
    11 SEATSMAX_B Boolean Value ('X' = True ' ' = False) INT4 10
    12 SEATSOCC_B Occupied seats in business class INT4 10
    13 SEATSMAX_F Boolean Value ('X' = True ' ' = False) INT4 10
    14 SEATSOCC_F Occupied seats in first class INT4 10

SAP Help, Wiki Resources, and Forum Discussions on SFLIGHT


Related Tables

TABLE Description Functional Area
SBOOK Single Flight Booking Basis - ABAP Workbench, Java IDE and Infrastructure
SPFLI Flight schedule Basis - ABAP Workbench, Java IDE and Infrastructure
SCARR Airline Basis - ABAP Workbench, Java IDE and Infrastructure
LVC_S_LAYO ALV control: Layout structure BC - SAP List Viewer
VBAK Sales Document: Header Data SD - Sales
MARA General Material Data Logistics - Material Master
DISVARIANT Layout (External Use) BC - SAP List Viewer

Transaction Codes for SAP Table SFLIGHT

TCODE Description Functional Area
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
CIF APO Core Interface SCM - Interfaces
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SE38 ABAP Editor Basis - ABAP Editor
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
RSA3 Extractor Checker Basis - BW Service API
SE24 Class Builder Basis - Class Builder
RSO2 Oltp Metadata Repository Basis - BW Service API

FMs for SAP Table SFLIGHT

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
LVC_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - liveCache
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_VARIANT_DEFAULT_GET Read default display variant (description only, w/o field catalog) BC - SAP List Viewer
SET_FOCUS Set focus to active editor Basis - ABAP Editor

ABAP Reports for SAP Table SFLIGHT

BW Datasources for SAP Table SFLIGHT

BW DATASOURCE Description Functional Area
0SAPI_SFLIGHT_SIMPLE DataSource Template for Function Module Extraction -
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0FI_GL_6 General Ledger Sales Figures via Delta Extraction FI - General Ledger Accounting
0VENDOR_ATTR Vendor Number MM - Materials Management
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
0EC_PCA_1 Profit Center: Transaction Data on Accounts Enterprice Controlling - Profit Center Accounting
0VER_CUBE_OLD_LIS Delta and Repeat-Capable DataSource with Initcommit -
0SALES_OFF_TEXT Sales Office SD - Sales and Distribution

Authorization Objects for SAP Table SFLIGHT

AUTHORIZATION OBJECT Description Functional Area
S_CARRID Authorization Object for Airlines
E_GRID Authorization Object for Grid
PLOG Personnel Planning
I_QMEL PM/QM: Notification Types