I_BusSolnOrderSrvcItmSitn

DDL: I_BUSSOLNORDERSRVCITMSITN Type: view COMPOSITE
45 Fields 2 Data Sources 4 Associations

Solution Order Service Item Situation

I_BusSolnOrderSrvcItmSitn is a Composite CDS View that provides data about "Solution Order Service Item Situation" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItemSuccssr_2, I_BusSolnOrdItemRelationships) and exposes 45 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, BusSolnOrdRelatedItem. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItemSuccssr_2 ServiceDocItemSuccessor inner
I_BusSolnOrdItemRelationships SolutionOrderItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocumentItemEnhcd _FollowUpDocumentItem ServiceDocItemSuccessor.ServiceDocItmSuccssrCharUUID is not null and _FollowUpDocumentItem.ServiceDocumentItemCharUUID = ServiceDocItemSuccessor.ServiceDocItmSuccssrCharUUID
[0..1] I_SrvcDocAppointment _EntProjectStartDate SolutionOrderItem.ServiceDocumentItemUUID = _EntProjectStartDate.SrvcMgmtObjectUUID and _EntProjectStartDate.SrvcDocAppointmentType = 'PROJSTART'
[0..1] I_SrvcDocAppointment _EntProjectEndDate SolutionOrderItem.ServiceDocumentItemUUID = _EntProjectEndDate.SrvcMgmtObjectUUID and _EntProjectEndDate.SrvcDocAppointmentType = 'PROJEND'
[0..1] I_ServiceDocumentItemEnhcd RelatedItemDet RelatedItemDet.ServiceDocument = SolutionOrderItem.BusinessSolutionOrder and RelatedItemDet.ServiceDocumentItem = SolutionOrderItem.BusSolnOrdRelatedItem and RelatedItemDet.ServiceObjectType = 'BUS2000172'

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISOLOSRVITMSITN view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
EndUserText.label Solution Order Service Item Situation view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder I_BusSolnOrdItemRelationships BusinessSolutionOrder Solution Order
KEY BusinessSolutionOrderItem I_BusSolnOrdItemRelationships BusinessSolutionOrderItem Solution Order Item
KEY BusSolnOrdRelatedItem I_BusSolnOrdItemRelationships BusSolnOrdRelatedItem
ServiceObjectType I_BusSolnOrdItemRelationships ServiceObjectType Object Type
ServiceDocumentItemCharUUID I_BusSolnOrdItemRelationships ServiceDocumentItemCharUUID
ServiceDocumentItemObjectType I_BusSolnOrdItemRelationships ServiceDocumentItemObjectType Object Type
ServiceDocItmSuccssrCharUUID I_ServiceDocumentItemSuccssr_2 ServiceDocItmSuccssrCharUUID
BusSolnOrderItemCharUUID RelatedItemDet ServiceDocumentItemCharUUID
BusSolnOrdReltdItmObjectType RelatedItemDet ServiceDocumentItemObjectType Object Type
ServiceDocumentItemUUID I_BusSolnOrdItemRelationships ServiceDocumentItemUUID
PlannedServiceStartDateTime I_BusSolnOrdItemRelationships PlannedServiceStartDateTime
PlannedServiceEndDateTime I_BusSolnOrdItemRelationships PlannedServiceEndDateTime
RequestedServiceStartDateTime I_BusSolnOrdItemRelationships RequestedServiceStartDateTime
RequestedServiceEndDateTime I_BusSolnOrdItemRelationships RequestedServiceEndDateTime
dec15endasBusSolnOrdReltdItmRefDateTime
LtstConfirmedDeliveryDateTime RelatedItemDet LtstConfirmedDeliveryDateTime
ServiceContrItemStartDateTime RelatedItemDet ServiceContrItemStartDateTime
SrvcDocApptEndDateTime _EntProjectEndDate SrvcDocApptEndDateTime
BusSolnOrdItemIsTargetItem I_BusSolnOrdItemRelationships BusSolnOrdItemIsTargetItem
ServiceDocumentItemStatus I_BusSolnOrdItemRelationships ServiceDocumentItemStatus
ResponsibleEmployee I_BusSolnOrdItemRelationships ResponsibleEmployee Employee Resp.
SalesOrganization I_BusSolnOrdItemRelationships SalesOrganization Sales Organization
SalesOffice I_BusSolnOrdItemRelationships SalesOffice Sales Office
SalesGroup I_BusSolnOrdItemRelationships SalesGroup Sales Group
DistributionChannel I_BusSolnOrdItemRelationships DistributionChannel RefDistCh-Cust/Mat.
Division I_BusSolnOrdItemRelationships Division Internal Division ID
ServiceDocumentType I_BusSolnOrdItemRelationships ServiceDocumentType Transaction Type
SalesOfficeOrgUnitID I_BusSolnOrdItemRelationships SalesOfficeOrgUnitID
SalesOrganizationOrgUnitID I_BusSolnOrdItemRelationships SalesOrganizationOrgUnitID
SalesGroupOrgUnitID I_BusSolnOrdItemRelationships SalesGroupOrgUnitID
ServiceOrganization I_BusSolnOrdItemRelationships ServiceOrganization
_SrvcDocItmLifecycleStatus I_BusSolnOrdItemRelationships _SrvcDocItmLifecycleStatus
_SalesOrganization I_BusSolnOrdItemRelationships _SalesOrganization
_DistributionChannel I_BusSolnOrdItemRelationships _DistributionChannel
_Division I_BusSolnOrdItemRelationships _Division
_SalesOffice I_BusSolnOrdItemRelationships _SalesOffice
_SalesGroup I_BusSolnOrdItemRelationships _SalesGroup
_SalesOfficeOrgUnit I_BusSolnOrdItemRelationships _SalesOfficeOrgUnit
_SalesOrganizationOrgUnit I_BusSolnOrdItemRelationships _SalesOrganizationOrgUnit
_SalesGroupOrgUnit I_BusSolnOrdItemRelationships _SalesGroupOrgUnit
_ServiceOrganizationOrgUnit I_BusSolnOrdItemRelationships _ServiceOrganizationOrgUnit
_ServiceDocumentType I_BusSolnOrdItemRelationships _ServiceDocumentType
_ServiceObjType I_BusSolnOrdItemRelationships _ServiceObjType
_RespEmployee I_BusSolnOrdItemRelationships _RespEmployee
_FollowUpDocumentItem _FollowUpDocumentItem

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_BusSolnOrderSrvcItmSitn.
-- 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_BusSolnOrderSrvcItmSitn AS
SELECT
  SolutionOrderItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  SolutionOrderItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  SolutionOrderItem.BusSolnOrdRelatedItem AS BusSolnOrdRelatedItem,
  SolutionOrderItem.ServiceObjectType AS ServiceObjectType,
  SolutionOrderItem.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
  SolutionOrderItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  ServiceDocItemSuccessor.ServiceDocItmSuccssrCharUUID AS ServiceDocItmSuccssrCharUUID,
  RelatedItemDet.ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  RelatedItemDet.ServiceDocumentItemObjectType AS BusSolnOrdReltdItmObjectType,
  SolutionOrderItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
  SolutionOrderItem.PlannedServiceStartDateTime AS PlannedServiceStartDateTime,
  SolutionOrderItem.PlannedServiceEndDateTime AS PlannedServiceEndDateTime,
  SolutionOrderItem.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  SolutionOrderItem.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  case RelatedItemDet.ServiceDocumentItemObjectType when 'BUS2000131' then RelatedItemDet.LtstConfirmedDeliveryDateTime when 'BUS2000140' then RelatedItemDet.PlannedServiceStartDateTime when 'BUS2000146' then RelatedItemDet.RequestedServiceStartDateTime when 'BUS2000159' then RelatedItemDet.RequestedServiceStartDateTime when 'BUS2000137' then RelatedItemDet.ServiceContrItemStartDateTime when 'BUS2000189' then RelatedItemDet.ServiceContrItemStartDateTime when 'BUS2000193' then _EntProjectStartDate.SrvcDocApptStartDateTime else cast(000000000000000 as abap.dec(15)) end as BusSolnOrdReltdItmRefDateTime AS dec15endasBusSolnOrdReltdItmRefDateTime,
  RelatedItemDet.LtstConfirmedDeliveryDateTime AS LtstConfirmedDeliveryDateTime,
  RelatedItemDet.ServiceContrItemStartDateTime AS ServiceContrItemStartDateTime,
  _EntProjectEndDate.SrvcDocApptEndDateTime AS SrvcDocApptEndDateTime,
  SolutionOrderItem.BusSolnOrdItemIsTargetItem AS BusSolnOrdItemIsTargetItem,
  SolutionOrderItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
  SolutionOrderItem.ResponsibleEmployee AS ResponsibleEmployee,
  SolutionOrderItem.SalesOrganization AS SalesOrganization,
  SolutionOrderItem.SalesOffice AS SalesOffice,
  SolutionOrderItem.SalesGroup AS SalesGroup,
  SolutionOrderItem.DistributionChannel AS DistributionChannel,
  SolutionOrderItem.Division AS Division,
  SolutionOrderItem.ServiceDocumentType AS ServiceDocumentType,
  SolutionOrderItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  SolutionOrderItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SolutionOrderItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  SolutionOrderItem.ServiceOrganization AS ServiceOrganization,
  SolutionOrderItem._SrvcDocItmLifecycleStatus AS _SrvcDocItmLifecycleStatus,
  SolutionOrderItem._SalesOrganization AS _SalesOrganization,
  SolutionOrderItem._DistributionChannel AS _DistributionChannel,
  SolutionOrderItem._Division AS _Division,
  SolutionOrderItem._SalesOffice AS _SalesOffice,
  SolutionOrderItem._SalesGroup AS _SalesGroup,
  SolutionOrderItem._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  SolutionOrderItem._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  SolutionOrderItem._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  SolutionOrderItem._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
  SolutionOrderItem._ServiceDocumentType AS _ServiceDocumentType,
  SolutionOrderItem._ServiceObjType AS _ServiceObjType,
  SolutionOrderItem._RespEmployee AS _RespEmployee
FROM I_BusSolnOrdItemRelationships AS SolutionOrderItem
INNER JOIN I_ServiceDocumentItemSuccssr_2 AS ServiceDocItemSuccessor ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _FollowUpDocumentItem ON ServiceDocItemSuccessor.ServiceDocItmSuccssrCharUUID is not null AND _FollowUpDocumentItem.ServiceDocumentItemCharUUID = ServiceDocItemSuccessor.ServiceDocItmSuccssrCharUUID  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocAppointment AS _EntProjectStartDate ON SolutionOrderItem.ServiceDocumentItemUUID = _EntProjectStartDate.SrvcMgmtObjectUUID AND _EntProjectStartDate.SrvcDocAppointmentType = 'PROJSTART'  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocAppointment AS _EntProjectEndDate ON SolutionOrderItem.ServiceDocumentItemUUID = _EntProjectEndDate.SrvcMgmtObjectUUID AND _EntProjectEndDate.SrvcDocAppointmentType = 'PROJEND'  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS RelatedItemDet ON RelatedItemDet.ServiceDocument = SolutionOrderItem.BusinessSolutionOrder AND RelatedItemDet.ServiceDocumentItem = SolutionOrderItem.BusSolnOrdRelatedItem AND RelatedItemDet.ServiceObjectType = 'BUS2000172'  -- association [0..1]
;

Learn More