I_ContractSnapshot

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_ContractSnapshot.
-- 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: ICNTRCTSNP

CREATE VIEW I_ContractSnapshot AS
SELECT
  cast( ACMSnapshotID as tkonn ) AS ACMSnpshtDocumentID,
  cast( ACMSnapshotID as tkonn ) AS ACMContractSnpshtID,
  ACMContractSnpshtDateTime,
  cast( 'H' as /accgo/e_cntrct_snp_level preserving type ) AS ACMSnapshotLevel,
  cast( '000000' as tposn ) AS TradingContractItem,
  TradingContractExternalID,
  ACMSnapshotID AS ContractNum,
  SnapshotHeader.ChangedBy AS ChangedBy,
  SnapshotHeader.ChangedByName AS ChangedByName,
  ACMSnpshtOutputProcStatus,
  ACMSignatureRelevant AS ACMTrdgContrIsSnpshtSgntrRlvt,
  ACMSignatureStatus,
  cast('Header' as /accgo/e_snapshot_lvl_txt ) AS ACMSnapshotLevelTxt,
  ContractSnapshotAdd.ACMSnapshotFieldName AS ACMSnapshotFieldName,
  ContractSnapshotAdd.ACMSnapshotFieldNameDesc AS ACMSnapshotFieldNameDesc,
  ContractSnapshotAdd.ACMTrdgContrSnapshotFieldValue AS ACMTrdgContrSnapshotFieldValue,
  ContractSnapshotAdd.ACMTrdgContrSnpshtFldAddlVal AS ACMTrdgContrSnpshtFldAddlVal,
  ContractSnapshotAdd.ACMTrdgContrSnpshtFldValDesc AS ACMTrdgContrSnpshtFldValDesc,
  ContractSnapshotAdd.ACMTrdgContrSnpshtPrpsDesc AS ACMTrdgContrSnpshtPrpsDesc,
  ContractOvw.Counterparty AS Counterparty,
  ContractOvw.ContractStatus AS ContractApplicationStatus,
  ContractOvw.TradingContractType AS ACMTradingContractType,
  ContractOvw.TradingContractTypeName AS ACMTrdgContrTypeDesc,
  ContractOvw.TradingContractCreatedBy AS ACMSnpshtCreatedByID,
  ContractOvw.TradingContractCreatedByName AS ACMSnpshtCreatedByName,
  ContractOvw.DocumentDate AS TradingContrCreatedOnDate,
  ContractOvw.SalesOrganization AS SalesOrganization,
  ContractOvw.SalesOrgDescr AS SalesOrganizationName,
  ContractOvw.DistributionChannel AS DistributionChannel,
  ContractOvw.DistributionChannelDescr AS DistributionChannelName,
  ContractOvw.Division AS Division,
  ContractOvw.SalesDivisionDescr AS ACMDivisionName,
  ContractOvw.PurchasingOrganization AS PurchasingOrganization,
  ContractOvw.ekotx AS PurchasingOrganizationName,
  ContractOvw.PurchasingGroup AS PurchasingGroup,
  ContractOvw.eknam AS PurchasingGroupName,
  ContractOvw.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  ContractOvw.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  _TrdgContrHdrPartDetails.TransactingCtpty AS TransactingCtpty,
  _ItemOverview.MaterialDesc AS MaterialDesc,
  _ItemOverview.ContractMaterial AS Material,
  _ItemOverview.ContractCommodityItem AS Commodity,
  _ItemOverview.ContractPlant AS Plant,
  _ItemOverview.PlantName AS PlantName,
  ContractOvw.ACMYourReference AS ACMYourReference,
  _ContractOvw.ACMCustomerReference AS ACMCustomerReference
FROM I_ContractSnapshotItemLevel AS SnapshotItem
LEFT OUTER JOIN P_TradingContractOverview AS ContractOvw ON ContractOvw.TradingContractNumber = SnapshotHeader.ACMSnapshotID  -- association [1..1]
LEFT OUTER JOIN I_TradingContractItemOverview AS _ItemOverview ON SnapshotHeader.ACMSnapshotID = _ItemOverview.TradingContractNumber  -- association [1..*]
LEFT OUTER JOIN C_ACMTrdgContrHdrPartDetails AS _TrdgContrHdrPartDetails ON SnapshotHeader.ACMSnapshotID = _TrdgContrHdrPartDetails.TradingContractNumber  -- association [1..*]
LEFT OUTER JOIN P_TradingContractOverview AS _ContractOvw ON _ContractOvw.TradingContractNumber = SnapshotItem.ACMSnapshotID  -- association [1..1]
-- UNION with additional select branch(es): I_ContractSnapshotItemLevel
;