I_DFSADDRESS
Address
I_DFSADDRESS is a CDS View in S/4HANA. Address. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DfsLocationAddress | view | inner | BASIC | Location and Account Assignment |
Fields (10)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AddressID | AddressID | 1 | |
| BusinessPartnerName1 | BusinessPartnerName1 | 1 | |
| CityName | CityName | 1 | |
| CitySearch | CitySearch | 1 | |
| HouseNumber | HouseNumber | 1 | |
| PostalCode | PostalCode | 1 | |
| SearchTerm1 | SearchTerm1 | 1 | |
| SearchTerm2 | SearchTerm2 | 1 | |
| StreetName | StreetName | 1 | |
| StreetSearch | StreetSearch | 1 |
@AbapCatalog.sqlViewName: 'IDFSADDRESS'
@EndUserText.label: 'Address'
//@Analytics : {dataCategory: #DIMENSION}
@AccessControl.authorizationCheck:#MANDATORY
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'AddressID'
//@Metadata.allowExtensions:true
@AbapCatalog.compiler.compareFilter:true
define view I_DfsAddress
as select from adrc
{
key adrc.addrnumber as AddressID,
adrc_uuid as AddressUUID,
langu as CorrespondenceLanguage,
city1 as CityName,
post_code1 as PostalCode,
street as StreetName,
house_num1 as HouseNumber,
//country as Country,
region as Region,
//county as County,
name1 as BusinessPartnerName1,
name2 as BusinessPartnerName2,
adrc.nation as Nation,
adrc.sort1 as SearchTerm1,
adrc.sort2 as SearchTerm2,
mc_street as StreetSearch,
mc_city1 as CitySearch,
name3 as BusinessPartnerName3,
name4 as BusinessPartnerName4
}
where
adrc.date_from = '00010101'
and adrc.nation = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/