C_BusSolnOrdItemRelationships

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 C_BusSolnOrdItemRelationships.
-- 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.
-- SQL view name: CSOLOITEMREL

CREATE VIEW C_BusSolnOrdItemRelationships AS
SELECT
  ItemRelationship.BusinessSolutionOrder AS BusinessSolutionOrder,
  ItemRelationship.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  ItemRelationship.BusSolnOrdRelatedItem AS BusSolnOrdRelatedItem,
  ItemRelationship.BusSolnOrdItemIsTargetItem AS BusSolnOrdItemIsTargetItem,
  RelatedItemDet.ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  RelatedItemDet.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  ItemRelationship._RelatedItemDet._ServiceDocItemStatus._ServiceDocumentStatusText[1: Language=$session.system_language].ServiceDocumentStatusName AS ServiceDocumentItemStatusName,
  _SrvcDocSystemStatus.SrvcMgmtObjectStatus AS SystemStatus,
  ItemRelationship.SrvcItemRelshpType AS SrvcItemRelshpType,
  RelatedItemDet.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
  RelatedItemDet.ServiceDocItemCategory AS BusSolnOrdItmCategory,
  ItemRelationship._RelatedItemDet._ServiceDocItemCategory._ServiceDocItemCategoryText[1: Language=$session.system_language].ServiceDocItemCategoryName AS ServiceDocItemCategoryName,
  RelatedItemDet.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  ItemRelationship.SalesOrganization AS SalesOrganization,
  ItemRelationship.DistributionChannel AS DistributionChannel,
  ItemRelationship.Division AS Division,
  ItemRelationship.SalesOffice AS SalesOffice,
  ItemRelationship.SalesGroup AS SalesGroup,
  ItemRelationship.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ItemRelationship.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ItemRelationship.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ItemRelationship.ServiceOrganization AS ServiceOrganization,
  ItemRelationship.ServiceDocumentType AS ServiceDocumentType,
  ItemRelationship.ResponsibleEmployee AS ResponsibleEmployee,
  ItemRelationship.ServiceObjectType AS ServiceObjectType,
  ItemRelationship._SalesOrganization AS _SalesOrganization,
  ItemRelationship._DistributionChannel AS _DistributionChannel,
  ItemRelationship._Division AS _Division,
  ItemRelationship._SalesOffice AS _SalesOffice,
  ItemRelationship._SalesGroup AS _SalesGroup,
  ItemRelationship._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  ItemRelationship._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  ItemRelationship._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  ItemRelationship._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
  ItemRelationship._ServiceDocumentType AS _ServiceDocumentType,
  ItemRelationship._RespEmployee AS _RespEmployee,
  ItemRelationship._ServiceObjType AS _ServiceObjType
FROM P_BusSolnOrdItemRelationships AS ItemRelationship
INNER JOIN I_ServiceDocumentItemEnhcd AS RelatedItemDet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SitnInstceIndicator AS SitnInstceIndicator ON BusSolnOrderItemCharUUID = SitnInstceIndicator.SitnInstceAnchorObjectKey AND SitnInstceIndicator.SitnDefAnchorObject = 'BusSolnOrderItemCharUUID'  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcDocSystemStatus ON RelatedItemDet.ServiceDocumentItemUUID = _SrvcDocSystemStatus.SrvcMgmtObjectUUID AND ( _SrvcDocSystemStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcDocSystemStatus.SrvcMgmtObjectStatus = 'I1003' OR _SrvcDocSystemStatus.SrvcMgmtObjectStatus = 'I1004' OR _SrvcDocSystemStatus.SrvcMgmtObjectStatus = 'I1005' ) AND _SrvcDocSystemStatus.SrvcMgmtObjectStatusIsInactive = ''  -- association [0..1]
;