R_ServiceContractTP

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 R_ServiceContractTP.
-- 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 R_ServiceContractTP AS
SELECT
  ServiceDocument AS ServiceContract,
  ServiceObjectType,
  ServiceDocumentType AS ServiceContractType,
  ServiceDocumentUUID AS ServiceContractUUID,
  ServiceDocumentDescription AS ServiceContractDescription,
  Language,
  PostingDate,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  EnterpriseServiceOrganization,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  SoldToPartyCountry,
  ServiceDocumentStatus AS ServiceContractStatus,
  ServiceDocBillingStatus AS SrvcContrBillingStatus,
  SrvcDocRejectionStatus,
  ServiceDocumentHasError AS ServiceContractHasError,
  SrvcDocTransferStatus,
  SrvcDocCreditStatus AS SrvcContrCreditStatus,
  SrvcDocGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus,
  SrvcDocGTSLglControlStatus,
  ServiceContractStartDateTime,
  ServiceContractEndDateTime,
  SrvcContrEarliestStartDateTime,
  SrvcContrLatestEndDateTime,
  TransactionCurrency,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  PricingDocument,
  ServiceDocumentCanclnParty AS ServiceContractCanclnParty,
  ServiceDocumentCanclnReason AS ServiceContrCancellationReason,
  ServiceContractCanclnSts,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceDocumentRejectionReason AS ServiceContractRejectionReason,
  _ExtRefServiceContract.CustMgmtExtRefID AS SrvcContrExternalReference,
  _ExtRefServiceQtan.CustMgmtExtRefID AS ServiceQtanExtReference,
  _ExtRefLegalContract.CustMgmtExtRefID AS LegalContractExtReference,
  RefBusinessSolutionOrder,
  cast( _RefServiceTemplate.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS RefServiceContractTemplate,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcContrStatus ON ServiceContractUUID = _SrvcContrStatus.StatusObjectUUID AND ( _SrvcContrStatus.StatusCode = 'I1002' OR _SrvcContrStatus.StatusCode = 'I1003' OR _SrvcContrStatus.StatusCode = 'I1004' OR _SrvcContrStatus.StatusCode = 'I1005' ) AND _SrvcContrStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceContract ON _ExtRefServiceContract.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceContract.CustMgmtDocument AND _ExtRefServiceContract.CustMgmtExtRefIDType = '0003'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceQtan ON _ExtRefServiceQtan.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceQtan.CustMgmtDocument AND _ExtRefServiceQtan.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefLegalContract ON _ExtRefLegalContract.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefLegalContract.CustMgmtDocument AND _ExtRefLegalContract.CustMgmtExtRefIDType = '0021'  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = I_ServiceDocumentEnhcd.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocDocumentFlow AS _RefServiceTemplate ON ServiceContractUUID = _RefServiceTemplate.ServiceDocumentUUID AND _RefServiceTemplate.PrdcssrSuccssrDocObjectType = 'BUS2000112' AND _RefServiceTemplate.ServiceObjectType = 'BUS2000112' AND _RefServiceTemplate.ServiceDocumentTemplateType is not initial  -- association [0..1]
LEFT OUTER JOIN R_BusinessSolutionOrderTP AS _SolutionOrder ON RefBusinessSolutionOrder = _SolutionOrder.BusinessSolutionOrder  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON ServiceObjectType = _Extension.ServiceCategory AND ServiceContract = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodInCountryVH AS _PaymentMethodVH ON PaymentMethod = _PaymentMethodVH.PaymentMethod AND SoldToPartyCountry = _PaymentMethodVH.Country  -- association [0..1]
LEFT OUTER JOIN R_ServiceContractItemTP AS _ServiceContractItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrPartnerTP AS _SrvcContrPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrPriceElementTP AS _SrvcContrPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrUserStatusTP AS _SrvcContrUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrAppointmentTP AS _SrvcContrAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrDurationTP AS _SrvcContrDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrFUPBillgDocTP AS _SrvcContrFUPBillgDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrFUPSrvcOrdTP AS _SrvcContrFUPSrvcOrdTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrLongTextTP AS _SrvcContrLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;