I_IntlgntEquipRetsFcstdRet

DDL: I_INTLGNTEQUIPRETSFCSTDRET Type: view_entity COMPOSITE
13 Fields 1 Data Sources 1 Associations

Forecasted Returns

I_IntlgntEquipRetsFcstdRet is a Composite CDS View that provides data about "Forecasted Returns" in SAP S/4HANA. It reads from 1 data source (I_NetReturnStock) and exposes 13 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_NetReturnStock I_NetReturnStock from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_IntlgntEquipRetRulesRsltFnl _RulesFinal $projection.Material = _RulesFinal.Material and $projection.FldLogsRemotePlant = _RulesFinal.FldLogsRemotePlant and $projection.FldLogsReferenceDocumentNumber = _RulesFinal.FldLogsReferenceDocumentNumber and $projection.ReferenceDocumentItem = _RulesFinal.ReferenceDocumentItem and $projection.FldLogsMaintenanceOrder = _RulesFinal.FldLogsMaintenanceOrder and $projection.RemoteStorageLocation = _RulesFinal.RemoteStorageLocation

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Forecasted Returns view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY FldLogsRemotePlant FldLogsRemotePlant Plant
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder FldLogsMaintenanceOrder
KEY RemoteStorageLocation RemoteStorageLocation
PurchasingDocument ReferencePurchasingDocument Purchasing Doc.
FldLogsSupplyProcess Supply Process
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
IntlgntEquipRetRecmddActn _RulesFinal IntlgntEquipRetRecmddActn
FldLogsPlndSrvcEndDate _RulesFinal DueDate Promised For
FldLogsTotNumberOfReturnReq
_RulesFinal _RulesFinal

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_IntlgntEquipRetsFcstdRet.
-- 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_IntlgntEquipRetsFcstdRet AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  ReferencePurchasingDocument AS PurchasingDocument,
  cast( FldLogsSupplyProcess as flog_sproc preserving type ) AS FldLogsSupplyProcess,
  IsMarkedForDeletion,
  _RulesFinal.IntlgntEquipRetRecmddActn AS IntlgntEquipRetRecmddActn,
  _RulesFinal.DueDate AS FldLogsPlndSrvcEndDate,
  cast( 1 as abap.int4 ) AS FldLogsTotNumberOfReturnReq
FROM I_NetReturnStock
LEFT OUTER JOIN I_IntlgntEquipRetRulesRsltFnl AS _RulesFinal ON Material = _RulesFinal.Material AND FldLogsRemotePlant = _RulesFinal.FldLogsRemotePlant AND FldLogsReferenceDocumentNumber = _RulesFinal.FldLogsReferenceDocumentNumber AND ReferenceDocumentItem = _RulesFinal.ReferenceDocumentItem AND FldLogsMaintenanceOrder = _RulesFinal.FldLogsMaintenanceOrder AND RemoteStorageLocation = _RulesFinal.RemoteStorageLocation  -- association [0..1]
;

Learn More