R_DRFMainFilterItemTP

DDL: R_DRFMAINFILTERITEMTP Type: view_entity TRANSACTIONAL
21 Fields 3 Data Sources 1 Associations

DRF Main Filter Criteria

R_DRFMainFilterItemTP is a Transactional CDS View that provides data about "DRF Main Filter Criteria" in SAP S/4HANA. It reads from 3 data sources (I_DRFFilterHeader, I_DRFFilterItem, I_DRFMainFilter) and exposes 21 fields with key fields ReplicationModel, ServiceImplementation, DRFFilterObject, DRFDataBaseKey, DRFDataBaseKeyUUID. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_DRFFilterHeader FilterHeader inner
I_DRFFilterItem FilterItem from
I_DRFMainFilter MainFilter inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DRFFilterObjectFieldNameVH _DRFFilterFields $projection.DRFFilterObject = _DRFFilterFields.DRFFilterObject and $projection.DRFFilterTable = _DRFFilterFields.DRFFilterTable and $projection.DRFFilterField = _DRFFilterFields.DRFFilterField and $projection.DRFFilterID = _DRFFilterFields.DRFFilterID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label DRF Main Filter Criteria view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ReplicationModel I_DRFFilterHeader ReplicationModel Rep. Model
KEY ServiceImplementation I_DRFMainFilter ServiceImplementation Outbound Implem.
KEY DRFFilterObject I_DRFFilterHeader DRFFilterObject Filter Object
KEY DRFDataBaseKey I_DRFFilterItem DRFDataBaseKey Character field, length 32
KEY DRFDataBaseKeyUUID I_DRFFilterItem DRFDataBaseKeyUUID UUID
DRFParentKeyUUID I_DRFFilterItem DRFParentKeyUUID UUID
DRFNodeCategoryKeyUUID I_DRFFilterItem DRFNodeCategoryKeyUUID NodeID
DRFFilterID I_DRFFilterItem DRFFilterID Universal Unique ID
DRFFilterTable I_DRFFilterItem DRFFilterTable
DRFFilterField I_DRFFilterItem DRFFilterField
DRFFilterSign I_DRFFilterItem DRFFilterSign Type of SIGN component in row type of a Ranges type
DRFFilterOption I_DRFFilterItem DRFFilterOption Type of OPTION component in row type of a Ranges type
DRFFilterValueLow I_DRFFilterItem DRFFilterValueLow Value from
DRFFilterValueHigh I_DRFFilterItem DRFFilterValueHigh Value up to
DRFFilterCreationDateTime I_DRFFilterItem DRFFilterCreationDateTime Time Stamp
DRFFilterCreatedBy I_DRFFilterItem DRFFilterCreatedBy Version Created By
DRFFilterChangeDateTime I_DRFFilterItem DRFFilterChangeDateTime Time Stamp
DRFFilterChangedBy I_DRFFilterItem DRFFilterChangedBy User Name
_DRFFilterFields _DRFFilterFields
_MainFilterHeader _MainFilterHeader
_ReplicationModel _ReplicationModel

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 R_DRFMainFilterItemTP.
-- 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 R_DRFMainFilterItemTP AS
SELECT
  FilterHeader.ReplicationModel AS ReplicationModel,
  MainFilter.ServiceImplementation AS ServiceImplementation,
  FilterHeader.DRFFilterObject AS DRFFilterObject,
  FilterItem.DRFDataBaseKey AS DRFDataBaseKey,
  FilterItem.DRFDataBaseKeyUUID AS DRFDataBaseKeyUUID,
  FilterItem.DRFParentKeyUUID AS DRFParentKeyUUID,
  FilterItem.DRFNodeCategoryKeyUUID AS DRFNodeCategoryKeyUUID,
  FilterItem.DRFFilterID AS DRFFilterID,
  FilterItem.DRFFilterTable AS DRFFilterTable,
  FilterItem.DRFFilterField AS DRFFilterField,
  FilterItem.DRFFilterSign AS DRFFilterSign,
  FilterItem.DRFFilterOption AS DRFFilterOption,
  FilterItem.DRFFilterValueLow AS DRFFilterValueLow,
  FilterItem.DRFFilterValueHigh AS DRFFilterValueHigh,
  FilterItem.DRFFilterCreationDateTime AS DRFFilterCreationDateTime,
  FilterItem.DRFFilterCreatedBy AS DRFFilterCreatedBy,
  FilterItem.DRFFilterChangeDateTime AS DRFFilterChangeDateTime,
  FilterItem.DRFFilterChangedBy AS DRFFilterChangedBy
FROM I_DRFFilterItem AS FilterItem
INNER JOIN I_DRFFilterHeader AS FilterHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_DRFMainFilter AS MainFilter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DRFFilterObjectFieldNameVH AS _DRFFilterFields ON DRFFilterObject = _DRFFilterFields.DRFFilterObject AND DRFFilterTable = _DRFFilterFields.DRFFilterTable AND DRFFilterField = _DRFFilterFields.DRFFilterField AND DRFFilterID = _DRFFilterFields.DRFFilterID  -- association [0..1]
;

Learn More