RFM_PP_MBOMConstcyChkItms

DDL: RFM_PP_MBOMCONSTCYCHKITMS Type: view
35 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
stpo _MBOMConstcyChkItms from

Annotations (9)

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

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory stpo stlty Single-Character Flag
KEY BillOfMaterial stpo stlnr BOM
KEY BillOfMaterialItemNodeNumber stpo stlkn Single-Character Flag
KEY BOMItemInternalChangeCount stpo stpoz Counter
BillOfMaterialItemNumber stpo posnr WBS Element
BillOfMaterialItemCategory stpo postp Item Category
BillOfMaterialComponent stpo idnrk Component
BillOfMaterialItemQuantity stpo menge WarrCountValue
BillOfMaterialItemUnit stpo meins Valuation Unit
ValidityStartDate stpo datuv Valid-from date
ItemChangeNumberFrom stpo aennr Change Number
ItemChangeNumberTo stpo ecn_to Change No. To
AlternativeItemGroup stpo alpgr AltItemGroup
ComponentScrapInPercent stpo ausch Sep. Scrap CostComps
OperationScrapInPercent stpo avoau Operation Scrap
ExplosionType stpo dspst Explosion type
BOMItemIsSparePart stpo erskz Spare Part ID
BOMItemHasFixedQuantity stpo fmeng Qty. is fixed
BOMItemSpecialProcurementType stpo itsob SpecProcurement
MaterialIsCoProduct stpo kzkup Co-Product
OperationLeadTimeOffsetUnit stpo nlfmv Oper. LTO unit
LeadTimeOffset stpo nlfzt Lead-tm offset
OperationLeadTimeOffset stpo nlfzv Oper. LT offset
CriticalComponentIndicator stpo fsh_critical_comp Critical Component
CriticalLevelOfComponentInBOM stpo fsh_critical_level Critical Level
BOMItemText1 stpo potx1 Item Text
BOMItemText2 stpo potx2 Item Text
IndicatorBOMRecursiveAllowed stpo rekrs Rec. allowed
ReferencePoint stpo rfpnt Reference point
BOMItemIsCostingRelevant stpo sanka CostingRelevncy
BOMItemIsEngineeringRelevant stpo sanko Engineering
DistributionKeyCompConsumption stpo verti Distribution
SortString stpo sortf Sort string
PredecessorItemNode stpo vgknt Previous node
PredecessorItemCounter stpo vgpzl Prev item count

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_MBOMConstcyChkItms.
-- 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_MBOMConstcyChkItms AS
SELECT
  _MBOMConstcyChkItms.stlty AS BillOfMaterialCategory,
  _MBOMConstcyChkItms.stlnr AS BillOfMaterial,
  _MBOMConstcyChkItms.stlkn AS BillOfMaterialItemNodeNumber,
  _MBOMConstcyChkItms.stpoz AS BOMItemInternalChangeCount,
  _MBOMConstcyChkItms.posnr AS BillOfMaterialItemNumber,
  _MBOMConstcyChkItms.postp AS BillOfMaterialItemCategory,
  _MBOMConstcyChkItms.idnrk AS BillOfMaterialComponent,
  _MBOMConstcyChkItms.menge AS BillOfMaterialItemQuantity,
  _MBOMConstcyChkItms.meins AS BillOfMaterialItemUnit,
  _MBOMConstcyChkItms.datuv AS ValidityStartDate,
  _MBOMConstcyChkItms.aennr AS ItemChangeNumberFrom,
  _MBOMConstcyChkItms.ecn_to AS ItemChangeNumberTo,
  _MBOMConstcyChkItms.alpgr AS AlternativeItemGroup,
  _MBOMConstcyChkItms.ausch AS ComponentScrapInPercent,
  _MBOMConstcyChkItms.avoau AS OperationScrapInPercent,
  _MBOMConstcyChkItms.dspst AS ExplosionType,
  _MBOMConstcyChkItms.erskz AS BOMItemIsSparePart,
  _MBOMConstcyChkItms.fmeng AS BOMItemHasFixedQuantity,
  _MBOMConstcyChkItms.itsob AS BOMItemSpecialProcurementType,
  _MBOMConstcyChkItms.kzkup AS MaterialIsCoProduct,
  _MBOMConstcyChkItms.nlfmv AS OperationLeadTimeOffsetUnit,
  _MBOMConstcyChkItms.nlfzt AS LeadTimeOffset,
  _MBOMConstcyChkItms.nlfzv AS OperationLeadTimeOffset,
  _MBOMConstcyChkItms.fsh_critical_comp AS CriticalComponentIndicator,
  _MBOMConstcyChkItms.fsh_critical_level AS CriticalLevelOfComponentInBOM,
  _MBOMConstcyChkItms.potx1 AS BOMItemText1,
  _MBOMConstcyChkItms.potx2 AS BOMItemText2,
  _MBOMConstcyChkItms.rekrs AS IndicatorBOMRecursiveAllowed,
  _MBOMConstcyChkItms.rfpnt AS ReferencePoint,
  _MBOMConstcyChkItms.sanka AS BOMItemIsCostingRelevant,
  _MBOMConstcyChkItms.sanko AS BOMItemIsEngineeringRelevant,
  _MBOMConstcyChkItms.verti AS DistributionKeyCompConsumption,
  _MBOMConstcyChkItms.sortf AS SortString,
  _MBOMConstcyChkItms.vgknt AS PredecessorItemNode,
  _MBOMConstcyChkItms.vgpzl AS PredecessorItemCounter
FROM stpo AS _MBOMConstcyChkItms
;

Learn More