CRMS4_IU_I_USR

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 CRMS4_IU_I_USR.
-- 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 CRMS4_IU_I_USR AS
SELECT
  I_ServiceDocument.ServiceObjectType AS ServiceObjectType,
  I_ServiceDocument.ServiceDocument AS ServiceDocument,
  I_ServiceDocument.SoldToParty AS SoldToParty,
  I_ServiceDocument.ServiceDocumentDescription AS ServiceDocumentDescription,
  I_ServiceDocument.PostingDate AS PostingDate,
  I_ServiceDocument.ServiceDocumentPriority AS ServiceDocumentPriority,
  I_ServiceDocument.ServiceDocumentUUID AS ServiceDocumentUUID,
  I_ServiceDocument.ServiceDocumentStatus AS ServiceDocumentStatus,
  I_ServiceDocument.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  I_ServiceDocument.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  I_ServiceDocument.ServiceDocumentType AS ServiceDocumentType,
  I_ServiceDocument.ResponsibleEmployee AS ResponsibleEmployee,
  I_ServiceDocument.SalesOrganization AS SalesOrganization,
  I_ServiceDocument.DistributionChannel AS DistributionChannel,
  I_ServiceDocument.Division AS Division,
  I_ServiceDocument.SalesOffice AS SalesOffice,
  I_ServiceDocument.SalesGroup AS SalesGroup,
  I_ServiceDocument.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  I_ServiceDocument.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  I_ServiceDocument.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  I_ServiceDocument.ServiceOrganization AS ServiceOrganization,
  I_ServiceDocument.ServiceDocumentUrgency AS ServiceDocumentUrgency,
  I_ServiceDocument.ServiceDocumentImpact AS ServiceDocumentImpact,
  I_ServiceDocument.ServiceEscalationLevel AS ServiceEscalationLevel,
  I_ServiceDocument.ServiceDocumentProblemCategory AS ServiceDocumentProblemCategory,
  I_ServiceDocument.ServiceRisk AS ServiceRisk,
  UtilitiesServiceDocumentRef.Equipment AS Equipment,
  UtilitiesServiceDocumentRef.FunctionalLocation AS FunctionalLocation,
  UtilitiesServiceDocumentRef.ServiceReferenceObjectType AS ServiceReferenceObjectType,
  I_ServiceDocument.ServiceReasonCategory AS ServiceReasonCategory,
  I_ServiceDocument.ServiceDefectSchema AS ServiceDefectSchema,
  I_ServiceDocument.ServiceDefectCategory AS ServiceDefectCategory
FROM I_ServiceDocument
INNER JOIN crms4d_serv_h ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CRMS4_IU_I_USOREF AS UtilitiesServiceDocumentRef ON UtilitiesServiceDocumentRef.ServiceObjectType = ServiceObjectType AND UtilitiesServiceDocumentRef.ServiceDocument = ServiceDocument AND UtilitiesServiceDocumentRef.SrvcRefObjIsMainObject = 'X'  -- association [1..1]
;