Deprecated
This CDS view is deprecated in S/4HANA. Use I_BomWhereUsed instead. View all deprecated CDS views →

I_BomWhereUsedWD

DDL: I_BOMWHEREUSEDWD Type: view_entity COMPOSITE Package: CS_MODEL
25 Fields 2 Data Sources

Interface view for single level where used list

I_BomWhereUsedWD is a Composite CDS View that provides data about "Interface view for single level where used list" in SAP S/4HANA. It reads from 2 data sources (I_Billofmaterialitemwd, I_Billofmaterialitemwd) and exposes 25 fields with key fields DraftUUIDendasDraftUUID, BillOfMaterialItemUUID. Part of development package CS_MODEL.

Data Sources (2)

SourceAliasJoin Type
I_Billofmaterialitemwd ItemActive from
I_Billofmaterialitemwd ItemDraft left_outer

Annotations (10)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Interface view for single level where used list view
Search.searchable true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_BomWhereUsed view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY DraftUUIDendasDraftUUID
KEY BillOfMaterialItemUUID I_Billofmaterialitemwd BillOfMaterialItemUUID Guid
Material I_Billofmaterialitemwd Material Vehicle Model
Plant I_Billofmaterialitemwd Plant Valuation Area
ParentDraftUUIDendasParentDraftUUID
BillOfMaterialVariantUsage I_Billofmaterialitemwd BillOfMaterialVariantUsage Usage
BillOfMaterialCategory I_Billofmaterialitemwd BillOfMaterialCategory BOM category
BillOfMaterial I_Billofmaterialitemwd BillOfMaterial BOM
BillOfMaterialVariant I_Billofmaterialitemwd BillOfMaterialVariant AlternativeBOM
BillOfMaterialItemCategory I_Billofmaterialitemwd BillOfMaterialItemCategory Item Category
BillOfMaterialItemNumber I_Billofmaterialitemwd BillOfMaterialItemNumber Item
IsActiveEntityendasIsActiveEntity
BillOfMaterialComponent I_Billofmaterialitemwd BillOfMaterialComponent Component
BillOfMaterialItemUnit I_Billofmaterialitemwd BillOfMaterialItemUnit Component UoM
BillOfMaterialItemQuantity I_Billofmaterialitemwd BillOfMaterialItemQuantity Quantity
EngineeringChangeDocument I_Billofmaterialitemwd EngineeringChangeDocument Change Number
ValidityStartDate I_Billofmaterialitemwd ValidityStartDate Validity Start Date
ValidityEndDate I_Billofmaterialitemwd ValidityEndDate ValidTo
BillOfMaterialItemNodeNumber I_Billofmaterialitemwd BillOfMaterialItemNodeNumber Item node
BOMItemDescription I_Billofmaterialitemwd BOMItemDescription Item Text
IsAssembly I_Billofmaterialitemwd IsAssembly Single-Character Flag
InheritedNodeNumberForBOMItem I_Billofmaterialitemwd InheritedNodeNumberForBOMItem Nodes
DraftAdministrativeDataUUID I_Billofmaterialitemwd DraftAdministrativeDataUUID UUID
HasActiveEntity I_Billofmaterialitemwd HasActiveEntity TRUE
HasDraftEntity I_Billofmaterialitemwd HasDraftEntity Has Draft

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_BomWhereUsedWD.
-- 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.

CREATE VIEW I_BomWhereUsedWD AS
SELECT
  case when ( ItemDraft.DraftUUID is not null or ItemDraft.DraftUUID <> hextobin('00000000000000000000000000000000') )and ItemDraft.BillOfMaterialComponent <> ItemActive.BillOfMaterialComponent then ItemDraft.DraftUUID else ItemActive.DraftUUID end as DraftUUID AS DraftUUIDendasDraftUUID,
  ItemActive.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  ItemActive.Material AS Material,
  ItemActive.Plant AS Plant,
  case when ( ItemDraft.DraftUUID is not null or ItemDraft.DraftUUID <> hextobin('00000000000000000000000000000000') )and ItemDraft.BillOfMaterialComponent <> ItemActive.BillOfMaterialComponent then ItemDraft.ParentDraftUUID else ItemActive.ParentDraftUUID end as ParentDraftUUID AS ParentDraftUUIDendasParentDraftUUID,
  ItemActive.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ItemActive.BillOfMaterialCategory AS BillOfMaterialCategory,
  ItemActive.BillOfMaterial AS BillOfMaterial,
  ItemActive.BillOfMaterialVariant AS BillOfMaterialVariant,
  ItemActive.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  ItemActive.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  case when ( ItemDraft.DraftUUID is not null or ItemDraft.DraftUUID <> hextobin('00000000000000000000000000000000') )and ItemDraft.BillOfMaterialComponent <> ItemActive.BillOfMaterialComponent then ItemDraft.IsActiveEntity else ItemActive.IsActiveEntity end as IsActiveEntity AS IsActiveEntityendasIsActiveEntity,
  ItemActive.BillOfMaterialComponent AS BillOfMaterialComponent,
  ItemActive.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  ItemActive.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  ItemActive.EngineeringChangeDocument AS EngineeringChangeDocument,
  ItemActive.ValidityStartDate AS ValidityStartDate,
  ItemActive.ValidityEndDate AS ValidityEndDate,
  ItemActive.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  ItemActive.BOMItemDescription AS BOMItemDescription,
  ItemActive.IsAssembly AS IsAssembly,
  ItemActive.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  ItemActive.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  ItemActive.HasActiveEntity AS HasActiveEntity,
  ItemActive.HasDraftEntity AS HasDraftEntity
FROM I_Billofmaterialitemwd AS ItemActive
LEFT OUTER JOIN I_Billofmaterialitemwd AS ItemDraft ON /* join condition not captured in parsed metadata */
;

Learn More