A_ServiceOrderTemplate

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_ServiceOrderTemplate.
-- 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_ServiceOrderTemplate AS
SELECT
  ServiceDocument AS ServiceOrderTemplate,
  ServiceDocumentUUID AS ServiceOrderTemplateUUID,
  ServiceDocumentType AS ServiceOrderTemplateType,
  ServiceObjectType,
  ServiceDocumentDescription AS SrvcOrdTmplDescription,
  ServiceDocumentTemplateType,
  SrvcDocTemplateSearchTermText,
  Language,
  ServiceDocumentPriority,
  SrvcDocTmplValdtyStartDateTime,
  SrvcDocTmplValdtyEndDateTime,
  ServiceDocumentIsReleased AS SrvcOrdTmplIsReleased,
  ServiceObjectType AS ServiceOrderType,
  ServiceDocumentType,
  SalesOrganizationOrgUnitID,
  SalesOrganization,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  EnterpriseServiceOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup
FROM I_ServiceDocumentEnhcd AS ServiceOrderTemplate
LEFT OUTER JOIN A_ServiceOrderTemplateItem AS _Item ON ServiceOrderTemplate = _Item.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderTmplPersonResp AS _PersonResponsible ON ServiceOrderTemplate = _PersonResponsible.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderTmplRefObject AS _ReferenceObject ON ServiceOrderTemplate = _ReferenceObject.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN A_ServiceOrderTmplText AS _Text ON ServiceOrderTemplate = _Text.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON _Extension.ServiceCategory = 'BUS2000116' AND ServiceOrderTemplate = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN A_SrvcOrdTmplUserStatus AS _SrvcOrdTmplUserStatus ON ServiceOrderTemplate = _SrvcOrdTmplUserStatus.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdTmplPartner AS _Partner ON ServiceOrderTemplate = _Partner.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdTmplDuration AS _Duration ON ServiceOrderTemplate = _Duration.ServiceOrderTemplate  -- association [0..*]
LEFT OUTER JOIN A_SrvcOrdTmplAppointment AS _Appointment ON ServiceOrderTemplate = _Appointment.ServiceOrderTemplate  -- association [0..*]
;