I_MaintenanceBillOfMaterial

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_MaintenanceBillOfMaterial.
-- 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: IMAINTBOMHDR

CREATE VIEW I_MaintenanceBillOfMaterial AS
SELECT
  cast( bom_header.BillOfMaterial as abap.char( 8 ) ) AS BillOfMaterial,
  case BillOfMaterialCategory when 'E' then bom_header._Eqst.Plant when 'T' then bom_header._Tpst.Plant when 'M' then bom_header._Mast.Plant else '' end as Plant AS PlantelseendasPlant,
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  case BillOfMaterialCategory when 'E' then bom_header._Eqst.Equipment when 'T' then bom_header._Tpst.FunctionalLocation when 'M' then bom_header._Mast.Material else '' end as TechnicalObject AS MaterialelseendasTechnicalObject,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  bom_header.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  bom_header.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  bom_header.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  bom_header.BOMUsagePriority AS BOMUsagePriority,
  bom_header.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  bom_header.IsLatestBOMVersion AS IsLatestBOMVersion,
  bom_header.IsConfiguredMaterial AS IsConfiguredMaterial,
  cast ( bom_header.BOMTechnicalType as tetyp_d preserving type) AS BOMTechnicalType,
  bom_header.BOMGroup AS BOMGroup,
  bom_header.BOMHeaderText AS BOMHeaderText,
  bom_header.BOMAlternativeText AS BOMAlternativeText,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus,
  bom_header.HeaderValidityStartDate AS HeaderValidityStartDate,
  bom_header.HeaderValidityEndDate AS HeaderValidityEndDate,
  bom_header.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  bom_header.IsMarkedForDeletion AS IsMarkedForDeletion,
  bom_header.IsALE AS IsALE,
  bom_header.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  bom_header.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  bom_header.RecordCreationDate AS RecordCreationDate,
  bom_header.LastChangeDate AS LastChangeDate,
  bom_header.CreatedByUser AS CreatedByUser,
  bom_header.LastChangedByUser AS LastChangedByUser,
  bom_header.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  bom_header.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  bom_header.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  bom_header.LastChangeDateTime AS LastChangeDateTime,
  cast(' ' as abap.char( 4 ) ) AS SelectedBillOfMaterialVersion,
  concat( concat( concat(_CreatedByUser.UserDescription,' (' ) , _CreatedByUser.UserID ), ')') AS CreatedByUserName,
  concat( concat( concat(_ChangedByUser.UserDescription,' (' ) , _ChangedByUser.UserID ), ')') AS ChangedByUserName,
  bom_header._Eqst.Equipment AS Equipment,
  cast( bom_header._Tpst.FunctionalLocation as vdm_eam_tplnr ) AS FunctionalLocation
FROM I_BillOfMaterial AS bom_header
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MaintTechObjBOMChgNumberVH AS _MaintTechObjBOMChgNumber ON EngineeringChangeDocument = _MaintTechObjBOMChgNumber.ChangeNumber AND ChangeNumberObjectType = _MaintTechObjBOMChgNumber.ChangeNumberObjectType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _MaintBillOfMaterialUsage ON BillOfMaterialVariantUsage = _MaintBillOfMaterialUsage.BillOfMaterialVariantUsage AND _MaintBillOfMaterialUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaintBillOfMaterialCategory AS _MaintBillOfMaterialCategory ON BillOfMaterialCategory = _MaintBillOfMaterialCategory.BillOfMaterialCategory AND _MaintBillOfMaterialCategory.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = equipment  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
;