I_ProjectBOMLink

DDL: I_PROJECTBOMLINK SQL: IPROJTOBOMLINK Type: view BASIC
7 Fields 1 Data Sources

Work Breakdown Structure Link for BOM

I_ProjectBOMLink (Basic)

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

R&D Engineering

I_ProjectBOMLink is a Basic CDS View that provides data about "Work Breakdown Structure Link for BOM" in SAP S/4HANA. It reads from 1 data source (prst) and exposes 7 fields with key fields WBSElementInternalID, Material, Plant, BillOfMaterialVariantUsage, BillOfMaterial.

SAP Help Documentation

CategoryCDS Views for Bills of Material
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the work breakdown structure (WBS) element for the work breakdown structure BOM? What is the BOM number associated with a work breakdown structure BOM? What is the BOM alternative, BOM usage, and BOM category for the work breakdown structure BOM? What is the plant assigned to the work breakdown structure BOM? What is the material associated with the work breakdown structure BOM?

Prerequisites
You have authorization to access the work breakdown structure BOM.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentLO-MD-BOM
CapabilitiesData Source for Defining CDS Entities, Data Source in SQL Select, Association Target for Defining CDS Entities
PackageR&D Engineering 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>What is the work breakdown structure (WBS) element for the work breakdown structure BOM?</p></li> <li><p>What is the BOM number associated with a work breakdown structure BOM?</p></li> <li><p>What is the BOM alternative, BOM usage, and BOM category for the work breakdown structure BOM?</p></li> <li><p>What is the plant assigned to the work breakdown structure BOM?</p></li> <li><p>What is the material associated with the work breakdown structure BOM?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
prst prst from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPROJTOBOMLINK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Work Breakdown Structure Link for BOM view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID pspnr Work breakdown structure element (WBS element)
KEY Material matnr Material Number
KEY Plant werks Receiving Plant
KEY BillOfMaterialVariantUsage stlan BOM Usage
KEY BillOfMaterial stlnr Bill of Material
KEY BillOfMaterialVariant stlal Alternative BOM
BillOfMaterialCategory BOM category

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_ProjectBOMLink.
-- 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: IPROJTOBOMLINK

CREATE VIEW I_ProjectBOMLink AS
SELECT
  pspnr AS WBSElementInternalID,
  matnr AS Material,
  werks AS Plant,
  stlan AS BillOfMaterialVariantUsage,
  stlnr AS BillOfMaterial,
  stlal AS BillOfMaterialVariant,
  cast ('P' as stlty preserving type) AS BillOfMaterialCategory
FROM prst
;

Learn More