/APE/C_BODMSTR_UI

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 /APE/C_BODMSTR_UI.
-- 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 /APE/C_BODMSTR_UI AS
SELECT
  BOStructure.config_key AS BusinessObjectStructureKey,
  BOStructure.ape_parent_key AS BusinessObjectDataModelKey,
  BOStructure.seq_no AS SeqNo,
  _BOStructureText.BOStructureDescription AS BOStrDescrption,
  _BOStructureText.BOStructureDescriptionISL AS BOStrDescrptionISL,
  _BODMHDR.BusinessObjectDDICType AS BODDICType,
  BOStructure.path AS Path,
  BOStructure.field AS Field,
  BOStructure.name_ext AS NameExt,
  BOStructure.type AS Type,
  BOStructure.ddic_type AS DDICType,
  BOStructure.person_data_ind AS PersonDataInd,
  BOStructure.qualifier_field AS QualifierFieldUUID,
  BOStructure.qualifier_code AS QualifierCode,
  BOStructure.qualif_path AS QualifierPath,
  BOStructure.qualif_field AS QualifierField,
  BOStructure.compress_actv AS Compression,
  BOStructure.comment_text AS CommentText
FROM /APE/I_BODATAMODELSTR_TP AS BOStructure
LEFT OUTER JOIN /APE/C_BODataModelHdr_UI AS _BODMHDR ON BusinessObjectDataModelKey = _BODMHDR.BusinessObjectDataModelKey  -- association [1..1]
LEFT OUTER JOIN /APE/C_COMPONENTTYPE_VH AS _COMPT ON _COMPT.Value = Type  -- association [0..1]
LEFT OUTER JOIN /APE/C_BODataModelStrText_UI AS _Text ON _Text.BusinessObjectStructureKey = BusinessObjectStructureKey AND _Text.BusinessObjectDataModelKey = BusinessObjectDataModelKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_BODMSTR_VH AS _BOStructureText ON _BOStructureText.BOStructureKey = BusinessObjectStructureKey AND _BOStructureText.BODataModelKey = BusinessObjectDataModelKey  -- association [0..1]
;