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.

1 data source(s) 9 fields

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
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
virtualElement
virtualElement2
virtualNumber 
@AbapCatalog.sqlViewName: 'SADLVEFIRE'
@EndUserText.label: 'Filter Restriction'

@Consumption.semanticObject: 'SalesOrder'

define view Sadl_V_Exp_Filter_Restriction
  as select from snwd_so as header
//  association [0..*] to Sadl_V_Exp_Currency_Text      as _currencyText on $projection.CurrencyCode = _currencyText.Currency

{
  key header.so_id                            as SalesOrder,

      @EndUserText.label: 'Single Values'
      @Consumption.filter.selectionType: #SINGLE
      @Consumption.filter.mandatory: true
      header.so_id                            as SingleValues,

      @EndUserText.label: 'Multiple Values'
      @Consumption.filter.selectionType: #SINGLE
      @Consumption.filter.multipleSelections: true
      @Consumption.filter.mandatory: true
      header.so_id                            as MultipleValues,

      @EndUserText.label: 'Interval Filter'
      @Consumption.filter.selectionType: #INTERVAL
      header.so_id                            as IntervalSelection,

      @EndUserText.label: 'Unsupported Filter'
      @Consumption.filter.selectionType: #RANGE
      header.so_id                            as UnsupportedSelection,

      @ObjectModel.text.association: '_currencyText'
      header.currency_code                    as CurrencyCode, 

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy:    'ABAP:ZCL_VIRTUALCALCULATION2'
      @ObjectModel.filter.transformedBy:          'ABAP:ZCL_FILTER_VIRTUALELEMENT2'
      @ObjectModel.sort.transformedBy:            'ABAP:ZCL_FILTER_VIRTUALELEMENT2'
      @ObjectModel.filter.enabled: false                  // do not change -> required for unittest

      @ObjectModel.sort.enabled: false                    // do not change -> required for unittest

      cast( 1 as abap.char(60) )              as virtualElement,

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy:    'ABAP:ZCL_VIRTUALCALCULATION2'

      @ObjectModel.filter.enabled: true                   // do not change -> required for unittest

      @ObjectModel.sort.enabled: true                     // do not change -> required for unittest

      cast( 1 as abap.char(60) )              as virtualElement2,

      cast( '0000000000' as abap.numc( 10 ) ) as virtualNumber

//      @ObjectModel.filter.enabled: false                  // do not change -> required for unittest

//      @ObjectModel.sort.enabled: false                    // do not change -> required for unittest

//      _currencyText


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More