I_ExplodedMatlPlngScp

DDL: I_EXPLODEDMATLPLNGSCP SQL: IEXPLMATPLNGSCP Type: view BASIC Package: MPE_PLAN_MEC
9 Fields 1 Data Sources

Exploded Materials for Planning Scope Source Material

I_ExplodedMatlPlngScp is a Basic CDS View that provides data about "Exploded Materials for Planning Scope Source Material" in SAP S/4HANA. It reads from 1 data source (vmp_exploded_mat) and exposes 9 fields with key fields DocumentId, PlanningScopeAlternative, ItemCounter. Part of development package MPE_PLAN_MEC.

Data Sources (1)

SourceAliasJoin Type
vmp_exploded_mat vmp_exploded_mat from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEXPLMATPLNGSCP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Exploded Materials for Planning Scope Source Material view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DocumentId vmp_exploded_mat documentid Routing slip doc. ID
KEY PlanningScopeAlternative vmp_exploded_mat plan_scope_alt Plan Scope Alternate
KEY ItemCounter vmp_exploded_mat item_counter INT4
MaterialName vmp_exploded_mat material_id Product
ExplosionType vmp_exploded_mat explosion_type VMP Explosion type
SourceBOMType vmp_exploded_mat source_bom_type EBom Type
SourcePlant vmp_exploded_mat source_bom_plant Plant
SourceBOMUsage vmp_exploded_mat source_bom_usage Usage
SourceBOMAlternative vmp_exploded_mat source_bom_alt Source BOM alt

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_ExplodedMatlPlngScp.
-- 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: IEXPLMATPLNGSCP

CREATE VIEW I_ExplodedMatlPlngScp AS
SELECT
  vmp_exploded_mat.documentid AS DocumentId,
  vmp_exploded_mat.plan_scope_alt AS PlanningScopeAlternative,
  vmp_exploded_mat.item_counter AS ItemCounter,
  vmp_exploded_mat.material_id AS MaterialName,
  vmp_exploded_mat.explosion_type AS ExplosionType,
  vmp_exploded_mat.source_bom_type AS SourceBOMType,
  vmp_exploded_mat.source_bom_plant AS SourcePlant,
  vmp_exploded_mat.source_bom_usage AS SourceBOMUsage,
  vmp_exploded_mat.source_bom_alt AS SourceBOMAlternative
FROM vmp_exploded_mat
;

Learn More