I_BillOfMaterialSubItemsTP

DDL: I_BILLOFMATERIALSUBITEMSTP SQL: IBOMSUBITEMSTP Type: view TRANSACTIONAL
17 Fields 1 Data Sources 3 Associations

Bill of Material Sub Item - TP

I_BillOfMaterialSubItemsTP is a Transactional CDS View that provides data about "Bill of Material Sub Item - TP" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialSubItemsHeader) and exposes 17 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterialSubItemsHeader I_BillOfMaterialSubItemsHeader from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BillOfMaterialItemTP _Item $projection.BillOfMaterial = _Item.BillOfMaterial and $projection.BillOfMaterialCategory = _Item.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _Item.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _Item.BillOfMaterialVersion and $projection.BillOfMaterialItemNodeNumber = _Item.BillOfMaterialItemNodeNumber and $projection.HeaderChangeDocument = _Item.HeaderChangeDocument and $projection.Material = _Item.Material and $projection.Plant = _Item.Plant
[1..1] I_BillOfMaterialTP _BillOfMaterial $projection.BillOfMaterial = _BillOfMaterial.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterial.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BillOfMaterial.BillOfMaterialVersion and $projection.HeaderChangeDocument = _BillOfMaterial.EngineeringChangeDocument and $projection.Material = _BillOfMaterial.Material and $projection.Plant = _BillOfMaterial.Plant
[0..1] I_Supplier_VH _SupplierVH $projection.Creditor = _SupplierVH.Supplier

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IBOMSUBITEMSTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bill of Material Sub Item - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence STPU_DRAFT_V2 view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber Item node
KEY HeaderChangeDocument HeaderChangeDocument Change Number
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY BOMItemInternalChangeCount BOMItemInternalChangeCount Counter
KEY BOMSubItemNumberValue BOMSubItemNumberValue
BillOfMaterialSubItemQuantity BillOfMaterialSubItemQuantity
BOMSubItemInstallationPoint BOMSubItemInstallationPoint
BillOfMaterialSubItemText BillOfMaterialSubItemText
Creditor Creditor Supplier
_SupplierVH _SupplierVH
_Item _Item
_BillOfMaterial _BillOfMaterial

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_BillOfMaterialSubItemsTP.
-- 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: IBOMSUBITEMSTP

CREATE VIEW I_BillOfMaterialSubItemsTP AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  BOMItemInternalChangeCount,
  BOMSubItemNumberValue,
  BillOfMaterialSubItemQuantity,
  BOMSubItemInstallationPoint,
  BillOfMaterialSubItemText,
  Creditor
FROM I_BillOfMaterialSubItemsHeader
LEFT OUTER JOIN I_BillOfMaterialItemTP AS _Item ON BillOfMaterial = _Item.BillOfMaterial AND BillOfMaterialCategory = _Item.BillOfMaterialCategory AND BillOfMaterialVariant = _Item.BillOfMaterialVariant AND BillOfMaterialVersion = _Item.BillOfMaterialVersion AND BillOfMaterialItemNodeNumber = _Item.BillOfMaterialItemNodeNumber AND HeaderChangeDocument = _Item.HeaderChangeDocument AND Material = _Item.Material AND Plant = _Item.Plant  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialTP AS _BillOfMaterial ON BillOfMaterial = _BillOfMaterial.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterial.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterial.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterial.BillOfMaterialVersion AND HeaderChangeDocument = _BillOfMaterial.EngineeringChangeDocument AND Material = _BillOfMaterial.Material AND Plant = _BillOfMaterial.Plant  -- association [1..1]
LEFT OUTER JOIN I_Supplier_VH AS _SupplierVH ON Creditor = _SupplierVH.Supplier  -- association [0..1]
;

Learn More