P_AGGREGATEDTOBEPOSTKPI

CDS View

Aggregated to be post KPI

P_AGGREGATEDTOBEPOSTKPI is a CDS View in S/4HANA. Aggregated to be post KPI. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RealTimeMfgOrderToBePostdKPI view from COMPOSITE Event-based Order KPI 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Aggregated to be post KPI'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_AggregatedToBePostKPI
with parameters
    P_FiscalPeriodStartDate : budat,
    P_FiscalPeriodEndDate   : budat
    as select from P_ToBePostEventBasedEntries(
                      P_FiscalPeriodStartDate: $parameters.P_FiscalPeriodStartDate,
                      P_FiscalPeriodEndDate: $parameters.P_FiscalPeriodEndDate)
{
  key CompanyCode,
  key Ledger,
//      ControllingObject,

  key OrderID,
      OrderDescription,
      ControllingArea,
      OrderType,
      Plant,
      OrderCategory,
      ProfitCenter,
     // StatusCode,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      sum(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      sum(AmountInGlobalCurrency) as AmountInGlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      sum(AmountInFreeDefinedCurrency1) as AmountInFreeDefinedCurrency1,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      sum(AmountInFreeDefinedCurrency2) as AmountInFreeDefinedCurrency2,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      sum(AmountInFreeDefinedCurrency3) as AmountInFreeDefinedCurrency3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      sum(AmountInFreeDefinedCurrency4) as AmountInFreeDefinedCurrency4,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      sum(AmountInFreeDefinedCurrency5) as AmountInFreeDefinedCurrency5,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      sum(AmountInFreeDefinedCurrency6) as AmountInFreeDefinedCurrency6,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      sum(AmountInFreeDefinedCurrency7) as AmountInFreeDefinedCurrency7,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      sum(AmountInFreeDefinedCurrency8) as AmountInFreeDefinedCurrency8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      sum(PeriodAmountInCompanyCodeCrcy) as PeriodAmountInCompanyCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      sum(PeriodAmountInGlobalCurrency) as PeriodAmountInGlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      sum(PeriodAmountInFreeDfndCrcy1) as PeriodAmountInFreeDfndCrcy1,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      sum(PeriodAmountInFreeDfndCrcy2) as PeriodAmountInFreeDfndCrcy2,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      sum(PeriodAmountInFreeDfndCrcy3) as PeriodAmountInFreeDfndCrcy3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      sum(PeriodAmountInFreeDfndCrcy4) as PeriodAmountInFreeDfndCrcy4,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      sum(PeriodAmountInFreeDfndCrcy5) as PeriodAmountInFreeDfndCrcy5,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      sum(PeriodAmountInFreeDfndCrcy6) as PeriodAmountInFreeDfndCrcy6,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      sum(PeriodAmountInFreeDfndCrcy7) as PeriodAmountInFreeDfndCrcy7,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      sum(PeriodAmountInFreeDfndCrcy8) as PeriodAmountInFreeDfndCrcy8,

      CompanyCodeCurrency,
      GlobalCurrency,
      FreeDefinedCurrency1,
      FreeDefinedCurrency2,
      FreeDefinedCurrency3,
      FreeDefinedCurrency4,
      FreeDefinedCurrency5,
      FreeDefinedCurrency6,
      FreeDefinedCurrency7,
      FreeDefinedCurrency8
}
group by
  CompanyCode,
  Ledger,
//  ControllingObject,

  OrderID,
  OrderDescription,
  ControllingArea,
  OrderType,
  Plant,
  OrderCategory,
  ProfitCenter,
  //StatusCode,

  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8

Learn More