P_CHGIMPACTSTATUSCODES

CDS View

Change Impact Order ID for Status

P_CHGIMPACTSTATUSCODES is a CDS View in S/4HANA. Change Impact Order ID for Status. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgImpactOrderDets view left_outer COMPOSITE Production Order Details
I_ChgImpactRoutingProdnOrd view left_outer COMPOSITE Production Orders for Routings

Fields (1)

KeyField CDS FieldsUsed in Views
StatusCode StatusCode 2 
@AbapCatalog.sqlViewName: 'PPCHIMPSTATCOD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_ChgImpactStatusCodes 
as select from I_MfgOrder as MfgOrder
 inner join I_ChgImpactOrderStatus as ChgImpactOrderStatus on ChgImpactOrderStatus.ManufacturingOrder = MfgOrder.ManufacturingOrder
 //inner join P_ChgImpactOrderStatus as ChgImOrderStatus on ChgImOrderStatus.ManufacturingOrder = ChgImpactOrderStatus.ManufacturingOrder

 association [0..*] to I_MaterialBOM as _MaterialBOM  on MfgOrder.BillOfMaterial = _MaterialBOM.BillOfMaterial
                                                     and MfgOrder.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant
                                                     and MfgOrder.BillOfMaterialVariantUsage = _MaterialBOM.BillOfMaterialVariantUsage
                                                     and MfgOrder.BillOfMaterialVersion = _MaterialBOM.BillOfMaterialVersion



{
 key MfgOrder.ManufacturingOrder,
 key BillOfMaterial,
  key BillOfMaterialVariant,
  key BillOfMaterialVariantUsage,
  key BillOfMaterialVersion,
  //_MaterialBOM.BillOfMaterialHeaderUUID as MfgBillOfMaterialHeaderUUID,

  MfgOrderScheduledStartDate,
  MfgOrderScheduledEndDate,
  ProductionPlant,
  BillOfMaterialCategory,  
cast( case ChgImpactOrderStatus.OrderIsDeleted
         when 'X' then 'I0013'
         else case ChgImpactOrderStatus.OrderIsClosed
              when 'X' then 'I0046'
              else case ChgImpactOrderStatus.OrderIsTechnicallyCompleted
              when 'X' then 'I0045'
              else case ChgImpactOrderStatus.OrderIsLocked
              when 'X' then  'I0043'
              else case ChgImpactOrderStatus.OrderIsDelivered
              when 'X' then 'I0012'
              else case ChgImpactOrderStatus.OrderIsPartiallyDelivered
              when 'X' then 'I0074'
              else case ChgImpactOrderStatus.OrderIsConfirmed
              when 'X' then 'I0009'
              else case ChgImpactOrderStatus.OrderIsPartiallyConfirmed
              when 'X' then 'I0010'
              else case MfgOrder.MfgOrderIsToBeDeleted
              when 'X' then 'I0076'
              else case ChgImpactOrderStatus.OrderIsReleased
              when 'X' then 'I0002'
              else case ChgImpactOrderStatus.OrderIsPartiallyReleased
              when 'X' then 'I0042'
              else case ChgImpactOrderStatus.OrderIsCreated
              when 'X' then 'I0001'
              else ''
              end end end end end end end end end end  end  end as j_status) as StatusCode,  
  
  
  
   _MaterialBOM 
}

Learn More