I_EngSnpshtHdrEBOM

DDL: I_ENGSNPSHTHDREBOM SQL: IENGSNPHDREBOM Type: view COMPOSITE

Engineering snapshot header EBOM

I_EngSnpshtHdrEBOM is a Composite CDS View that provides data about "Engineering snapshot header EBOM" in SAP S/4HANA. It reads from 2 data sources (I_EngSnpshtRefEngBOM, I_EngSnpshtHdr) and exposes 17 fields with key field EngSnapshotRefUUID.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_EngSnpshtRefEngBOM EngBom from
I_EngSnpshtHdr Snpshthdr inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPHDREBOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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
EndUserText.label Engineering snapshot header EBOM view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID I_EngSnpshtRefEngBOM EngSnapshotRefUUID
EngSnapshotUUID I_EngSnpshtRefEngBOM EngSnapshotUUID
EngSnapshotID I_EngSnpshtHdr EngSnapshotID
EngSnpshtRevisionNumber I_EngSnpshtHdr EngSnpshtRevisionNumber
Material I_EngSnpshtRefEngBOM Material
Plant I_EngSnpshtRefEngBOM Plant
BillOfMaterialVariant I_EngSnpshtRefEngBOM BillOfMaterialVariant
BillOfMaterialVariantUsage I_EngSnpshtRefEngBOM BillOfMaterialVariantUsage
BillOfMaterialVersion I_EngSnpshtRefEngBOM BillOfMaterialVersion
EngSnpshtAuxiliaryPrepSts I_EngSnpshtHdr EngSnpshtAuxiliaryPrepSts
BillOfMaterial I_EngSnpshtRefEngBOM BillOfMaterial
BOMVersionStatus I_EngSnpshtRefEngBOM BOMVersionStatus
BillOfMaterialStatus I_EngSnpshtRefEngBOM BillOfMaterialStatus
CreatedByUser I_EngSnpshtRefEngBOM CreatedByUser
CreationDateTime I_EngSnpshtRefEngBOM CreationDateTime
LastChangedByUser I_EngSnpshtRefEngBOM LastChangedByUser
LastChangeDateTime I_EngSnpshtRefEngBOM LastChangeDateTime 
@AbapCatalog.sqlViewName: 'IENGSNPHDREBOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Engineering snapshot header EBOM'
define view I_EngSnpshtHdrEBOM as select from I_EngSnpshtRefEngBOM as EngBom 
inner join I_EngSnpshtHdr as Snpshthdr on EngBom.EngSnapshotUUID = Snpshthdr.EngSnapshotUUID

{
   key EngBom.EngSnapshotRefUUID,
       EngBom.EngSnapshotUUID,
       Snpshthdr.EngSnapshotID,
       Snpshthdr.EngSnpshtRevisionNumber,
       EngBom.Material,
       EngBom.Plant,
       EngBom.BillOfMaterialVariant,
       EngBom.BillOfMaterialVariantUsage,
       EngBom.BillOfMaterialVersion,
       Snpshthdr.EngSnpshtAuxiliaryPrepSts,
       EngBom.BillOfMaterial,
       EngBom.BOMVersionStatus,
       EngBom.BillOfMaterialStatus,
       EngBom.CreatedByUser,
       EngBom.CreationDateTime,
       EngBom.LastChangedByUser,
       EngBom.LastChangeDateTime

    
} where (    EngBom.Material = Snpshthdr.Material 
          and EngBom.Plant    = Snpshthdr.Plant
          and EngBom.BillOfMaterialVariant = Snpshthdr.BillOfMaterialVariant 
          and EngBom.BillOfMaterialVariantUsage = Snpshthdr.BillOfMaterialVariantUsage ) 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGSNPSHTHDR",
"I_ENGSNPSHTREFENGBOM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More