I_BOMExplosionDate

DDL: I_BOMEXPLOSIONDATE SQL: IPPBOMEXPLDATE Type: view BASIC
10 Fields 1 Data Sources 3 Associations

BOM Explosion Date

I_BOMExplosionDate (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_BOMExplosionDate is a Basic CDS View (Dimension) that provides data about "BOM Explosion Date" in SAP S/4HANA. It reads from 1 data source (snum) and exposes 10 fields with key field BOMExplosionDateID. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Search
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which BOM explosion date IDs are maintained?</p></li> <li><p>Which materials and plants are assigned to a BOM explosion date ID?</p></li> <li><p>Which is the text of a BOM explosion date ID?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
snum s from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material
[1..1] I_Product _Product $projection.Material = _Product.Product
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IPPBOMEXPLDATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey BOMExplosionDateID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label BOM Explosion Date view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BOMExplosionDateID Bill of Material Explosion Date ID
BOMExplosionFixedKeyDate snum brutr Fixed Key Date
Material snum matnr Material Number
Plant snum werks Receiving Plant
BOMExplosionDateText Text for BOM Explosion Date ID
IsDeleted snum xloek Item is Deleted
EffectivityParameterVariant snum techs Parameter Variant/Standard Variant
_Material _Material
_Product _Product
_Plant _Plant

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_BOMExplosionDate.
-- 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: IPPBOMEXPLDATE

CREATE VIEW I_BOMExplosionDate AS
SELECT
  cast(s.sernr as pph_sernr preserving type) AS BOMExplosionDateID,
  s.brutr AS BOMExplosionFixedKeyDate,
  s.matnr AS Material,
  s.werks AS Plant,
  cast(s.sntxt as pph_sntxt preserving type) AS BOMExplosionDateText,
  s.xloek AS IsDeleted,
  s.techs AS EffectivityParameterVariant
FROM snum AS s
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;

Learn More