DEVCLASS_F4_Select

DDL: DEVCLASS_F4_SELECT Type: view_entity

Source data for search help DEVCLASS

DEVCLASS_F4_Select is a CDS View that provides data about "Source data for search help DEVCLASS" in SAP S/4HANA. It reads from 2 data sources (tdevc, tdevct) and exposes 4 fields with key field devclass.

Data Sources (2)

SourceAliasJoin Type
tdevc main from
tdevct text left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Source data for search help DEVCLASS view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #META view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY devclass tdevc devclass
pdevclass
consys tdevc consys
ctext
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Source data for search help DEVCLASS'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #META
}
define view entity DEVCLASS_F4_Select
  as select from    tdevc  as main
    left outer join tdevct as text on  main.devclass = text.devclass
                                   and text.spras    = $session.system_language
{

  key main.devclass,
      cast( main.pdevclass as devlayer preserving type ) as pdevclass,
      main.consys,
      coalesce( text.ctext, main.ctext )                 as ctext

}