P_MfgProcgExecOrdMainStatus

DDL: P_MFGPROCGEXECORDMAINSTATUS SQL: PMPEORDSTATUS Type: view COMPOSITE

P_MfgProcgExecOrdMainStatus is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MfgOrderStatus) and exposes 5 fields with key field ManufacturingOrder. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderStatus stat from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_StatusObjectStatus _StatusObjectStatus $projection.StatusCode = _StatusObjectStatus.StatusCode and $projection.StatusObject = _StatusObjectStatus.StatusObject

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMPEORDSTATUS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_MfgOrderStatus ManufacturingOrder
StatusObject I_MfgOrderStatus ManufacturingObject
numc2asOrderMainStatus
OrderIsReleased I_MfgOrderStatus OrderIsReleased
_StatusObjectStatus _StatusObjectStatus 
@AbapCatalog.sqlViewName: 'PMPEORDSTATUS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// Used in P_MFGPROCGEXECORDMAINSTATUS2 to get status of order

define view P_MfgProcgExecOrdMainStatus
  as select from I_MfgOrderStatus as stat
  association [1..1] to I_StatusObjectStatus as _StatusObjectStatus on  $projection.StatusCode   = _StatusObjectStatus.StatusCode
                                                                    and $projection.StatusObject = _StatusObjectStatus.StatusObject

{
  key stat.ManufacturingOrder                                                               as ManufacturingOrder,
      stat.ManufacturingObject                                                              as StatusObject,
      cast( case OrderIsDeleted
         when 'X' then '12'
         else case OrderIsClosed
              when 'X' then '11'
              else case OrderIsTechnicallyCompleted
              when 'X' then '10'
              else case OrderIsLocked
              when 'X' then  '09'
              else case OrderIsDelivered
              when 'X' then '08'
              else case OrderIsPartiallyDelivered
              when 'X' then '07'
              else case OrderIsConfirmed
              when 'X' then '06'
              else case OrderIsPartiallyConfirmed
              when 'X' then '05'
              else case OrderIsMarkedForDeletion
              when 'X' then '04'
              else case OrderIsReleased
              when 'X' then '03'
              else case OrderIsPartiallyReleased
              when 'X' then '02'
              else case OrderIsCreated
              when 'X' then '01'
              else '00'
              end end end end end end end end end end  end  end as abap.numc(2))            as OrderMainStatus,
      cast( case OrderIsDeleted
         when 'X' then 'I0013'
         else case OrderIsClosed
              when 'X' then 'I0046'
              else case OrderIsTechnicallyCompleted
              when 'X' then 'I0045'
              else case OrderIsLocked
              when 'X' then  'I0043'
              else case OrderIsDelivered
              when 'X' then 'I0012'
              else case OrderIsPartiallyDelivered
              when 'X' then 'I0074'
              else case OrderIsConfirmed
              when 'X' then 'I0009'
              else case OrderIsPartiallyConfirmed
              when 'X' then 'I0010'
              else case OrderIsMarkedForDeletion
              when 'X' then 'I0076'
              else case OrderIsReleased
              when 'X' then 'I0002'
              else case OrderIsPartiallyReleased
              when 'X' then 'I0042'
              else case OrderIsCreated
              when 'X' then 'I0001'
              else ''
              end end end end end end end end end end  end  end as j_istat preserving type) as StatusCode,
//      case OrderIsDeleted

//         when 'X' then 1 --red

//         else case OrderIsClosed

//              when 'X' then 0

//              else case OrderIsTechnicallyCompleted

//              when 'X' then 0

//              else case OrderIsLocked

//              when 'X' then 3

//              else case OrderIsDelivered

//              when 'X' then 3

//              else case OrderIsPartiallyDelivered

//              when 'X' then 2

//              else case OrderIsConfirmed

//              when 'X' then 3

//              else case OrderIsPartiallyConfirmed

//              when 'X' then 2

//              else case OrderIsMarkedForDeletion

//              when 'X' then 1

//              else case OrderIsReleased

//              when 'X' then 0

//              else case OrderIsPartiallyReleased

//              when 'X' then 0

//              else case OrderIsCreated

//              when 'X' then 0

//              else 0

//              end end end end end end end end end end  end  end                             as OrderStatusCriticality,

      stat.OrderIsReleased,

      _StatusObjectStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERSTATUS"
],
"ASSOCIATED":
[
"I_STATUSOBJECTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More