I_ChgImpactMBOMAssg

DDL: I_CHGIMPACTMBOMASSG SQL: ICHGIMPCTMBOMASS Type: view COMPOSITE

Manufacturing BOM Assignment

I_ChgImpactMBOMAssg is a Composite CDS View that provides data about "Manufacturing BOM Assignment" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefMBOM) and exposes 8 fields with key fields ChgRecRefInternalKey1, ChgRecRefInternalKey2, ChgRecRefInternalKey3, ChgRecRefInternalKey4. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefMBOM ChgRecdRefMfgBOMBsc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MaterialBOM _MaterialBOM ChgRecdRefMfgBOMBsc.Plant = _MaterialBOM.Plant and ChgRecdRefMfgBOMBsc.BillOfMaterial = _MaterialBOM.BillOfMaterial and ChgRecdRefMfgBOMBsc.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant and ChgRecdRefMfgBOMBsc.ChgRecRefInternalKey4 = _MaterialBOM.BillOfMaterialVersion

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPCTMBOMASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Manufacturing BOM Assignment view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChgRecRefInternalKey1
KEY ChgRecRefInternalKey2
KEY ChgRecRefInternalKey3
KEY ChgRecRefInternalKey4
ChangeRecord ChangeRecord
BillOfMaterialHeaderUUID _MaterialBOM BillOfMaterialHeaderUUID
ChangeRecordUUID ChangeRecordUUID
_ChangeRecordBsc _ChangeRecordBsc 
@AbapCatalog.sqlViewName: 'ICHGIMPCTMBOMASS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Manufacturing BOM Assignment'
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
@VDM.viewType:#COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ChgImpactMBOMAssg as select from I_ChgRecdRefMBOM as ChgRecdRefMfgBOMBsc

association [1..1] to I_MaterialBOM as _MaterialBOM on ChgRecdRefMfgBOMBsc.Plant                  = _MaterialBOM.Plant
                                                    and ChgRecdRefMfgBOMBsc.BillOfMaterial        = _MaterialBOM.BillOfMaterial
                                                    and ChgRecdRefMfgBOMBsc.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant
                                                    and ChgRecdRefMfgBOMBsc.ChgRecRefInternalKey4 = _MaterialBOM.BillOfMaterialVersion

 {
  key cast(ChgRecRefInternalKey1 as stlty )
    as ChgRecRefInternalKey1,
    key cast(ChgRecRefInternalKey2 as stnum  )
    as ChgRecRefInternalKey2,
    key cast(ChgRecRefInternalKey3 as stalt )
    as ChgRecRefInternalKey3,
    key cast(ChgRecRefInternalKey4 as cs_versn )
    as ChgRecRefInternalKey4,
  ChangeRecord,
   _MaterialBOM.BillOfMaterialHeaderUUID ,
  ChangeRecordUUID,
  _ChangeRecordBsc
  
}

Learn More