RFM_PP_MBOMConstcyChkBOMItms

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_MBOMConstcyChkBOMItms.
-- 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_MBOMConstcyChkBOMItms AS
SELECT
  _MBOMConstcyChkItms.BillOfMaterialCategory AS BillOfMaterialCategory,
  _MBOMConstcyChkItms.BillOfMaterial AS BillOfMaterial,
  _MBOMConstcyChkItmsSel.BillOfMaterialVariant AS BillOfMaterialVariant,
  _MBOMConstcyChkItms.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  _MBOMConstcyChkItms.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _MBOMConstcyChkItms.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  _MBOMConstcyChkItms.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _MBOMConstcyChkItms.BillOfMaterialComponent AS BillOfMaterialComponent,
  _MBOMConstcyChkItms.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  _MBOMConstcyChkItms.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _MBOMConstcyChkItms.ValidityStartDate AS ValidityStartDate,
  _MBOMConstcyChkItms.ValidityEndDate AS ValidityEndDate,
  _MBOMConstcyChkItms.ItemChangeNumberFrom AS ItemChangeNumberFrom,
  _MBOMConstcyChkItms.ItemChangeNumberTo AS ItemChangeNumberTo,
  _MBOMConstcyChkItms.AlternativeItemGroup AS AlternativeItemGroup,
  _MBOMConstcyChkItms.ComponentScrapInPercent AS ComponentScrapInPercent,
  _MBOMConstcyChkItms.OperationScrapInPercent AS OperationScrapInPercent,
  _MBOMConstcyChkItms.ExplosionType AS ExplosionType,
  _MBOMConstcyChkItms.BOMItemIsSparePart AS BOMItemIsSparePart,
  _MBOMConstcyChkItms.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  _MBOMConstcyChkItms.BOMItemSpecialProcurementType AS BOMItemSpecialProcurementType,
  _MBOMConstcyChkItms.MaterialIsCoProduct AS MaterialIsCoProduct,
  _MBOMConstcyChkItms.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  _MBOMConstcyChkItms.LeadTimeOffset AS LeadTimeOffset,
  _MBOMConstcyChkItms.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  _MBOMConstcyChkItms.CriticalComponentIndicator AS CriticalComponentIndicator,
  _MBOMConstcyChkItms.CriticalLevelOfComponentInBOM AS CriticalLevelOfComponentInBOM,
  _MBOMConstcyChkItms.BOMItemText1 AS BOMItemText1,
  _MBOMConstcyChkItms.BOMItemText2 AS BOMItemText2,
  _MBOMConstcyChkItms.IndicatorBOMRecursiveAllowed AS IndicatorBOMRecursiveAllowed,
  _MBOMConstcyChkItms.ReferencePoint AS ReferencePoint,
  _MBOMConstcyChkItms.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  _MBOMConstcyChkItms.BOMItemIsEngineeringRelevant AS BOMItemIsEngineeringRelevant,
  _MBOMConstcyChkItms.DistributionKeyCompConsumption AS DistributionKeyCompConsumption,
  _MBOMConstcyChkItms.SortString AS SortString,
  _MBOMConstcyChkItms.PredecessorItemNode AS PredecessorItemNode,
  _MBOMConstcyChkItms.PredecessorItemCounter AS PredecessorItemCounter,
  _MBOMConstcyChkItmsSel.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem
FROM RFM_PP_MBOMConstcyChkItms AS _MBOMConstcyChkItms
INNER JOIN RFM_PP_MBOMConstcyChkItmsSel AS _MBOMConstcyChkItmsSel ON /* join condition not captured in parsed metadata */
;