I_ChgImpactEBOMAssg

DDL: I_CHGIMPACTEBOMASSG SQL: ICHGIMPCTEBOMASS Type: view COMPOSITE

Engineering BOM Assignment

I_ChgImpactEBOMAssg is a Composite CDS View that provides data about "Engineering BOM Assignment" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefEBOM) and exposes 8 fields with key fields ChgRecRefInternalKey1, ChgRecRefInternalKey2, ChgRecRefInternalKey3, ChgRecRefInternalKey4.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefEBOM ChgRecdRefEngBOMBsc from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPCTEBOMASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Engineering 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
_ChangeRecord _ChangeRecord 
@AbapCatalog.sqlViewName: 'ICHGIMPCTEBOMASS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Engineering BOM Assignment'
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
@VDM.viewType:#COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ChgImpactEBOMAssg as select from I_ChgRecdRefEBOM as ChgRecdRefEngBOMBsc

 association[1..1] to I_MaterialBOM as _MaterialBOM on ChgRecdRefEngBOMBsc.Plant                 = _MaterialBOM.Plant
                                                   and ChgRecdRefEngBOMBsc.BillOfMaterial        = _MaterialBOM.BillOfMaterial
                                                   and ChgRecdRefEngBOMBsc.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant
                                                   and ChgRecdRefEngBOMBsc.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,
    _ChangeRecord
    
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFEBOM",
"I_MATERIALBOM"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC",
"I_MATERIALBOM"
],
"BASE":
[
"I_CHGRECDREFEBOM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More