I_DFS_MaintCritlEquipStructure

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_DFS_MaintCritlEquipStructure.
-- 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: IDFSCEQSTRUC
-- Parameters: P_equipment : equnr

CREATE VIEW I_DFS_MaintCritlEquipStructure AS
SELECT
  _MaintEquipTechStsHier.Equipment AS Equipment,
  _MaintEquipTechStsHier.FunctionalLocation AS DfsMaintFunctionalLocation,
  _MaintEquipTechStsHier.DfsMaintTechStsAggrgnIsStppd AS DfsMaintTechStsAggrgnIsStppd,
  _MaintEquipTechStsHier.DfsMaintEquipTechStatusProfile AS DfsMaintEquipTechStatusProfile,
  _MaintEquipTechStsHier.DfsMaintSuperordinateEquipNmbr AS DfsMaintSuperordinateEquipNmbr,
  _MaintEquipTechStsHier.DfsMaintEquipmentType AS DfsMaintEquipmentType,
  _MaintStsBrdCriticalEquip.FunctionalLocationName AS FunctionalLocationName,
  _MaintStsBrdCriticalEquip.EquipmentName AS EquipmentName,
  _MaintStsBrdCriticalEquip.SuperordinateEquipment AS SuperordinateEquipment,
  _MaintStsBrdCriticalEquip.DfsMaintSuperordinateEquipName AS DfsMaintSuperordinateEquipName,
  _MaintStsBrdCriticalEquip.DfsMaintTailNumber AS DfsMaintTailNumber,
  _MaintStsBrdCriticalEquip.DfsMaintRemarkText AS DfsMaintRemarkText,
  _MaintStsBrdCriticalEquip.DfsMaintActualConfiguration AS DfsMaintActualConfiguration,
  _MaintStsBrdCriticalEquip.DfsMaintForeignEquipIdfgText AS DfsMaintForeignEquipIdfgText,
  _MaintStsBrdCriticalEquip.DfsMaintUsagePrefPriority AS DfsMaintUsagePrefPriority,
  _MaintStsBrdCriticalEquip.DfsMaintEquipOplObjNmbr AS DfsMaintEquipOplObjNmbr,
  _MaintStsBrdCriticalEquip.DfsMaintMasterEquipTechObjNmbr AS DfsMaintMasterEquipTechObjNmbr,
  _MaintStsBrdCriticalEquip.DfsMaintModelIdentification AS DfsMaintModelIdentification,
  _MaintStsBrdCriticalEquip.DfsMaintSiteID AS DfsMaintSiteID,
  _MaintStsBrdCriticalEquip.DfsMaintSiteDescription AS DfsMaintSiteDescription,
  _MaintStsBrdCriticalEquip.DfsMaintEquipOplStsShrtName AS DfsMaintEquipOplStsShrtName,
  _MaintStsBrdCriticalEquip.DfsMaintEquipStatusIcon AS DfsMaintEquipStatusIcon,
  _MaintStsBrdCriticalEquip.DfsMaintEquipOplStatusProfile AS DfsMaintEquipOplStatusProfile,
  _MaintStsBrdCriticalEquip.DfsMaintEquipTechStsShrtName AS DfsMaintEquipTechStsShrtName,
  _MaintStsBrdCriticalEquip.DfsMaintEquipTechStsLongName AS DfsMaintEquipTechStsLongName,
  _MaintStsBrdCriticalEquip.DfsMaintModelDescription AS DfsMaintModelDescription,
  _MaintStsBrdCriticalEquip.DfsMaintMaterialSerialNumber AS DfsMaintMaterialSerialNumber,
  _MaintStsBrdCriticalEquip.Material AS Material,
  _MaintStsBrdCriticalEquip.MaintObjectInternalID AS MaintObjectInternalID,
  _MaintStsBrdCriticalEquip.DfsMaintOperationalRole AS DfsMaintOperationalRole,
  _MaintStsBrdCriticalEquip.DfsMaintOperationalRoleDesc AS DfsMaintOperationalRoleDesc,
  _MaintStsBrdCriticalEquip.FlxMtPlObjRIC AS FlxMtPlObjRIC,
  _MaintStsBrdCriticalEquip.FlxMtPlObjRICDescription AS FlxMtPlObjRICDescription,
  _MaintStsBrdCriticalEquip.FlxblMatlPlngObjectID AS FlxblMatlPlngObjectID,
  _MaintStsBrdCriticalEquip.FlxblMatlPlngObjDescription AS FlxblMatlPlngObjDescription,
  _MaintStsBrdCriticalEquip.WorkCenter AS WorkCenter,
  _MaintStsBrdCriticalEquip.WorkCenterText AS WorkCenterText,
  _MaintStsBrdCriticalEquip.Plant AS Plant,
  _MaintStsBrdCriticalEquip.DfsMaintEquipmentUtilizerID AS DfsMaintEquipmentUtilizerID,
  _MaintStsBrdCriticalEquip.DfsMaintEquipmentUtilizerName AS DfsMaintEquipmentUtilizerName,
  _MaintStsBrdCriticalEquip.DfsMaintEquipStorageLocation AS DfsMaintEquipStorageLocation,
  _MaintStsBrdCriticalEquip.FrcElmntOrgMRPStockArea AS FrcElmntOrgMRPStockArea,
  _MaintStsBrdCriticalEquip.FrcElmntOrgPrvsnMRPArea AS FrcElmntOrgPrvsnMRPArea,
  _MaintStsBrdCriticalEquip.DfsMaintCriticalityText AS DfsMaintCriticalityText,
  _MaintStsBrdCriticalEquip.DfsMaintNumberOfNotifications AS DfsMaintNumberOfNotifications,
  _MaintStsBrdCriticalEquip.DfsMaintNumberOfWorkOrders AS DfsMaintNumberOfWorkOrders,
  _MaintStsBrdCriticalEquip.DfsMaintExplosionType AS DfsMaintExplosionType,
  _MaintStsBrdCriticalEquip.DfsMaintFrcElmntOrgRoleText AS DfsMaintFrcElmntOrgRoleText,
  _MaintStsBrdCriticalEquip._MaintEquipmentTechStatus AS _MaintEquipmentTechStatus,
  _MaintStsBrdCriticalEquip.DfsMaintOplStsIconURL AS DfsMaintOplStsIconURL,
  _MaintStsBrdCriticalEquip.DfsMaintTechStsIconURL AS DfsMaintTechStsIconURL,
  _MaintStsBrdCriticalEquip.DfsMaintEquipUserStsShortName AS DfsMaintEquipUserStsShortName,
  _MaintStsBrdCriticalEquip.DfsMaintEquipSystStsShortName AS DfsMaintEquipSystStsShortName,
  _MaintStsBrdCriticalEquip.DfsMaintTechStsAggrgnExecText AS DfsMaintTechStsAggrgnExecText,
  cast( '' as abap.char(40)) AS TechObjectWithLeadingZeros
FROM I_DFS_MaintEquipTechStsHier
LEFT OUTER JOIN I_DFS_MaintStsBrdCriticalEquip AS _MaintStsBrdCriticalEquip ON _MaintStsBrdCriticalEquip.Equipment = _MaintEquipTechStsHier.Equipment  -- association [0..1]
;