P_ChgImpactOrderStatus

@AbapCatalog.sqlViewName: 'PCHIORDERSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_ChgImpactOrderStatus 
  as select from I_MfgOrderBasic      as aufk
    inner join   I_StatusObjectStatus as jest on  jest.StatusObject     = aufk.ObjectInternalID
                                              and jest.StatusIsInactive = '' 
{
    // Technical Key

key aufk.ManufacturingOrder,
    
    aufk.ManufacturingOrderCategory,
          
    // Status

    aufk.ObjectInternalID as ManufacturingObject,
    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 'I0007' then 'X'
      else ''
    end as OrderIsPrinted,
    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 '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 'I0048' then 'X'
      else ''
    end as OrderIsDistributedToMES,
    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 'I0117' then 'X'
      else ''
    end as OrderIsScheduled,
    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,
    
    StatusObject,
    StatusCode,
    StatusProfile,
    
    // Associations

    _StatusObject,
    _StatusCode,
    _StatusProfile
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERBASIC",
"I_STATUSOBJECTSTATUS"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTSTATUS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/