RFM_PP_MBOMConstcyChkBOMItm

DDL: RFM_PP_MBOMCONSTCYCHKBOMITM Type: view

RFM_PP_MBOMConstcyChkBOMItm is a CDS View in SAP S/4HANA. It reads from 1 data source (RFM_PP_MBOMConstcyChkBOMItms) and exposes 38 fields.

Data Sources (1)

SourceAliasJoin Type
RFM_PP_MBOMConstcyChkBOMItms _MBOMConstcyBOMItm from

Annotations (9)

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

KeyFieldSource TableSource FieldDescription
BillOfMaterialCategory RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialCategory BOM category
BillOfMaterial RFM_PP_MBOMConstcyChkBOMItms BillOfMaterial BOM
BillOfMaterialVariant RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialVariant AlternativeBOM
BillOfMaterialItemNodeNumber RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialItemNodeNumber Item node
BOMItemInternalChangeCount RFM_PP_MBOMConstcyChkBOMItms BOMItemInternalChangeCount Counter
BillOfMaterialItemNumber RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialItemNumber Item
BillOfMaterialItemCategory RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialItemCategory Item Category
BillOfMaterialComponent RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialComponent Component
BillOfMaterialItemQuantity RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialItemQuantity Quantity
BillOfMaterialItemUnit RFM_PP_MBOMConstcyChkBOMItms BillOfMaterialItemUnit Component UoM
ValidityStartDate RFM_PP_MBOMConstcyChkBOMItms ValidityStartDate Validity Start Date
ValidityEndDate RFM_PP_MBOMConstcyChkBOMItms ValidityEndDate ValidTo
ItemChangeNumberFrom RFM_PP_MBOMConstcyChkBOMItms ItemChangeNumberFrom
ItemChangeNumberTo RFM_PP_MBOMConstcyChkBOMItms ItemChangeNumberTo
AlternativeItemGroup RFM_PP_MBOMConstcyChkBOMItms AlternativeItemGroup AltItemGroup
ComponentScrapInPercent RFM_PP_MBOMConstcyChkBOMItms ComponentScrapInPercent Component Scrap
OperationScrapInPercent RFM_PP_MBOMConstcyChkBOMItms OperationScrapInPercent Operation Scrap
ExplosionType RFM_PP_MBOMConstcyChkBOMItms ExplosionType Explosion type
BOMItemIsSparePart RFM_PP_MBOMConstcyChkBOMItms BOMItemIsSparePart Spare Part ID
BOMItemHasFixedQuantity RFM_PP_MBOMConstcyChkBOMItms BOMItemHasFixedQuantity Fixed Quantity
BOMItemSpecialProcurementType RFM_PP_MBOMConstcyChkBOMItms BOMItemSpecialProcurementType
MaterialIsCoProduct RFM_PP_MBOMConstcyChkBOMItms MaterialIsCoProduct Co-product
OperationLeadTimeOffsetUnit RFM_PP_MBOMConstcyChkBOMItms OperationLeadTimeOffsetUnit
LeadTimeOffset RFM_PP_MBOMConstcyChkBOMItms LeadTimeOffset Lead-tm offset
OperationLeadTimeOffset RFM_PP_MBOMConstcyChkBOMItms OperationLeadTimeOffset Oper. LT offset
CriticalComponentIndicator RFM_PP_MBOMConstcyChkBOMItms CriticalComponentIndicator
CriticalLevelOfComponentInBOM RFM_PP_MBOMConstcyChkBOMItms CriticalLevelOfComponentInBOM
BOMItemText1 RFM_PP_MBOMConstcyChkBOMItms BOMItemText1
BOMItemText2 RFM_PP_MBOMConstcyChkBOMItms BOMItemText2 Item Text
IndicatorBOMRecursiveAllowed RFM_PP_MBOMConstcyChkBOMItms IndicatorBOMRecursiveAllowed
ReferencePoint RFM_PP_MBOMConstcyChkBOMItms ReferencePoint Reference point
BOMItemIsCostingRelevant RFM_PP_MBOMConstcyChkBOMItms BOMItemIsCostingRelevant CostingRelevncy
BOMItemIsEngineeringRelevant RFM_PP_MBOMConstcyChkBOMItms BOMItemIsEngineeringRelevant
DistributionKeyCompConsumption RFM_PP_MBOMConstcyChkBOMItms DistributionKeyCompConsumption
SortString RFM_PP_MBOMConstcyChkBOMItms SortString
PredecessorItemNode RFM_PP_MBOMConstcyChkBOMItms PredecessorItemNode
PredecessorItemCounter RFM_PP_MBOMConstcyChkBOMItms PredecessorItemCounter
InheritedNodeNumberForBOMItem RFM_PP_MBOMConstcyChkBOMItms InheritedNodeNumberForBOMItem Nodes

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_MBOMConstcyChkBOMItm.
-- 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_MBOMConstcyChkBOMItm AS
SELECT
  _MBOMConstcyBOMItm.BillOfMaterialCategory AS BillOfMaterialCategory,
  _MBOMConstcyBOMItm.BillOfMaterial AS BillOfMaterial,
  _MBOMConstcyBOMItm.BillOfMaterialVariant AS BillOfMaterialVariant,
  _MBOMConstcyBOMItm.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  _MBOMConstcyBOMItm.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _MBOMConstcyBOMItm.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  _MBOMConstcyBOMItm.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _MBOMConstcyBOMItm.BillOfMaterialComponent AS BillOfMaterialComponent,
  _MBOMConstcyBOMItm.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  _MBOMConstcyBOMItm.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _MBOMConstcyBOMItm.ValidityStartDate AS ValidityStartDate,
  _MBOMConstcyBOMItm.ValidityEndDate AS ValidityEndDate,
  _MBOMConstcyBOMItm.ItemChangeNumberFrom AS ItemChangeNumberFrom,
  _MBOMConstcyBOMItm.ItemChangeNumberTo AS ItemChangeNumberTo,
  _MBOMConstcyBOMItm.AlternativeItemGroup AS AlternativeItemGroup,
  _MBOMConstcyBOMItm.ComponentScrapInPercent AS ComponentScrapInPercent,
  _MBOMConstcyBOMItm.OperationScrapInPercent AS OperationScrapInPercent,
  _MBOMConstcyBOMItm.ExplosionType AS ExplosionType,
  _MBOMConstcyBOMItm.BOMItemIsSparePart AS BOMItemIsSparePart,
  _MBOMConstcyBOMItm.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  _MBOMConstcyBOMItm.BOMItemSpecialProcurementType AS BOMItemSpecialProcurementType,
  _MBOMConstcyBOMItm.MaterialIsCoProduct AS MaterialIsCoProduct,
  _MBOMConstcyBOMItm.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  _MBOMConstcyBOMItm.LeadTimeOffset AS LeadTimeOffset,
  _MBOMConstcyBOMItm.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  _MBOMConstcyBOMItm.CriticalComponentIndicator AS CriticalComponentIndicator,
  _MBOMConstcyBOMItm.CriticalLevelOfComponentInBOM AS CriticalLevelOfComponentInBOM,
  _MBOMConstcyBOMItm.BOMItemText1 AS BOMItemText1,
  _MBOMConstcyBOMItm.BOMItemText2 AS BOMItemText2,
  _MBOMConstcyBOMItm.IndicatorBOMRecursiveAllowed AS IndicatorBOMRecursiveAllowed,
  _MBOMConstcyBOMItm.ReferencePoint AS ReferencePoint,
  _MBOMConstcyBOMItm.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  _MBOMConstcyBOMItm.BOMItemIsEngineeringRelevant AS BOMItemIsEngineeringRelevant,
  _MBOMConstcyBOMItm.DistributionKeyCompConsumption AS DistributionKeyCompConsumption,
  _MBOMConstcyBOMItm.SortString AS SortString,
  _MBOMConstcyBOMItm.PredecessorItemNode AS PredecessorItemNode,
  _MBOMConstcyBOMItm.PredecessorItemCounter AS PredecessorItemCounter,
  _MBOMConstcyBOMItm.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem
FROM RFM_PP_MBOMConstcyChkBOMItms AS _MBOMConstcyBOMItm
;