I_ProdRtlUnitOfMeasureBOM

DDL: I_PRODRTLUNITOFMEASUREBOM SQL: IPRDRTLBOM Type: view BASIC
4 Fields 1 Data Sources

Basic View for T415B table

I_ProdRtlUnitOfMeasureBOM is a Basic CDS View that provides data about "Basic View for T415B table" in SAP S/4HANA. It reads from 1 data source (t415b) and exposes 4 fields with key fields Product, AlternativeUnit, ProductBOMUsage.

Data Sources (1)

SourceAliasJoin Type
t415b RetailBOM from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPRDRTLBOM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basic View for T415B table view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product t415b matnr Vehicle Model
KEY AlternativeUnit t415b basme Unit of measure
KEY ProductBOMUsage t415b stlan Usage
AlternativeBillOfMaterial t415b stlal AlternativeBOM

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_ProdRtlUnitOfMeasureBOM.
-- 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: IPRDRTLBOM

CREATE VIEW I_ProdRtlUnitOfMeasureBOM AS
SELECT
  RetailBOM.matnr AS Product,
  RetailBOM.basme AS AlternativeUnit,
  RetailBOM.stlan AS ProductBOMUsage,
  RetailBOM.stlal AS AlternativeBillOfMaterial
FROM t415b AS RetailBOM
;

Learn More