P_BusinessSolnOrdItmFinData

DDL: P_BUSINESSSOLNORDITMFINDATA Type: view COMPOSITE

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

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
P_ServiceDocLinItmFinData P_ServiceDocLinItmFinData from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PBSORDITMFINDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem
CompanyCodeCurrency CompanyCodeCurrency
RevenueAmountInCompanyCodeCrcy
CostAmountInCompanyCodeCrcy
RecognizedMarginAmtInCCCrcy 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:{
sqlViewName: 'PBSORDITMFINDATA',
compiler.compareFilter: true,
preserveKey: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #XXL
   }
   }

@VDM: {
  viewType: #COMPOSITE,
  private:true
}
define view P_BusinessSolnOrdItmFinData as select from P_ServiceDocLinItmFinData {
  
  key     BusinessSolutionOrder,
  key     BusinessSolutionOrderItem,
  @Semantics.currencyCode:true
  CompanyCodeCurrency,
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  @DefaultAggregation: #SUM
  sum( RevenueAmountInCompanyCodeCrcy ) as RevenueAmountInCompanyCodeCrcy ,
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  @DefaultAggregation: #SUM
  sum( CostAmountInCompanyCodeCrcy ) as CostAmountInCompanyCodeCrcy,
  @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
  @DefaultAggregation: #SUM
  sum( RecognizedMarginAmtInCCCrcy ) as RecognizedMarginAmtInCCCrcy
  
}
group by BusinessSolutionOrder , BusinessSolutionOrderItem ,CompanyCodeCurrency
having BusinessSolutionOrder is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SERVICEDOCLINITMFINDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More