I_IntlgntEquipRetRuleRsltRecd

DDL: I_INTLGNTEQUIPRETRULERSLTRECD Type: view_entity BASIC
16 Fields 1 Data Sources

Rule Result Table Selection

I_IntlgntEquipRetRuleRsltRecd is a Basic CDS View that provides data about "Rule Result Table Selection" in SAP S/4HANA. It reads from 1 data source (flog_ier_return) and exposes 16 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder.

Data Sources (1)

SourceAliasJoin Type
flog_ier_return flog_ier_return from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Rule Result Table Selection view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Material matnr Vehicle Model
KEY FldLogsRemotePlant plant Valuation Area
KEY FldLogsReferenceDocumentNumber ref_doc Reference Key
KEY ReferenceDocumentItem ref_docitem Ref. Doc. Item
KEY FldLogsMaintenanceOrder work_order Order
KEY FldLogsIntlgntEquipRetRuleName rule_name Symbol.Name
KEY RemoteStorageLocation remote_lgort Location
FldLogsRuleExecutedDateTime rule_executed_on Time Stamp
FldLogsChangeDateTime last_updated_on Changed On
FldLogsIntlgntEquipRetStatus status Workflow Status
DueDate due_date Net Due Date
FieldLogisticsProposedReason proposed_reason Proposed Reason
FldLogsProposedReturnQuantity quantity Value
BaseUnit unit UoM
FldLogsRecommendedAction proposed_action Recommended Action
FieldLogisticsRulesPriority priority Workflow priority

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_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 I_IntlgntEquipRetRuleRsltRecd AS
SELECT
  matnr AS Material,
  plant AS FldLogsRemotePlant,
  ref_doc AS FldLogsReferenceDocumentNumber,
  ref_docitem AS ReferenceDocumentItem,
  work_order AS FldLogsMaintenanceOrder,
  rule_name AS FldLogsIntlgntEquipRetRuleName,
  remote_lgort AS RemoteStorageLocation,
  rule_executed_on AS FldLogsRuleExecutedDateTime,
  last_updated_on AS FldLogsChangeDateTime,
  status AS FldLogsIntlgntEquipRetStatus,
  due_date AS DueDate,
  proposed_reason AS FieldLogisticsProposedReason,
  quantity AS FldLogsProposedReturnQuantity,
  unit AS BaseUnit,
  proposed_action AS FldLogsRecommendedAction,
  priority AS FieldLogisticsRulesPriority
FROM flog_ier_return
;

Learn More