RFM_PP_MBOMConstcyChkDevtnQty

DDL: RFM_PP_MBOMCONSTCYCHKDEVTNQTY Type: view
14 Fields 1 Data Sources

RFM_PP_MBOMConstcyChkDevtnQty is a CDS View in SAP S/4HANA. It reads from 1 data source (fsh_bom_vd) and exposes 14 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialItemNodeNumber, BOMItemInternalChangeCount, MaterialPrimary.

Data Sources (1)

SourceAliasJoin Type
fsh_bom_vd _MBOMConstcyChkDevtnQty from

Annotations (9)

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

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory fsh_bom_vd stlty Single-Character Flag
KEY BillOfMaterial fsh_bom_vd stlnr BOM
KEY BillOfMaterialItemNodeNumber fsh_bom_vd stlkn Single-Character Flag
KEY BOMItemInternalChangeCount fsh_bom_vd stpoz Counter
KEY MaterialPrimary fsh_bom_vd matnr Vehicle Model
KEY BOMComponentPrimary fsh_bom_vd idnrk Component
VarBillOfMaterialCategory fsh_bom_vd v_stlty BOM category
VarBillOfMaterial fsh_bom_vd v_stlnr BOM
VarBillOfMaterialItemNodeNum fsh_bom_vd v_stlkn Item node
VarBOMItemInternalChangeCount fsh_bom_vd v_stpoz Counter
BOMComponentQtyPrimary fsh_bom_vd menge WarrCountValue
BOMItemUnitPrimary fsh_bom_vd meins Valuation Unit
CriticalComponentIndicator fsh_bom_vd fsh_critical_comp Critical Component
CriticalLevelOfComponentInBOM fsh_bom_vd fsh_critical_level Critical Level

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_MBOMConstcyChkDevtnQty.
-- 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_MBOMConstcyChkDevtnQty AS
SELECT
  _MBOMConstcyChkDevtnQty.stlty AS BillOfMaterialCategory,
  _MBOMConstcyChkDevtnQty.stlnr AS BillOfMaterial,
  _MBOMConstcyChkDevtnQty.stlkn AS BillOfMaterialItemNodeNumber,
  _MBOMConstcyChkDevtnQty.stpoz AS BOMItemInternalChangeCount,
  _MBOMConstcyChkDevtnQty.matnr AS MaterialPrimary,
  _MBOMConstcyChkDevtnQty.idnrk AS BOMComponentPrimary,
  _MBOMConstcyChkDevtnQty.v_stlty AS VarBillOfMaterialCategory,
  _MBOMConstcyChkDevtnQty.v_stlnr AS VarBillOfMaterial,
  _MBOMConstcyChkDevtnQty.v_stlkn AS VarBillOfMaterialItemNodeNum,
  _MBOMConstcyChkDevtnQty.v_stpoz AS VarBOMItemInternalChangeCount,
  _MBOMConstcyChkDevtnQty.menge AS BOMComponentQtyPrimary,
  _MBOMConstcyChkDevtnQty.meins AS BOMItemUnitPrimary,
  _MBOMConstcyChkDevtnQty.fsh_critical_comp AS CriticalComponentIndicator,
  _MBOMConstcyChkDevtnQty.fsh_critical_level AS CriticalLevelOfComponentInBOM
FROM fsh_bom_vd AS _MBOMConstcyChkDevtnQty
;

Learn More