C_RealTimeOrderCount

DDL: C_REALTIMEORDERCOUNT SQL: CEBORDRTCNT Type: view CONSUMPTION

Event Based Order Real Time KPI Count

C_RealTimeOrderCount is a Consumption CDS View that provides data about "Event Based Order Real Time KPI Count" in SAP S/4HANA. It reads from 4 data sources (I_UserSettingsForCompanyCode, I_UserSetGetParamForCtrlgArea, P_CoEvtBsdOrderKeyStatus, I_ProductCostCtrlgOrder) and exposes 7 fields with key field OrderID.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
I_UserSettingsForCompanyCode _CompCodeDefault left_outer
I_UserSetGetParamForCtrlgArea _CtrlAreaDefault inner
P_CoEvtBsdOrderKeyStatus _Status inner
I_ProductCostCtrlgOrder EvtBsdOrder from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CEBORDRTCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
EndUserText.label Event Based Order Real Time KPI Count view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_ProductCostCtrlgOrder OrderID
ControllingArea I_ProductCostCtrlgOrder ControllingArea
CompanyCode I_ProductCostCtrlgOrder CompanyCode
OrderCategory OrderCategory
OrderType OrderType
Plant Plant
ControllingObjectStatus 
@AbapCatalog.sqlViewName: 'CEBORDRTCNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType:  #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@EndUserText.label: 'Event Based Order Real Time KPI Count'
define view C_RealTimeOrderCount
  as select from    I_ProductCostCtrlgOrder       as EvtBsdOrder
    inner join      P_CoEvtBsdOrderKeyStatus      as _Status          on EvtBsdOrder.ObjectInternalID = _Status.ControllingObject
    inner join      I_UserSetGetParamForCtrlgArea as _CtrlAreaDefault on  EvtBsdOrder.ControllingArea   = _CtrlAreaDefault.ControllingArea
                                                                      and _CtrlAreaDefault.BusinessUser = $session.user
    left outer join I_UserSettingsForCompanyCode  as _CompCodeDefault on _CompCodeDefault.BusinessUser = $session.user

{
  key EvtBsdOrder.OrderID,

      EvtBsdOrder.ControllingArea,
      EvtBsdOrder.CompanyCode,
      OrderCategory,
      OrderType,
      Plant,

      // Order Status /////////////////////////////////////////////////

      cast( _Status.ControllingObjectStatus as fco_order_status) as ControllingObjectStatus
}
where
           EvtBsdOrder.OrderIsEventBasedPosting =  'X'
  and(
    (
           EvtBsdOrder.ActualReleasedDate       is not initial // filters Released Orders '10', '40' only

      and(
           EvtBsdOrder.OrderCategory            =  '10'
        or EvtBsdOrder.OrderCategory            =  '40'
      )
    )
    or     EvtBsdOrder.OrderCategory            =  '05' // ActualReleasedDate is not filled for Released Orders '05'

  )
  and(
    (
           _CompCodeDefault.CompanyCode         is not null
      and  _CompCodeDefault.CompanyCode         <> ''
      and  _CompCodeDefault.CompanyCode         =  EvtBsdOrder.CompanyCode
    )
    or     _CompCodeDefault.CompanyCode         is null
    or     _CompCodeDefault.CompanyCode         =  ''
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTCOSTCTRLGORDER",
"I_USERSETGETPARAMFORCTRLGAREA",
"I_USERSETTINGSFORCOMPANYCODE",
"P_COEVTBSDORDERKEYSTATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More