I_MaterialBOMValidItemsSearch

DDL: I_MATERIALBOMVALIDITEMSSEARCH SQL: IBOMITEMSEARCH Type: view BASIC Package: CS_MODEL

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.

2 data source(s) 23 fields

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
KEY BillOfMaterialVariant stas stlal
KEY BillOfMaterialCategory stas stlty
KEY BillOfMaterialItemNodeNumber stas stlkn
KEY BillOfMaterialItemUUID stpo guidx
InheritedNodeNumberForBOMItem stas stvkn
InheritedNodeNumberVersionBOM stpo stvkn_versn
BillOfMaterialVersion stas bom_versn
ValidityStartDate stpo datuv
ValidityEndDate stpo valid_to
EngineeringChangeDocument stpo aennr
BOMItemRecordCreationDate stpo andat
BOMItemCreatedByUser stpo annam
BOMItemLastChangeDate stpo aedat
BOMItemLastChangedByUser stpo aenam
BillOfMaterialComponent stpo idnrk
ComponentDescription _MaterialText MaterialName Component Description
BillOfMaterialItemCategory stpo postp
BillOfMaterialItemNumber stpo posnr
BillOfMaterialItemUnit stpo meins
BillOfMaterialItemQuantity stpo menge
BOMItemDescription stpo potx1
BOMItemText2 stpo potx2 
@AbapCatalog.sqlViewName: 'IBOMITEMSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'CDS based search model view for BOM Item'
define view I_MaterialBOMValidItemsSearch
  as select from stas as stas
    inner join   stpo as stpo on  stas.stlty = stpo.stlty
                              and stas.stlnr = stpo.stlnr
                              and stas.stlkn = stpo.stlkn
    association [0..1] to I_MaterialText       as _MaterialText               on  (
                    $projection.BillOfMaterialComponent       = _MaterialText.Material
                    and _MaterialText.Language = $session.system_language
                  )                          
{
  key stas.stlnr                            as    BillOfMaterial,
  key stas.stlal                            as    BillOfMaterialVariant,
  key stas.stlty                            as    BillOfMaterialCategory,
  key stas.stlkn                            as    BillOfMaterialItemNodeNumber,
  key stpo.guidx                            as    BillOfMaterialItemUUID,
      stas.stvkn                            as    InheritedNodeNumberForBOMItem,
      stpo.stvkn_versn                      as    InheritedNodeNumberVersionBOM,
      stas.bom_versn                        as    BillOfMaterialVersion,
      @Semantics.businessDate.from: true
      stpo.datuv                            as    ValidityStartDate,
      @Semantics.businessDate.to: true
      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,
      @EndUserText.label: 'Component Description'
      _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
}
where
      stpo.stlty = 'M'
  and stas.lkenz = ''

Learn More