R_ServiceOrderTemplateTP

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 R_ServiceOrderTemplateTP.
-- 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 R_ServiceOrderTemplateTP AS
SELECT
  ServiceDocument AS ServiceOrderTemplate,
  ServiceObjectType,
  ServiceDocumentType AS ServiceOrderTemplateType,
  ServiceDocumentUUID AS ServiceOrderTemplateUUID,
  ServiceDocumentDescription AS SrvcOrdTmplDescription,
  ServiceDocumentPriority,
  SrvcDocTmplValdtyStartDateTime,
  SrvcDocTmplValdtyEndDateTime,
  SalesGroupOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesOrganizationOrgUnitID,
  SalesGroup,
  SalesOffice,
  Division,
  DistributionChannel,
  SalesOrganization,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  EnterpriseServiceOrganization,
  ServiceDocumentTemplateType,
  SrvcDocTemplateSearchTermText,
  Language
FROM I_ServiceDocumentEnhcd
LEFT OUTER JOIN E_ServiceDocument AS _Extension ON ServiceObjectType = _Extension.ServiceCategory AND ServiceOrderTemplate = _Extension.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcOrdTmplStatus ON ServiceOrderTemplateUUID = _SrvcOrdTmplStatus.StatusObjectUUID AND ( _SrvcOrdTmplStatus.StatusCode = 'I1002' OR _SrvcOrdTmplStatus.StatusCode = 'I1003' OR _SrvcOrdTmplStatus.StatusCode = 'I1004' OR _SrvcOrdTmplStatus.StatusCode = 'I1005' ) AND _SrvcOrdTmplStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN R_ServiceOrderTemplateItemTP AS _ServiceOrderTemplateItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdTmplRefObjectTP AS _SrvcOrdTmplReferenceObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdTmplUserStatusTP AS _SrvcOrdTmplUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdTmplPartnerTP AS _SrvcOrdTmplPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdTmplLongTextTP AS _SrvcOrdTmplLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdTmplAppointmentTP AS _SrvcOrdTmplAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcOrdTmplDurationTP AS _SrvcOrdTmplDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
;