P_ChgImpactNtwkOrderStatus

@AbapCatalog.sqlViewName: 'PCHINTWORDERSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@EndUserText.label: 'Network Order Status'

define view P_ChgImpactNtwkOrderStatus 
as select from aufk  as aufk
    inner join   I_StatusObjectStatus as jest on  jest.StatusObject     = aufk.objnr
                                              and jest.StatusIsInactive = '' 
                                                                                            
{
    // Technical Key

key aufk.aufnr  as NetworkOrder,
            
    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_STATUSOBJECTSTATUS",
"AUFK"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT",
"I_STATUSPROFILE"
],
"BASE":
[
"I_STATUSOBJECTSTATUS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/