I_DRFFilter

DDL: I_DRFFILTER Type: view_entity COMPOSITE
7 Fields 6 Data Sources

Available Filters for ETAG fulfillment

I_DRFFilter is a Composite CDS View that provides data about "Available Filters for ETAG fulfillment" in SAP S/4HANA. It reads from 6 data sources and exposes 7 fields with key fields ReplicationModel, ServiceImplementation, DRFFilterObject, ServiceImplementation, DRFFilterObject.

Data Sources (6)

SourceAliasJoin Type
I_DRFFilterHeader FilterHeader inner
I_DRFFilterHeader FilterHeader inner
I_DRFFilterItem FilterItem from
I_DRFFilterItem FilterItem union
I_DRFMainFilter MainFilter inner
I_DRFSegmentedFilter SegmentedFilter inner

Annotations (7)

NameValueLevelField
EndUserText.label Available Filters for ETAG fulfillment view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ReplicationModel I_DRFFilterHeader ReplicationModel Rep. Model
KEY ServiceImplementation I_DRFSegmentedFilter ServiceImplementation Outbound Implem.
KEY DRFFilterObject I_DRFFilterHeader DRFFilterObject Filter Object
ReplicationModel Rep. Model
KEY ServiceImplementation I_DRFMainFilter ServiceImplementation Outbound Implem.
KEY DRFFilterObject I_DRFFilterHeader DRFFilterObject Filter Object
DRFLastChangedDateTime I_DRFFilterItem DRFFilterChangeDateTime Time Stamp

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_DRFFilter.
-- 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_DRFFilter AS
SELECT
  FilterHeader.ReplicationModel AS ReplicationModel,
  SegmentedFilter.ServiceImplementation AS ServiceImplementation,
  FilterHeader.DRFFilterObject AS DRFFilterObject,
  FilterItem.DRFFilterChangeDateTime AS DRFLastChangedDateTime
FROM I_DRFFilterItem AS FilterItem
INNER JOIN I_DRFFilterHeader AS FilterHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_DRFSegmentedFilter AS SegmentedFilter ON /* join condition not captured in parsed metadata */
INNER JOIN I_DRFMainFilter AS MainFilter ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_DRFFilterItem
;

Learn More