I_TranspIATALocationCode

DDL: I_TRANSPIATALOCATIONCODE SQL: IIATALOCC Type: view BASIC

Transportation IATA Location Codes

I_TranspIATALocationCode is a Basic CDS View that provides data about "Transportation IATA Location Codes" in SAP S/4HANA. It reads from 1 data source (/scmtms/c_iatac) and exposes 8 fields with key field LocationIATACode. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
/scmtms/c_iatac /scmtms/c_iatac from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TranspIATALocationCodeText _Text $projection.LocationIATACode = _Text.LocationIATACode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IIATALOCC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey LocationIATACode view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #NONE view
EndUserText.label Transportation IATA Location Codes view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY LocationIATACode iatac
Country country
Region region
OrganizationalUnitExternalID exec_org_id
Longitude xpos
Latitude ypos
LocationTimeZone tzone
_Text _Text 
@AbapCatalog.sqlViewName: 'IIATALOCC'
@AbapCatalog.compiler.compareFilter:        true
@AbapCatalog.preserveKey:                   true
@AccessControl.authorizationCheck:          #NOT_REQUIRED
@AccessControl.personalData.blocking:       #NOT_REQUIRED
@ClientHandling.algorithm:                  #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:      #C
@ObjectModel.usageType.sizeCategory:        #L
@ObjectModel.usageType.dataClass:           #MASTER
@ObjectModel.representativeKey:             'LocationIATACode'
@VDM.viewType:                              #BASIC
@VDM.lifecycle.contract.type:               #NONE
@EndUserText.label:                         'Transportation IATA Location Codes'
define view I_TranspIATALocationCode
  as select from /scmtms/c_iatac
  association [0..*] to I_TranspIATALocationCodeText as _Text on $projection.LocationIATACode = _Text.LocationIATACode
{
      @ObjectModel.text.association: '_Text'
  key iatac       as LocationIATACode,
      country     as Country,
      region      as Region,
      exec_org_id as OrganizationalUnitExternalID,
      xpos        as Longitude,
      ypos        as Latitude,
      tzone       as LocationTimeZone,
      _Text
}

Learn More