C_ACMContractSnapshot

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_ACMContractSnapshot.
-- 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: CACMCNTRCTSNP

CREATE VIEW C_ACMContractSnapshot AS
SELECT
  ACMSnpshtDocumentID AS TradingContractNumber,
  ACMContractSnpshtDateTime AS TrdgContrSnpshtCrtedOnDateTime,
  ACMSnapshotLevel AS ACMTrdgContrSnpshtLevel,
  ACMContractSnpshtID,
  TradingContractItem,
  ACMSnpshtDocumentID,
  TradingContractExternalID,
  ContractNum,
  ACMContractSnpshtDateTime,
  ACMSnapshotLevel,
  ACMContractSnpshtID AS ACMSnapshotID,
  ContractApplicationStatus,
  ContractSide,
  ContractDocumentSide,
  _ContractApplicationStatus.ACMContractApplStatusTxt AS ACMContractApplStatusTxt,
  Counterparty,
  _CounterParty.CustomerName AS ACMTrdgContrCtptyFullName,
  _CounterParty.CounterpartyFullName AS ACMCounterpartyFullName,
  _CounterParty.ACMCounterpartyFirstName AS ACMCounterpartyFirstName,
  _CounterParty.ACMCounterpartyLastName AS ACMCounterpartyLastName,
  _CounterParty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CounterParty.AuthorizationGroup AS AuthorizationGroup,
  TransactingCtpty,
  _TransCounterparty.CounterpartyFullName AS ACMTrdgContrTransCtptyDesc,
  _TransCounterparty.ACMCounterpartyFirstName AS ACMTransCounterpartyFirstName,
  _TransCounterparty.ACMCounterpartyLastName AS ACMTransCounterpartyLastName,
  _TransCounterparty.CounterpartyFullName AS ACMTransCounterpartyFullName,
  ACMSnpshtOutputProcStatus AS ACMTrdgContrOutpProcgStsVal,
  _OutputProcessingStatus.ProcessingStatusDesc AS ACMTrdgContrOutpProcgStsDesc,
  ACMTrdgContrIsSnpshtSgntrRlvt,
  ACMRelevantForSignatureTxt,
  ACMSignatureStatus,
  _SignatureStatus.ACMTrdgContrSgntrStsText AS ACMTrdgContrSgntrStsText,
  ACMTradingContractType,
  ACMSignedStatus,
  ACMTargetTrdgContrType,
  ACMTargetTrdgContrTypeName,
  ACMTrdgContrQuotesValidDate,
  ACMVehContrIndVal,
  TradingContractCreditSales,
  _CreditSale.HCMDomainValueText AS ACMCreditSaleText,
  ACMTrdgContrSnpshtPrpsDesc,
  ACMSnapshotFieldName,
  ACMSnapshotFieldNameDesc,
  ACMTrdgContrSnapshotFieldValue,
  ACMTrdgContrSnpshtFldAddlVal,
  ACMTrdgContrSnpshtFldValDesc,
  ACMTrdgContrTypeDesc,
  ACMSnpshtCreatedByID,
  ACMSnpshtCreatedByName,
  ACMSnpshtChangedByID,
  ACMSnpshtLastChangedOnDate,
  ACMSnpshtChangedByName,
  TradingContrCreatedOnDate,
  DocumentDate,
  TradingContractCurrency,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  SalesOrganization,
  SalesOrganizationName,
  DistributionChannel,
  DistributionChannelName,
  Division,
  ACMDivisionName,
  PurchasingOrganization,
  PurchasingOrganizationName,
  PurchasingGroup,
  PurchasingGroupName,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc1Text,
  ACMSnapshotLevelTxt AS ACMTrdgContrSnpshtLevelDesc,
  Material,
  MaterialDesc AS MaterialName,
  Commodity,
  CommodityName,
  Plant,
  PlantName,
  ActualStartDateFrom,
  ActualStartDateTo,
  cast( ' ' as /accgo/e_snpshot_edit_ind ) AS ACMSnapshotFieldIsEditable,
  cast( ' ' as /accgo/e_snpshot_edit_ind ) AS ACMTrdgContrSnpshtFldIsAuthzd,
  cast( ' ' as /accgo/e_snapshot_note ) AS ACMTrdgContrSnapshotNoteText,
  _note.ACMTrdgContrSnapshotNoteText AS ACMTrdgContrSnpshtNoteLongTxt,
  cast(1 as abap.int4) AS ACMTrdgContrSnpshtCndnTotalVal,
  ACMCustomerReference,
  ACMYourReference,
  Incoterms,
  IncotermsClassificationName,
  IncotermsLocation1,
  PersonResponsible,
  PersonResponsibleName
FROM C_ACMMntnContractSnapshot AS ContractSnapshot
LEFT OUTER JOIN C_ACMSnapshotProcessingStsVH AS _OutputProcessingStatus ON ACMTrdgContrOutpProcgStsVal = _OutputProcessingStatus.ACMSnpshtOutputProcStatus  -- association [0..1]
LEFT OUTER JOIN C_SnapshotSignatureStatusVH AS _SignatureStatus ON ACMSignatureStatus = _SignatureStatus.ACMSignatureStatus  -- association [0..1]
LEFT OUTER JOIN C_ContractApplicationStatusVH AS _ContractApplicationStatus ON ContractApplicationStatus = _ContractApplicationStatus.ContractApplicationStatus  -- association [1..1]
LEFT OUTER JOIN P_TradingContractCounterparty AS _CounterParty ON Counterparty = _CounterParty.Counterparty  -- association [0..1]
LEFT OUTER JOIN I_ACMCompanyCodeStdVH AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN P_TradingContractCounterparty AS _TransCounterparty ON TransactingCtpty = _TransCounterparty.Counterparty  -- association [0..1]
LEFT OUTER JOIN I_ACMContractSnapshotNote AS _note ON ACMSnpshtDocumentID = _note.ACMSnapshotID  -- association [0..1]
LEFT OUTER JOIN I_CreditSaleValueHelp AS _CreditSale ON TradingContractCreditSales = _CreditSale.ACMDomainValue  -- association [0..1]
LEFT OUTER JOIN I_VehicleContractValueHelp AS _signedStatus ON ACMSignedStatus = _signedStatus.DomainValue  -- association [0..1]
;