I_DfsAddress

DDL: I_DFSADDRESS SQL: IDFSADDRESS Type: view BASIC

Address

I_DfsAddress is a Basic CDS View that provides data about "Address" in SAP S/4HANA. It reads from 1 data source (adrc) and exposes 17 fields with key field AddressID.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
adrc adrc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFSADDRESS view
EndUserText.label Address view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey AddressID view
AbapCatalog.compiler.compareFilter true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY AddressID adrc addrnumber
AddressUUID adrc_uuid
CorrespondenceLanguage langu
CityName city1
PostalCode post_code1
StreetName street
HouseNumber house_num1
Region region
BusinessPartnerName1 name1
BusinessPartnerName2 name2
Nation adrc nation
SearchTerm1 adrc sort1
SearchTerm2 adrc sort2
StreetSearch mc_street
CitySearch mc_city1
BusinessPartnerName3 name3
BusinessPartnerName4 name4 
@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":""
}
}*/

Learn More