DAAG_SBOOK

Transparent Table Application Table
26 Fields 13 CDS Views

Single Flight Booking

DAAG_SBOOK is an SAP database table in S/4HANA. Single Flight Booking. It contains 26 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
DAAG00O2TII6W782UK4PCHMY6CQY4 view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAG00O2TII6W782UK7X42V6KKA3K view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAG00O2TIKO7MT887PMZ9YYZ6VFY view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAG00O2TIKO7MT9YJ2RHL6D4VCP5 view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET090V6Y179OE0OFCKNJE9QVV view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET090V6Y179OE0OKECAT1QQCA view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET090V6Y179OE0OOPFAP4UUP6 view from DAAG Obj-DAAG_SFLIGHT_RULES Residence Rule Source
DAAGET091VTW8O1XQ74V4EC27E9S9 view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET091VTW8O1XQ74V882094AQH view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET091VTW8O1XQ74Z8S1J1XPQN view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET091VTW8O1XQ74ZBMMA3BIJA view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
DAAGET091VTW8O1XQ74ZCIH1T08U3 view from DAAG Obj-DAAG_SFLIGHT Residence Rule Source
demo_cds_daag_sflight_sbook view_entity inner

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt S_MANDT Client
KEY carrid S_CARR_ID Airline
KEY connid S_CONN_ID Flight Number
KEY fldate S_DATE Date
KEY bookid S_BOOK_ID Booking number
customid S_CUSTOMER Customer Number
custtype S_CUSTTYPE B/P customer
smoker S_SMOKER Smoker
luggweight S_LUGWEIGH Luggage Weight
wunit S_WEIUNIT Unit of measure
invoice S_INVFLAG Invoice pty.
class S_CLASS Class
forcuram S_F_CUR_PR Amount
forcurkey S_CURR Paymnt currency
loccuram S_L_CUR_PR Amount
loccurkey S_CURRCODE Airline Currency
order_date S_BDATE Booking date
counter S_COUNTNUM Sales office
agencynum S_AGNCYNUM Agency No.
cancelled S_CANCEL Cancelation flag
reserved S_RESERV Reserved
passname S_PASSNAME Passenger Name
passform S_FORM Title
passbirth S_BIRTHDAT DOB of Passeng.
invoice_open DAAG_INVOICE_OPEN Open Invoice
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Single Flight Booking
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DAAG_SBOOK (
    MANDT,         -- Client [S_MANDT]
    CARRID,        -- Airline [S_CARR_ID]
    CONNID,        -- Flight Number [S_CONN_ID]
    FLDATE,        -- Date [S_DATE]
    BOOKID,        -- Booking number [S_BOOK_ID]
    CUSTOMID,      -- Customer Number [S_CUSTOMER]
    CUSTTYPE,      -- B/P customer [S_CUSTTYPE]
    SMOKER,        -- Smoker [S_SMOKER]
    LUGGWEIGHT,    -- Luggage Weight [S_LUGWEIGH]
    WUNIT,         -- Unit of measure [S_WEIUNIT]
    INVOICE,       -- Invoice pty. [S_INVFLAG]
    CLASS,         -- Class [S_CLASS]
    FORCURAM,      -- Amount [S_F_CUR_PR]
    FORCURKEY,     -- Paymnt currency [S_CURR]
    LOCCURAM,      -- Amount [S_L_CUR_PR]
    LOCCURKEY,     -- Airline Currency [S_CURRCODE]
    ORDER_DATE,    -- Booking date [S_BDATE]
    COUNTER,       -- Sales office [S_COUNTNUM]
    AGENCYNUM,     -- Agency No. [S_AGNCYNUM]
    CANCELLED,     -- Cancelation flag [S_CANCEL]
    RESERVED,      -- Reserved [S_RESERV]
    PASSNAME,      -- Passenger Name [S_PASSNAME]
    PASSFORM,      -- Title [S_FORM]
    PASSBIRTH,     -- DOB of Passeng. [S_BIRTHDAT]
    INVOICE_OPEN,  -- Open Invoice [DAAG_INVOICE_OPEN]
    _DATAAGING,    -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, CARRID, CONNID, FLDATE, BOOKID)
);

Learn More