C_BillOfMaterialSubItemsTP

DDL: C_BILLOFMATERIALSUBITEMSTP SQL: CBOMSUBITEMSTP Type: view CONSUMPTION Package: CS_MODEL
18 Fields 1 Data Sources 2 Associations

Consumption for BOM sub items

C_BillOfMaterialSubItemsTP is a Consumption CDS View that provides data about "Consumption for BOM sub items" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialSubItemsTP) and exposes 18 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 2 associations to related views. Part of development package CS_MODEL.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterialSubItemsTP I_BillOfMaterialSubItemsTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_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] C_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

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CBOMSUBITEMSTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption for BOM sub items view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view

Fields (18)

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 Subitem
BillOfMaterialSubItemQuantity BillOfMaterialSubItemQuantity Subitem Quantity
BOMSubItemInstallationPoint BOMSubItemInstallationPoint Installation Point
BillOfMaterialSubItemText BillOfMaterialSubItemText Subitem Text
Creditor Creditor Supplier
IsBusinessPurposeCompleted _SupplierVH IsBusinessPurposeCompleted Purpose Completed
_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 C_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: CBOMSUBITEMSTP

CREATE VIEW C_BillOfMaterialSubItemsTP AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  BOMItemInternalChangeCount,
  BOMSubItemNumberValue,
  BillOfMaterialSubItemQuantity,
  BOMSubItemInstallationPoint,
  BillOfMaterialSubItemText,
  Creditor,
  _SupplierVH.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_BillOfMaterialSubItemsTP
LEFT OUTER JOIN C_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 C_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]
;

Learn More