I_EngSnpshtRefPlngBOM

DDL: I_ENGSNPSHTREFPLNGBOM Type: view_entity COMPOSITE
17 Fields 3 Data Sources

Snapshot Reference Obj PBOM

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

Data Sources (3)

SourceAliasJoin Type
I_EngSnpshtHdr EngSnpshtHdr inner
I_EngSnpshtObjRef EngSnpshtObjRef from
I_MaterialBOM MaterialBOM inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Snapshot Reference Obj PBOM view

Fields (17)

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 I_MaterialBOM Material Vehicle Model
Plant I_MaterialBOM Plant Valuation Area
BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
BOMVersionStatus I_MaterialBOM BOMVersionStatus BOM Version Status
BillOfMaterialStatus I_MaterialBOM BillOfMaterialStatus BOM Status
BillOfMaterial
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_EngSnpshtRefPlngBOM.
-- 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.

CREATE VIEW I_EngSnpshtRefPlngBOM 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.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.BOMVersionStatus AS BOMVersionStatus,
  MaterialBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  cast( MaterialBOM.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  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 I_MaterialBOM AS MaterialBOM ON /* join condition not captured in parsed metadata */
;

Learn More