P_RealTimeMfgOrderToBePostdKPI

DDL: P_REALTIMEMFGORDERTOBEPOSTDKPI SQL: PRTMOTBPKPI Type: view COMPOSITE Package: ODATA_EBW_ORDER_INSPECTOR

Event-based Order KPI

P_RealTimeMfgOrderToBePostdKPI is a Composite CDS View that provides data about "Event-based Order KPI" in SAP S/4HANA. It reads from 2 data sources (I_Ledger, P_AggregatedToBePostKPI) and exposes 46 fields with key fields CompanyCode, Ledger, OrderID. Part of development package ODATA_EBW_ORDER_INSPECTOR.

2 data source(s) 46 fields

Data Sources (2)

SourceAliasJoin Type
I_Ledger ledger inner
P_AggregatedToBePostKPI P_AggregatedToBePostKPI from

Parameters (2)

NameTypeDefault
P_FiscalPeriodStartDate budat
P_FiscalPeriodEndDate budat

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRTMOTBPKPI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode item CompanyCode
KEY Ledger I_Ledger Ledger
KEY OrderID item OrderID
OrderDescription item OrderDescription
ControllingArea item ControllingArea
OrderType item OrderType
Plant item Plant
OrderCategory item OrderCategory
ProfitCenter item ProfitCenter
Material leadingOrderItem Material
LedgerName
SimulationStatus orderLog SimulationStatus
LogNumber orderLog LogNumber
LogHandle orderLog LogHandle
LogMessageText orderLog LogMessageText
EventBasedProdnCostWlLogType orderLog EventBasedProdnCostWlLogType
AmountInCompanyCodeCurrency item AmountInCompanyCodeCurrency
AmountInGlobalCurrency item AmountInGlobalCurrency
AmountInFreeDefinedCurrency1 item AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2 item AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3 item AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4 item AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5 item AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6 item AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7 item AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8 item AmountInFreeDefinedCurrency8
PeriodAmountInCompanyCodeCrcy item PeriodAmountInCompanyCodeCrcy
PeriodAmountInGlobalCurrency item PeriodAmountInGlobalCurrency
PeriodAmountInFreeDfndCrcy1 item PeriodAmountInFreeDfndCrcy1
PeriodAmountInFreeDfndCrcy2 item PeriodAmountInFreeDfndCrcy2
PeriodAmountInFreeDfndCrcy3 item PeriodAmountInFreeDfndCrcy3
PeriodAmountInFreeDfndCrcy4 item PeriodAmountInFreeDfndCrcy4
PeriodAmountInFreeDfndCrcy5 item PeriodAmountInFreeDfndCrcy5
PeriodAmountInFreeDfndCrcy6 item PeriodAmountInFreeDfndCrcy6
PeriodAmountInFreeDfndCrcy7 item PeriodAmountInFreeDfndCrcy7
PeriodAmountInFreeDfndCrcy8 item PeriodAmountInFreeDfndCrcy8
CompanyCodeCurrency item CompanyCodeCurrency
GlobalCurrency item GlobalCurrency
FreeDefinedCurrency1 item FreeDefinedCurrency1
FreeDefinedCurrency2 item FreeDefinedCurrency2
FreeDefinedCurrency3 item FreeDefinedCurrency3
FreeDefinedCurrency4 item FreeDefinedCurrency4
FreeDefinedCurrency5 item FreeDefinedCurrency5
FreeDefinedCurrency6 item FreeDefinedCurrency6
FreeDefinedCurrency7 item FreeDefinedCurrency7
FreeDefinedCurrency8 item FreeDefinedCurrency8 
@AbapCatalog.sqlViewName: 'PRTMOTBPKPI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Event-based Order KPI'

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey:true

define view P_RealTimeMfgOrderToBePostdKPI
  with parameters
    P_FiscalPeriodStartDate : budat,
    P_FiscalPeriodEndDate   : budat
  as select from           P_AggregatedToBePostKPI(
                                       P_FiscalPeriodStartDate: $parameters.P_FiscalPeriodStartDate,
                                       P_FiscalPeriodEndDate: $parameters.P_FiscalPeriodEndDate) as item
    inner join             I_Ledger                                              as ledger           on  item.Ledger            = ledger.Ledger
                                                                                                     and ledger.LedgerType      = ''
                                                                                                     and ledger.ReferenceLedger = ''
    left outer to one join I_ProductCostCtrlgOrderItem                           as leadingOrderItem on  leadingOrderItem.OrderItem = '0001'
                                                                                                     and leadingOrderItem.OrderID   = item.OrderID
    left outer to one join R_EvtBsdProdnCostError                                as orderLog         on  item.OrderID                         =  orderLog.OrderID
                                                                                                     and item.Ledger                          =  orderLog.Ledger
                                                                                                     and item.CompanyCode                     =  orderLog.CompanyCode
                                                                                                     and orderLog.BusinessTransactionCategory <> 'KZPR'
{
  key item.CompanyCode,
  key ledger.Ledger,
//      item.ControllingObject,

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

      leadingOrderItem.Material,
      ledger._Text[1: Language = $session.system_language].LedgerName,

      orderLog.SimulationStatus,

      orderLog.LogNumber,
      orderLog.LogHandle,
      orderLog.LogMessageText,
      //Severity,

      orderLog.EventBasedProdnCostWlLogType,

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

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

      item.CompanyCodeCurrency,
      item.GlobalCurrency,
      item.FreeDefinedCurrency1,
      item.FreeDefinedCurrency2,
      item.FreeDefinedCurrency3,
      item.FreeDefinedCurrency4,
      item.FreeDefinedCurrency5,
      item.FreeDefinedCurrency6,
      item.FreeDefinedCurrency7,
      item.FreeDefinedCurrency8
}


//@AbapCatalog.sqlViewName: 'PRTMOTBPKPI'

//@AbapCatalog.compiler.compareFilter: true

//@AccessControl.authorizationCheck: #NOT_REQUIRED

//@ClientHandling.algorithm: #SESSION_VARIABLE

////@EndUserText.label: 'Event-based Order KPI'

//@VDM.viewType: #COMPOSITE

//@VDM.private:true

//@ObjectModel.usageType.serviceQuality: #C

//@ObjectModel.usageType.sizeCategory: #XXL

//@ObjectModel.usageType.dataClass: #TRANSACTIONAL

//@AbapCatalog.preserveKey:true

//

//define view P_RealTimeMfgOrderToBePostdKPI

//  with parameters

//    P_FiscalPeriodStartDate : budat,

//    P_FiscalPeriodEndDate   : budat

//  as select from           P_ToBePostEventBasedEntries(

//                                       P_FiscalPeriodStartDate: $parameters.P_FiscalPeriodStartDate,

//                                       P_FiscalPeriodEndDate: $parameters.P_FiscalPeriodEndDate) as item

//    inner join             I_Ledger                                              as ledger           on  item.Ledger            = ledger.Ledger

//                                                                                                     and ledger.LedgerType      = ''

//                                                                                                     and ledger.ReferenceLedger = ''

//    left outer to one join I_ProductCostCtrlgOrderItem                           as leadingOrderItem on  leadingOrderItem.OrderItem = '0001'

//                                                                                                     and leadingOrderItem.OrderID   = item.OrderID

//    left outer to one join R_EvtBsdProdnCostError                                as orderLog         on  item.OrderID                         =  orderLog.OrderID

//                                                                                                     and item.Ledger                          =  orderLog.Ledger

//                                                                                                     and item.CompanyCode                     =  orderLog.CompanyCode

//                                                                                                     and orderLog.BusinessTransactionCategory <> 'KZPR'

//{

//  key item.CompanyCode,

//  key ledger.Ledger,

//  key item.AccountingDocument,

//  key item.LedgerGLLineItem,

//  key item.FiscalYear,

//      item.ControllingObject,

//      item.ReferenceDocumentType,

//      item.ReferenceDocumentContext,

//      item.ReferenceDocument,

//      item.OrderID,

//      item.OrderItem,

//      item.OrderDescription,

//      item.ControllingArea,

//      item.OrderType,

//      item.Plant,

//      item.OrderCategory,

//      item.ProfitCenter,

//      item.StatusCode,

//      leadingOrderItem.Material,

//      ledger._Text[1: Language = $session.system_language].LedgerName,

//

//      orderLog.SimulationStatus,

//

//      orderLog.LogNumber,

//      orderLog.LogHandle,

//      orderLog.LogMessageText,

//      //Severity,

//      orderLog.EventBasedProdnCostWlLogType,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      item.AmountInCompanyCodeCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

//      item.AmountInGlobalCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      item.AmountInFreeDefinedCurrency1,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      item.AmountInFreeDefinedCurrency2,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      item.AmountInFreeDefinedCurrency3,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      item.AmountInFreeDefinedCurrency4,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      item.AmountInFreeDefinedCurrency5,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      item.AmountInFreeDefinedCurrency6,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      item.AmountInFreeDefinedCurrency7,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      item.AmountInFreeDefinedCurrency8,

//

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

//      item.PeriodAmountInCompanyCodeCrcy,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

//      item.PeriodAmountInGlobalCurrency,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

//      item.PeriodAmountInFreeDfndCrcy1,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

//      item.PeriodAmountInFreeDfndCrcy2,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

//      item.PeriodAmountInFreeDfndCrcy3,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

//      item.PeriodAmountInFreeDfndCrcy4,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

//      item.PeriodAmountInFreeDfndCrcy5,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

//      item.PeriodAmountInFreeDfndCrcy6,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

//      item.PeriodAmountInFreeDfndCrcy7,

//      @DefaultAggregation: #SUM

//      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

//      item.PeriodAmountInFreeDfndCrcy8,

//

//      item.CompanyCodeCurrency,

//      item.GlobalCurrency,

//      item.FreeDefinedCurrency1,

//      item.FreeDefinedCurrency2,

//      item.FreeDefinedCurrency3,

//      item.FreeDefinedCurrency4,

//      item.FreeDefinedCurrency5,

//      item.FreeDefinedCurrency6,

//      item.FreeDefinedCurrency7,

//      item.FreeDefinedCurrency8

//}

//

Learn More