I_ChgImpactETOVersBOMItem

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_ChgImpactETOVersBOMItem.
-- 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: ICHGIMPETOBOMITM

CREATE VIEW I_ChgImpactETOVersBOMItem AS
SELECT
  cast( ETOVersBOMItem.BillOfMaterial as abap.char(8) ) AS BillOfMaterial,
  ETOVersBOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  ETOVersBOMItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  ETOVersBOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  BOMItemInternalChangeCount,
  BillOfMaterialItemUUID,
  ValidityStartDate,
  ValidityEndDate,
  ETOVersBOMItem.ChangeNumberFrom AS EngineeringChangeDocument,
  cast( ETOVersBOMItem.ChangeNumberTo as aenra preserving type ) AS ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  ETOVersBOM.Material AS Material,
  ETOVersBOM.Plant AS Plant,
  ETOVersBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  BillOfMaterialComponent,
  MaterialText.MaterialName AS MaterialName,
  BillOfMaterialItemCategory,
  cast( BillOfMaterialItemNumber as abap.char(4) ) AS BillOfMaterialItemNumber,
  BillOfMaterialItemUnit,
  BillOfMaterialItemQuantity,
  IsAssembly,
  IsSubItem,
  BOMItemSorter,
  PurchasingGroup,
  Currency,
  MaterialComponentPrice,
  IdentifierBOMItem,
  MaterialPriceUnitQty,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  QuantityVariableSizeItem,
  FormulaKey,
  BOMItemDescription,
  BOMItemText2,
  ETOVersBOMItem.MaterialGroup AS MaterialGroup,
  DocumentType,
  DocNumber,
  DocumentVersion,
  DocumentPart,
  ClassNumber,
  ClassType,
  ResultingItemCategory,
  DependencyObjectNumber,
  IsClassificationRelevant,
  IsBulkMaterial,
  BOMItemIsSparePart,
  BOMItemIsSalesRelevant,
  IsProductionRelevant,
  BOMItemIsPlantMaintRelevant,
  BOMItemIsCostingRelevant,
  IsEngineeringRelevant,
  SpecialProcurementType,
  IsBOMRecursiveAllowed,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  IsMaterialProvision,
  BOMIsRecursive,
  ETOVersBOMItem.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,
  ETOVersBOMItem.IsALE AS IsALE,
  _BOMItemCategoryText.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  cast ( ETOVersBOMItem.IsPhantomItem as dumps preserving type ) AS MaterialComponentIsPhantomItem,
  IsPhantomItem,
  ETOVersBOMItem.OrigSalesOrderBOMItmCategory AS OrigSalesOrderBOMItmCategory,
  cast( ETOVersBOMItem.OrigSalesOrderBOM as abap.char(8) ) AS OrigSalesOrderBOM,
  ETOVersBOMItem.OrigSalesOrderBOMItmNodeNumber AS OrigSalesOrderBOMItmNodeNumber,
  ETOVersBOMItem.OrigSalesOrderBOMItmNumber AS OrigSalesOrderBOMItmNumber
FROM P_BOMItems AS ETOVersBOMItem
INNER JOIN I_BillOfMaterialHeader AS ETOVersBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [1..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _BOMItemCategoryText ON BillOfMaterialItemCategory = _BOMItemCategoryText.BillOfMaterialItemCategory AND _BOMItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BillOfMaterialItemUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_MaterialBOMLink AS _Mast ON BillOfMaterialCategory = _Mast.BillOfMaterialCategory AND BillOfMaterial = _Mast.BillOfMaterial AND BillOfMaterialVariant = _Mast.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_DocumentBOMLink AS _Dost ON BillOfMaterialCategory = _Dost.BillOfMaterialCategory AND BillOfMaterial = _Dost.BillOfMaterial AND BillOfMaterialVariant = _Dost.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Prst AS _ProjBOMLnk ON BillOfMaterialCategory = _ProjBOMLnk.BillOfMaterialCategory AND BillOfMaterial = _ProjBOMLnk.BillOfMaterial AND BillOfMaterialVariant = _ProjBOMLnk.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderBOMLink AS _SlsOrdBOMLnk ON BillOfMaterialCategory = _SlsOrdBOMLnk.BillOfMaterialCategory AND BillOfMaterial = _SlsOrdBOMLnk.BillOfMaterial AND BillOfMaterialVariant = _SlsOrdBOMLnk.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Eqst AS _EquipBOMLnk ON BillOfMaterialCategory = _EquipBOMLnk.BillOfMaterialCategory AND BillOfMaterial = _EquipBOMLnk.BillOfMaterial AND BillOfMaterialVariant = _EquipBOMLnk.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Tpst AS _FuncnlLocBOMLnk ON BillOfMaterialCategory = _FuncnlLocBOMLnk.BillOfMaterialCategory AND BillOfMaterial = _FuncnlLocBOMLnk.BillOfMaterial AND BillOfMaterialVariant = _FuncnlLocBOMLnk.BillOfMaterialVariant  -- association [0..1]
LEFT OUTER JOIN I_Stst AS _StdBOMLnk ON BillOfMaterialCategory = _StdBOMLnk.BillOfMaterialCategory AND BillOfMaterial = _StdBOMLnk.BillOfMaterial AND BillOfMaterialVariant = _StdBOMLnk.BillOfMaterialVariant  -- association [0..1]
;