fndei_adr2_filter

DDL: FNDEI_ADR2_FILTER SQL: FNDEIFADR2 Type: view

Filter View for table ADR2

fndei_adr2_filter is a CDS View that provides data about "Filter View for table ADR2" in SAP S/4HANA. It reads from 2 data sources (adr2, FNDEI_ADR2_BLOCKINGINFO) and exposes 18 fields with key fields client, addrnumber, persnumber, date_from, consnumber.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
adr2 adr2 from
FNDEI_ADR2_BLOCKINGINFO FNDEI_ADR2_BLOCKINGINFO inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIFADR2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Filter View for table ADR2 view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY client adr2 client
KEY addrnumber adr2 addrnumber
KEY persnumber adr2 persnumber
KEY date_from adr2 date_from
KEY consnumber adr2 consnumber
country adr2 country
flgdefault adr2 flgdefault
flg_nouse adr2 flg_nouse
home_flag adr2 home_flag
tel_number adr2 tel_number
tel_extens adr2 tel_extens
telnr_long adr2 telnr_long
telnr_call adr2 telnr_call
dft_receiv adr2 dft_receiv
r3_user adr2 r3_user
valid_from adr2 valid_from
valid_to adr2 valid_to
_dataaging adr2 _dataaging 
@AbapCatalog.sqlViewName: 'FNDEIFADR2'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'Filter View for table ADR2'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
define view fndei_adr2_filter as select from adr2 inner join FNDEI_ADR2_BLOCKINGINFO
      on  adr2.client = FNDEI_ADR2_BLOCKINGINFO.client
      and adr2.addrnumber = FNDEI_ADR2_BLOCKINGINFO.addrnumber
      and adr2.persnumber = FNDEI_ADR2_BLOCKINGINFO.persnumber 
      and adr2.date_from = FNDEI_ADR2_BLOCKINGINFO.date_from
      and adr2.consnumber = FNDEI_ADR2_BLOCKINGINFO.consnumber {
key adr2.client,
key adr2.addrnumber,
key adr2.persnumber,
key adr2.date_from,
key adr2.consnumber,
adr2.country,
adr2.flgdefault,
adr2.flg_nouse,
adr2.home_flag,
adr2.tel_number,
adr2.tel_extens,
adr2.telnr_long,
adr2.telnr_call,
adr2.dft_receiv,
adr2.r3_user ,
adr2.valid_from,
adr2.valid_to,
adr2._dataaging
}
where FNDEI_ADR2_BLOCKINGINFO.NotBlocked = 'X' 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FNDEI_ADR2_BLOCKINGINFO",
"ADR2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More