P_BusSolnOrdItmWithHdrStat

DDL: P_BUSSOLNORDITMWITHHDRSTAT Type: view_entity COMPOSITE Package: CRMS4_ANALYTICS_SOLUTION_ORDER

View to get status of solution order

P_BusSolnOrdItmWithHdrStat is a Composite CDS View that provides data about "View to get status of solution order" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 6 fields with key fields ServiceObjectType, BusinessSolutionOrder. Part of development package CRMS4_ANALYTICS_SOLUTION_ORDER.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType
KEY BusinessSolutionOrder ServiceDocument
BusinessSolutionOrderItem
ServiceDocumentIsOpen
ServiceDocumentIsReleased
_ServiceDocumentIsOpen _ServiceDocument _ServiceDocumentIsOpen 
@VDM: {
   private:true,
   viewType: #COMPOSITE
}

@AccessControl: {
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XXL
   }
}
define view entity P_BusSolnOrdItmWithHdrStat
  as select from I_ServiceDocumentItemEnhcd
{
  key ServiceObjectType,
  key ServiceDocument            as BusinessSolutionOrder,
      @ObjectModel.text.element: [ 'ServiceDocumentItemDescription']
      min( ServiceDocumentItem ) as BusinessSolutionOrderItem,

      @ObjectModel.foreignKey.association: '_ServiceDocumentIsOpen'
      I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceDocumentIsOpen,
      I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceDocumentIsReleased,
      
      _ServiceDocument._ServiceDocumentIsOpen
      

}
where
  ServiceObjectType = 'BUS2000172'
group by
  ServiceObjectType,
  ServiceDocument,
  I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceDocumentIsOpen,
  I_ServiceDocumentItemEnhcd._ServiceDocument.ServiceDocumentIsReleased

Learn More