I_EngSnpshtRefMfgBOM

DDL: I_ENGSNPSHTREFMFGBOM SQL: IENGSNPREFMBOM Type: view COMPOSITE

Engineering Snapshot Reference Obj MBOM

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

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 IENGSNPREFMBOM 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 MBOM 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
CreatedByUser I_EngSnpshtObjRef CreatedByUser
CreationDateTime I_EngSnpshtObjRef CreationDateTime
LastChangedByUser I_EngSnpshtObjRef LastChangedByUser
LastChangeDateTime I_EngSnpshtObjRef LastChangeDateTime 
@AbapCatalog.sqlViewName: 'IENGSNPREFMBOM'
@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 MBOM'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_EngSnpshtRefMfgBOM
  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,
      //using cast to delink the Conversion Routine "NUMCV" on BillOfMaterial

      cast( MaterialBOM.BillOfMaterial as cs_stlnr preserving type ) as 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 = 'MBOM'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGSNPSHTHDR",
"I_ENGSNPSHTOBJREF",
"I_MATERIALBOM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More