I_DfsLocationAddress

DDL: I_DFSLOCATIONADDRESS Type: view BASIC

Location and Account Assignment

I_DfsLocationAddress is a Basic CDS View that provides data about "Location and Account Assignment" in SAP S/4HANA. It reads from 3 data sources (I_DfsAddress, iloa, equz) and exposes 13 fields with key fields Equipment, ValidityEndDate.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_DfsAddress _Address inner
iloa _Location inner
equz equz from

Annotations (10)

NameValueLevelField
EndUserText.label Location and Account Assignment view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IDFSLOCADDRESS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey Equipment view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Equipment equz equnr
KEY ValidityEndDate equz datbi
Location
AddressID I_DfsAddress AddressID
BusinessPartnerName1 I_DfsAddress BusinessPartnerName1
CityName I_DfsAddress CityName
StreetName I_DfsAddress StreetName
HouseNumber I_DfsAddress HouseNumber
SearchTerm1 I_DfsAddress SearchTerm1
SearchTerm2 I_DfsAddress SearchTerm2
PostalCode I_DfsAddress PostalCode
CitySearch I_DfsAddress CitySearch
StreetSearch I_DfsAddress StreetSearch 
@EndUserText.label: 'Location and Account Assignment'
@VDM.viewType: #BASIC
@AbapCatalog: { sqlViewName: 'IDFSLOCADDRESS' }
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@ObjectModel.semanticKey:  [ 'Equipment' ]
@ObjectModel.representativeKey: 'Equipment'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

define view I_DfsLocationAddress
  as select from equz  
  inner join iloa as _Location  on _Location.iloan = equz.iloan
  
 inner join I_DfsAddress     as _Address   on   _Address.AddressID = _Location.adrnr
  {
   key equz.equnr                           as Equipment, 
   key equz.datbi                           as ValidityEndDate,
       cast(equz.iloan  as abap.char(20))   as Location,   
      _Address.AddressID,
      _Address.BusinessPartnerName1,     
      _Address.CityName,  
      _Address.StreetName,
      _Address.HouseNumber,  
      _Address.SearchTerm1,  
      _Address.SearchTerm2,   
      _Address.PostalCode,
      _Address.CitySearch,
      _Address.StreetSearch
      

      
} where   equz.datbi = '99991231' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DFSADDRESS",
"EQUZ",
"ILOA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More