I_BusSolnOrdFUPEntProject

DDL: I_BUSSOLNORDFUPENTPROJECT Type: view COMPOSITE

Follow up Enterprise Project

I_BusSolnOrdFUPEntProject is a Composite CDS View that provides data about "Follow up Enterprise Project" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentSuccessor) and exposes 8 fields with key fields ServiceDocumentRelationUUID, ServiceDocRltnSequenceNumber. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentSuccessor I_ServiceDocumentSuccessor from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocument _BusinessSolutionOrder _BusinessSolutionOrder.ServiceObjectType = 'BUS2000172' and _BusinessSolutionOrder.ServiceDocumentUUID = $projection.BusinessSolutionOrderUUID
[0..1] I_EnterpriseProject _EnterpriseProject _EnterpriseProject.ProjectUUID = $projection.ProjectUUID

Annotations (12)

NameValueLevelField
EndUserText.label Follow up Enterprise Project view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IBSOFUPENTPROJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentRelationUUID ServiceDocumentRelationUUID
KEY ServiceDocRltnSequenceNumber ServiceDocRltnSequenceNumber
BusinessSolutionOrderUUID ServiceDocumentUUID
BusinessSolutionOrder _BusinessSolutionOrder ServiceDocument
ProjectUUID ServiceDocumentSuccessorUUID
Project _EnterpriseProject Project
_BusinessSolutionOrder _BusinessSolutionOrder
_EnterpriseProject _EnterpriseProject 
@EndUserText.label: 'Follow up Enterprise Project'

@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog:{
  sqlViewName: 'IBSOFUPENTPROJ',
  compiler.compareFilter: true,
  preserveKey: true
}

@VDM:{
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

@AccessControl:{
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}

@Metadata.ignorePropagatedAnnotations: true

define view I_BusSolnOrdFUPEntProject as select from I_ServiceDocumentSuccessor
  association [0..1] to I_ServiceDocument   as _BusinessSolutionOrder on  _BusinessSolutionOrder.ServiceObjectType     = 'BUS2000172'
                                                                      and _BusinessSolutionOrder.ServiceDocumentUUID   = $projection.BusinessSolutionOrderUUID
  association [0..1] to I_EnterpriseProject as _EnterpriseProject     on  _EnterpriseProject.ProjectUUID = $projection.ProjectUUID
{
 
      key   ServiceDocumentRelationUUID,
      key   ServiceDocRltnSequenceNumber,
      
            ServiceDocumentUUID                     as BusinessSolutionOrderUUID,
            _BusinessSolutionOrder.ServiceDocument  as BusinessSolutionOrder,
            ServiceDocumentSuccessorUUID            as ProjectUUID,
            _EnterpriseProject.Project              as Project,
            
      _BusinessSolutionOrder,
      _EnterpriseProject
}
where
      ServiceObjectType             = 'BUS2000172'
  and ServiceDocSuccessorBusObjType = 'CPMPROJH';

Learn More