I_ChgImpactOrderDets

DDL: I_CHGIMPACTORDERDETS SQL: ICHGIMPORDDET Type: view COMPOSITE

Production Order Details

I_ChgImpactOrderDets is a Composite CDS View that provides data about "Production Order Details" in SAP S/4HANA. It reads from 3 data sources (I_ChgImpactOrderStatus, P_ChgImpactStatusCodes, I_MfgOrder) and exposes 14 fields with key fields ManufacturingOrder, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVariantUsage, BillOfMaterialVersion. It has 1 association to related views.

3 data source(s) 14 fields

Data Sources (3)

SourceAliasJoin Type
I_ChgImpactOrderStatus ChgImpactOrderStatus inner
P_ChgImpactStatusCodes ChgImpactStatusCodes left_outer
I_MfgOrder MfgOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_StatusCodeText _StatusCodeText $projection.StatusCode = _StatusCodeText.StatusCode and _StatusCodeText.Language = $session.system_language

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPORDDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Production Order Details view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_MfgOrder ManufacturingOrder
KEY BillOfMaterial I_MfgOrder BillOfMaterial
KEY BillOfMaterialVariant I_MfgOrder BillOfMaterialVariant
KEY BillOfMaterialVariantUsage I_MfgOrder BillOfMaterialVariantUsage
KEY BillOfMaterialVersion I_MfgOrder BillOfMaterialVersion
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
BillOfMaterialCategory I_MfgOrder BillOfMaterialCategory
MfgOrderScheduledStartDate I_MfgOrder MfgOrderScheduledStartDate
MfgOrderScheduledEndDate I_MfgOrder MfgOrderScheduledEndDate
ProductionPlant I_MfgOrder ProductionPlant
StatusCode P_ChgImpactStatusCodes StatusCode
StatusName _StatusCodeText StatusName
_StatusCodeText _StatusCodeText 
@AbapCatalog.sqlViewName: 'ICHGIMPORDDET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Production Order Details'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
define view I_ChgImpactOrderDets

  as select from    I_MfgOrder             as MfgOrder
    inner join      I_ChgImpactOrderStatus as ChgImpactOrderStatus on ChgImpactOrderStatus.ManufacturingOrder = MfgOrder.ManufacturingOrder
    left outer join P_ChgImpactStatusCodes as ChgImpactStatusCodes on MfgOrder.ManufacturingOrder = ChgImpactStatusCodes.ManufacturingOrder

  association [0..*] to I_StatusCodeText as _StatusCodeText on  $projection.StatusCode   = _StatusCodeText.StatusCode
                                                            and _StatusCodeText.Language = $session.system_language

{
  key MfgOrder.ManufacturingOrder,
  key MfgOrder.BillOfMaterial,
  key MfgOrder.BillOfMaterialVariant,
  key MfgOrder.BillOfMaterialVariantUsage,
  key MfgOrder.BillOfMaterialVersion,
      MfgOrder.ManufacturingOrderCategory,
      ManufacturingOrderType,
      MfgOrder.BillOfMaterialCategory,
      MfgOrder.MfgOrderScheduledStartDate,
      MfgOrder.MfgOrderScheduledEndDate,
      MfgOrder.ProductionPlant,
      ChgImpactStatusCodes.StatusCode as StatusCode,
      _StatusCodeText.StatusName      as StatusName,
      _StatusCodeText
      //_ChgImpactStatusCodes

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGIMPACTORDERSTATUS",
"I_MFGORDER",
"I_STATUSCODETEXT",
"P_CHGIMPACTSTATUSCODES"
],
"ASSOCIATED":
[
"I_STATUSCODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More