P_BusSolnOrdItmWithHdrStat

DDL: P_BUSSOLNORDITMWITHHDRSTAT SQL: PBSORDITMWTHSTAT Type: view COMPOSITE

P_BusSolnOrdItmWithHdrStat is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 6 fields with key fields ServiceObjectType, BusinessSolutionOrder.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PBSORDITMWTHSTAT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
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 _ServiceDocument ServiceDocumentIsOpen
ServiceDocumentIsReleased _ServiceDocument ServiceDocumentIsReleased
_ServiceDocumentIsOpen _ServiceDocument _ServiceDocumentIsOpen 
@AbapCatalog.sqlViewName: 'PBSORDITMWTHSTAT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM: {
   private:true,
   viewType: #COMPOSITE
}

@AccessControl: {
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XXL
   }
}
define view 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'
      _ServiceDocument.ServiceDocumentIsOpen,
      _ServiceDocument.ServiceDocumentIsReleased,
      
      _ServiceDocument._ServiceDocumentIsOpen
      

}
where
  ServiceObjectType = 'BUS2000172'
group by
  ServiceObjectType,
  ServiceDocument,
  _ServiceDocument.ServiceDocumentIsOpen,
  _ServiceDocument.ServiceDocumentIsReleased
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTITEMENHCD"
],
"ASSOCIATED":
[
"I_SERVICEDOCOPENSTATUS"
],
"BASE":
[
"I_SERVICEDOCUMENTENHCD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More