I_DocInfoRecdStructureItem

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_DocInfoRecdStructureItem.
-- 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: ICVDOCSTRUCTITEM

CREATE VIEW I_DocInfoRecdStructureItem AS
SELECT
  bom_item.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  bom_item.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_item.BillOfMaterial AS BillOfMaterial,
  bom_item.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  bom_item.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  bom_item.BillOfMaterialVariant AS AlternativeBillOfMaterial,
  bom_item.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  bom_item.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  bom_item.DocumentType AS DocumentType,
  bom_item.DocNumber AS DocumentInfoRecord,
  bom_item.DocumentVersion AS DocumentVersion,
  bom_item.DocumentPart AS DocumentPart,
  bom_item.ValidityStartDate AS ValidityStartDate,
  bom_item.ValidityEndDate AS ValidityEndDate,
  bom_item.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_item.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_item.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  bom_item.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  bom_item.FixedQuantity AS FixedQuantity,
  bom_item.IsSubItem AS IsSubItem,
  bom_item.BOMItemSorter AS BOMItemSorter,
  bom_item.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  bom_item.BOMIsRecursive AS BOMIsRecursive,
  bom_item.IsALE AS IsALE,
  bom_item.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_item.ReferencePoint AS ReferencePoint,
  bom_item.IsAssembly AS IsAssembly,
  bom_item.BOMItemDescription AS BOMItemDescription,
  bom_item.BOMItemText2 AS BOMItemText2,
  bom_item.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  bom_item.IsEngineeringRelevant AS IsEngineeringRelevant,
  bom_item.IsDeleted AS IsDeleted,
  bom_item.BOMItemRecordCreationDate AS CreationDate,
  bom_item.BOMItemCreatedByUser AS CreatedByUser,
  bom_item.BOMItemRecordCreationDate AS LastChangeDate,
  bom_item.BOMItemLastChangedByUser AS LastChangedByUser
FROM I_BillOfMaterialItem AS bom_item
LEFT OUTER JOIN I_DocInfoRecdStructure AS _Header ON BillOfMaterial = _Header.BillOfMaterial AND BillOfMaterialCategory = _Header.BillOfMaterialCategory AND AlternativeBillOfMaterial = _Header.AlternativeBillOfMaterial  -- association [1..*]
LEFT OUTER JOIN I_DocInfoRecd AS _Document ON DocumentType = _Document.DocumentType AND DocumentInfoRecord = _Document.DocumentInfoRecord AND DocumentVersion = _Document.DocumentVersion AND DocumentPart = _Document.DocumentPart  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedUser ON CreatedByUser = _CreatedUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedUser ON LastChangedByUser = _LastChangedUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BillOfMaterialItemUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
;