C_IntlgntEquipRetRuleRsltRecd

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 C_IntlgntEquipRetRuleRsltRecd.
-- 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 C_IntlgntEquipRetRuleRsltRecd AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  FldLogsIntlgntEquipRetRuleName,
  RemoteStorageLocation,
  _RuleDesc.FldLogsIntlgntEquipRetRuleText AS FldLogsIntlgntEquipRetRuleText,
  FldLogsRuleExecutedDateTime,
  FldLogsChangeDateTime,
  FldLogsIntlgntEquipRetStatus,
  _PrpsdReason.FldLogsRulesRecmddActnText AS FldLogsRulesRecmddActnText,
  DueDate,
  cast(dats_days_between($session.system_date,DueDate) as abap.char( 15 ) ) AS FldLogsIntlgntEquipRetDuInVal,
  cast( '' as abap.char(50)) AS FldLogsIntlgntEquipVirtualDays,
  FieldLogisticsProposedReason,
  _PrpsdReason.FldLogisticsProposedReasonText AS FldLogisticsProposedReasonText,
  FldLogsProposedReturnQuantity,
  BaseUnit
FROM I_IntlgntEquipRetRuleRsltRecd
LEFT OUTER JOIN I_IntlgntEquipRetPrpsdRsnActn AS _PrpsdReason ON FieldLogisticsProposedReason = _PrpsdReason.FieldLogisticsProposedReason  -- association [1..1]
LEFT OUTER JOIN I_IntlgntEquipRetRuleNameDesc AS _RuleDesc ON FldLogsIntlgntEquipRetRuleName = _RuleDesc.FldLogsIntlgntEquipRetRuleName  -- association [0..1]
;