A_ProductionOrderStatus_2

DDL: A_PRODUCTIONORDERSTATUS_2 Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER_2

Production Order Status

A_ProductionOrderStatus_2 is a Composite CDS View that provides data about "Production 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_PRODORDER_2.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_APIOrderStatus _Status from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_ProductionOrder _ProductionOrder $projection.ManufacturingOrder = _ProductionOrder.ProductionOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Production 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
_ProductionOrder _ProductionOrder 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production 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_ProductionOrderStatus_2   
  as select from P_APIOrderStatus as _Status

  association [1..1] to A_ProductionOrder          as _ProductionOrder on  $projection.ManufacturingOrder = _ProductionOrder.ProductionOrder
                                                                                                          
{
      // Key

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

//      _StatusCodeText.IsUserStatus, 

      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,                                                              
        _ProductionOrder
                
} 
where 
//  _Status.StatusIsHidden = '' and

   _Status.ManufacturingOrderCategory = '10'

Learn More