I_LocationAddressVH

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

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. It is exposed through 1 OData service (LMD_ROUTE_MONITOR_SD).

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

OData Services (1)

ServiceBindingVersionContractRelease
LMD_ROUTE_MONITOR_SD LMD_ROUTE_MONITOR_SB_UI_V2 V2 C1 NOT_RELEASED

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