P_EBPCC_OrderKeyStatus

DDL: P_EBPCC_ORDERKEYSTATUS SQL: PEBPCCORDKEYSTS Type: view COMPOSITE Package: ODATA_CO_EB_PROD_COST_CLTR_DET

EBPCC - Order Key Status

P_EBPCC_OrderKeyStatus is a Composite CDS View that provides data about "EBPCC - Order Key Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 2 fields with key fields StatusObject, StatusCode. Part of development package ODATA_CO_EB_PROD_COST_CLTR_DET.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Parameters (1)

NameTypeDefault
P_StatusObject j_objnr

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEBPCCORDKEYSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode StatusCode 
@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