I_ChgImpactBOMItem

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 I_ChgImpactBOMItem.
-- 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.
-- SQL view name: ICHGIMPBOMITM

CREATE VIEW I_ChgImpactBOMItem AS
SELECT
  BOMItem.BillOfMaterial AS BillOfMaterial,
  BOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  BOMItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  BOMItemInternalChangeCount,
  MatlBOM.Material AS Material,
  MatlBOM.Plant AS Plant,
  BillOfMaterialItemUUID,
  ValidityStartDate,
  ValidityEndDate,
  BOMItem.EngineeringChangeDocument AS EngineeringChangeDocument,
  BOMItem.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  MatlBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  UnitizedMatl.EffectivityType AS EffectivityType,
  UnitizedMatl.ComplexAssemblyType AS ComplexAssemblyType,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  BillOfMaterialComponent,
  MaterialText.MaterialName AS MaterialName,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  BillOfMaterialItemUnit,
  BillOfMaterialItemQuantity,
  IsAssembly,
  IsSubItem,
  BOMItemSorter,
  FixedQuantity,
  PurchasingGroup,
  Currency,
  MaterialComponentPrice,
  IdentifierBOMItem,
  MaterialPriceUnitQty,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  NumberOfVariableSizeItem,
  QuantityVariableSizeItem,
  FormulaKey,
  BOMItemDescription,
  BOMItemText2,
  BOMItem.MaterialGroup AS MaterialGroup,
  DocumentType,
  DocNumber,
  DocumentVersion,
  DocumentPart,
  ClassNumber,
  ClassType,
  ResultingItemCategory,
  DependencyObjectNumber,
  ObjectType,
  IsClassificationRelevant,
  IsBulkMaterial,
  BOMItemIsSparePart,
  BOMItemIsSalesRelevant,
  IsProductionRelevant,
  BOMItemIsPlantMaintRelevant,
  BOMItemIsCostingRelevant,
  IsEngineeringRelevant,
  SpecialProcurementType,
  IsBOMRecursiveAllowed,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  IsMaterialProvision,
  BOMIsRecursive,
  BOMItem.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  DistrKeyCompConsumption,
  DeliveryDurationInDays,
  Creditor,
  CostElement,
  Size1,
  Size2,
  Size3,
  UnitOfMeasureForSize1To3,
  GoodsReceiptDuration,
  PurchasingOrganization,
  RequiredComponent,
  MultipleSelectionAllowed,
  ProdOrderIssueLocation,
  MaterialIsCoProduct,
  ExplosionType,
  AlternativeItemGroup,
  FollowUpGroup,
  DiscontinuationGroup,
  IsConfigurableBOM,
  ReferencePoint,
  LeadTimeOffset,
  IsSoftwareComponent,
  ProductionSupplyArea,
  IsDeleted,
  BOMItem.IsALE AS IsALE,
  BillOfMaterialItemCategoryDesc,
  MaterialComponentIsPhantomItem,
  IsPhantomItem,
  BOMItem._UnitOfMeasure AS _UnitOfMeasure
FROM I_BillOfMaterialItem AS BOMItem
INNER JOIN I_MaterialBOM AS MatlBOM ON /* join condition not captured in parsed metadata */
;