P_EBPCC_ORDERKEYSTATUS

CDS View

P_EBPCC_ORDERKEYSTATUS is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProdCostCollectorKeyStatus view from CONSUMPTION Event-Based Product Cost Collector Key Status 
@AbapCatalog.sqlViewName: 'PEBPCCORDKEYSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_EBPCC_OrderKeyStatus
  with parameters
    P_StatusObject : j_objnr
  as select from I_StatusObjectStatusBasic
{
  key StatusObject,
  key StatusCode,

      cast(
        case StatusCode
          when 'I0002' then 1
          when 'I0009' then 2
          when 'I0045' then 3
          when 'I0076' then 4
          else 0
        end
      as fco_ord_key_stat_sort_sequence ) as SortSequence
}
where
       StatusObject     = :P_StatusObject
  and(
       StatusCode       = 'I0002' // Released

    or StatusCode       = 'I0009' // Confirmed

    or StatusCode       = 'I0045' // Technicaly Completed

    or StatusCode       = 'I0076' // Deletion Flag

  )
  and  StatusIsInactive = ''

Learn More