I_TranspUNLocationCode

DDL: I_TRANSPUNLOCATIONCODE SQL: ITUNLOCC Type: view BASIC

Transportation UN Location Codes

I_TranspUNLocationCode is a Basic CDS View that provides data about "Transportation UN Location Codes" in SAP S/4HANA. It reads from 1 data source (/scmtms/c_unloc) and exposes 5 fields with key field LocationUNCode. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
/scmtms/c_unloc /scmtms/c_unloc from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TranspUNLocationCodeText _Text $projection.LocationUNCode = _Text.LocationUNCode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITUNLOCC 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 LocationUNCode view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #NONE view
EndUserText.label Transportation UN Location Codes view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY LocationUNCode unlocode
OrganizationalUnitExternalID exec_org_id
ResourcePositionLongitude xpos
ResourcePositionLatitude ypos
_Text _Text 
@AbapCatalog.sqlViewName: 'ITUNLOCC'
@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:             'LocationUNCode'
@VDM.viewType:                              #BASIC
@VDM.lifecycle.contract.type:               #NONE
@EndUserText.label:                         'Transportation UN Location Codes'
define view I_TranspUNLocationCode
  as select from /scmtms/c_unloc
  association [0..*] to I_TranspUNLocationCodeText as _Text on $projection.LocationUNCode = _Text.LocationUNCode
{
      @ObjectModel.text.association: '_Text'
  key unlocode    as LocationUNCode,
      exec_org_id as OrganizationalUnitExternalID,
      xpos        as ResourcePositionLongitude,
      ypos        as ResourcePositionLatitude,
      _Text
}

Learn More