Sadl_V_Exp_Filter_Restriction

DDL: SADL_V_EXP_FILTER_RESTRICTION SQL: SADLVEFIRE Type: view

Filter Restriction

Sadl_V_Exp_Filter_Restriction is a CDS View that provides data about "Filter Restriction" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 9 fields with key field SalesOrder.

Data Sources (1)

SourceAliasJoin Type
snwd_so header from

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName SADLVEFIRE view
EndUserText.label Filter Restriction view
Consumption.semanticObject SalesOrder view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder snwd_so so_id Sales Order ID
SingleValues snwd_so so_id Single Values
MultipleValues snwd_so so_id Multiple Values
IntervalSelection snwd_so so_id Interval Filter
UnsupportedSelection snwd_so so_id Unsupported Filter
CurrencyCode snwd_so currency_code Currency Code
virtualElement
virtualElement2
virtualNumber

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 Sadl_V_Exp_Filter_Restriction.
-- 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.
-- SQL view name: SADLVEFIRE

CREATE VIEW Sadl_V_Exp_Filter_Restriction AS
SELECT
  header.so_id AS SalesOrder,
  header.so_id AS SingleValues,
  header.so_id AS MultipleValues,
  header.so_id AS IntervalSelection,
  header.so_id AS UnsupportedSelection,
  header.currency_code AS CurrencyCode,
  cast( 1 as abap.char(60) ) AS virtualElement,
  cast( 1 as abap.char(60) ) AS virtualElement2,
  cast( '0000000000' as abap.numc( 10 ) ) AS virtualNumber
FROM snwd_so AS header
;