I_LocationAddressVH

DDL: I_LOCATIONADDRESSVH SQL: ILOCADDR_VH Type: view COMPOSITE

Location Value help with Address Attributes

I_LocationAddressVH is a Composite CDS View that provides data about "Location Value help with Address Attributes" in SAP S/4HANA. It reads from 1 data source (I_LocationBasic) and exposes 18 fields with key field Location.

Data Sources (1)

SourceAliasJoin Type
I_LocationBasic I_LocationBasic from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ILOCADDR_VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Location view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Location Value help with Address Attributes view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Location Location
LocationUUID LocationUUID
BusinessPartnerUUID BusinessPartnerUUID
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
LocationDescription
LocationType LocationType
Country _AddrDfltRprstn Country
CityName _AddrDfltRprstn CityName
PostalCode _AddrDfltRprstn PostalCode
StreetName _AddrDfltRprstn StreetName
HouseNumber _AddrDfltRprstn HouseNumber
BusinessPartner _BusinessPartner BusinessPartner
GlobalLocationNumber GlobalLocationNumber
LocationDUNSNumber LocationDUNSNumber
LocationUNCode LocationUNCode
LocationIATACode LocationIATACode
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'ILOCADDR_VH'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'Location'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Location Value help with Address Attributes'
define view I_LocationAddressVH
  as select from I_LocationBasic
{

      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @UI: {lineItem: [ {position: 10, label: 'Location'} ]}
  key Location                                                        as Location,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      LocationUUID,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      BusinessPartnerUUID,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      AuthorizationGroup,
      @Consumption.filter.hidden: true
      @UI.hidden: true
      @Semantics.booleanIndicator: true
      IsBusinessPurposeCompleted,
      @UI: {lineItem: [ {position: 20, label: 'Location Description'} ]}
      @Search.defaultSearchElement: true
      _Text[1:Language= $session.system_language].LocationDescription as LocationDescription,

      LocationType                                                    as LocationType,

      @Semantics.address.country: true
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CountryVH', element: 'Country' } } ]
      _AddrDfltRprstn.Country                                         as Country,

      @Search.defaultSearchElement: true          
      _AddrDfltRprstn.CityName                                        as CityName,

      _AddrDfltRprstn.PostalCode                                      as PostalCode,

      _AddrDfltRprstn.StreetName                                      as StreetName,

      _AddrDfltRprstn.HouseNumber                                     as HouseNumber, 

      _BusinessPartner.BusinessPartner                                as BusinessPartner,

      GlobalLocationNumber                                            as GlobalLocationNumber,

      LocationDUNSNumber                                              as LocationDUNSNumber,

      LocationUNCode                                                  as LocationUNCode,

      @Consumption.filter.hidden: true
      @UI.hidden: true
      LocationIATACode                                                as LocationIATACode,

      _BusinessPartner



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSDEFAULTREPRESENTATION",
"I_LOCATIONBASIC",
"I_LOCATIONTEXT",
"I_TMBUSINESSPARTNERBYINTKEY"
],
"ASSOCIATED":
[
"I_TMBUSINESSPARTNERBYINTKEY"
],
"BASE":
[
"I_LOCATIONBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/