I_Swcstrtdata

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_Swcstrtdata.
-- 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: ISWCSTRTDATA

CREATE VIEW I_Swcstrtdata AS
SELECT
  db_key AS ProductStructureNodeUUID,
  sw_module AS EmbeddedSwSoftwareMaterial,
  sw_version_type AS DocumentType,
  sw_version_id AS DocNumber,
  sw_version_min AS EmbeddedSwFromVersion,
  sw_version_max AS EmbeddedSwToVersion,
  cstrt_rule AS EmbeddedSwConstraintRule,
  cstrt_obj_type AS EmbeddedSwConstraintObjectType,
  cstrt_obj_id AS EmbeddedSwHardwareMaterial,
  cstrt_obj_val_min AS EmbeddedSwSoftwareMinVersion,
  cstrt_obj_val_max AS EmbeddedSwSoftwareMaxVersion,
  cstrt_obj_descr AS EmbeddedSwHardwareMaterialDesc,
  created_on AS CreationDate,
  created_by AS CreatedByUser,
  changed_on AS LastChangeDate,
  changed_by AS LastChangedByUser,
  etag AS EmbeddedSoftwareETag,
  timestamp AS EmbeddedSoftwareTimeStamp,
  m1.begru AS AuthorizationGroup,
  m2.begru AS MaterialAuthorizationGroup
FROM /plmi/sw_cstrt
INNER JOIN mara AS m1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mara AS m2 ON /* join condition not captured in parsed metadata */
;