P_EngBOMAssgdToChgRecd

DDL: P_ENGBOMASSGDTOCHGRECD SQL: PENGBOMASSTOCR Type: view COMPOSITE

P_EngBOMAssgdToChgRecd is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ChgRecdRefEBOM, I_MaterialBOM) and exposes 12 fields with key field ChangeRecordReferenceUUID. It has 1 association to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_ChgRecdRefEBOM EngBOMAssigned from
I_MaterialBOM MaterialBOM inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_PlngScpAssgdToChgRecd _PlngScpAssgd $projection.ChangeRecordUUID = _PlngScpAssgd.ChangeRecordUUID

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PENGBOMASSTOCR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefEBOM ChangeRecordReferenceUUID
ChangeRecord I_ChgRecdRefEBOM ChangeRecord
ChangeRecordUUID I_ChgRecdRefEBOM ChangeRecordUUID
Material I_MaterialBOM Material
Plant I_MaterialBOM Plant
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage
BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory
BillOfMaterial I_MaterialBOM BillOfMaterial
BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion
_PlngScpAssgd _PlngScpAssgd 
@AbapCatalog.sqlViewName: 'PENGBOMASSTOCR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_EngBOMAssgdToChgRecd
  as select from I_ChgRecdRefEBOM as EngBOMAssigned
    inner join   I_MaterialBOM    as MaterialBOM on  EngBOMAssigned.Plant                 = MaterialBOM.Plant
                                                 and EngBOMAssigned.BillOfMaterial        = MaterialBOM.BillOfMaterial
                                                 and EngBOMAssigned.BillOfMaterialVariant = MaterialBOM.BillOfMaterialVariant
                                                 and EngBOMAssigned.ChgRecRefInternalKey4 = MaterialBOM.BillOfMaterialVersion
  association [0..1] to P_PlngScpAssgdToChgRecd as _PlngScpAssgd on $projection.ChangeRecordUUID = _PlngScpAssgd.ChangeRecordUUID

{
  key EngBOMAssigned.ChangeRecordReferenceUUID,
      EngBOMAssigned.ChangeRecord,
      EngBOMAssigned.ChangeRecordUUID,

      // Material BOM Header Details for the respective ones

      MaterialBOM.Material,
      MaterialBOM.Plant,
      MaterialBOM.BillOfMaterialHeaderUUID,
      MaterialBOM.BillOfMaterialVariantUsage,
      MaterialBOM.BillOfMaterialCategory,
      MaterialBOM.BillOfMaterial,
      MaterialBOM.BillOfMaterialVariant,
      MaterialBOM.BillOfMaterialVersion,
      _PlngScpAssgd
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFEBOM",
"I_MATERIALBOM"
],
"ASSOCIATED":
[
"P_PLNGSCPASSGDTOCHGRECD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More