A_BOMWhereUsed

DDL: A_BOMWHEREUSED SQL: ABOMWHEREUSED Type: view COMPOSITE
24 Fields 1 Data Sources 1 Associations

Where Used List

A_BOMWhereUsed is a Composite CDS View that provides data about "Where Used List" in SAP S/4HANA. It reads from 1 data source (I_BOMItemHdrChangeState) and exposes 24 fields with key field BillOfMaterialItemUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BOMItemHdrChangeState bomitems from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_MaterialBOM _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 (12)

NameValueLevelField
AbapCatalog.sqlViewName ABOMWHEREUSED view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Where Used List view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialItemUUID I_BOMItemHdrChangeState BillOfMaterialItemUUID Guid
BillOfMaterialComponent I_BOMItemHdrChangeState BillOfMaterialComponent Component
BillOfMaterialItemNumber I_BOMItemHdrChangeState BillOfMaterialItemNumber Item
HeaderChangeDocument I_BOMItemHdrChangeState HeaderChangeDocument Change Number
BillOfMaterialCategory I_BOMItemHdrChangeState BillOfMaterialCategory BOM category
BillOfMaterial I_BOMItemHdrChangeState BillOfMaterial BOM
BillOfMaterialVariant I_BOMItemHdrChangeState BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_BOMItemHdrChangeState BillOfMaterialVersion BOM Version
BillOfMaterialItemCategory I_BOMItemHdrChangeState BillOfMaterialItemCategory Item Category
BillOfMaterialItemUnit I_BOMItemHdrChangeState BillOfMaterialItemUnit Component UoM
BillOfMaterialItemQuantity I_BOMItemHdrChangeState BillOfMaterialItemQuantity Quantity
EngineeringChangeDocument I_BOMItemHdrChangeState EngineeringChangeDocument Change Number
ValidityStartDate I_BOMItemHdrChangeState ValidityStartDate Validity Start Date
ValidityEndDate I_BOMItemHdrChangeState ValidityEndDate ValidTo
BillOfMaterialItemNodeNumber I_BOMItemHdrChangeState BillOfMaterialItemNodeNumber Item node
BOMItemDescription I_BOMItemHdrChangeState BOMItemDescription Item Text
Material I_BOMItemHdrChangeState Material Vehicle Model
MaterialName
PlantName
BillOfMaterialVariantUsageDesc
Plant I_BOMItemHdrChangeState Plant Valuation Area
BillOfMaterialVariantUsage _BillOfMaterial BillOfMaterialVariantUsage Usage
BOMVersionStatus _BillOfMaterial BOMVersionStatus BOM Version Status
BOMVersionStatusDescription

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 A_BOMWhereUsed.
-- 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: ABOMWHEREUSED

CREATE VIEW A_BOMWhereUsed AS
SELECT
  bomitems.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  bomitems.BillOfMaterialComponent AS BillOfMaterialComponent,
  bomitems.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  bomitems.HeaderChangeDocument AS HeaderChangeDocument,
  bomitems.BillOfMaterialCategory AS BillOfMaterialCategory,
  bomitems.BillOfMaterial AS BillOfMaterial,
  bomitems.BillOfMaterialVariant AS BillOfMaterialVariant,
  bomitems.BillOfMaterialVersion AS BillOfMaterialVersion,
  bomitems.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  bomitems.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  bomitems.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  bomitems.EngineeringChangeDocument AS EngineeringChangeDocument,
  bomitems.ValidityStartDate AS ValidityStartDate,
  bomitems.ValidityEndDate AS ValidityEndDate,
  bomitems.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  bomitems.BOMItemDescription AS BOMItemDescription,
  bomitems.Material AS Material,
  _BillOfMaterial._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _BillOfMaterial._Plant.PlantName AS PlantName,
  _BillOfMaterial._BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  bomitems.Plant AS Plant,
  _BillOfMaterial.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _BillOfMaterial.BOMVersionStatus AS BOMVersionStatus,
  _BillOfMaterial._VersionStatus.BOMVersionStatusDescription AS BOMVersionStatusDescription
FROM I_BOMItemHdrChangeState AS bomitems
LEFT OUTER JOIN I_MaterialBOM 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..*]
;

Learn More