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