I_SbsMssProcgElmContrDocChg

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_SbsMssProcgElmContrDocChg.
-- 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_SbsMssProcgElmContrDocChg AS
SELECT
  SubscrpnMassProcgElmntUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime,
  SubscrpnMassProcgUUID,
  SubscrpnMassProcgID,
  SbsMssProcgElmntProcdAtDteTme,
  SubscrpnMassProcgElmntSts,
  SubscrpnMassProcgElmntLgHandle,
  SubscriptionContract,
  SubscriptionChangeOrder,
  SbsMssProcgElmFllwUpDoc,
  SbsMssProcgElmntActvtnDteTme,
  SbsMssProcgElmntSoldToParty,
  SbsMssProcgElmContractAccount,
  SubscrpnMassProcgElmntSlsOrg,
  SbsMssProcgElmDistrChnl,
  SubscrpnMassProcgElmntDivn,
  SubscrpnMassProcgElmntSlsOffc,
  SubscrpnMassProcgElmntSlsGrp,
  SbsMssProcgElmSlsOrgUntID
FROM crms4d_som_mped
LEFT OUTER JOIN I_SubscrpnMassProcgElmntSts AS _SubscrpnMassProcgElmntSts ON SubscrpnMassProcgElmntSts = _SubscrpnMassProcgElmntSts.SubscrpnMassProcgElmntSts  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON SbsMssProcgElmContractAccount = _ContractAccountPartner.ContractAccount AND SbsMssProcgElmntSoldToParty = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SbsMssProcgElmntSoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SubscrpnMassProcgElmntSlsOrg = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SubscrpnMassProcgElmntSlsOffc = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SubscrpnMassProcgElmntSlsGrp = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON SubscrpnMassProcgElmntDivn = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON SbsMssProcgElmDistrChnl = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesOrganizationUnit ON SbsMssProcgElmSlsOrgUntID = _SalesOrganizationUnit.OrganizationalUnit  -- association [0..1]
;