I_EngSnpshtRefEngBOM

DDL: I_ENGSNPSHTREFENGBOM SQL: IENGSNPREFEBOM Type: view COMPOSITE Package: VDM_MPE_PLAN_ENG_SNPSHT

Engineering Snapshot Reference Obj EBOM

I_EngSnpshtRefEngBOM is a Composite CDS View that provides data about "Engineering Snapshot Reference Obj EBOM" in SAP S/4HANA. It reads from 3 data sources (I_EngSnpshtHdr, I_EngSnpshtObjRef, I_MaterialBOM) and exposes 17 fields with key field EngSnapshotRefUUID. Part of development package VDM_MPE_PLAN_ENG_SNPSHT.

3 data source(s) 17 fields

Data Sources (3)

SourceAliasJoin Type
I_EngSnpshtHdr EngSnpshtHdr inner
I_EngSnpshtObjRef EngSnpshtObjRef from
I_MaterialBOM MaterialBOM inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPREFEBOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Engineering Snapshot Reference Obj EBOM view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID I_EngSnpshtObjRef EngSnapshotRefUUID
EngSnapshotUUID I_EngSnpshtObjRef EngSnapshotUUID
EngSnapshotID I_EngSnpshtHdr EngSnapshotID
EngSnpshtRevisionNumber I_EngSnpshtHdr EngSnpshtRevisionNumber
EngSnpshtRefType I_EngSnpshtObjRef EngSnpshtRefType
Material I_MaterialBOM Material
Plant I_MaterialBOM Plant
BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion
BOMVersionStatus I_MaterialBOM BOMVersionStatus
BillOfMaterialStatus I_MaterialBOM BillOfMaterialStatus
BillOfMaterial I_MaterialBOM BillOfMaterial
CreatedByUser I_EngSnpshtObjRef CreatedByUser
CreationDateTime I_EngSnpshtObjRef CreationDateTime
LastChangedByUser I_EngSnpshtObjRef LastChangedByUser
LastChangeDateTime I_EngSnpshtObjRef LastChangeDateTime 
@AbapCatalog.sqlViewName: 'IENGSNPREFEBOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
@EndUserText.label: 'Engineering Snapshot Reference Obj EBOM'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_EngSnpshtRefEngBOM
  as select from I_EngSnpshtObjRef as EngSnpshtObjRef
    inner join   I_EngSnpshtHdr    as EngSnpshtHdr on EngSnpshtObjRef.EngSnapshotUUID = EngSnpshtHdr.EngSnapshotUUID
    inner join   I_MaterialBOM     as MaterialBOM  on  EngSnpshtObjRef.EngSnpshtRefKey1 = MaterialBOM.Material
                                                   and EngSnpshtObjRef.EngSnpshtRefKey2 = MaterialBOM.Plant
                                                   and EngSnpshtObjRef.EngSnpshtRefKey3 = MaterialBOM.BillOfMaterialVariant
                                                   and EngSnpshtObjRef.EngSnpshtRefKey4 = MaterialBOM.BillOfMaterialVariantUsage
                                                   and EngSnpshtObjRef.EngSnpshtRefKey5 = MaterialBOM.BillOfMaterialVersion

{
  key EngSnpshtObjRef.EngSnapshotRefUUID,
      EngSnpshtObjRef.EngSnapshotUUID,
      EngSnpshtHdr.EngSnapshotID,
      EngSnpshtHdr.EngSnpshtRevisionNumber,
      EngSnpshtObjRef.EngSnpshtRefType,
      MaterialBOM.Material,
      MaterialBOM.Plant,
      MaterialBOM.BillOfMaterialVariant,
      MaterialBOM.BillOfMaterialVariantUsage,
      MaterialBOM.BillOfMaterialVersion,
      MaterialBOM.BOMVersionStatus,
      MaterialBOM.BillOfMaterialStatus,
      MaterialBOM.BillOfMaterial,
      @Semantics.user.createdBy: true
      EngSnpshtObjRef.CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      EngSnpshtObjRef.CreationDateTime,
      @Semantics.user.lastChangedBy: true
      EngSnpshtObjRef.LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      EngSnpshtObjRef.LastChangeDateTime
}
where
  EngSnpshtObjRef.EngSnpshtRefType = 'EBOM'

Learn More