P_OrderStatusClosed

DDL: P_ORDERSTATUSCLOSED Type: view_entity COMPOSITE Package: ODATA_EAM_WORKORDER

Order Status Closed

P_OrderStatusClosed is a Composite CDS View that provides data about "Order Status Closed" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectActiveStatus) and exposes 1 field with key field StatusObject. Part of development package ODATA_EAM_WORKORDER.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectActiveStatus I_StatusObjectActiveStatus from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Order Status Closed view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Order Status Closed'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity P_OrderStatusClosed
  as select from I_StatusObjectActiveStatus
{

  key StatusObject,
      case when max( case when StatusCode = 'I0046' or StatusCode = 'I0076'
      then 1
      else 0 end ) > 0 then 'X' else '' end as OrderisClosed

}
group by
  StatusObject

Learn More