I_BillOfMaterialStatus

DDL: I_BILLOFMATERIALSTATUS SQL: IBOMSTATUS Type: view BASIC

Bill Of Material Status

I_BillOfMaterialStatus (Basic)

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

BillOfMaterialStatus · R&D Engineering

I_BillOfMaterialStatus is a Basic CDS View that provides data about "Bill Of Material Status" in SAP S/4HANA. It reads from 1 data source (t415s) and exposes 2 fields with key field BillOfMaterialStatus. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Bills of Material
StatusBOM status
Purpose
This CDS view retrieves bill of material status data. A bill of material status is a coded representation of the status of a bill of material (BOM). It is used in BOM processing and indicates the current processing stage of a BOM.

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description Comment BillOfMaterialStatus BOM status The following are values SAP ships: 01 : Active 02 : Inactive 03 : Active with history requirement

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentLO-MD-BOM
CapabilitiesData Source in SQL Select, Data Source for Data Extraction, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view retrieves bill of material status data. A bill of material status is a coded representation of the status of a bill of material (BOM). It is used in BOM processing and indicates the current processing stage of a BOM.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t415s t415s from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BillOfMaterialStatusText _BillOfMaterialStatusText $projection.BillOfMaterialStatus = _BillOfMaterialStatusText.BillOfMaterialStatus

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBOMSTATUS view
ClientHandling.type #INHERITED view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name BillOfMaterialStatus view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bill Of Material Status view
ObjectModel.representativeKey BillOfMaterialStatus view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialStatus t415s stlst Bill of Material Status
_BillOfMaterialStatusText _BillOfMaterialStatusText

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_BillOfMaterialStatus.
-- 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: IBOMSTATUS

CREATE VIEW I_BillOfMaterialStatus AS
SELECT
  t415s.stlst AS BillOfMaterialStatus
FROM t415s
LEFT OUTER JOIN I_BillOfMaterialStatusText AS _BillOfMaterialStatusText ON BillOfMaterialStatus = _BillOfMaterialStatusText.BillOfMaterialStatus  -- association [0..*]
;