/SSB/BOOKLET_APP

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 /SSB/BOOKLET_APP.
-- 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.

CREATE VIEW /SSB/BOOKLET_APP AS
SELECT
  Booklet_App.app_id AS AppId,
  Booklet_App.app_descriptor_item_id AS AppDescriptorItemId,
  Booklet_App.reviewbooklet AS Reviewbooklet,
  Booklet_App.type AS Type,
  Booklet_App.drilldown_type AS DrillDownType,
  Booklet_App.catalog_id AS CatalogId,
  Booklet_App.semantic_object AS SemanticObject,
  Booklet_App.semantic_action AS SemanticAction,
  Booklet_App.created_by AS CreatedBy,
  Booklet_App.created_on AS CreatedOn,
  Booklet_App.changed_by AS ChangedBy,
  Booklet_App.changed_on AS ChangedOn,
  Booklet_App.application_component AS ApplicationComponent,
  Booklet_App.fiori_id AS FioriId,
  Booklet_App.variant_id AS VariantId,
  Booklet_App.target_mapping_instance_id AS TargetMappingInstanceId,
  Booklet_App.chip_config AS ChipConfig,
  Single_Booklet_App_Text.title AS Title,
  Single_Booklet_App_Text.subtitle AS Subtitle,
  Booklet_App_Text
FROM /ssb/book_app_s AS Booklet_App
LEFT OUTER JOIN /SSB/BOOKLET_APP_TEXT AS Single_Booklet_App_Text ON Booklet_App.app_id = Single_Booklet_App_Text.app_id AND Single_Booklet_App_Text.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /SSB/BOOKLET_APP_TEXT AS Booklet_App_Text ON Booklet_App.app_id = Booklet_App_Text.app_id  -- association [0..*]
;