P_OrderStatusBasic

@AbapCatalog.sqlViewName: 'PORDERSTSBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE   // technically a BASIC but due to view layering a COMPOSITE)

@VDM.private: true
// provides the non-aggregated status

// to be used in aggregation views such as P_OrderStatusAggr only


/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ]  } */
define view P_OrderStatusBasic
  as select from I_StatusObjectStatusBasic as jest
  
  association [0..1] to I_StatusCode as _OrderIsCreatedCode          on  _OrderIsCreatedCode.StatusCode    = 'I0001'
                                                                     and _OrderIsCreatedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsReleasedCode         on  _OrderIsReleasedCode.StatusCode    = 'I0002'
                                                                     and _OrderIsReleasedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderHasMatlShortageCode    on  _OrderHasMatlShortageCode.StatusCode    = 'I0004'
                                                                     and _OrderHasMatlShortageCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsPrintedCode          on  _OrderIsPrintedCode.StatusCode    = 'I0007'
                                                                     and _OrderIsPrintedCode.StatusProfile = ''                                                                     
  association [0..1] to I_StatusCode as _OrderIsPrtlyPrintedCode     on  _OrderIsPrtlyPrintedCode.StatusCode    = 'I0008'
                                                                     and _OrderIsPrtlyPrintedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsConfirmedCode        on  _OrderIsConfirmedCode.StatusCode    = 'I0009'
                                                                     and _OrderIsConfirmedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsPrtlyConfirmedCode   on  _OrderIsPrtlyConfirmedCode.StatusCode    = 'I0010'
                                                                     and _OrderIsPrtlyConfirmedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsDeliveredCode        on  _OrderIsDeliveredCode.StatusCode    = 'I0012'
                                                                     and _OrderIsDeliveredCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsDeletedCode          on  _OrderIsDeletedCode.StatusCode    = 'I0013'
                                                                     and _OrderIsDeletedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsProductCostedCode    on  _OrderIsProductCostedCode.StatusCode    = 'I0014'
                                                                     and _OrderIsProductCostedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsPreCostedCode        on  _OrderIsPreCostedCode.StatusCode    = 'I0016'
                                                                     and _OrderIsPreCostedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _SettlmtRuleIsCreatedCode    on  _SettlmtRuleIsCreatedCode.StatusCode    = 'I0028'
                                                                     and _SettlmtRuleIsCreatedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsPrtlyReleasedCode    on  _OrderIsPrtlyReleasedCode.StatusCode    = 'I0042'
                                                                     and _OrderIsPrtlyReleasedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsLockedCode           on  _OrderIsLockedCode.StatusCode    = 'I0043'
                                                                     and _OrderIsLockedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsTechlyCmpltdCode     on  _OrderIsTechlyCmpltdCode.StatusCode    = 'I0045'
                                                                     and _OrderIsTechlyCmpltdCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsClosedCode           on  _OrderIsClosedCode.StatusCode    = 'I0046'
                                                                     and _OrderIsClosedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsDistributionRlvtCode on  _OrderIsDistributionRlvtCode.StatusCode    = 'I0047'
                                                                     and _OrderIsDistributionRlvtCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsDistrdToMESCode      on  _OrderIsDistrdToMESCode.StatusCode    = 'I0048'
                                                                     and _OrderIsDistrdToMESCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderReleaseIsRejectedCode  on  _OrderReleaseIsRejectedCode.StatusCode    = 'I0055'
                                                                     and _OrderReleaseIsRejectedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsPrtlyDeliveredCode   on  _OrderIsPrtlyDeliveredCode.StatusCode    = 'I0074'
                                                                     and _OrderIsPrtlyDeliveredCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsMrkdForDeletionCode  on  _OrderIsMrkdForDeletionCode.StatusCode    = 'I0076'
                                                                     and _OrderIsMrkdForDeletionCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _SettlmtRuleIsCrtedMnllyCode on  _SettlmtRuleIsCrtedMnllyCode.StatusCode    = 'I0102'
                                                                     and _SettlmtRuleIsCrtedMnllyCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderHasCostCalcErrorCode   on  _OrderHasCostCalcErrorCode.StatusCode    = 'I0115'
                                                                     and _OrderHasCostCalcErrorCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsScheduledCode        on  _OrderIsScheduledCode.StatusCode    = 'I0117'
                                                                     and _OrderIsScheduledCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _DistributionToMESCmpltdCode on  _DistributionToMESCmpltdCode.StatusCode    = 'I0168'
                                                                     and _DistributionToMESCmpltdCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsDiscardedByMESCode   on  _OrderIsDiscardedByMESCode.StatusCode    = 'I0169'
                                                                     and _OrderIsDiscardedByMESCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsReleasedByMESCode    on  _OrderIsReleasedByMESCode.StatusCode    = 'I0172'
                                                                     and _OrderIsReleasedByMESCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderHasPostdGoodsMvtCode   on  _OrderHasPostdGoodsMvtCode.StatusCode    = 'I0321'
                                                                     and _OrderHasPostdGoodsMvtCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderHasGeneratedOpsCode    on  _OrderHasGeneratedOpsCode.StatusCode    = 'I0328'
                                                                     and _OrderHasGeneratedOpsCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsHandledInBatchesCode  on _OrderIsHandledInBatchesCode.StatusCode    = 'I0369'
                                                                     and _OrderIsHandledInBatchesCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _MatlAvailyIsNotCheckedCode  on  _MatlAvailyIsNotCheckedCode.StatusCode    = 'I0420'
                                                                     and _MatlAvailyIsNotCheckedCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderHasNoComponentsCode    on  _OrderHasNoComponentsCode.StatusCode    = 'I0485'
                                                                     and _OrderHasNoComponentsCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsShopFloorOrderCode   on  _OrderIsShopFloorOrderCode.StatusCode    = 'I0665'
                                                                     and _OrderIsShopFloorOrderCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderIsHandedOvrToProdnCode on  _OrderIsHandedOvrToProdnCode.StatusCode    = 'I0666'
                                                                     and _OrderIsHandedOvrToProdnCode.StatusProfile = ''
  association [0..1] to I_StatusCode as _OrderChangeIsRestrictedCode on  _OrderChangeIsRestrictedCode.StatusCode    = 'I0667'
                                                                     and _OrderChangeIsRestrictedCode.StatusProfile = ''
{
    // Key

key jest.StatusObject as ObjectInternalID,

    case jest.StatusCode
      when 'I0001' then 'X'
      else ''
    end as OrderIsCreated,

    case jest.StatusCode
      when 'I0002' then 'X'
      else ''
    end as OrderIsReleased,

    case jest.StatusCode
      when 'I0004' then 'X'
      else ''
    end as OrderHasMaterialShortage,

    case jest.StatusCode
      when 'I0007' then 'X'
      else ''
    end as OrderIsPrinted,

    case jest.StatusCode
      when 'I0008' then 'X'
      else ''
    end as OrderIsPartiallyPrinted,

    case jest.StatusCode
      when 'I0009' then 'X'
      else ''
    end as OrderIsConfirmed,

     case jest.StatusCode
      when 'I0010' then 'X'
      else ''
    end as OrderIsPartiallyConfirmed,
    
    case jest.StatusCode
      when 'I0012' then 'X'
      else ''
    end as OrderIsDelivered,
    
    case jest.StatusCode
      when 'I0013' then 'X'
      else ''
    end as OrderIsDeleted,

    case jest.StatusCode
      when 'I0014' then 'X'
      else ''
    end as OrderIsProductCosted,

    case jest.StatusCode
      when 'I0016' then 'X'
      else ''
    end as OrderIsPreCosted,
    
    case jest.StatusCode
      when 'I0028' then 'X'
      else ''
    end as SettlementRuleIsCreated,
    
    case jest.StatusCode
      when 'I0042' then 'X'
      else ''
    end as OrderIsPartiallyReleased,

    case jest.StatusCode
      when 'I0043' then 'X'
      else ''
    end as OrderIsLocked,

    case jest.StatusCode
      when 'I0045' then 'X'
      else ''
    end as OrderIsTechnicallyCompleted,

    case jest.StatusCode
      when 'I0046' then 'X'
      else ''
    end as OrderIsClosed,

    case jest.StatusCode
      when 'I0047' then 'X'
      else ''
    end as OrderIsDistributionRelevant,

    case jest.StatusCode
      when 'I0048' then 'X'
      else ''
    end as OrderIsDistributedToMES,

    case jest.StatusCode
      when 'I0055' then 'X'
      else ''
    end as OrderReleaseIsRejected,

    case jest.StatusCode
      when 'I0074' then 'X'
      else ''
    end as OrderIsPartiallyDelivered,

    case jest.StatusCode
      when 'I0076' then 'X'
      else ''
    end as OrderIsMarkedForDeletion,

    case jest.StatusCode
      when 'I0102' then 'X'
      else ''
    end as SettlementRuleIsCrtedManually,

    case jest.StatusCode
      when 'I0115' then 'X'
      else ''
    end as OrderHasCostCalculationError,
    
    case jest.StatusCode
      when 'I0117' then 'X'
      else ''
    end as OrderIsScheduled,

    case jest.StatusCode
      when 'I0168' then 'X'
      else ''
    end as DistributionToMESIsCompleted,
    
    case jest.StatusCode
      when 'I0169' then 'X'
      else ''
    end as OrderIsDiscardedByMES,

    case jest.StatusCode
      when 'I0172' then 'X'
      else ''
    end as OrderIsReleasedByMES,

    case jest.StatusCode
      when 'I0321' then 'X'
      else ''
    end as OrderHasPostedGoodsMovements,

    case jest.StatusCode
      when 'I0328' then 'X'
      else ''
    end as OrderHasGeneratedOperations,

    case jest.StatusCode
      when 'I0369' then 'X'
      else ''
    end as OrderIsToBeHandledInBatches,

    case jest.StatusCode
      when 'I0420' then 'X'
      else ''
    end as MaterialAvailyIsNotChecked,
    
    case jest.StatusCode
      when 'I0485' then 'X'
      else ''
    end as OrderHasNoMaterialComponents,
    
    case jest.StatusCode
      when 'I0665' then 'X'
      else ''
    end as OrderIsShopFloorOrder,
    
    case jest.StatusCode
      when 'I0666' then 'X'
      else ''
    end as OrderIsHandedOverToProduction,
    
    case jest.StatusCode
      when 'I0667' then 'X'
      else ''
    end as OrderChangeIsRestricted,
    
    // Associations

    _OrderIsCreatedCode,
    _OrderIsReleasedCode,
    _OrderHasMatlShortageCode,
    _OrderIsPrintedCode,
    _OrderIsPrtlyPrintedCode, 
    _OrderIsConfirmedCode, 
    _OrderIsPrtlyConfirmedCode,
    _OrderIsDeliveredCode, 
    _OrderIsDeletedCode,
    _OrderIsProductCostedCode,
    _OrderIsPreCostedCode,
    _SettlmtRuleIsCreatedCode,
    _OrderIsPrtlyReleasedCode,
    _OrderIsLockedCode,
    _OrderIsTechlyCmpltdCode,
    _OrderIsClosedCode,
    _OrderIsDistributionRlvtCode,
    _OrderIsDistrdToMESCode,
    _OrderReleaseIsRejectedCode,
    _OrderIsPrtlyDeliveredCode,
    _OrderIsMrkdForDeletionCode,
    _SettlmtRuleIsCrtedMnllyCode,
    _OrderHasCostCalcErrorCode,
    _OrderIsScheduledCode,
    _DistributionToMESCmpltdCode,
    _OrderIsDiscardedByMESCode,
    _OrderIsReleasedByMESCode,
    _OrderHasPostdGoodsMvtCode,
    _OrderHasGeneratedOpsCode,
    _OrderIsHandledInBatchesCode,
    _MatlAvailyIsNotCheckedCode,
    _OrderHasNoComponentsCode,
    _OrderIsShopFloorOrderCode,
    _OrderIsHandedOvrToProdnCode,
    _OrderChangeIsRestrictedCode
} 
where
  (    jest.StatusCode       = 'I0001'
    or jest.StatusCode       = 'I0002'
    or jest.StatusCode       = 'I0004'
    or jest.StatusCode       = 'I0007'
    or jest.StatusCode       = 'I0008'
    or jest.StatusCode       = 'I0009'
    or jest.StatusCode       = 'I0010'
    or jest.StatusCode       = 'I0012'
    or jest.StatusCode       = 'I0013'
    or jest.StatusCode       = 'I0014'
    or jest.StatusCode       = 'I0016'
    or jest.StatusCode       = 'I0028'
    or jest.StatusCode       = 'I0042'
    or jest.StatusCode       = 'I0043'
    or jest.StatusCode       = 'I0045'
    or jest.StatusCode       = 'I0046'
    or jest.StatusCode       = 'I0047'
    or jest.StatusCode       = 'I0048'
    or jest.StatusCode       = 'I0055'
    or jest.StatusCode       = 'I0074'
    or jest.StatusCode       = 'I0076'
    or jest.StatusCode       = 'I0102'
    or jest.StatusCode       = 'I0115'
    or jest.StatusCode       = 'I0117'
    or jest.StatusCode       = 'I0168'
    or jest.StatusCode       = 'I0169'
    or jest.StatusCode       = 'I0172'
    or jest.StatusCode       = 'I0321'
    or jest.StatusCode       = 'I0328'
    or jest.StatusCode       = 'I0369'
    or jest.StatusCode       = 'I0420'
    or jest.StatusCode       = 'I0485'
    or jest.StatusCode       = 'I0665'
    or jest.StatusCode       = 'I0666'
    or jest.StatusCode       = 'I0667' )
   and jest.StatusIsInactive = '' 
   and jest.StatusObject like 'OR%';