P_ChgImpactStatusCodes

DDL: P_CHGIMPACTSTATUSCODES SQL: PPCHIMPSTATCOD Type: view COMPOSITE Package: MPE_PLAN_CIMA

Change Impact Order ID for Status

P_ChgImpactStatusCodes is a Composite CDS View that provides data about "Change Impact Order ID for Status" in SAP S/4HANA. It reads from 2 data sources (I_ChgImpactOrderStatus, I_MfgOrder) and exposes 10 fields with key fields ManufacturingOrder, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVariantUsage, BillOfMaterialVersion. It has 1 association to related views. Part of development package MPE_PLAN_CIMA.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_ChgImpactOrderStatus ChgImpactOrderStatus inner
I_MfgOrder MfgOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialBOM _MaterialBOM MfgOrder.BillOfMaterial = _MaterialBOM.BillOfMaterial and MfgOrder.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant and MfgOrder.BillOfMaterialVariantUsage = _MaterialBOM.BillOfMaterialVariantUsage and MfgOrder.BillOfMaterialVersion = _MaterialBOM.BillOfMaterialVersion

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPCHIMPSTATCOD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_MfgOrder ManufacturingOrder
KEY BillOfMaterial BillOfMaterial
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage
KEY BillOfMaterialVersion BillOfMaterialVersion
MfgOrderScheduledStartDate MfgOrderScheduledStartDate
MfgOrderScheduledEndDate MfgOrderScheduledEndDate
ProductionPlant ProductionPlant
BillOfMaterialCategory BillOfMaterialCategory
_MaterialBOM _MaterialBOM 
@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