RFM_PP_MBOMConstcyMatDevtnQty

DDL: RFM_PP_MBOMCONSTCYMATDEVTNQTY Type: view
16 Fields 2 Data Sources

RFM_PP_MBOMConstcyMatDevtnQty is a CDS View in SAP S/4HANA. It reads from 2 data sources (RFM_PP_MBOMConstcyChkDevtnQty, RFM_PP_MBOMConstcyChkMaterial) and exposes 16 fields.

Data Sources (2)

SourceAliasJoin Type
RFM_PP_MBOMConstcyChkDevtnQty _MBOMConstcyChkDevtnQty from
RFM_PP_MBOMConstcyChkMaterial _MBOMConstcyChkMaterial inner

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName RFMPPMATDEVTNQTY 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 (16)

KeyFieldSource TableSource FieldDescription
BillOfMaterialCategory RFM_PP_MBOMConstcyChkDevtnQty BillOfMaterialCategory BOM category
BillOfMaterial RFM_PP_MBOMConstcyChkDevtnQty BillOfMaterial BOM
BillOfMaterialItemNodeNumber RFM_PP_MBOMConstcyChkDevtnQty BillOfMaterialItemNodeNumber Item node
BOMItemInternalChangeCount RFM_PP_MBOMConstcyChkDevtnQty BOMItemInternalChangeCount Counter
MaterialPrimary RFM_PP_MBOMConstcyChkDevtnQty MaterialPrimary Vehicle Model
BOMComponentPrimary RFM_PP_MBOMConstcyChkDevtnQty BOMComponentPrimary Component
CrossPlantConfigurableProduct RFM_PP_MBOMConstcyChkMaterial CrossPlantConfigurableProduct Cross-plant CP
ArticleCategory RFM_PP_MBOMConstcyChkMaterial ArticleCategory Prod Category
BOMComponentQtyPrimary RFM_PP_MBOMConstcyChkDevtnQty BOMComponentQtyPrimary WarrCountValue
BOMItemUnitPrimary RFM_PP_MBOMConstcyChkDevtnQty BOMItemUnitPrimary Valuation Unit
CriticalComponentIndicator RFM_PP_MBOMConstcyChkDevtnQty CriticalComponentIndicator Critical Component
CriticalLevelOfComponentInBOM RFM_PP_MBOMConstcyChkDevtnQty CriticalLevelOfComponentInBOM Critical Level
VarBillOfMaterialCategory RFM_PP_MBOMConstcyChkDevtnQty VarBillOfMaterialCategory BOM category
VarBillOfMaterial RFM_PP_MBOMConstcyChkDevtnQty VarBillOfMaterial BOM
VarBillOfMaterialItemNodeNum RFM_PP_MBOMConstcyChkDevtnQty VarBillOfMaterialItemNodeNum Item node
VarBOMItemInternalChangeCount RFM_PP_MBOMConstcyChkDevtnQty VarBOMItemInternalChangeCount Counter

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_MBOMConstcyMatDevtnQty.
-- 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_MBOMConstcyMatDevtnQty AS
SELECT
  _MBOMConstcyChkDevtnQty.BillOfMaterialCategory AS BillOfMaterialCategory,
  _MBOMConstcyChkDevtnQty.BillOfMaterial AS BillOfMaterial,
  _MBOMConstcyChkDevtnQty.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  _MBOMConstcyChkDevtnQty.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _MBOMConstcyChkDevtnQty.MaterialPrimary AS MaterialPrimary,
  _MBOMConstcyChkDevtnQty.BOMComponentPrimary AS BOMComponentPrimary,
  _MBOMConstcyChkMaterial.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  _MBOMConstcyChkMaterial.ArticleCategory AS ArticleCategory,
  _MBOMConstcyChkDevtnQty.BOMComponentQtyPrimary AS BOMComponentQtyPrimary,
  _MBOMConstcyChkDevtnQty.BOMItemUnitPrimary AS BOMItemUnitPrimary,
  _MBOMConstcyChkDevtnQty.CriticalComponentIndicator AS CriticalComponentIndicator,
  _MBOMConstcyChkDevtnQty.CriticalLevelOfComponentInBOM AS CriticalLevelOfComponentInBOM,
  _MBOMConstcyChkDevtnQty.VarBillOfMaterialCategory AS VarBillOfMaterialCategory,
  _MBOMConstcyChkDevtnQty.VarBillOfMaterial AS VarBillOfMaterial,
  _MBOMConstcyChkDevtnQty.VarBillOfMaterialItemNodeNum AS VarBillOfMaterialItemNodeNum,
  _MBOMConstcyChkDevtnQty.VarBOMItemInternalChangeCount AS VarBOMItemInternalChangeCount
FROM RFM_PP_MBOMConstcyChkDevtnQty AS _MBOMConstcyChkDevtnQty
INNER JOIN RFM_PP_MBOMConstcyChkMaterial AS _MBOMConstcyChkMaterial ON /* join condition not captured in parsed metadata */
;

Learn More