C_EngSnpshtObjPg

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 C_EngSnpshtObjPg.
-- 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: CENGSNP

CREATE VIEW C_EngSnpshtObjPg AS
SELECT
  header.EngSnapshotUUID AS EngSnapshotUUID,
  header.EngSnapshotID AS EngSnapshotID,
  header.EngSnapshotName AS EngSnapshotName,
  header.EngSnapshotType AS EngSnapshotType,
  _EngSnpshtTypeText.EngSnapshotTypeText AS EngSnapshotTypeText,
  header.EngSnpshtRevisionNumber AS EngSnpshtRevisionNumber,
  header.Material AS Material,
  cast ( _Material.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  header.Plant AS Plant,
  header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  header.BillOfMaterialVariant AS BillOfMaterialVariant,
  header.EngSnpshtAuxiliaryPrepSts AS EngSnpshtAuxiliaryPrepSts,
  _AuxPrepStatusText.EngSnpshtAuxiliaryPrepStsText AS EngSnpshtAuxiliaryPrepStsText,
  header.EngSnpshtChangePrepSts AS EngSnpshtChangePrepSts,
  _ChgPrepStatusText.EngSnpshtChangePrepStsText AS EngSnpshtChangePrepStsText,
  cast('' as text255 ) AS SnapshotHdrText,
  _EngSnpshtObjPgVislDoc.DocumentInfoRecord AS DocumentInfoRecord,
  _EngSnpshtObjPgVislDoc.DocumentDescription AS DocumentDescription,
  _SnpshtRevsnRank.EngSnpshtRevisionRank AS EngSnpshtRevisionRank,
  cast('' as boole_d ) AS EngSnpshtHasDocs,
  header.EngSnpshtProposedEffectiveDate AS EngSnpshtProposedEffectiveDate,
  cast ( header.CreatedByUser as mpe_create_user ) AS CreatedByUser,
  header.CreationDateTime AS CreationDateTime,
  cast ( header.LastChangedByUser as mpe_lchange_user ) AS LastChangedByUser,
  header.LastChangeDateTime AS LastChangeDateTime
FROM I_EngSnpshtHdrTP AS header
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BOMVariantUsageText ON BillOfMaterialVariantUsage = _BOMVariantUsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_EngSnpshtAuxiliaryPrepStsTxt AS _AuxPrepStatusText ON EngSnpshtAuxiliaryPrepSts = _AuxPrepStatusText.EngSnpshtAuxiliaryPrepSts  -- association [0..*]
LEFT OUTER JOIN I_EngSnpshtChangePrepStsTxt AS _ChgPrepStatusText ON EngSnpshtChangePrepSts = _ChgPrepStatusText.EngSnpshtChangePrepSts  -- association [0..*]
LEFT OUTER JOIN I_EngSnpshtTypeText AS _EngSnpshtTypeText ON EngSnapshotType = _EngSnpshtTypeText.EngSnapshotType  -- association [0..*]
LEFT OUTER JOIN C_EngSnpshtObjPgEngBOM AS _EngSnpshtObjPgEngBOM ON EngSnapshotUUID = _EngSnpshtObjPgEngBOM.EngSnapshotUUID  -- association [0..*]
LEFT OUTER JOIN C_EngSnpshtObjPgMfgBOM AS _EngSnpshtObjPgMfgBOM ON EngSnapshotUUID = _EngSnpshtObjPgMfgBOM.EngSnapshotUUID  -- association [0..1]
LEFT OUTER JOIN C_EngSnpshtObjPgDoc AS _EngSnpshtObjPgDoc ON EngSnapshotUUID = _EngSnpshtObjPgDoc.EngSnapshotUUID  -- association [0..*]
LEFT OUTER JOIN C_EngSnpshtObjPgVislDoc AS _EngSnpshtObjPgVislDoc ON EngSnapshotUUID = _EngSnpshtObjPgVislDoc.EngSnapshotUUID  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdDetsAssgdToEngSnpsht AS _ChgRecdDetsAssgd ON EngSnapshotID = _ChgRecdDetsAssgd.EngSnapshotID AND EngSnpshtRevisionNumber = _ChgRecdDetsAssgd.EngSnpshtRevisionNumber  -- association [0..*]
LEFT OUTER JOIN I_EngSnpshtRevisionRankTblFunc AS _SnpshtRevsnRank ON EngSnapshotID = _SnpshtRevsnRank.EngSnapshotID AND EngSnpshtRevisionNumber = _SnpshtRevsnRank.EngSnpshtRevisionNumber  -- association [1..1]
;