P_APIORDERSTATUS

CDS View

Production Order Status

P_APIORDERSTATUS is a CDS View in S/4HANA. Production Order Status. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_ProcessOrderStatus_2 view_entity from COMPOSITE Process Order Status
A_ProductionOrderStatus_2 view_entity from COMPOSITE Production Order Status
I_ProductionOrderStatusJoule view_entity from COMPOSITE Production Order Status

Fields (1)

KeyField CDS FieldsUsed in Views
KEY StatusCode StatusCode 3 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #MIXED}
@VDM.private:true

define view entity P_APIOrderStatus   
as select from I_OrderBasic as _order
                                                      //Get Manufacturing Order

    inner join    I_StatusObjectStatusBasic  as _StatusBasic  on _order.ObjectInternalID   = _StatusBasic.StatusObject
                                                                   and _StatusBasic.StatusIsInactive = ''     
    left outer to one join I_SystemStatus             as _SystemStatus on _SystemStatus.SystemStatus = _StatusBasic.StatusCode
                                                      //Get system status short name and description

    association [1..1] to     I_SystemStatusText           as _SystemStatusText  on $projection.StatusCode = _SystemStatusText.SystemStatus
                                                                      and _SystemStatusText.Language = $session.system_language
                                                                        
                                                      //Get user status short name and description

   association [1..1] to     I_UserStatusText           as _UserStatusText  on $projection.statusprofile = _UserStatusText.StatusProfile
                                                                      and $projection.StatusCode    = _UserStatusText.UserStatus
                                                                      and _UserStatusText.Language    = $session.system_language
{
      // Key

  @ObjectModel.sapObjectNodeTypeReference: 'ProductionOrder'
  key _order.OrderID     as ManufacturingOrder,     
  key _StatusBasic.StatusCode,
       _order.OrderCategory as ManufacturingOrderCategory,

       _order._StatusObject.StatusProfile,
//      case when _SystemStatus.StatusIsHidden is null then '' else _SystemStatus.StatusIsHidden end as StatusIsHidden, 

      _SystemStatusText.SystemStatusName,
      _SystemStatusText.SystemStatusShortName,
      // Status  

      _UserStatusText
                
} 
where 
  ( _SystemStatus.StatusIsHidden = '' or _SystemStatus.StatusIsHidden is null)

Learn More