I_EngSnpshtRefMfgBOM

DDL: I_ENGSNPSHTREFMFGBOM SQL: IENGSNPREFMBOM Type: view COMPOSITE
18 Fields 3 Data Sources

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, P_EngSnpshtMfgBOM) and exposes 18 fields with key field EngSnapshotRefUUID.

Data Sources (3)

SourceAliasJoin Type
I_EngSnpshtHdr EngSnpshtHdr inner
I_EngSnpshtObjRef EngSnpshtObjRef from
P_EngSnpshtMfgBOM MaterialBOM inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPREFMBOM view
AbapCatalog.compiler.compareFilter 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 (18)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID I_EngSnpshtObjRef EngSnapshotRefUUID Waste Partner UUID
EngSnapshotUUID I_EngSnpshtObjRef EngSnapshotUUID Waste Partner UUID
EngSnapshotID I_EngSnpshtHdr EngSnapshotID Snapshot ID
EngSnpshtRevisionNumber I_EngSnpshtHdr EngSnpshtRevisionNumber Snapshot Revision
EngSnpshtRefType I_EngSnpshtObjRef EngSnpshtRefType Worklist Type
Material P_EngSnpshtMfgBOM Material Vehicle Model
Plant P_EngSnpshtMfgBOM Plant Valuation Area
BillOfMaterialCategory P_EngSnpshtMfgBOM BillOfMaterialCategory BOM category
BillOfMaterialVariant P_EngSnpshtMfgBOM BillOfMaterialVariant AlternativeBOM
BillOfMaterialVariantUsage P_EngSnpshtMfgBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVersion
BillOfMaterial
SalesOrder P_EngSnpshtMfgBOM SalesOrder SD Document
SalesOrderItem P_EngSnpshtMfgBOM SalesOrderItem Sales Order Item
CreatedByUser I_EngSnpshtObjRef CreatedByUser User Name
CreationDateTime I_EngSnpshtObjRef CreationDateTime Timestamp
LastChangedByUser I_EngSnpshtObjRef LastChangedByUser User Name
LastChangeDateTime I_EngSnpshtObjRef LastChangeDateTime Timestamp

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 I_EngSnpshtRefMfgBOM.
-- 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: IENGSNPREFMBOM

CREATE VIEW I_EngSnpshtRefMfgBOM AS
SELECT
  EngSnpshtObjRef.EngSnapshotRefUUID AS EngSnapshotRefUUID,
  EngSnpshtObjRef.EngSnapshotUUID AS EngSnapshotUUID,
  EngSnpshtHdr.EngSnapshotID AS EngSnapshotID,
  EngSnpshtHdr.EngSnpshtRevisionNumber AS EngSnpshtRevisionNumber,
  EngSnpshtObjRef.EngSnpshtRefType AS EngSnpshtRefType,
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  cast( EngSnpshtObjRef.EngSnpshtRefKey5 as cs_versn ) AS BillOfMaterialVersion,
  cast( MaterialBOM.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  MaterialBOM.SalesOrder AS SalesOrder,
  MaterialBOM.SalesOrderItem AS SalesOrderItem,
  EngSnpshtObjRef.CreatedByUser AS CreatedByUser,
  EngSnpshtObjRef.CreationDateTime AS CreationDateTime,
  EngSnpshtObjRef.LastChangedByUser AS LastChangedByUser,
  EngSnpshtObjRef.LastChangeDateTime AS LastChangeDateTime
FROM I_EngSnpshtObjRef AS EngSnpshtObjRef
INNER JOIN I_EngSnpshtHdr AS EngSnpshtHdr ON /* join condition not captured in parsed metadata */
INNER JOIN P_EngSnpshtMfgBOM AS MaterialBOM ON /* join condition not captured in parsed metadata */
;

Learn More