I_EngSnpshtHdr

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_EngSnpshtHdr.
-- 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: IENGSNPHDR

CREATE VIEW I_EngSnpshtHdr AS
SELECT
  Header.uuid AS EngSnapshotUUID,
  Header.snapshot_id AS EngSnapshotID,
  Header.snapshot_name AS EngSnapshotName,
  Header.snapshot_type AS EngSnapshotType,
  Header.matnr AS Material,
  Header.werks AS Plant,
  Header.stlan AS BillOfMaterialVariantUsage,
  Header.stlal AS BillOfMaterialVariant,
  Header.dokar AS DocumentInfoRecordDocType,
  Header.doknr AS DocumentInfoRecordDocNumber,
  Header.doktl AS DocumentInfoRecordDocPart,
  Header.plan_scope_documentid AS PlanningScopeInternalID,
  Header.plan_scope_alt AS PlanningScopeAlternative,
  Header.revn_nmbr AS EngSnpshtRevisionNumber,
  Header.aux_prep_sts AS EngSnpshtAuxiliaryPrepSts,
  Header.chg_prep_sts AS EngSnpshtChangePrepSts,
  Header.prpsd_effective_date AS EngSnpshtProposedEffectiveDate,
  Header.created_by AS CreatedByUser,
  Header.created_at AS CreationDateTime,
  Header.changed_by AS LastChangedByUser,
  Header.changed_at AS LastChangeDateTime
FROM mpe_snp_hdr AS Header
;