SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

Generate Data for SAP Flight Demo Tables

Although SAP demo tables SFLIGHT, SCARR, SPFLI exist on SAP S/4HANA, they have no data, all demo tables are empty. But when I query SFlight demo tables using HANA Studio SAP HANA Development perspective SQL Console, I see there are records for sample data in them. This SAP guide shows how to populate SFlight SAP demo tables with sample data.

By default SAP demo tables are empty for user clients.
But if you query the SCARR table using SQL Console oby connecting to the HANA database with SAP HANA Studio, you can see there are sample records in the database table.

select * from sapabap1.scarr

Here is sample data for demo table SCARR. So it is not empty and we have demo data in our SAP HANA system.

SAP demo table data in HANA database

Unfortunately, since data is for CLIENT '000' it is not displayed when queried from another SAP client on SAP GUI.

On the other hand, there is an ABAP program SAPBC_DATA_GENERATOR which generates standard entries in the database tables that belong to the flight data model.

If you run ABAP report SAPBC_DATA_GENERATOR using SE38 or SA38 transactions, you can generate test data for SAP flight demo tables.

generate test data for SAP demo flight tables

Here are some of the Flight demo tables which are shipped with SAP systems.

SBOOK Single Flight Booking
SCARPLAN Plane-airline assignment
SCARR Airline
SCOUNTER Sales counter
SDESSERT Inflight meal/Dessert
SFLBOPOS Flight Booking Order Item
SFLCONNPOS Stage of a Flight Connection
SFLIMEAL Flight-Meal assignment
SFLTRIPBOK Individual Flight Bookings for a Flight Trip
SMACOURSE Inflight meal/Main course
SMEAL Inflight Meal
SMEALT Inflight meal/Description
SPFLI Flight schedule
SSTARTER Inflight meal/Appetizer
STICKET Flight Ticket


Install SAP Free
CRM Companies List
Web Based CRM Software

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.