I_BillOfMaterialSubItemsHeader

DDL: I_BILLOFMATERIALSUBITEMSHEADER SQL: IBOMSUBITEMSHDR Type: view COMPOSITE Package: CS_MODEL

Composite for sub items

I_BillOfMaterialSubItemsHeader is a Composite CDS View that provides data about "Composite for sub items" in SAP S/4HANA. It reads from 2 data sources (I_BillOfMaterial, I_BillOfMaterialSubItems) and exposes 14 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialItemNodeNumber, BOMItemInternalChangeCount, BOMSubItemNumberValue. Part of development package CS_MODEL.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_BillOfMaterial stko inner
I_BillOfMaterialSubItems SubItem from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBOMSUBITEMSHDR view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.updateEnabled true view
ObjectModel.createEnabled true view
Search.searchable true view
AbapCatalog.preserveKey true view
EndUserText.label Composite for sub items view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_BillOfMaterialSubItems BillOfMaterial
KEY BillOfMaterialCategory I_BillOfMaterialSubItems BillOfMaterialCategory
KEY BillOfMaterialItemNodeNumber I_BillOfMaterialSubItems BillOfMaterialItemNodeNumber
KEY BOMItemInternalChangeCount I_BillOfMaterialSubItems BOMItemInternalChangeCount
KEY BOMSubItemNumberValue I_BillOfMaterialSubItems BOMSubItemNumberValue
BillOfMaterialSubItemQuantity I_BillOfMaterialSubItems BillOfMaterialSubItemQuantity
BOMSubItemInstallationPoint I_BillOfMaterialSubItems BOMSubItemInstallationPoint
BillOfMaterialSubItemText I_BillOfMaterialSubItems BillOfMaterialSubItemText
BillOfMaterialVariant Item BillOfMaterialVariant
BillOfMaterialVersion Item BillOfMaterialVersion
Creditor Item Creditor
HeaderChangeDocument I_BillOfMaterial EngineeringChangeDocument
Material
Plant 
@AbapCatalog.sqlViewName: 'IBOMSUBITEMSHDR'
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.updateEnabled: true
@ObjectModel.createEnabled: true
@Search.searchable: true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Composite for sub items'
define view I_BillOfMaterialSubItemsHeader
  as select from            I_BillOfMaterialSubItems  as SubItem
    left outer to many join I_BillOfMaterialComponent as Item on  SubItem.BillOfMaterialCategory       = Item.BillOfMaterialCategory
                                                              and SubItem.BillOfMaterial               = Item.BillOfMaterial
                                                              and SubItem.BillOfMaterialItemNodeNumber = Item.BillOfMaterialItemNodeNumber
                                                              and SubItem.BOMItemInternalChangeCount   = Item.BOMItemInternalChangeCount
    inner join              I_BillOfMaterial          as stko on  Item.BillOfMaterial              = stko.BillOfMaterial
                                                              and Item.BillOfMaterialCategory      = stko.BillOfMaterialCategory
                                                              and Item.BillOfMaterialVariant       = stko.BillOfMaterialVariant
                                                              and Item.BillOfMaterialVersion       = stko.BillOfMaterialVersion
                                                              and Item.BillOfMaterialCategory      = 'M'
                                                              and (
                                                                 (
                                                                   Item.ValidityStartDate          = '00000000'
                                                                   or stko.HeaderValidityStartDate = '00000000'
                                                                 )
                                                                 or(
                                                                   Item.ValidityStartDate          < stko.HeaderValidityEndDate
                                                                   and Item.ValidityEndDate        > stko.HeaderValidityStartDate
                                                                 )
                                                               )
{
  key SubItem.BillOfMaterial,
  key SubItem.BillOfMaterialCategory,
  key SubItem.BillOfMaterialItemNodeNumber,
  key SubItem.BOMItemInternalChangeCount,
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key SubItem.BOMSubItemNumberValue,
      SubItem.BillOfMaterialSubItemQuantity, 
      SubItem.BOMSubItemInstallationPoint,
      SubItem.BillOfMaterialSubItemText,
      Item.BillOfMaterialVariant,
      Item.BillOfMaterialVersion,
      Item.Creditor,
      stko.EngineeringChangeDocument as HeaderChangeDocument,
      stko._Mast.Material            as Material,
      stko._Mast.Plant               as Plant
}

Learn More