RFM_PP_MBOMConstcyChkMatlLink

DDL: RFM_PP_MBOMCONSTCYCHKMATLLINK Type: view
8 Fields 1 Data Sources

RFM_PP_MBOMConstcyChkMatlLink is a CDS View in SAP S/4HANA. It reads from 1 data source (mast) and exposes 8 fields with key fields Material, Plant, BillOfMaterialVariantUsage, BillOfMaterial, BillOfMaterialVariant.

Data Sources (1)

SourceAliasJoin Type
mast _MaterialBOMLink from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName RFMPPMATLBOMLINK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Material mast matnr Vehicle Model
KEY Plant mast werks Receiving Plant
KEY BillOfMaterialVariantUsage mast stlan Usage
KEY BillOfMaterial mast stlnr BOM
KEY BillOfMaterialVariant mast stlal AlternativeBOM
BillOfMaterialCategory
MatFromLotSizeQuantity mast losvn Lot Size From
MaterialToLotSizeQuantity mast losbs To Lot Size

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 RFM_PP_MBOMConstcyChkMatlLink.
-- 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 RFM_PP_MBOMConstcyChkMatlLink AS
SELECT
  _MaterialBOMLink.matnr AS Material,
  _MaterialBOMLink.werks AS Plant,
  _MaterialBOMLink.stlan AS BillOfMaterialVariantUsage,
  _MaterialBOMLink.stlnr AS BillOfMaterial,
  _MaterialBOMLink.stlal AS BillOfMaterialVariant,
  cast ('M' as stlty preserving type) AS BillOfMaterialCategory,
  _MaterialBOMLink.losvn AS MatFromLotSizeQuantity,
  _MaterialBOMLink.losbs AS MaterialToLotSizeQuantity
FROM mast AS _MaterialBOMLink
;

Learn More