R_MDODRFAPPLFILTERBASE

DDL: R_MDODRFAPPLFILTERBASE Type: view_entity Package: MDO_DRF_MODEL

DRF Filters Base View

R_MDODRFAPPLFILTERBASE is a CDS View that provides data about "DRF Filters Base View" in SAP S/4HANA. It reads from 2 data sources (drfd_appl_filt_c, drfd_appl_filt_h) and exposes 13 fields with key fields DbNameLongH, DbNameLongC. Part of development package MDO_DRF_MODEL.

Data Sources (2)

SourceAliasJoin Type
drfd_appl_filt_c content inner
drfd_appl_filt_h header from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DRF Filters Base View view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DbNameLongH drfd_appl_filt_h db_name_long Character field, length 32
KEY DbNameLongC drfd_appl_filt_c db_name_long Character field, length 32
Id drfd_appl_filt_h id WorklistID
Appl drfd_appl_filt_h appl Rep. Model
Fobj drfd_appl_filt_h fobj Filter Object
ServImpl drfd_appl_filt_h serv_impl Outbound Implem.
FilterId drfd_appl_filt_c filter_id Universal Unique ID
TableName drfd_appl_filt_c table_name Table Name
FieldName drfd_appl_filt_c field_name VAT Declaration Fld
Sign drfd_appl_filt_c sign Type of SIGN component in row type of a Ranges type
Opt drfd_appl_filt_c opt Type of OPTION component in row type of a Ranges type
Low drfd_appl_filt_c low Value from
High drfd_appl_filt_c high Value up to

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_MDODRFAPPLFILTERBASE.
-- 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_MDODRFAPPLFILTERBASE AS
SELECT
  header.db_name_long AS DbNameLongH,
  content.db_name_long AS DbNameLongC,
  header.id AS Id,
  header.appl AS Appl,
  header.fobj AS Fobj,
  header.serv_impl AS ServImpl,
  content.filter_id AS FilterId,
  content.table_name AS TableName,
  content.field_name AS FieldName,
  content.sign AS Sign,
  content.opt AS Opt,
  content.low AS Low,
  content.high AS High
FROM drfd_appl_filt_h AS header
INNER JOIN drfd_appl_filt_c AS content ON /* join condition not captured in parsed metadata */
;