I_LocationAddressVH

DDL: I_LOCATIONADDRESSVH SQL: ILOCADDR_VH Type: view COMPOSITE
18 Fields 1 Data Sources

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 Text
LocationUUID LocationUUID UUID
BusinessPartnerUUID BusinessPartnerUUID UUID
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
LocationDescription
LocationType LocationType Location Type
Country _AddrDfltRprstn Country Venue: Ctry/Reg
CityName _AddrDfltRprstn CityName Name
PostalCode _AddrDfltRprstn PostalCode Postal Code
StreetName _AddrDfltRprstn StreetName Text
HouseNumber _AddrDfltRprstn HouseNumber House Number
BusinessPartner _BusinessPartner BusinessPartner Issuing Authority
GlobalLocationNumber GlobalLocationNumber GLN
LocationDUNSNumber LocationDUNSNumber DUNS+4
LocationUNCode LocationUNCode UN/LOCODE
LocationIATACode LocationIATACode IATA Code
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_LocationAddressVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ILOCADDR_VH

CREATE VIEW I_LocationAddressVH AS
SELECT
  Location,
  LocationUUID,
  BusinessPartnerUUID,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  _Text[1:Language= $session.system_language].LocationDescription AS LocationDescription,
  LocationType,
  _AddrDfltRprstn.Country AS Country,
  _AddrDfltRprstn.CityName AS CityName,
  _AddrDfltRprstn.PostalCode AS PostalCode,
  _AddrDfltRprstn.StreetName AS StreetName,
  _AddrDfltRprstn.HouseNumber AS HouseNumber,
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  GlobalLocationNumber,
  LocationDUNSNumber,
  LocationUNCode,
  LocationIATACode
FROM I_LocationBasic
;

Learn More