C_VisualLocations

DDL: C_VISUALLOCATIONS SQL: CVISUALLOC Type: view CONSUMPTION

Location Master Data

C_VisualLocations is a Consumption CDS View that provides data about "Location Master Data" in SAP S/4HANA. It reads from 1 data source (I_VisualLocations) and exposes 15 fields with key fields CompanyCode, Plant, LocationId.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_VisualLocations a from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CVISUALLOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Location Master Data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_VisualLocations CompanyCode
KEY Plant I_VisualLocations Plant
KEY LocationId I_VisualLocations LocationId Location Id
BusinessPartnerRoleType I_VisualLocations BusinessPartnerRoleType
BusinessEntityLocationName I_VisualLocations BusinessEntityLocationName Location Description
LocationType I_VisualLocations LocationType
AddressNumber I_VisualLocations AddressNumber
CityName I_VisualLocations CityName
CountryName I_VisualLocations CountryName
Region I_VisualLocations Region
PostalCode I_VisualLocations PostalCode
Latitude I_VisualLocations Latitude
Longitude I_VisualLocations Longitude
IsBerthManaged I_VisualLocations IsBerthManaged
TankID I_VisualLocations TankID 
@AbapCatalog.sqlViewName: 'CVISUALLOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Location Master Data'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION        // this mentions that view is for odata consumption

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking :#REQUIRED

define view C_VisualLocations as select from I_VisualLocations as a
  {
    key a.CompanyCode, 
    key a.Plant,
    @EndUserText.label: 'Location Id'
    key a.LocationId,
        a.BusinessPartnerRoleType,
        @EndUserText.label: 'Location Description'
        a.BusinessEntityLocationName,
        a.LocationType, 
        a.AddressNumber, 
        a.CityName, 
        a.CountryName ,
        a.Region,
        a.PostalCode,
        a.Latitude,
        a.Longitude,
        a.IsBerthManaged,
        a.TankID
  }
 // where ( a.BusinessPartnerRoleType <> 'KN' or a.BusinessPartnerRoleType <> 'LF' )

Learn More