A_ServiceRequest

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 A_ServiceRequest.
-- 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 A_ServiceRequest AS
SELECT
  ServiceDocument AS ServiceRequest,
  ServiceDocumentType AS ServiceRequestType,
  ServiceDocumentUUID AS ServiceRequestUUID,
  ServiceDocumentDescription AS ServiceRequestDescription,
  Language,
  ServiceDocumentPriority,
  BusinessActivityCategory AS ServiceDocumentCategory,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceFirstResponseByDateTime,
  ServiceDueByDateTime,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  RecommendedServicePriority,
  ServiceDocumentUrgency AS ServiceRequestUrgency,
  ServiceDocumentImpact AS ServiceRequestImpact,
  ServiceDocumentProblemCategory AS ServiceRequestProblemCategory,
  ServiceDocumentIsRejected AS ServiceRequestIsCanceled,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SoldToParty,
  ContactPerson AS ServiceRequestReporter,
  _Item.ResponseProfile AS ResponseProfile,
  _Item.ServiceProfile AS ServiceProfile,
  SalesOrganizationOrgUnitID,
  ServiceOrganization,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
FROM I_ServiceDocumentEnhcd AS ServiceRequest
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _Item ON ServiceRequest = _Item.ServiceDocument AND _Item.ServiceDocumentItemObjectType = 'BUS2000140' AND _Item.ServiceObjectType = 'BUS2000223'  -- association [0..1]
LEFT OUTER JOIN A_ServiceRequestPersonResp AS _PersonResponsible ON ServiceRequest = _PersonResponsible.ServiceRequest  -- association [0..*]
LEFT OUTER JOIN A_ServiceRequestRefObject AS _ReferenceObject ON ServiceRequest = _ReferenceObject.ServiceRequest  -- association [0..*]
LEFT OUTER JOIN A_ServiceRequestText AS _Text ON ServiceRequest = _Text.ServiceRequest  -- association [0..*]
LEFT OUTER JOIN A_ServiceRequestDefect AS _Defect ON ServiceRequest = _Defect.ServiceRequest  -- association [0..*]
LEFT OUTER JOIN A_ServiceRequestReason AS _Reason ON ServiceRequest = _Reason.ServiceRequest  -- association [0..1]
LEFT OUTER JOIN A_ServiceRequestOrder AS _Order ON ServiceRequest = _Order.ServiceRequest  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON _Extension.ServiceCategory = 'BUS2000223' AND ServiceRequest = _Extension.ServiceOrder  -- association [0..1]
;