C_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 C_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: CSRVENHCD

CREATE VIEW C_ServiceOrderEnhcd AS
SELECT
  ServiceDocument AS ServiceOrder,
  ServiceDocumentType,
  ServiceObjectType,
  ServiceDocumentDescription AS ServiceOrderDescription,
  SoldToParty,
  ShipToParty,
  BillToParty,
  ServiceDocumentPriority AS ServiceOrderPriority,
  PostingDate,
  ServiceDocumentHasError,
  ServiceDocumentStatus AS ServiceOrderStatus,
  _ServiceDocRefObj.Equipment AS Equipment,
  _ServiceDocRefObj._Equipment._EquipmentText[1: Language=$session.system_language].EquipmentName AS EquipmentName,
  _ServiceDocRefObj.FunctionalLocation AS FunctionalLocation,
  _ServiceDocRefObj._FunctionalLocation._FunctionalLocationText[1: Language=$session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _ServiceDocRefObj._Equipment.Material AS ReferenceProduct,
  _ServiceDocRefObj.ProductID AS ProductID,
  _ServiceDocRefObj._Product._Text[1: Language=$session.system_language].ProductName AS ProductName,
  PaymentTerms,
  BusinessActivityCategory,
  tstmp_to_dats( RequestedServiceStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceStartDate AS clientNULLasRequestedServiceStartDate,
  tstmp_to_dats( RequestedServiceEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceEndDate AS clientNULLasRequestedServiceEndDate,
  ResponsibleEmployee,
  ServiceTeam,
  SoldToPartyCountry,
  SoldToPartyRegion,
  PurchaseOrderByCustomer,
  ServiceEmployee,
  ContactPerson,
  ServiceDocumentUUID,
  ServiceDocumentCharUUID AS ServiceOrderUUID,
  ServiceDocumentIsQuotation,
  ServiceDocumentIsReleased,
  ServiceDocumentIsOpen,
  cast( '' as abap.char( 40 )) AS ServiceDocBillingStatusName,
  cast(3 as abap.int4) AS ServiceDocIsRelForBillCritlty,
  cast( '' as abap.char( 40 )) AS ServiceDocOvrlBillgBlkStsName,
  cast(3 as abap.int4) AS SrvcDocOvrlBillgBlkStsCritlty,
  cast( '' as abap.char( 40 )) AS ServiceDocOvrlBillingStsName,
  cast( '' as abap.char( 1 )) AS ServiceDocOvrlBillgBlkSts,
  cast(3 as abap.int4) AS ServiceDocOvrlBillingStsCritl,
  cast( '' as abap.char( 1 )) AS ServiceDocOvrlBillingSts,
  cast( '' as crmt_boolean ) AS PriceIsFixed,
  cast(0 as abap.int4) AS OverallCompletionPercent,
  cast(0 as abap.curr(15,2)) AS SrvcConfGrossAmount,
  cast( 1 as abap.dec(13,3)) AS ServiceDocDuration,
  cast( 1 as abap.dec(13,3)) AS ActualDurationInHours,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
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_SrvcDocObjPgTransHistory AS _ServiceDocumentTransHistory ON ServiceObjectType = _ServiceDocumentTransHistory.ServiceObjectType AND ServiceOrder = _ServiceDocumentTransHistory.ServiceDocument  -- 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..*]
;