P_COEVTBSDORDERKEYSTATUS

CDS View

Event Based Order Key Status

P_COEVTBSDORDERKEYSTATUS is a CDS View in S/4HANA. Event Based Order Key Status. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_RealTimeOrderCount view inner CONSUMPTION Event Based Order Real Time KPI Count
P_EBPC_Cost3 view_entity inner COMPOSITE Event-Based Order Cost 
@AbapCatalog.sqlViewName: 'PCOEBOKST'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ControllingObject'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_CoEvtBsdOrderKeyStatus
  as select from P_CoEvtBsdOrderMaxKeyStatus
{
  key ControllingObject,

      OrderID,
      OrderItem,

      //Orders with status 'Released' or 'Partially Released' or 'Confirmed'

      //but not 'Delivered' or 'Technically Completed' or 'Closed'

      //are considerred as 'OPEN'

      case StatusCode
          when 'I0002' then 'OPEN' //Released

          when 'I0042' then 'OPEN' //Partially Released

          when 'I0009' then 'OPEN' //Confirmed

          else 'CLSD'
      end as ControllingObjectStatus,

      StatusCode
}
where
  OrderID <> ''

Learn More