I_BomChanges

DDL: I_BOMCHANGES SQL: IBOMCHANGES Type: view COMPOSITE

Bill Of Material Changes

I_BomChanges is a Composite CDS View that provides data about "Bill Of Material Changes" in SAP S/4HANA. It has 2 associations to related views.

14 fields

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChangeMasterStatusText StatusText $projection.ChangeNumberStatus = StatusText.ChangeNumberStatus and StatusText.Language = $session.system_language
[0..*] I_BOMChangeHistory _BOMChangeHistory $projection.BillOfMaterial = _BOMChangeHistory.BillOfMaterial and $projection.BillOfMaterialCategory = _BOMChangeHistory.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BOMChangeHistory.BillOfMaterialVariant and $projection.EngineeringChangeDocument = _BOMChangeHistory.EngineeringChangeDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBOMCHANGES view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill Of Material Changes view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY BillOfMaterial BillOfMaterial
KEY BillOfMaterialCategory BillOfMaterialCategory
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage
KEY BillOfMaterialVersion BillOfMaterialVersion
KEY EngineeringChangeDocument EngineeringChangeDocument
ChangeNumberStatus ChangeNumberStatus
ChangeNumberStatusText StatusText ChangeNumberStatusText
ChangeNumberCreationDate ChangeNumberCreationDate
ChangeNumberCreatedByUser ChangeNumberCreatedByUser
ValidityStartDate ChangeNumberValidFromDate
_BOMChangeHistory _BOMChangeHistory 
@AbapCatalog.sqlViewName: 'IBOMCHANGES'
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bill Of Material Changes'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #TRANSACTIONAL}
define view I_BomChanges
  as select distinct from P_Bomchanges as bomchanges
  
  association [0..1] to I_ChangeMasterStatusText as StatusText on $projection.ChangeNumberStatus = StatusText.ChangeNumberStatus
                                                               and StatusText.Language = $session.system_language
  association [0..*] to I_BOMChangeHistory as _BOMChangeHistory on  $projection.BillOfMaterial            = _BOMChangeHistory.BillOfMaterial
                                                                and $projection.BillOfMaterialCategory    = _BOMChangeHistory.BillOfMaterialCategory
                                                                and $projection.BillOfMaterialVariant     = _BOMChangeHistory.BillOfMaterialVariant
                                                                and $projection.EngineeringChangeDocument = _BOMChangeHistory.EngineeringChangeDocument
{
  key Material,
  key Plant,
  key BillOfMaterial,
  key BillOfMaterialCategory,
  key BillOfMaterialVariant,
  key BillOfMaterialVariantUsage,
  key BillOfMaterialVersion,
  key EngineeringChangeDocument,
      ChangeNumberStatus,
      StatusText.ChangeNumberStatusText,
      ChangeNumberCreationDate,
      ChangeNumberCreatedByUser,
      ChangeNumberValidFromDate as ValidityStartDate,  
      _BOMChangeHistory
} 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMASTERSTATUSTEXT",
"P_BOMCHANGES"
],
"ASSOCIATED":
[
"I_BOMCHANGEHISTORY",
"I_CHANGEMASTERSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More