DAAG00O2TIKO7MT9YJ2RHL6D4VCP5

DDL: DAAG00O2TIKO7MT9YJ2RHL6D4VCP5 SQL: DAAG2RHL6D4VCP5 Type: view Package: S_DAAG_SFLIGHT_EXAMPLE
9 Fields 1 Data Sources

DAAG Obj-DAAG_SFLIGHT Residence Rule Source

DAAG00O2TIKO7MT9YJ2RHL6D4VCP5 is a CDS View that provides data about "DAAG Obj-DAAG_SFLIGHT Residence Rule Source" in SAP S/4HANA. It reads from 1 data source (DAAG_SBOOK) and exposes 9 fields with key fields CARRID, CONNID, FLDATE, BOOKID. Part of development package S_DAAG_SFLIGHT_EXAMPLE.

Data Sources (1)

SourceAliasJoin Type
DAAG_SBOOK DAAG_SBOOK from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName DAAG2RHL6D4VCP5 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label DAAG Obj-DAAG_SFLIGHT Residence Rule Source view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CARRID DAAG_SBOOK CARRID Carrier
KEY CONNID DAAG_SBOOK CONNID Flight Number
KEY FLDATE DAAG_SBOOK FLDATE Flight Date
KEY BOOKID DAAG_SBOOK BOOKID Booking number
CANCELLED DAAG_SBOOK CANCELLED Item Discarded
INVOICE DAAG_SBOOK INVOICE Orig.Inv.Number
SMOKER DAAG_SBOOK SMOKER Smoker
FORCURKEY DAAG_SBOOK FORCURKEY Paymnt currency
CUSTTYPE DAAG_SBOOK CUSTTYPE B/P customer

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 DAAG00O2TIKO7MT9YJ2RHL6D4VCP5.
-- 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: DAAG2RHL6D4VCP5

CREATE VIEW DAAG00O2TIKO7MT9YJ2RHL6D4VCP5 AS
SELECT
  DAAG_SBOOK.CARRID AS CARRID,
  DAAG_SBOOK.CONNID AS CONNID,
  DAAG_SBOOK.FLDATE AS FLDATE,
  DAAG_SBOOK.BOOKID AS BOOKID,
  DAAG_SBOOK.CANCELLED AS CANCELLED,
  DAAG_SBOOK.INVOICE AS INVOICE,
  DAAG_SBOOK.SMOKER AS SMOKER,
  DAAG_SBOOK.FORCURKEY AS FORCURKEY,
  DAAG_SBOOK.CUSTTYPE AS CUSTTYPE
FROM DAAG_SBOOK
;

Learn More