I_ServiceMassRunElmntChgInfo

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_ServiceMassRunElmntChgInfo.
-- 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_ServiceMassRunElmntChgInfo AS
SELECT
  Element.ServiceMassRunElementUUID AS ServiceMassRunElementUUID,
  Element.ServiceMassRunUUID AS ServiceMassRunUUID,
  _MassRunHeader.ServiceMassRunType AS ServiceMassRunType,
  Element.ServiceMassRunElementStatus AS ServiceMassRunElementStatus,
  Element.SrvcMassRunElmntExectdAtDteTme AS SrvcMassRunElmntExectdAtDteTme,
  Element.SrvcMassRunElmntVerificatSts AS SrvcMassRunElmntVerificatSts,
  Element.SubscriptionContractUUID AS SubscriptionContractUUID,
  _SubscriptionContr.ServiceDocItemCreationDateTime AS CreationDateTime,
  _SubscriptionContr.ServiceDocItemCreatedByUser AS CreatedByUser,
  _SubscriptionContr.OriginallyRequestedProduct AS Product,
  _SubscriptionContr.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  _SubscriptionContr.ServiceDocumentItem AS ServiceDocumentItem,
  _SubscriptionContr.PostingDate AS PostingDate,
  _SubscriptionContr.SubscrpnContrActivationStatus AS SubscrpnContrActivationStatus,
  _SubscriptionContr.SubscrpnContrTimeSliceStatus AS SubscrpnContrTimeSliceStatus,
  _SubscriptionContr._ServiceDocItemStatus.ServiceDocumentStatus AS ServiceDocumentStatus,
  _SubscriptionContr.ServiceDocument AS ServiceDocument,
  _SubscriptionContr._SoldToParty.BusinessPartnerName AS SoldToPartyFullName,
  _SubscriptionContr.SoldToParty AS SoldToParty,
  _SubscriptionContr.SubscrpnOrdProdSelType AS SubscrpnOrdProdSelType,
  _SubscriptionContr.SubscriptionContract AS SubscriptionContract,
  _SubscriptionContr._MasterAgrmtItem.CustMgmtMasterAgreement AS CustMgmtMasterAgreement,
  _SubscriptionContr._MasterAgrmtItem.CustMgmtMstrAgrmtCustomProdID AS CustMgmtMstrAgrmtCustomProdID,
  _SubscriptionContr.SharingContractID AS SharingContractID,
  _SubscriptionContr.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SubscriptionContr.ServiceContrItemStartDateTime AS ServiceContrItemStartDateTime,
  _SubscriptionContr.ServiceContrItemEndDateTime AS ServiceContrItemEndDateTime,
  Element.ServiceChangeOrderUUID AS ServiceChangeOrderUUID,
  _ServiceDocument.ServiceDocument AS SubscriptionOrder
FROM I_ServiceMassRunElementChange AS Element
LEFT OUTER JOIN I_ServiceMassRunHeaderAdmin AS _MassRunHeader ON ServiceMassRunUUID = _MassRunHeader.ServiceMassRunUUID  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceDocument ON ServiceChangeOrderUUID = _ServiceDocument.ServiceDocumentUUID  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItem AS _SubscriptionContr ON SubscriptionContractUUID = _SubscriptionContr.ServiceDocumentItemUUID  -- association [0..1]
;