P_BusSolnOrderEntProjItmSitn

DDL: P_BUSSOLNORDERENTPROJITMSITN Type: view COMPOSITE
30 Fields 1 Data Sources 4 Associations

Solution Order Enterprise Project Item Situation

P_BusSolnOrderEntProjItmSitn is a Composite CDS View that provides data about "Solution Order Enterprise Project Item Situation" in SAP S/4HANA. It reads from 1 data source (I_BusSolnOrdItemRelationships) and exposes 30 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, BusSolnOrdRelatedItem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusSolnOrdItemRelationships SolutionOrderItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BusSolnOrdItmFUPEntProject FollowUpDocumentItem $projection.BusinessSolutionOrder = FollowUpDocumentItem.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = FollowUpDocumentItem.BusinessSolutionOrderItem and SolutionOrderItem.ServiceDocumentItemObjectType = 'BUS2000193'
[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 (11)

NameValueLevelField
AbapCatalog.sqlViewName PSOLOEPITMSITN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Solution Order Enterprise Project Item Situation view

Fields (30)

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
ProjectStartDate
ProjectEndDate
SuccessorProject FollowUpDocumentItem Project WBS Element
ProcessingStatus
ServiceDocSuccessorBusObjType
BusSolnOrderItemCharUUID RelatedItemDet ServiceDocumentItemCharUUID
BusSolnOrdReltdItmObjectType RelatedItemDet ServiceDocumentItemObjectType
LtstConfirmedDeliveryDateTime RelatedItemDet LtstConfirmedDeliveryDateTime
PlannedServiceEndDateTime RelatedItemDet PlannedServiceEndDateTime
SrvcDocApptEndDateTime _EntProjectEndDate SrvcDocApptStartDateTime
ServiceContrItemStartDateTime RelatedItemDet ServiceContrItemStartDateTime
dec15endasBusSolnOrdReltdItmRefDateTime
BusSolnOrdItemIsTargetItem I_BusSolnOrdItemRelationships BusSolnOrdItemIsTargetItem
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

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 P_BusSolnOrderEntProjItmSitn.
-- 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 P_BusSolnOrderEntProjItmSitn 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,
  SolutionOrderItem._EntProjectStartDate.SrvcDocApptStartDateTime AS ProjectStartDate,
  SolutionOrderItem._EntProjectEndDate.SrvcDocApptStartDateTime AS ProjectEndDate,
  FollowUpDocumentItem.Project AS SuccessorProject,
  FollowUpDocumentItem._EnterpriseProject.ProcessingStatus AS ProcessingStatus,
  cast('CPMPROJI' as abap.char(10)) AS ServiceDocSuccessorBusObjType,
  RelatedItemDet.ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  RelatedItemDet.ServiceDocumentItemObjectType AS BusSolnOrdReltdItmObjectType,
  RelatedItemDet.LtstConfirmedDeliveryDateTime AS LtstConfirmedDeliveryDateTime,
  RelatedItemDet.PlannedServiceEndDateTime AS PlannedServiceEndDateTime,
  _EntProjectEndDate.SrvcDocApptStartDateTime AS SrvcDocApptEndDateTime,
  RelatedItemDet.ServiceContrItemStartDateTime AS ServiceContrItemStartDateTime,
  case RelatedItemDet.ServiceDocumentItemObjectType when 'BUS2000131' then LtstConfirmedDeliveryDateTime when 'BUS2000140' then RelatedItemDet.PlannedServiceStartDateTime 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,
  SolutionOrderItem.BusSolnOrdItemIsTargetItem AS BusSolnOrdItemIsTargetItem,
  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
FROM I_BusSolnOrdItemRelationships AS SolutionOrderItem
LEFT OUTER JOIN I_BusSolnOrdItmFUPEntProject AS FollowUpDocumentItem ON BusinessSolutionOrder = FollowUpDocumentItem.BusinessSolutionOrder AND BusinessSolutionOrderItem = FollowUpDocumentItem.BusinessSolutionOrderItem AND SolutionOrderItem.ServiceDocumentItemObjectType = 'BUS2000193'  -- 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