C_EngSnpshtObjPgMfgBOM

DDL: C_ENGSNPSHTOBJPGMFGBOM SQL: CENGSNPREFMBOM Type: view CONSUMPTION
21 Fields 3 Data Sources 6 Associations

Engineering Snapshot Ref Obj Page MBOM

C_EngSnpshtObjPgMfgBOM is a Consumption CDS View that provides data about "Engineering Snapshot Ref Obj Page MBOM" in SAP S/4HANA. It reads from 3 data sources (I_BillOfMaterial, I_EngSnpshtRefMfgBOM, I_EngSnpshtObjRefTP) and exposes 21 fields with key field EngSnapshotRefUUID. It has 6 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_BillOfMaterial BillOfMaterial inner
I_EngSnpshtRefMfgBOM EngSnpshtMBOM inner
I_EngSnpshtObjRefTP EngSnpshtObjRefTP from

Associations (6)

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
[1..1] C_EngSnpshtObjPg _EngSnpshtObjPg $projection.EngSnapshotUUID = _EngSnpshtObjPg.EngSnapshotUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CENGSNPREFMBOM 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 MBOM view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID I_EngSnpshtRefMfgBOM EngSnapshotRefUUID Waste Partner UUID
EngSnapshotUUID I_EngSnpshtRefMfgBOM EngSnapshotUUID Unique GUID
EngSnapshotID I_EngSnpshtRefMfgBOM EngSnapshotID
EngSnpshtRevisionNumber I_EngSnpshtRefMfgBOM EngSnpshtRevisionNumber
Material I_EngSnpshtRefMfgBOM Material Vehicle Model
MaterialGroup
Plant I_EngSnpshtRefMfgBOM Plant Valuation Area
BillOfMaterial I_EngSnpshtRefMfgBOM BillOfMaterial BOM
BillOfMaterialVariantUsage I_EngSnpshtRefMfgBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_EngSnpshtRefMfgBOM BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_EngSnpshtRefMfgBOM BillOfMaterialVersion BOM Version
BOMVersionStatus I_BillOfMaterial BOMVersionStatus BOM Version Status
CreatedByUser
CreationDateTime I_EngSnpshtRefMfgBOM CreationDateTime Timestamp
LastChangedByUser
LastChangeDateTime I_EngSnpshtRefMfgBOM LastChangeDateTime Timestamp
_MaterialText _MaterialText
_Plant _Plant
_BOMVersionStsTxt _BOMVersionStsTxt
_BOMVariantUsageText _BOMVariantUsageText
_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_EngSnpshtObjPgMfgBOM.
-- 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: CENGSNPREFMBOM

CREATE VIEW C_EngSnpshtObjPgMfgBOM AS
SELECT
  EngSnpshtMBOM.EngSnapshotRefUUID AS EngSnapshotRefUUID,
  EngSnpshtMBOM.EngSnapshotUUID AS EngSnapshotUUID,
  EngSnpshtMBOM.EngSnapshotID AS EngSnapshotID,
  EngSnpshtMBOM.EngSnpshtRevisionNumber AS EngSnpshtRevisionNumber,
  EngSnpshtMBOM.Material AS Material,
  cast (_Material._MaterialGroup.MaterialGroup as productgroup preserving type ) AS MaterialGroup,
  EngSnpshtMBOM.Plant AS Plant,
  EngSnpshtMBOM.BillOfMaterial AS BillOfMaterial,
  EngSnpshtMBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  EngSnpshtMBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  EngSnpshtMBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  BillOfMaterial.BOMVersionStatus AS BOMVersionStatus,
  cast( EngSnpshtMBOM.CreatedByUser as mpe_create_user ) AS CreatedByUser,
  EngSnpshtMBOM.CreationDateTime AS CreationDateTime,
  cast( EngSnpshtMBOM.LastChangedByUser as mpe_lchange_user ) AS LastChangedByUser,
  EngSnpshtMBOM.LastChangeDateTime AS LastChangeDateTime
FROM I_EngSnpshtObjRefTP AS EngSnpshtObjRefTP
INNER JOIN I_EngSnpshtRefMfgBOM AS EngSnpshtMBOM ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfMaterial AS BillOfMaterial 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 C_EngSnpshtObjPg AS _EngSnpshtObjPg ON EngSnapshotUUID = _EngSnpshtObjPg.EngSnapshotUUID  -- association [1..1]
;

Learn More