P_RealTimeMfgOrderStatus

DDL: P_REALTIMEMFGORDERSTATUS SQL: PRTMFORDSTAT Type: view COMPOSITE Package: ODATA_EBW_ORDER_INSPECTOR

CO PCC Object Max Status

P_RealTimeMfgOrderStatus is a Composite CDS View that provides data about "CO PCC Object Max Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatusBasic) and exposes 2 fields with key field ControllingObject. Part of development package ODATA_EBW_ORDER_INSPECTOR.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRTMFORDSTAT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ControllingObject view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject StatusObject
StatusCode 
@AbapCatalog.sqlViewName: 'PRTMFORDSTAT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ControllingObject'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
//@EndUserText.label: 'CO PCC Object Max Status'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view P_RealTimeMfgOrderStatus
  as select from I_StatusObjectStatusBasic
{
  key StatusObject as ControllingObject,

      case substring(StatusObject, 1, 2)
        when 'OR'
            then substring(StatusObject, 3, 12)
        when 'OP'
            then substring(StatusObject, 3, 12)
        else ''
      end          as OrderID,

      case substring(StatusObject, 1, 2)
        when 'OR'
            then '0000'
        when 'OP'
            then substring(StatusObject, 15, 4)
        else ''
      end          as OrderItem,

      max(StatusCode) as StatusCode
}
where
  (
       StatusCode       =  'I0002' //Released

    or StatusCode       =  'I0012' //Delivered

    or StatusCode       =  'I0045' //Technically Completed

    or StatusCode       =  'I0046'
    or StatusCode       =  'I0076'
  )
  and  StatusIsInactive =  ''
  //and  StatusCode       <> 'I0046' // CLSD = closed

  //and  StatusCode       <> 'I0076' // DLFL = deletion flag

group by
  StatusObject
  //StatusCode

Learn More