R_LocationTextTP

DDL: R_LOCATIONTEXTTP Type: view_entity TRANSACTIONAL Package: RAP_LOCATION

Transactional Processing View for Location Description

R_LocationTextTP is a Transactional CDS View that provides data about "Transactional Processing View for Location Description" in SAP S/4HANA. It reads from 1 data source (I_LocationText) and exposes 7 fields with key fields LocationUUID, Language. Part of development package RAP_LOCATION.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_LocationText I_LocationText from

Annotations (5)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.dataCategory #TEXT view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY LocationUUID LocationUUID
KEY Language Language
LocationDescription LocationDescription
LocalLastChangeDateTime _LocationTP ChangedDateTime
_Language _Language
_LocationBasic _LocationBasic
_LocationTP _LocationTP 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@VDM.viewType                       : #TRANSACTIONAL
@ObjectModel. usageType             : { serviceQuality: #C,sizeCategory : #M,dataClass: #MASTER}
@AccessControl.authorizationCheck   : #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@VDM.lifecycle.contract.type        : #SAP_INTERNAL_API
@ObjectModel.dataCategory           : #TEXT

define view entity R_LocationTextTP
  as select from I_LocationText
  association to parent R_LocationTP as _LocationTP on $projection.LocationUUID = _LocationTP.LocationUUID
{
  key LocationUUID,
  key Language,
      LocationDescription,
      _LocationTP.ChangedDateTime as LocalLastChangeDateTime,

      /* Associations */
      _Language,
      _LocationBasic,
      _LocationTP
}
where _LocationTP.LocationType = '1001' or
      _LocationTP.LocationType = '1002' or
      _LocationTP.LocationType = '1003' or
      _LocationTP.LocationType = '1020' or
      _LocationTP.LocationType = '1021' or
      _LocationTP.LocationType = '1030' or
      _LocationTP.LocationType = '1040' or
      _LocationTP.LocationType = '1100' or
      _LocationTP.LocationType = '1110' or
      _LocationTP.LocationType = '1120' or
      _LocationTP.LocationType = '1130' or
      _LocationTP.LocationType = '1140' or
      _LocationTP.LocationType = '1150' or
      _LocationTP.LocationType = '1160' or
      _LocationTP.LocationType = '1170' or
      _LocationTP.LocationType = '1180' or
      _LocationTP.LocationType = '1190' or
      _LocationTP.LocationType = '1191' or
      _LocationTP.LocationType = '1200'

Learn More