I_SrvcMgmtKnowledgeObject

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 I_SrvcMgmtKnowledgeObject.
-- 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 I_SrvcMgmtKnowledgeObject AS
SELECT
  objtype_h AS ServiceObjectType,
  object_id AS KnowledgeArticle,
  category AS ServiceDocumentCategory,
  priority AS ServiceDocumentPriority,
  class AS BusinessActivityClass,
  valid_from AS SMKnwlObjValidityStartDateTime,
  valid_to AS SMKnwlObjValidityEndDateTime,
  header_guid AS SrvcMgmtKnowledgeObjectUUID,
  process_type AS SrvcMgmtKnwlObjType,
  posting_date AS SrvcMgmtKnwlObjPostingDate,
  description_h AS SrvcMgmtKnwlObjDescription,
  descr_language AS Language,
  template_type AS ServiceDocumentTemplateType,
  created_at_h AS SMKnwlObjCreationDateTime,
  created_by_h AS SMKnwlObjCreatedByUser,
  changed_at_h AS SMKnwlObjChangedDateTime,
  changed_by_h AS SMKnwlObjChangedByUser,
  dis_channel AS DistributionChannel,
  Division,
  sales_org AS SalesOrganizationOrgUnitID,
  sales_office AS SalesOfficeOrgUnitID,
  sales_group AS SalesGroupOrgUnitID,
  sales_org_resp AS ResponsibleSalesOrganization,
  service_org AS ServiceOrganization,
  service_org_resp AS ResponsibleServiceOrganization,
  person_resp AS RespEmployeeBusinessPartnerId,
  stat_lifecycle AS SrvcMgmtKnwlObjStatus,
  stat_released AS SrvcMgmtKnwlObjIsReleased,
  stat_cancelled AS SrvcMgmtKnwlObjIsRejected,
  stat_error AS SrvcMgmtKnwlObjHasError,
  stat_open AS SrvcMgmtKnwlObjIsOpen
FROM crms4d_knar_h
LEFT OUTER JOIN I_CustMgmtBusObjType AS _CustMgmtBusObjType ON ServiceObjectType = _CustMgmtBusObjType.BusinessObjectType  -- association [1..1]
LEFT OUTER JOIN I_BusinessActivityCategory AS _ActivityCategory ON ServiceDocumentCategory = _ActivityCategory.BusinessActivityCategory  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON SrvcMgmtKnwlObjType = _ServiceDocumentType.ServiceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentPriority AS _ServiceDocumentPriority ON ServiceDocumentPriority = _ServiceDocumentPriority.ServiceDocumentPriority  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOrganizationOrgUnit ON SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOfficeOrgUnit ON SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesGroupOrgUnit ON SalesGroupOrgUnitID = _SalesGroupOrgUnit.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ResponsibleSalesOrganization ON ResponsibleSalesOrganization = _ResponsibleSalesOrganization.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ServiceOrganization ON ServiceOrganization = _ServiceOrganization.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ResponsibleServiceOrg ON ResponsibleServiceOrganization = _ResponsibleServiceOrg.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _RespEmployeeBusinessPartnerId ON RespEmployeeBusinessPartnerId = _RespEmployeeBusinessPartnerId.BusinessPartner  -- association [0..1]
;