Fdt_Test_Book_Cds

DDL: FDT_TEST_BOOK_CDS SQL: FDT_TEST_BOOK Type: view Package: SFDT_TEST
25 Fields 1 Data Sources

BOOK CDS

Fdt_Test_Book_Cds is a CDS View that provides data about "BOOK CDS" in SAP S/4HANA. It reads from 1 data source (sbook) and exposes 25 fields with key fields mandt, carrid, connid, fldate, bookid. Part of development package SFDT_TEST.

Data Sources (1)

SourceAliasJoin Type
sbook sbook from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName FDT_TEST_BOOK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BOOK CDS view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY mandt sbook mandt Editing Client
KEY carrid sbook carrid Carrier
KEY connid sbook connid Flight Number
KEY fldate sbook fldate Flight Date
KEY bookid sbook bookid Booking number
customid sbook customid Customer Number
custtype sbook custtype B/P customer
smoker sbook smoker Smoker
luggweight sbook luggweight Luggage Weight
wunit sbook wunit Weight Unit
invoice sbook invoice Orig.Inv.Number
class sbook class User Group
forcuram sbook forcuram Amount
forcurkey sbook forcurkey Paymnt currency
loccuram sbook loccuram Amount
loccurkey sbook loccurkey Airline Currency
order_date sbook order_date Posting Date
counter sbook counter Version
agencynum sbook agencynum Travel Agency
cancelled sbook cancelled Item Discarded
reserved sbook reserved Reserved
passname sbook passname Passenger Name
passform sbook passform Title
passbirth sbook passbirth DOB of Passeng.
_scustom _scustom

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view Fdt_Test_Book_Cds.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FDT_TEST_BOOK

CREATE VIEW Fdt_Test_Book_Cds AS
SELECT
  sbook.mandt AS mandt,
  sbook.carrid AS carrid,
  sbook.connid AS connid,
  sbook.fldate AS fldate,
  sbook.bookid AS bookid,
  sbook.customid AS customid,
  sbook.custtype AS custtype,
  sbook.smoker AS smoker,
  sbook.luggweight AS luggweight,
  sbook.wunit AS wunit,
  sbook.invoice AS invoice,
  sbook.class AS class,
  sbook.forcuram AS forcuram,
  sbook.forcurkey AS forcurkey,
  sbook.loccuram AS loccuram,
  sbook.loccurkey AS loccurkey,
  sbook.order_date AS order_date,
  sbook.counter AS counter,
  sbook.agencynum AS agencynum,
  sbook.cancelled AS cancelled,
  sbook.reserved AS reserved,
  sbook.passname AS passname,
  sbook.passform AS passform,
  sbook.passbirth AS passbirth
FROM sbook
;

Learn More