P_ProjectBOMSubitemDEX

DDL: P_PROJECTBOMSUBITEMDEX Type: view_entity BASIC Package: CS_MODEL
9 Fields 2 Data Sources

Private view for WBS BOM Subitem

P_ProjectBOMSubitemDEX is a Basic CDS View that provides data about "Private view for WBS BOM Subitem" in SAP S/4HANA. It reads from 2 data sources (stpo, stpu) and exposes 9 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialItemNodeNumber, BOMItemInternalChangeCount, BOMSubItemNumberValue. Part of development package CS_MODEL.

Data Sources (2)

SourceAliasJoin Type
stpo stpo inner
stpu stpu from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stpu stlty Single-Character Flag
KEY BillOfMaterial
KEY BillOfMaterialItemNodeNumber stpu stlkn Single-Character Flag
KEY BOMItemInternalChangeCount stpu stpoz Counter
KEY BOMSubItemNumberValue
BillOfMaterialItemUnit stpo meins Valuation Unit
BillOfMaterialSubItemQuantity stpu upmng Sub-item qty
BOMSubItemInstallationPoint stpu ebort Install. Point
BillOfMaterialSubItemText stpu uptxt Sub-item text

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 P_ProjectBOMSubitemDEX.
-- 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 P_ProjectBOMSubitemDEX AS
SELECT
  stpu.stlty AS BillOfMaterialCategory,
  cast(stpu.stlnr as cs_stlnr preserving type) AS BillOfMaterial,
  stpu.stlkn AS BillOfMaterialItemNodeNumber,
  stpu.stpoz AS BOMItemInternalChangeCount,
  cast(stpu.uposz as char4 preserving type) AS BOMSubItemNumberValue,
  stpo.meins AS BillOfMaterialItemUnit,
  stpu.upmng AS BillOfMaterialSubItemQuantity,
  stpu.ebort AS BOMSubItemInstallationPoint,
  stpu.uptxt AS BillOfMaterialSubItemText
FROM stpu
INNER JOIN stpo ON /* join condition not captured in parsed metadata */
;

Learn More