I_LocationMigrationValueHelp

DDL: I_LOCATIONMIGRATIONVALUEHELP Type: view_entity COMPOSITE Package: EHFND_BO_LOC_IMPL

Location Migration

I_LocationMigrationValueHelp is a Composite CDS View that provides data about "Location Migration" in SAP S/4HANA. It reads from 1 data source (I_EHSLocationRoot) and exposes 9 fields with key field EHSLocationUUID. It has 2 associations to related views. Part of development package EHFND_BO_LOC_IMPL.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_EHSLocationRoot I_EHSLocationRoot from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LocationDescFallbackLang _LocTextDesc $projection.EHSLocationUUID = _LocTextDesc.EHSLocationUUID
[0..*] I_EHSLocationRevision _EHSLocationRevision $projection.EHSLocationUUID = _EHSLocationRevision.EHSLocationUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Location Migration view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey EHSLocationUUID view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID EHSLocationUUID
EHSLocationID EHSLocationID
LocationMigrationSource LocationMigrationSource
EHSLocationName
EHSLocationType
EHSLocationTypeText
EHSLocationStatus
EHSLocationStatusText
_EHSLocationRevision _EHSLocationRevision 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Location Migration'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'EHSLocationUUID'


define view entity I_LocationMigrationValueHelp
  as select from I_EHSLocationRoot

  association [1..1] to I_LocationDescFallbackLang as _LocTextDesc         on $projection.EHSLocationUUID = _LocTextDesc.EHSLocationUUID
  association [0..*] to I_EHSLocationRevision      as _EHSLocationRevision on $projection.EHSLocationUUID = _EHSLocationRevision.EHSLocationUUID
{

  key EHSLocationUUID,

      EHSLocationID,
      LocationMigrationSource,

      cast( _LocTextDesc.EHSLocationName as ehfnd_loc_name preserving type ) as EHSLocationName,

      _EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].EHSLocationType,
      _EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationType._Text[1: Language = $session.system_language].EHSLocationTypeText,

      _EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date].EHSLocationStatus,
      _EHSLocationRevision[1: RevisionStartDate <= $session.system_date and RevisionEndDate >= $session.system_date]._EHSLocationStatus._Text[1: Language = $session.system_language].EHSLocationStatusText,

      _EHSLocationRevision
}

Learn More