A_ProcessOrderStatus_2

DDL: A_PROCESSORDERSTATUS_2 Type: view_entity COMPOSITE Package: ODATA_PP_API_PROCORDER_2

Process Order Status

A_ProcessOrderStatus_2 is a Composite CDS View that provides data about "Process Order Status" in SAP S/4HANA. It reads from 1 data source (P_APIOrderStatus) and exposes 4 fields with key fields ManufacturingOrder, StatusCode. It has 1 association to related views. Part of development package ODATA_PP_API_PROCORDER_2.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_APIOrderStatus _Status from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_ProcessOrder _ProcessOrder $projection.ManufacturingOrder = _ProcessOrder.ProcessOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Order Status view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder
KEY StatusCode P_APIOrderStatus StatusCode
IsUserStatus
_ProcessOrder _ProcessOrder 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Process Order Status'
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view entity A_ProcessOrderStatus_2   
 as select from P_APIOrderStatus as _Status

  association [1..1] to A_ProcessOrder             as _ProcessOrder   on  $projection.ManufacturingOrder = _ProcessOrder.ProcessOrder
  {
      // Key

  @ObjectModel.sapObjectNodeTypeReference: 'ProductionOrder'
  key cast(_Status.ManufacturingOrder      as co_bid preserving type) as ManufacturingOrder,     
  key _Status.StatusCode,
      // Status  

      cast (case when _Status.StatusCode like 'E%' then 'X' else '' end as vdm_j_isuserstatus) as IsUserStatus, 
      
      cast( case 
         when _UserStatusText.UserStatus is null then _Status.SystemStatusShortName else _UserStatusText.UserStatusShortName
         end as j_txt04 preserving type )          as StatusShortName,                                                     
         
      cast(case 
        when _UserStatusText.UserStatus is null then _Status.SystemStatusName else _UserStatusText.UserStatusName        
        end as j_txt30 preserving type )           as StatusName,                                                                                                        
        _ProcessOrder
                
} 
where 
// _Status.StatusIsHidden = '' and 

 _Status.ManufacturingOrderCategory = '40'

Learn More