I_ResourceTextBasic

DDL: I_RESOURCETEXTBASIC SQL: IRESOURCETEXTB Type: view BASIC Package: VDM_RESOURCE

APO Resource Text

I_ResourceTextBasic is a Basic CDS View that provides data about "APO Resource Text" in SAP S/4HANA. It reads from 1 data source (/sapapo/res_txt) and exposes 8 fields with key fields ResourceUUID, ResourceSimulationVersionUUID, ResourceSimulationSessionUUID, Language. It has 2 associations to related views. Part of development package VDM_RESOURCE.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
/sapapo/res_txt ResourceTextBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ResourceBasic _ResourceBasic $projection.ResourceUUID = _ResourceBasic.ResourceUUID and $projection.ResourceSimulationSessionUUID = _ResourceBasic.ResourceSimulationSessionUUID and $projection.ResourceSimulationVersionUUID = _ResourceBasic.ResourceSimulationVersionUUID
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRESOURCETEXTB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ResourceUUID view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #NONE view
EndUserText.label APO Resource Text view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ResourceUUID /sapapo/res_txt resuid
KEY ResourceSimulationVersionUUID /sapapo/res_txt simversid
KEY ResourceSimulationSessionUUID /sapapo/res_txt simsessid
KEY Language /sapapo/res_txt langu
ResourceName /sapapo/res_txt text
ResourceNameInCapitals /sapapo/res_txt text_up
_ResourceBasic _ResourceBasic
_Language _Language 
@AbapCatalog.sqlViewName:                   'IRESOURCETEXTB'

@AbapCatalog.compiler.compareFilter:        true
@AbapCatalog.preserveKey:                   true
@AccessControl.authorizationCheck:          #NOT_REQUIRED
@ClientHandling.algorithm:                  #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:      #A
@ObjectModel.usageType.sizeCategory:        #L
@ObjectModel.usageType.dataClass:           #MASTER
@ObjectModel.dataCategory:                  #TEXT
@ObjectModel.representativeKey:             'ResourceUUID'
@VDM.viewType:                              #BASIC
@VDM.lifecycle.contract.type:               #NONE

@EndUserText.label:                         'APO Resource Text'

define view I_ResourceTextBasic
  as select from /sapapo/res_txt as ResourceTextBasic
  association [0..1] to I_ResourceBasic as _ResourceBasic on $projection.ResourceUUID                  = _ResourceBasic.ResourceUUID   
                                                         and $projection.ResourceSimulationSessionUUID = _ResourceBasic.ResourceSimulationSessionUUID
                                                         and $projection.ResourceSimulationVersionUUID = _ResourceBasic.ResourceSimulationVersionUUID  
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_ResourceBasic'
  key ResourceTextBasic.resuid        as ResourceUUID,
  key ResourceTextBasic.simversid     as ResourceSimulationVersionUUID,
  key ResourceTextBasic.simsessid     as ResourceSimulationSessionUUID,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key ResourceTextBasic.langu         as Language,
      @Semantics.text: true
      ResourceTextBasic.text          as ResourceName,
      @Semantics.text: true
      ResourceTextBasic.text_up       as ResourceNameInCapitals,
      _ResourceBasic,
      _Language
}

Learn More