Saturday 9 March 2013

SAP HANA CATLOG TABLE NAMES


  SAIRPORT – master data table with name and time zone information for airports
  SAPLANE – master data table with information about plane types, e. g. number of seats, 
weight, tank capacity, and operating speed
  SBOOK – fact table containing all flight bookings and their details like date of flight, flight 
number, price, customer ID, and ID of the travel agency that sold the ticket.
  SBUSPART – master data table with information about business partners
  SCARR – master data table with some airline information (name, currency, URL)
  SCURR – table with currency conversion factors
  SCURX – per-currency number of decimals used to display currency values
  SCUSTOM – master data table containing information about passengers
  SDESSERT – master data table with information about the desserts available during flights
  SFLIGHT -  master data table containing per-flight information, e. g. date, price, plane type, 
seats
  SMACOURSE – master data table with information about the main courses available during 
flights
  SMEAL – master data table with information about the meals available during flights
  SMEALT – master data table with information about the meals in various languages
  SMENU – master data table with information about the available combinations of meals
  SSTARTER – master data table with information about the main courses available during 
flights
  STICKET – fact table which contains information about the tickets issued at the airports
  STRAVELAG – master data table containing information about travel agencies

No comments:

Post a Comment