P_RealTimeMfgReleasedOrder

DDL: P_REALTIMEMFGRELEASEDORDER SQL: PRTMFGRLSDORD Type: view COMPOSITE Package: ODATA_EBW_ORDER_INSPECTOR

CO PCC Object Max Status

P_RealTimeMfgReleasedOrder 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.

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatusBasic I_StatusObjectStatusBasic from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PRTMFGRLSDORD 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 StatusCode
@AbapCatalog.sqlViewName: 'PRTMFGRLSDORD'
@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_RealTimeMfgReleasedOrder
  as select from I_StatusObjectStatusBasic
{
  key StatusObject as ControllingObject,

      StatusCode
}
where
  (
       StatusCode       = 'I0002' //Released

    or StatusCode       = 'I0045'
  )
  and  StatusIsInactive = ''