I_LocationBasicStdVH

DDL: I_LOCATIONBASICSTDVH SQL: ILB__VH Type: view COMPOSITE
14 Fields 1 Data Sources

Location

I_LocationBasicStdVH is a Composite CDS View that provides data about "Location" in SAP S/4HANA. It reads from 1 data source (I_LocationBasic) and exposes 14 fields with key field LocationUUID.

Data Sources (1)

SourceAliasJoin Type
I_LocationBasic I_LocationBasic from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ILB__VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey LocationUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Location view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY LocationUUID LocationUUID UUID
LocationAdditionalUUID LocationAdditionalUUID
Location Location Text
LocationType LocationType Location Type
LocationIATACode LocationIATACode IATA Code
LocationUNCode LocationUNCode UN/LOCODE
LocationIsMarkedForDeletion LocationIsMarkedForDeletion Stock del. flag
BusinessPartnerUUID BusinessPartnerUUID UUID
CollaborationPartner CollaborationPartner
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
_Text _Text
_BusinessPartner _BusinessPartner
_CollaborationPartner _CollaborationPartner

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_LocationBasicStdVH.
-- 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: ILB__VH

CREATE VIEW I_LocationBasicStdVH AS
SELECT
  LocationUUID,
  LocationAdditionalUUID,
  Location,
  LocationType,
  LocationIATACode,
  LocationUNCode,
  LocationIsMarkedForDeletion,
  BusinessPartnerUUID,
  CollaborationPartner,
  AuthorizationGroup,
  IsBusinessPurposeCompleted
FROM I_LocationBasic
;

Learn More