SIT2_DEMO_BOOK

Transparent Table Application Table
19 Fields 1 CDS Views

Situation Demo Booking

SIT2_DEMO_BOOK is an SAP database table in S/4HANA. Situation Demo Booking. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_Sitn2DemoBooking view from BASIC Bookings for Situation Demo

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt s_mandt Client
KEY carrid sit2_demo_carrier_id Airline Code
KEY connid sit2_demo_connection_id Connection ID
KEY fldate sit2_demo_flight_date Flight Date
KEY bookid sit2_demo_booking_id Booking ID
unique_key sit2_demo_unique_key_booking Unique Booking Key
title sit2_demo_title Title
luggweight sit2_demo_luggage_weight Luggage Weight
wunit sit2_demo_luggage_weight_unit Weight Unit
confirmed sit2_demo_booking_confirmed Confirmed
invoice sit2_demo_booking_invoiced Invoiced
reserved sit2_demo_booking_reserved Reserved
class sit2_demo_booking_class Booking Class
loccuram s_l_cur_pr Amount
loccurkey s_currcode Airline Currency
order_date sit2_demo_booking_date Booking Date
agencynum sit2_demo_travel_agency_id Travel Agency
pass_name sit2_demo_pssngr_name Passenger Name
pass_phono sit2_demo_pssngr_phone_number Passenger Phone Number

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Situation Demo Booking
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SIT2_DEMO_BOOK (
    MANDT,       -- Client [s_mandt]
    CARRID,      -- Airline Code [sit2_demo_carrier_id]
    CONNID,      -- Connection ID [sit2_demo_connection_id]
    FLDATE,      -- Flight Date [sit2_demo_flight_date]
    BOOKID,      -- Booking ID [sit2_demo_booking_id]
    UNIQUE_KEY,  -- Unique Booking Key [sit2_demo_unique_key_booking]
    TITLE,       -- Title [sit2_demo_title]
    LUGGWEIGHT,  -- Luggage Weight [sit2_demo_luggage_weight]
    WUNIT,       -- Weight Unit [sit2_demo_luggage_weight_unit]
    CONFIRMED,   -- Confirmed [sit2_demo_booking_confirmed]
    INVOICE,     -- Invoiced [sit2_demo_booking_invoiced]
    RESERVED,    -- Reserved [sit2_demo_booking_reserved]
    CLASS,       -- Booking Class [sit2_demo_booking_class]
    LOCCURAM,    -- Amount [s_l_cur_pr]
    LOCCURKEY,   -- Airline Currency [s_currcode]
    ORDER_DATE,  -- Booking Date [sit2_demo_booking_date]
    AGENCYNUM,   -- Travel Agency [sit2_demo_travel_agency_id]
    PASS_NAME,   -- Passenger Name [sit2_demo_pssngr_name]
    PASS_PHONO,  -- Passenger Phone Number [sit2_demo_pssngr_phone_number]
    PRIMARY KEY (MANDT, CARRID, CONNID, FLDATE, BOOKID)
);

Learn More