I_MaterialBOMValidItemsSearch

DDL: I_MATERIALBOMVALIDITEMSSEARCH SQL: IBOMITEMSEARCH Type: view BASIC Package: CS_MODEL
23 Fields 2 Data Sources 1 Associations

CDS based search model view for BOM Item

I_MaterialBOMValidItemsSearch is a Basic CDS View that provides data about "CDS based search model view for BOM Item" in SAP S/4HANA. It reads from 2 data sources (stas, stpo) and exposes 23 fields with key fields BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, BillOfMaterialItemNodeNumber, BillOfMaterialItemUUID. It has 1 association to related views. Part of development package CS_MODEL.

Data Sources (2)

SourceAliasJoin Type
stas stas from
stpo stpo inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _MaterialText ( $projection.BillOfMaterialComponent = _MaterialText.Material and _MaterialText.Language = $session.system_language )

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBOMITEMSEARCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label CDS based search model view for BOM Item view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial stas stlnr BOM
KEY BillOfMaterialVariant stas stlal AlternativeBOM
KEY BillOfMaterialCategory stas stlty Single-Character Flag
KEY BillOfMaterialItemNodeNumber stas stlkn Single-Character Flag
KEY BillOfMaterialItemUUID stpo guidx Guid
InheritedNodeNumberForBOMItem stas stvkn Nodes
InheritedNodeNumberVersionBOM stpo stvkn_versn Nodes
BillOfMaterialVersion stas bom_versn BOM Version
ValidityStartDate stpo datuv Valid-from date
ValidityEndDate stpo valid_to Validity End Time
EngineeringChangeDocument stpo aennr Change Number
BOMItemRecordCreationDate stpo andat Created On
BOMItemCreatedByUser stpo annam Created By
BOMItemLastChangeDate stpo aedat Obsolete
BOMItemLastChangedByUser stpo aenam User Name
BillOfMaterialComponent stpo idnrk Component
ComponentDescription _MaterialText MaterialName Component Description
BillOfMaterialItemCategory stpo postp Item Category
BillOfMaterialItemNumber stpo posnr WBS Element
BillOfMaterialItemUnit stpo meins Valuation Unit
BillOfMaterialItemQuantity stpo menge WarrCountValue
BOMItemDescription stpo potx1 Item Text
BOMItemText2 stpo potx2 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 I_MaterialBOMValidItemsSearch.
-- 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: IBOMITEMSEARCH

CREATE VIEW I_MaterialBOMValidItemsSearch AS
SELECT
  stas.stlnr AS BillOfMaterial,
  stas.stlal AS BillOfMaterialVariant,
  stas.stlty AS BillOfMaterialCategory,
  stas.stlkn AS BillOfMaterialItemNodeNumber,
  stpo.guidx AS BillOfMaterialItemUUID,
  stas.stvkn AS InheritedNodeNumberForBOMItem,
  stpo.stvkn_versn AS InheritedNodeNumberVersionBOM,
  stas.bom_versn AS BillOfMaterialVersion,
  stpo.datuv AS ValidityStartDate,
  stpo.valid_to AS ValidityEndDate,
  stpo.aennr AS EngineeringChangeDocument,
  stpo.andat AS BOMItemRecordCreationDate,
  stpo.annam AS BOMItemCreatedByUser,
  stpo.aedat AS BOMItemLastChangeDate,
  stpo.aenam AS BOMItemLastChangedByUser,
  stpo.idnrk AS BillOfMaterialComponent,
  _MaterialText.MaterialName AS ComponentDescription,
  stpo.postp AS BillOfMaterialItemCategory,
  stpo.posnr AS BillOfMaterialItemNumber,
  stpo.meins AS BillOfMaterialItemUnit,
  stpo.menge AS BillOfMaterialItemQuantity,
  stpo.potx1 AS BOMItemDescription,
  stpo.potx2 AS BOMItemText2
FROM stas
INNER JOIN stpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON ( BillOfMaterialComponent = _MaterialText.Material AND _MaterialText.Language = $session.system_language )  -- association [0..1]
;

Learn More