I_ACMContractSnapshotHeader

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_ACMContractSnapshotHeader.
-- 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_ACMContractSnapshotHeader AS
SELECT
  header.snapshot_uuid AS ACMSnpshtUUID,
  header.contract_number AS ACMContractNumber,
  header.creation_timestamp AS ACMSnpshtCreationDateTime,
  header.changed_timestamp AS ACMSnpshtChangedDateTime,
  header.created_by AS ACMSnpshtCreatedByID,
  header.changed_by AS ACMSnpshtChangedByID,
  header.signature_rel AS ACMTrdgContrIsSnpshtSgntrRlvt,
  header.signature_status AS ACMSignatureStatus,
  _SignatureStatusVH._Text[Language = $session.system_language].ACMTrdgContrSgntrStsText AS ACMSignatureStatusDesc,
  header.output_process AS ACMSnpshtOutputProcess,
  _OutputProcessVH._Text[Language = $session.system_language].ProcessingStatusDesc AS ACMOutputProcessingStatusDesc,
  orig_resp_trader_id AS ACMOriginalTraderID,
  _Extension.ACMOriginalTraderIDText AS ACMOriginalTraderIDText,
  resp_trader_id AS ACMAmendingTraderID,
  _Extension.ACMAmendingTraderIDText AS ACMAmendingTraderIDText
FROM /accgo/t_snp_hdr AS header
LEFT OUTER JOIN I_ACMCONTRSNPSHTOutpProcgSts AS _OutputProcessVH ON ACMSnpshtOutputProcess = _OutputProcessVH.ACMSnpshtOutputProcStatus  -- association [0..1]
LEFT OUTER JOIN I_ACMCONTRSnpshtSgntrSts AS _SignatureStatusVH ON ACMSignatureStatus = _SignatureStatusVH.ACMSignatureStatus  -- association [0..1]
LEFT OUTER JOIN I_ACMContractSnapshotHdrExtn AS _Extension ON ACMSnpshtUUID = _Extension.ACMSnpshtUUID AND ACMContractNumber = _Extension.ACMContractNumber AND ACMSnpshtCreationDateTime = _Extension.ACMSnpshtCreationDateTime  -- association [1]
LEFT OUTER JOIN I_ACMTrdgContrHdrForPrcgOvw AS _ContractHeader ON ACMContractNumber = _ContractHeader.TradingContractNumber  -- association [1]
LEFT OUTER JOIN I_ACMContractSnapshotDetail AS _SnapshotDetails ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ACMContrSnpshtAddlDets AS _AdminFields ON /* condition not available in parsed metadata */  -- association [0..*]
;