I_ServiceOrderEnhcd

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_ServiceOrderEnhcd.
-- 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: ISRVENHCD

CREATE VIEW I_ServiceOrderEnhcd AS
SELECT
  ServiceDocument AS ServiceOrder,
  ServiceDocumentType,
  ServiceObjectType,
  ServiceDocumentDescription AS ServiceOrderDescription,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ServiceDocumentPriority AS ServiceOrderPriority,
  PostingDate,
  ServiceDocumentHasError,
  ServiceDocGrossAmount,
  ServiceDocNetAmount,
  ServiceDocTaxAmount,
  TransactionCurrency,
  SrvcDocBslnCostPostgStatus,
  SrvcDocContinuousCostStatus,
  SrvcDocTransferStatus,
  SrvcDocExecutionStatus,
  ServiceDocumentStatus AS ServiceOrderStatus,
  _ServiceDocRefObj._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  _ServiceDocRefObj._FunctionalLocation._FunctionalLocationText[1: Language=$session.system_language].FunctionalLocationName AS FunctionalLocationName,
  case _ServiceDocRefObj.ReferenceProduct when '' then _ServiceDocRefObj._Equipment.Material else _ServiceDocRefObj.ReferenceProduct end as ReferenceProduct AS ReferenceProductendasReferenceProduct,
  _ServiceDocRefObj._Product._Text[1: Language=$session.system_language].ProductName AS ProductName,
  WBSElementInternalID,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  BusinessActivityCategory,
  tstmp_to_dats( RequestedServiceStartDateTime, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceStartDate AS clientNULLasRequestedServiceStartDate,
  tstmp_to_dats( RequestedServiceEndDateTime, abap_user_timezone($session.user, $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceEndDate AS clientNULLasRequestedServiceEndDate,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ResponsibleEmployee,
  ServiceTeam,
  SoldToPartyCountry,
  ServiceDocumentIsRejected,
  SoldToPartyRegion,
  PurchaseOrderByCustomer,
  ServiceEmployee,
  ContactPerson,
  ServiceDocumentUUID,
  ServiceDocumentCharUUID AS ServiceOrderUUID,
  ServiceDocumentIsQuotation,
  RefInHouseRepairIsExisting,
  ServiceDocumentIsReleased,
  ServiceDocumentIsOpen,
  cast( '' as abap.char( 40 )) AS ServiceDocBillingStatusName,
  cast(3 as abap.int4) AS ServiceDocIsRelForBillCritlty,
  cast( '' as abap.char( 1 )) AS ServiceDocOvrlBillgBlkSts,
  cast( '' as abap.char( 40 )) AS ServiceDocOvrlBillgBlkStsName,
  cast(3 as abap.int4) AS SrvcDocOvrlBillgBlkStsCritlty,
  cast( '' as abap.char( 1 )) AS ServiceDocOvrlBillingSts,
  cast( '' as abap.char( 40 )) AS ServiceDocOvrlBillingStsName,
  cast(3 as abap.int4) AS ServiceDocOvrlBillingStsCritl,
  cast( '' as crmt_boolean ) AS PriceIsFixed,
  cast(0 as abap.int4) AS OverallCompletionPercent,
  cast(0 as crmt_gross_value) AS SrvcConfGrossAmount,
  cast( 1 as abap.dec(13,3)) AS ServiceDocDuration,
  cast( 1 as abap.dec(13,3)) AS ActualDurationInHours,
  cast( '' as crmt_boolean ) AS ServiceConfIsFinalEnabled,
  cast( '' as crmt_boolean ) AS IsBillingRelevant,
  cast( '' as crmt_boolean ) AS ServiceConfirmationIsCanceled,
  cast( '' as crmt_boolean ) AS ServiceConfirmationIsCompleted,
  cast( '' as crmt_boolean ) AS ServiceOrderIsEditable,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RefBusinessSolutionOrder,
  ServiceDocumentTemplateType,
  SrvcDocCreditStatus AS SrvcOrdCreditStatus,
  I_ServiceDocumentEnhcd.RespyMgmtServiceTeam AS RespyMgmtServiceTeam,
  _CustMgmtExtRef.CustMgmtExtRefID AS CustMgmtExtRefID,
  _CustomerSEPAMandate.SEPAMandateCreditor AS SEPAMandateCreditor,
  _CustomerSEPAMandate.SEPAMandateApplication AS SEPAMandateApplication,
  _CustomerSEPAMandate.SEPAMandateStatus AS SEPAMandateStatus,
  _RefMaintenanceItem.MaintenanceItem AS MaintenanceItem,
  _RefMaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _RefMaintenancePlan.MaintenancePlan AS MaintenancePlan,
  _RefMaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  _ServiceDocRefObj.Equipment AS Equipment,
  _ServiceDocRefObj.FunctionalLocation AS FunctionalLocation,
  _ServiceDocRefObj.ProductID AS ProductID,
  _SoldToPartyToCustomer.Customer AS Customer,
  _SrvcDocBslnPlannedCost.SrvcDocBslnPlndCostAmount AS SrvcDocBslnPlndCostAmount,
  _SrvcDocBslnPlannedRevenue.SrvcDocBslnPlndRevenueAmount AS SrvcDocBslnPlndRevenueAmount,
  _SrvcDocContinuousPlannedCost.SrvcDocContnsPlndCostAmount AS SrvcDocContnsPlndCostAmount,
  _SrvcDocContinuousPlannedRevn.SrvcDocContnsPlndRevnAmount AS SrvcDocContnsPlndRevnAmount,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN C_ServiceDocumentSoldToPartyVH AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_ServiceDocObjPgNotes AS _ServiceDocumentNotes ON ServiceObjectType = _ServiceDocumentNotes.ServiceObjectType AND ServiceOrder = _ServiceDocumentNotes.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_SrvcOrdFUPSrvcConfTransHist AS _SrvcOrdFUPSrvcConfTransHist ON ServiceOrder = _SrvcOrdFUPSrvcConfTransHist.ServiceOrder AND ServiceObjectType = _SrvcOrdFUPSrvcConfTransHist.ServiceObjectType  -- association [1..*]
LEFT OUTER JOIN C_SrvcDocDocumentFlow AS _SrvcDocDocumentFlow ON ServiceOrder = _SrvcDocDocumentFlow.ServiceOrder  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocObjPgErrorLog AS _ServiceDocumentErrorLog ON ServiceObjectType = _ServiceDocumentErrorLog.ServiceObjectType AND ServiceOrder = _ServiceDocumentErrorLog.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN C_ServiceDocumentPartner AS _PartiesInvolved ON ServiceObjectType = _PartiesInvolved.CustMgmtObjectType AND ServiceOrder = _PartiesInvolved.CustMgmtDocument AND _PartiesInvolved.CustMgmtDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN C_SrvcOrderObjPgPricingDets AS _ServiceOrderPriceDets ON ServiceObjectType = _ServiceOrderPriceDets.ServiceObjectType AND ServiceOrder = _ServiceOrderPriceDets.ServiceDocument  -- association [1..*]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _CustMgmtExtRef ON ServiceOrder = _CustMgmtExtRef.CustMgmtDocument AND ServiceObjectType = _CustMgmtExtRef.CustMgmtObjectType AND _CustMgmtExtRef.CustMgmtExtRefIDSequenceNumber = '000001' AND _CustMgmtExtRef.CustMgmtExtRefIDType = '0001'  -- association [0..1]
LEFT OUTER JOIN C_ServiceOrderTypeVH AS _ServiceOrderType ON ServiceDocumentType = _ServiceOrderType.ServiceOrderType  -- association [1..1]
LEFT OUTER JOIN C_SrvcMgmtCntctPersnQuickVw AS _SrvcDocBPContactCard ON ContactPerson = _SrvcDocBPContactCard.BusinessPartner AND SoldToParty = _SrvcDocBPContactCard.SoldToParty  -- association [1..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPSoldToParty ON SoldToParty = _SrvcDocBPSoldToParty.BusinessPartner AND customer = _SrvcDocBPSoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPBillToParty ON BillToParty = _SrvcDocBPBillToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPShipToParty ON ShipToParty = _SrvcDocBPShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SrvcDocBPPayerParty ON PayerParty = _SrvcDocBPPayerParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessSolutionOrderStdVH AS _SolutionOrderVH ON RefBusinessSolutionOrder = _SolutionOrderVH.BusinessSolutionOrder  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefMaintenancePlan AS _RefMaintenancePlan ON ServiceDocumentUUID = _RefMaintenancePlan.ServiceDocumentUUID AND ServiceObjectType = _RefMaintenancePlan.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefMaintenanceItem AS _RefMaintenanceItem ON ServiceDocumentUUID = _RefMaintenanceItem.ServiceDocumentUUID AND ServiceObjectType = _RefMaintenanceItem.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN C_SrvcDocChangeDocument AS _ChangeDocument ON ServiceOrderUUID = _ChangeDocument.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN I_CustomerSEPAMandate AS _CustomerSEPAMandate ON SEPAMandate = _CustomerSEPAMandate.SEPAMandate AND _CustomerSEPAMandate.SEPAMandateVersion = '0000'  -- association [1..*]
LEFT OUTER JOIN I_SrvcDocBslnPlannedCost AS _SrvcDocBslnPlannedCost ON _SrvcDocBslnPlannedCost.ServiceDocument = ServiceOrder AND _SrvcDocBslnPlannedCost.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SEPAMandateStatus AS _SEPAMandateStatus ON SEPAMandateStatus = _SEPAMandateStatus.SEPAMandateStatus  -- association [1..1]
LEFT OUTER JOIN I_SrvcDocBslnPlannedRevenue AS _SrvcDocBslnPlannedRevenue ON _SrvcDocBslnPlannedRevenue.ServiceDocument = ServiceOrder AND _SrvcDocBslnPlannedRevenue.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocContnsPlannedCost AS _SrvcDocContinuousPlannedCost ON _SrvcDocContinuousPlannedCost.ServiceDocument = ServiceOrder AND _SrvcDocContinuousPlannedCost.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocContnsPlannedRevenue AS _SrvcDocContinuousPlannedRevn ON _SrvcDocContinuousPlannedRevn.ServiceDocument = ServiceOrder AND _SrvcDocContinuousPlannedRevn.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;