C_ACMMntnContractSnapshot

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_ACMMntnContractSnapshot.
-- 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: CACMCNTRCTSNAP

CREATE VIEW C_ACMMntnContractSnapshot AS
SELECT
  ContractSnapshot.ACMSnpshtDocumentID AS ACMSnpshtDocumentID,
  ACMContractSnpshtID,
  ACMContractSnpshtDateTime,
  ACMSnapshotLevel,
  ContractSnapshot.TradingContractItem AS TradingContractItem,
  TradingContractExternalID,
  cast(ContractNum as tkonn ) AS ContractNum,
  ACMSnpshtOutputProcStatus,
  ACMTrdgContrIsSnpshtSgntrRlvt,
  ACMSignatureStatus,
  ACMSnapshotLevelTxt,
  ACMRelevantForSignatureTxt,
  _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.Side AS ContractSide,
  ContractOvw.DocumentSide AS ContractDocumentSide,
  ContractOvw.TradingContractType AS ACMTradingContractType,
  ContractOvw.TradingContractTypeName AS ACMTrdgContrTypeDesc,
  ContractOvw.TradingContractCreatedBy AS ACMSnpshtCreatedByID,
  ContractOvw.TradingContractCreatedByName AS ACMSnpshtCreatedByName,
  ContractOvw.ACMVehContrIndVal AS ACMVehContrIndVal,
  _SnapshotHeader.ChangedBy AS ACMSnpshtChangedByID,
  _SnapshotHeader.ChangedByName AS ACMSnpshtChangedByName,
  _SnapshotHeader.ACMSystemTimeZoneToDate AS ACMSnpshtLastChangedOnDate,
  ContractOvw.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  ContractOvw.DocumentDate AS DocumentDate,
  ContractOvw.TradingContractCurrency AS TradingContractCurrency,
  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.CompanyCode AS CompanyCode,
  ContractOvw.TradingContractCreditSales AS TradingContractCreditSales,
  ContractOvw.ACMSignedStatus AS ACMSignedStatus,
  ContractOvw.ACMTargetTrdgContrType AS ACMTargetTrdgContrType,
  ContractOvw.ACMTargetTrdgContrTypeName AS ACMTargetTrdgContrTypeName,
  ContractOvw.ACMTrdgContrQuotesValidDate AS ACMTrdgContrQuotesValidDate,
  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.CommodityName AS CommodityName,
  _ItemOverview.ContractPlant AS Plant,
  _ItemOverview.PlantName AS PlantName,
  _ItemOverview.ActualStartDateFrom AS ActualStartDateFrom,
  _ItemOverview.ActualStartDateTo AS ActualStartDateTo,
  ContractOvw.Incoterms AS Incoterms,
  ContractOvw.IncotermsClassificationName AS IncotermsClassificationName,
  ContractOvw.IncotermsLocation1 AS IncotermsLocation1,
  ContractOvw.ACMYourReference AS ACMYourReference,
  ContractOvw.ACMCustomerReference AS ACMCustomerReference,
  ContractOvw.PersonResponsible AS PersonResponsible,
  ContractOvw.PersonResponsibleName AS PersonResponsibleName
FROM I_ACMContrSnpshtHeadItmDet AS ContractSnapshot
LEFT OUTER JOIN I_ACMContractSnapshotAddlDet AS _ContractSnapshotAdd ON _ContractSnapshotAdd.ACMSnpshtDocumentID = ContractSnapshot.ContractNum AND ( _ContractSnapshotAdd.TradingContractItem = ContractSnapshot.TradingContractItem OR _ContractSnapshotAdd.TradingContractItem = '000000' ) AND _ContractSnapshotAdd.TrdgContrSnpshtCrtedOnDateTime = ContractSnapshot.ACMContractSnpshtDateTime  -- association [0..*]
LEFT OUTER JOIN P_ACMTradingContractOverview AS ContractOvw ON ContractOvw.TradingContractNumber = ContractSnapshot.ContractNum  -- association [1..1]
LEFT OUTER JOIN I_TradingContractItemOverview AS _ItemOverview ON ContractSnapshot.ContractNum = _ItemOverview.TradingContractNumber  -- association [1..*]
LEFT OUTER JOIN I_ACMTrdgContractPartnerDets AS _TrdgContrHdrPartDetails ON ContractSnapshot.ContractNum = _TrdgContrHdrPartDetails.TradingContractNumber AND _TrdgContrHdrPartDetails.TradingContractItem = '000000' AND ( _TrdgContrHdrPartDetails.PartnerFunction = 'A4' OR _TrdgContrHdrPartDetails.PartnerFunction = 'A3' )  -- association [1..*]
LEFT OUTER JOIN I_ContractSnapshotHeaderLevel AS _SnapshotHeader ON ContractSnapshot.ACMSnpshtDocumentID = _SnapshotHeader.ACMSnapshotID AND ContractSnapshot.ACMContractSnpshtDateTime = _SnapshotHeader.ACMContractSnpshtDateTime  -- association [0..1]
LEFT OUTER JOIN I_ContractSnapshotItemLevel AS _SnapshotItem ON ContractSnapshot.ACMSnpshtDocumentID = _SnapshotItem.ACMSnapshotID AND ContractSnapshot.ACMContractSnpshtDateTime = _SnapshotItem.ACMContractSnpshtDateTime AND ContractSnapshot.TradingContractItem = _SnapshotItem.TradingContractItem  -- association [0..1]
;