I_ServiceDocumentEnhcd

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_ServiceDocumentEnhcd.
-- 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_ServiceDocumentEnhcd AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentUUID,
  ServiceDocumentCharUUID,
  ServiceDocumentType,
  ServiceDocumentDescription,
  Language,
  PostingDate,
  ServiceDocumentTemplateType,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  PricingDocument,
  PricingProcedure,
  RefBusinessSolutionOrder,
  SrvcDocIsMaintServiceOrder,
  SrvcDocWarrantyStatus,
  BusinessActivityCategory,
  ServiceDocumentPriority,
  ServiceDocNetAmount,
  ServiceDocGrossAmount,
  ServiceDocTaxAmount,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  ServiceTeam,
  ResponsibleEmployee,
  ServiceEmployee,
  ContactPerson,
  ShipToParty,
  BillToParty,
  PayerParty,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceContractStartDateTime,
  ServiceContractEndDateTime,
  SrvcContrEarliestStartDateTime,
  SrvcContrLatestEndDateTime,
  SrvcQtanValidityStartDateTime,
  SrvcQtanValidityEndDateTime,
  SrvcDocTmplValdtyStartDateTime,
  SrvcDocTmplValdtyEndDateTime,
  SrvcDocTemplateSearchTermText,
  PaymentTerms,
  PaymentMethod,
  SrvcSEPAMandateRelevance,
  SEPAMandate,
  WBSElementInternalID,
  TransactionCurrency,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  ServiceDocumentRejectionReason,
  Region,
  ServiceDocumentStatus,
  ServiceDocumentHasError,
  ServiceDocBillingStatus,
  ServiceDocIsReleasedForBilling,
  ServiceDocumentIsOpen,
  SrvcDocTransferStatus,
  ServiceDocumentIsQuotation,
  ServiceDocumentIsReleased,
  ServiceDocumentIsRejected,
  ServiceConfirmationIsFinal,
  ServiceContractCanclnSts,
  MaintSrvcOrdExecutionStatus,
  SrvcDocExecutionStatus,
  SrvcDocDeliveryStatus,
  SrvcDocGoodsIssueStatus,
  SrvcDocRejectionStatus,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ResponsibleSalesOrganization,
  EnterpriseServiceOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  RespyMgmtServiceTeam,
  BillingBlockReason,
  ServiceReasonSchema,
  ServiceReasonCategory,
  ServiceDefectSchema,
  ServiceDefectCategory,
  ServiceFirstResponseByDateTime,
  ServiceDueByDateTime,
  ErlstRequestedDeliveryDateTime,
  RecommendedServicePriority,
  ServiceDocumentUrgency,
  ServiceDocumentImpact,
  ServiceEscalationLevel,
  ServiceDocumentProblemCategory,
  ServiceRisk,
  ServiceDocumentCanclnParty,
  ServiceDocumentCanclnReason,
  ReferenceInHouseRepair,
  ReferenceInHouseRepairItem,
  RefInHouseRepairIsExisting,
  SrvcDocCreditStatus,
  SrvcDocGTSEmbargoStatus,
  SrvcDocGTSScreeningStatus,
  SrvcDocGTSLglControlStatus,
  SrvcDocBslnCostPostgStatus,
  SrvcDocContinuousCostStatus,
  SrvcOrdIsBusinessCompleted,
  SrvcOrdIsBusinessReopened,
  ShippingCondition,
  CustomerPriceGroup,
  SrvcDocAcctAssgmtObjectType,
  SrvcDocAcctAssgmtObject,
  _StatusObjectWithUUID.StatusProfile AS StatusProfile
FROM I_ServiceDocument
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ServiceDocItem ON ServiceObjectType = _ServiceDocItem.ServiceObjectType AND ServiceDocument = _ServiceDocItem.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN I_ServiceDocumentRefObject AS _ServiceDocRefObj ON ServiceObjectType = _ServiceDocRefObj.ServiceObjectType AND ServiceDocument = _ServiceDocRefObj.ServiceDocument AND _ServiceDocRefObj.ServiceDocumentItem is initial AND _ServiceDocRefObj.SrvcRefObjIsMainObject is not initial  -- association [0..*]
LEFT OUTER JOIN I_ServiceDocumentPredecessor AS _ServiceDocPredecessor ON ServiceDocumentUUID = _ServiceDocPredecessor.ServiceDocumentUUID AND ServiceObjectType = _ServiceDocPredecessor.ServiceObjectType  -- association [1]
LEFT OUTER JOIN I_ServiceDocumentSuccessor AS _ServiceDocSuccessor ON ServiceDocumentUUID = _ServiceDocSuccessor.ServiceDocumentUUID AND ServiceObjectType = _ServiceDocSuccessor.ServiceObjectType  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceDocument = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocBPContactCardQuickVw AS _SrvcDocBPSoldToParty ON SoldToParty = _SrvcDocBPSoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentLongText AS _ServiceDocLongText ON ServiceObjectType = _ServiceDocLongText.ServiceObjectType AND ServiceDocument = _ServiceDocLongText.ServiceDocument AND _ServiceDocLongText.ServiceDocumentItem is initial AND _ServiceDocLongText.TextObjectCategory = 'CRM_ORDERH'  -- association [0..*]
LEFT OUTER JOIN I_StatusObjectWithUUID AS _StatusObjectWithUUID ON ServiceDocumentUUID = _StatusObjectWithUUID.StatusObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _CustMgmtPartner ON ServiceDocument = _CustMgmtPartner.CustMgmtDocument AND ServiceObjectType = _CustMgmtPartner.CustMgmtObjectType AND _CustMgmtPartner.CustMgmtDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_SrvcDocHeaderLongText AS _SrvcDocHeaderLongText ON ServiceObjectType = _SrvcDocHeaderLongText.ServiceObjectType AND ServiceDocument = _SrvcDocHeaderLongText.ServiceDocument AND _SrvcDocHeaderLongText.Language = $session.system_language  -- association [0..*]
;