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 SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


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
SFLIGHT Flight
SFLIMEAL Flight-Meal assignment
SFLTRIPBOK Individual Flight Bookings for a Flight Trip
SMACOURSE Inflight meal/Main course
SMEAL Inflight Meal
SMEALT Inflight meal/Description
SMENU Menu
SPFLI Flight schedule
SSTARTER Inflight meal/Appetizer
STICKET Flight Ticket






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems