P_Cfd_Associable_Cds_View

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 P_Cfd_Associable_Cds_View.
-- 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 P_Cfd_Associable_Cds_View AS
SELECT
  stob.objectname AS ViewName,
  entity.strucobjn_raw AS ViewNameCamelCase,
  coalesce( _viewLabelCurrentLanguage.ddtext, coalesce( _viewLabelFallbackLanguage.ddtext, _viewDescriptionFallback.ddtext ) ) as ViewDescription AS ddtextasViewDescription,
  cast( ddlSource.source_origin as abap.char(3) ) AS SourceOrigin,
  case when ddlSource.source_type = 'Q' then 'X' else '' end as IsCustomEntity AS source_typeQthenXelseendasIsCustomEntity,
  count( distinct keyFields.FieldName ) AS NumberOfKeys,
  objectModelQueryImplemented.value AS CustomEntityImplementation,
  _viewLabelCurrentLanguage.ddtext AS ViewDescriptionCurrentLanguage,
  _viewLabelFallbackLanguage.ddtext AS ViewDescriptionFallbackLang,
  _viewDescriptionFallback.ddtext AS ViewDescriptionFallback
INNER JOIN ddddlsrc AS ddlSource ON /* join condition not captured in parsed metadata */
INNER JOIN dd02b AS entity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_U_ITEM_KEY AS atoItems ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS releasedObjects ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS analyticsDataCategoryAnno ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS objectModelDataCategoryAnno ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS objectModelQueryImplemented ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd10b AS parameters ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Cfd_Associable_Cds_View_Keys AS keyFields ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Cfd_Cds_Source_Origin AS _sourceOrigin ON _sourceOrigin.Code = SourceOrigin  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _viewLabelCurrentLanguage ON _viewLabelCurrentLanguage.ddlname = ddlSource.ddlname AND _viewLabelCurrentLanguage.strucobjn = stob.objectname AND _viewLabelCurrentLanguage.as4local = stob.state AND _viewLabelCurrentLanguage.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _viewLabelFallbackLanguage ON _viewLabelFallbackLanguage.ddlname = ddlSource.ddlname AND _viewLabelFallbackLanguage.strucobjn = stob.objectname AND _viewLabelFallbackLanguage.as4local = stob.state AND _viewLabelFallbackLanguage.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN ddddlsrct AS _viewDescriptionFallback ON _viewDescriptionFallback.ddlname = ddlSource.ddlname AND _viewDescriptionFallback.as4local = stob.state AND _viewDescriptionFallback.ddlanguage = $session.system_language  -- association [0..1]
;