I_BOOOpBOMItmIntId

DDL: I_BOOOPBOMITMINTID SQL: IBOOOBOMII Type: view_entity BASIC Package: VDM_PP_MD_RTG

BOO Op BOM Item Internal ID

I_BOOOpBOMItmIntId (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_BOOOpBOMItmIntId is a Basic CDS View (Dimension) that provides data about "BOO Op BOM Item Internal ID" in SAP S/4HANA. It has 2 associations to related views. Part of development package VDM_PP_MD_RTG.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD-2CL
CapabilitiesAnalytical Dimension,Data Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition

Documentation

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup

Annotations (11)

NameValueLevelField
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey BOOOpBOMItemInternalID view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
EndUserText.label BOO Op BOM Item Internal ID view
Metadata.allowExtensions true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plmz plnty Task List Type
KEY BillOfOperationsGroup plmz plnnr Key for Task List Group
KEY BOOOpBOMItemInternalID plmz zuonr No. for material comp. allocation to task list
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup

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_BOOOpBOMItmIntId.
-- 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: IBOOOBOMII

CREATE VIEW I_BOOOpBOMItmIntId AS
SELECT
  plmz.plnty AS BillOfOperationsType,
  plmz.plnnr AS BillOfOperationsGroup,
  plmz.zuonr AS BOOOpBOMItemInternalID
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
;