C_EngSnpshtObjPgEngBOM

DDL: C_ENGSNPSHTOBJPGENGBOM SQL: CENGSNPREFEBOM Type: view CONSUMPTION Package: VDM_MPE_PLAN_ENG_SNPSHT
25 Fields 2 Data Sources 8 Associations

Engineering Snapshot Ref Obj Page EBOM

C_EngSnpshtObjPgEngBOM is a Consumption CDS View that provides data about "Engineering Snapshot Ref Obj Page EBOM" in SAP S/4HANA. It reads from 2 data sources (I_EngSnpshtEBOM, I_EngSnpshtObjRefTP) and exposes 25 fields with key field EngSnapshotRefUUID. It has 8 associations to related views. Part of development package VDM_MPE_PLAN_ENG_SNPSHT.

Data Sources (2)

SourceAliasJoin Type
I_EngSnpshtEBOM EngSnpshtEBOM inner
I_EngSnpshtObjRefTP EngSnpshtObjRefTP from

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..*] I_BillOfMaterialUsageText _BOMVariantUsageText $projection.BillOfMaterialVariantUsage = _BOMVariantUsageText.BillOfMaterialVariantUsage
[0..1] I_VersionStatus _BOMVersionStsTxt $projection.BOMVersionStatus = _BOMVersionStsTxt.BOMVersionStatus and _BOMVersionStsTxt.Language = $session.system_language
[0..*] I_BillOfMaterialStatusText _BOMStatusTxt $projection.BillOfMaterialStatus = _BOMStatusTxt.BillOfMaterialStatus
[1..1] C_EngSnpshtObjPg _EngSnpshtObjPg $projection.EngSnapshotUUID = _EngSnpshtObjPg.EngSnapshotUUID
[0..1] I_EngSnpshtEBOMLtstRevision _SnpshtLtstRevision $projection.EngSnapshotID = _SnpshtLtstRevision.EngSnapshotID and $projection.Material = _SnpshtLtstRevision.Material and $projection.Plant = _SnpshtLtstRevision.Plant and $projection.BillOfMaterialVariantUsage = _SnpshtLtstRevision.BillOfMaterialVariantUsage and $projection.BillOfMaterialVariant = _SnpshtLtstRevision.BillOfMaterialVariant

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CENGSNPREFEBOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled false view
EndUserText.label Engineering Snapshot Ref Obj Page EBOM view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID I_EngSnpshtEBOM EngSnapshotRefUUID Waste Partner UUID
EngSnapshotUUID I_EngSnpshtEBOM EngSnapshotUUID Unique GUID
EngSnapshotID I_EngSnpshtEBOM EngSnapshotID
EngSnpshtRevisionNumber I_EngSnpshtEBOM EngSnpshtRevisionNumber
Material I_EngSnpshtEBOM Material Vehicle Model
MaterialGroup
Plant I_EngSnpshtEBOM Plant Valuation Area
BillOfMaterial I_EngSnpshtEBOM BillOfMaterial BOM
BillOfMaterialVariantUsage I_EngSnpshtEBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_EngSnpshtEBOM BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_EngSnpshtEBOM BillOfMaterialVersion BOM Version
BOMVersionStatus I_EngSnpshtEBOM BOMVersionStatus BOM Version Status
BillOfMaterialStatus I_EngSnpshtEBOM BillOfMaterialStatus BOM Status
IsBOMHeader I_EngSnpshtEBOM IsBOMHeader
EngSnpshtLatestRevisionNmbr _SnpshtLtstRevision EngSnpshtRevisionNumber
CreatedByUser
CreationDateTime I_EngSnpshtEBOM CreationDateTime Timestamp
LastChangedByUser
LastChangeDateTime I_EngSnpshtEBOM LastChangeDateTime Timestamp
_MaterialText _MaterialText
_Plant _Plant
_BOMVersionStsTxt _BOMVersionStsTxt
_BOMVariantUsageText _BOMVariantUsageText
_BOMStatusTxt _BOMStatusTxt
_EngSnpshtObjPg _EngSnpshtObjPg

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_EngSnpshtObjPgEngBOM.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CENGSNPREFEBOM

CREATE VIEW C_EngSnpshtObjPgEngBOM AS
SELECT
  EngSnpshtEBOM.EngSnapshotRefUUID AS EngSnapshotRefUUID,
  EngSnpshtEBOM.EngSnapshotUUID AS EngSnapshotUUID,
  EngSnpshtEBOM.EngSnapshotID AS EngSnapshotID,
  EngSnpshtEBOM.EngSnpshtRevisionNumber AS EngSnpshtRevisionNumber,
  EngSnpshtEBOM.Material AS Material,
  cast (_Material._MaterialGroup.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  EngSnpshtEBOM.Plant AS Plant,
  EngSnpshtEBOM.BillOfMaterial AS BillOfMaterial,
  EngSnpshtEBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  EngSnpshtEBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  EngSnpshtEBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  EngSnpshtEBOM.BOMVersionStatus AS BOMVersionStatus,
  EngSnpshtEBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  EngSnpshtEBOM.IsBOMHeader AS IsBOMHeader,
  _SnpshtLtstRevision.EngSnpshtRevisionNumber AS EngSnpshtLatestRevisionNmbr,
  cast( EngSnpshtEBOM.CreatedByUser as mpe_create_user ) AS CreatedByUser,
  EngSnpshtEBOM.CreationDateTime AS CreationDateTime,
  cast( EngSnpshtEBOM.LastChangedByUser as mpe_lchange_user ) AS LastChangedByUser,
  EngSnpshtEBOM.LastChangeDateTime AS LastChangeDateTime
FROM I_EngSnpshtObjRefTP AS EngSnpshtObjRefTP
INNER JOIN I_EngSnpshtEBOM AS EngSnpshtEBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BOMVariantUsageText ON BillOfMaterialVariantUsage = _BOMVariantUsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_VersionStatus AS _BOMVersionStsTxt ON BOMVersionStatus = _BOMVersionStsTxt.BOMVersionStatus AND _BOMVersionStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialStatusText AS _BOMStatusTxt ON BillOfMaterialStatus = _BOMStatusTxt.BillOfMaterialStatus  -- association [0..*]
LEFT OUTER JOIN C_EngSnpshtObjPg AS _EngSnpshtObjPg ON EngSnapshotUUID = _EngSnpshtObjPg.EngSnapshotUUID  -- association [1..1]
LEFT OUTER JOIN I_EngSnpshtEBOMLtstRevision AS _SnpshtLtstRevision ON EngSnapshotID = _SnpshtLtstRevision.EngSnapshotID AND Material = _SnpshtLtstRevision.Material AND Plant = _SnpshtLtstRevision.Plant AND BillOfMaterialVariantUsage = _SnpshtLtstRevision.BillOfMaterialVariantUsage AND BillOfMaterialVariant = _SnpshtLtstRevision.BillOfMaterialVariant  -- association [0..1]
;

Learn More