I_VIEWBROWSER

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 I_VIEWBROWSER.
-- 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 I_VIEWBROWSER AS
SELECT
  ddddlsrc.ddlname AS CDSView,
  _dd02b.strucobjn_raw AS CDSViewRaw,
  _cdsDescription.ddtext AS CDSDescription,
  _applicationComponent.ApplicationComponent AS ApplicationComponent,
  _applicationComponent.ApplicationComponentDesc AS ApplicationComponentDesc,
  _fieldEntity.Fieldname AS FieldName,
  _fieldEntity.FieldDescription AS FieldDescription,
  _cdsApiState.CompatibilityContract AS ReleaseContract,
  _cdsApiState.ReleaseContractDesc AS ReleaseContractDesc,
  _cdsApiState.ReleaseState AS ReleaseState,
  _modelingPattern.HeaderAnnotationValue AS ModelingPatternValue,
  _modelingPattern.Description AS ModelingPatternDesc,
  _supportedCapabilities.HeaderAnnotationValue AS SupportedCapabilitiesValue,
  _supportedCapabilities.Description AS SupportedCapabilitiesDesc,
  _sapObjectNodeType.HeaderAnnotationRaw AS SAPObjectNodeType,
  _businessContext.BusinessContext AS BusinessContext,
  _businessContext.BusinessContextDesc AS BusinessContextDesc,
  _businessContext.ExtensionInclViewName AS ExtensionIncludeViewName,
  _businessFeature.AnnotationValue AS FeatureAnnoValue,
  _directBaseObjectsV2.CDSV2BaseObject AS CDSV2DirectBaseObject,
  _directBaseObjectsV1.CDSV1BaseObject AS CDSV1DirectBaseObject
FROM ddddlsrc
LEFT OUTER JOIN I_VDMPRIVATE_CDS AS _privateCDS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02b AS _dd02b ON ddddlsrc.ddlname = _dd02b.strucobjn AND _dd02b.as4local = 'A'  -- association [0..1]
LEFT OUTER JOIN dd02bnd AS _dd02bnd ON ddddlsrc.ddlname = _dd02bnd.strucobjn AND _dd02bnd.nodename = '.NODE1' AND _dd02bnd.as4local = 'A'  -- association [0..1]
LEFT OUTER JOIN ddddlsrct AS _cdsDescription ON ddddlsrc.ddlname = _cdsDescription.ddlname AND _cdsDescription.as4local = 'A' AND _cdsDescription.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RELEASESTATE AS _cdsApiState ON ddddlsrc.ddlname = _cdsApiState.ObjectId  -- association [0..1]
LEFT OUTER JOIN I_OBJECTHEADERANNO AS _modelingPattern ON CDSView = _modelingPattern.CDSView AND _modelingPattern.HeaderAnnotation = 'OBJECTMODEL.MODELINGPATTERN'  -- association [0..1]
LEFT OUTER JOIN I_OBJECTHEADERANNO AS _supportedCapabilities ON CDSView = _supportedCapabilities.CDSView AND _supportedCapabilities.HeaderAnnotation = 'OBJECTMODEL.SUPPORTEDCAPABILITIES'  -- association [0..1]
LEFT OUTER JOIN I_OBJECTHEADERANNO AS _sapObjectNodeType ON CDSView = _sapObjectNodeType.CDSView AND _sapObjectNodeType.HeaderAnnotation = 'OBJECTMODEL.SAPOBJECTNODETYPE.NAME'  -- association [0..1]
LEFT OUTER JOIN I_BUSINESSCONTEXT AS _businessContext ON ddddlsrc.ddlname = _businessContext.CdsViewName  -- association [0..1]
LEFT OUTER JOIN I_FIELDENTITY AS _fieldEntity ON ddddlsrc.ddlname = _fieldEntity.CDSView  -- association [0..1]
LEFT OUTER JOIN I_CDSAPPCOMPONENT AS _applicationComponent ON ddddlsrc.ddlname = _applicationComponent.CDSView  -- association [0..1]
LEFT OUTER JOIN I_BUSINESSFEATURE_SW AS _businessFeature ON ddddlsrc.ddlname = _businessFeature.CDSView AND _businessFeature.AnnotationName = 'FEATURE'  -- association [0..1]
LEFT OUTER JOIN I_DIRECTBASEOBJECTS_V1CDS AS _directBaseObjectsV1 ON CDSView = _directBaseObjectsV1.Ddlname  -- association [0..1]
LEFT OUTER JOIN I_DIRECTBASEOBJECTS_V2CDS AS _directBaseObjectsV2 ON CDSView = _directBaseObjectsV2.Ddlname  -- association [0..1]
;