I_DFS_EquipmentDEX

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_EquipmentDEX.
-- 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.

CREATE VIEW I_DFS_EquipmentDEX AS
SELECT
  _DFS_EquipmentBasicDEX.Equipment AS Equipment,
  _DFS_EquipmentBasicDEX.DfsMaintTailNumber AS DfsMaintTailNumber,
  _DFS_EquipmentBasicDEX.DfsMaintRemarkText AS DfsMaintRemarkText,
  _DFS_EquipmentBasicDEX.DfsMaintActualConfiguration AS DfsMaintActualConfiguration,
  _DFS_EquipmentBasicDEX.DfsMaintIsForeignEquipment AS DfsMaintIsForeignEquipment,
  _DFS_EquipmentBasicDEX.DfsMaintPrioritizationCategory AS DfsMaintPrioritizationCategory,
  _DFS_EquipmentBasicDEX.DfsMaintUsagePrefPriority AS DfsMaintUsagePrefPriority,
  _DFS_EquipmentBasicDEX.DfsMaintEquipOplObjNmbr AS DfsMaintEquipOplObjNmbr,
  _DFS_EquipmentBasicDEX.DfsMaintMasterEquipTechObjNmbr AS DfsMaintMasterEquipTechObjNmbr,
  _DFS_EquipmentBasicDEX.DfsMaintModelIdentification AS DfsMaintModelIdentification,
  _DFS_EquipmentBasicDEX.DfsMaintMeasuringPoint AS DfsMaintMeasuringPoint,
  _DFS_EquipmentBasicDEX.DfsMaintSiteID AS DfsMaintSiteID,
  _DFS_EquipmentBasicDEX.DfsMaintEquipmentType AS DfsMaintEquipmentType,
  _DFS_EquipmentBasicDEX.DfsMaintIsMasterEquipment AS DfsMaintIsMasterEquipment,
  _DFS_EquipmentBasicDEX.DfsMaintTechStsAggrgnIsStppd AS DfsMaintTechStsAggrgnIsStppd,
  _DFS_EquipmentBasicDEX.DfsMaintSiteDescription AS DfsMaintSiteDescription,
  _DFS_EquipmentBasicDEX.DfsMaintAreaID AS DfsMaintAreaID,
  _DFS_EquipmentBasicDEX.DfsMaintAreaDescription AS DfsMaintAreaDescription,
  _DFS_EquipmentBasicDEX.DfsMaintEquipOplStatusProfile AS DfsMaintEquipOplStatusProfile,
  _DFS_EquipmentBasicDEX.DfsMaintEquipTechStatusProfile AS DfsMaintEquipTechStatusProfile,
  _DFS_EquipmentBasicDEX.DfsMaintEquipTechStsPrflName AS DfsMaintEquipTechStsPrflName,
  _DFS_EquipmentBasicDEX.DfsMaintModelDescription AS DfsMaintModelDescription,
  _DFS_EquipmentBasicDEX.Material AS Material,
  _DFS_EquipmentBasicDEX.MaintObjectInternalID AS MaintObjectInternalID,
  _DFS_EquipmentBasicDEX.TechnicalObjectType AS TechnicalObjectType,
  _DFS_EquipmentBasicDEX.InventoryNumber AS InventoryNumber,
  _DFS_EquipmentBasicDEX.Plant AS Plant,
  _DFS_EquipmentBasicDEX.AcquisitionValue AS AcquisitionValue,
  _DFS_EquipmentBasicDEX.Currency AS Currency,
  _DFS_EquipmentBasicDEX.AcquisitionDate AS AcquisitionDate,
  _DFS_EquipmentBasicDEX.CreationDate AS CreationDate,
  _DFS_EquipmentBasicDEX.LastChangeDate AS LastChangeDate,
  _DFS_EquipmentBasicDEX.LastChangeDateTime AS LastChangeDateTime,
  _DFS_EquipmentBasicDEX.OperationStartDate AS OperationStartDate,
  _DFS_EquipmentBasicDEX.StorageLocation AS StorageLocation,
  _DFS_EquipmentBasicDEX.Batch AS Batch,
  _DFS_EquipmentBasicDEX.EquipmentCategory AS EquipmentCategory,
  _DFS_EquipmentBasicDEX.Batch AS MaterialSerialNumberStockBatch,
  cast('' as abap.char(30)) AS DefenseTopFunctionalLocation,
  _DFS_EquipmentBasicDEX.ForceElementOrgID AS ForceElementOrgID,
  _DFS_UniversalAssignmentBasic.FrcElmntOrgOpExerciseID AS FrcElmntOrgOpExerciseID,
  _DFS_UniversalAssignmentBasic.FrcElmntOrgRotationKey AS FrcElmntOrgRotationKey,
  _DFS_UniversalAssignmentBasic.FrcElmntOrgForceProviderID AS FrcElmntOrgForceProviderID,
  _DFS_UniversalAssignmentBasic.FrcElmntOrgInitialMatlSuplrID AS FrcElmntOrgInitialMatlSuplrID,
  _DFS_UniversalAssignmentBasic.FrcElmntOrgInitialPersSuplrID AS FrcElmntOrgInitialPersSuplrID,
  cast('' as abap.char(32)) AS DfsMaintenanceDeviceIdentifier
FROM I_DFS_EquipmentBasicDEX AS _DFS_EquipmentBasicDEX
LEFT OUTER JOIN I_DFS_UniversalAssignmentBasic AS _DFS_UniversalAssignmentBasic ON _DFS_UniversalAssignmentBasic.ForceElementOrgSrceID = ForceElementOrgID AND _DFS_UniversalAssignmentBasic.DfsAssgmtStatusCode = 'IDFS4' AND _DFS_UniversalAssignmentBasic.DfsAssgmtValdtyStrtDate <= $session.user_date AND _DFS_UniversalAssignmentBasic.DfsAssgmtValdtyEndDate >= $session.user_date AND _DFS_UniversalAssignmentBasic.DfsAssgmtType = 'OPER'  -- association [1..*]
;