TMO_HPT_ZI_StatusText

DDL: TMO_HPT_ZI_STATUSTEXT SQL: HPT_STATUSTEXT Type: view Package: S_TMO_HPT

TMO-HPT: Status Translation

TMO_HPT_ZI_StatusText is a CDS View that provides data about "TMO-HPT: Status Translation" in SAP S/4HANA. It reads from 2 data sources (dd07t, dd07v) and exposes 2 fields with key field int2asStatus. Part of development package S_TMO_HPT.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
dd07t DomainText inner
dd07v DomainValue from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName HPT_STATUSTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label TMO-HPT: Status Translation view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY int2asStatus
StatusText dd07t ddtext 
@AbapCatalog.sqlViewName: 'HPT_STATUSTEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'TMO-HPT: Status Translation'
@Metadata.ignorePropagatedAnnotations: true
define view TMO_HPT_ZI_StatusText
as select from dd07v as DomainValue
  inner join dd07t as DomainText
    on  DomainValue.domname    = DomainText.domname
    and DomainValue.domvalue_l = DomainText.domvalue_l
    and DomainValue.valpos     = DomainText.valpos
    and DomainValue.ddlanguage = DomainText.ddlanguage

{

  @ObjectModel.text.element: ['StatusText']
  key
    cast(
      cast( DomainValue.domvalue_l as abap.numc(4) ) as abap.int2
    ) as Status,

  @Semantics.text: true
  DomainText.ddtext as StatusText
}
where
      DomainValue.domname = 'TMO_HPT_V_TRACE_STATUS'
  and DomainText.ddlanguage = $session.system_language

Learn More