I_FldLogsRetStockTypeText

DDL: I_FLDLOGSRETSTOCKTYPETEXT SQL: IFLSTOCKTYPETEXT Type: view BASIC Package: FLOG_RETURN

Text view for StockType

I_FldLogsRetStockTypeText is a Basic CDS View that provides data about "Text view for StockType" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 3 fields with key fields Language, InventoryUsabilityCode. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFLSTOCKTYPETEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey InventoryUsabilityCode view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
Search.searchable true view
VDM.viewType #BASIC view
EndUserText.label Text view for StockType view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language ddlanguage
KEY InventoryUsabilityCode
StockTypeName ddtext
@AbapCatalog.sqlViewName: 'IFLSTOCKTYPETEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.dataCategory: #TEXT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'InventoryUsabilityCode'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.resultSet.sizeCategory: #XS
@Search.searchable: true
@VDM.viewType: #BASIC
@EndUserText.label: 'Text view for StockType'

define view I_FldLogsRetStockTypeText
  as select from dd07t
{
            @Semantics.language: true
  key       ddlanguage                   as Language,

            @ObjectModel.text.element    : ['StockTypeName']
            @UI.textArrangement :#TEXT_ONLY
            @Search: { defaultSearchElement: true, ranking: #HIGH }
  key       cast(domvalue_l as mb_insmk) as InventoryUsabilityCode,

            @Semantics.text: true
            ddtext                       as StockTypeName
}
where
       dd07t.domname    = 'INSMK'
  and  dd07t.as4local   = 'A'
  and  dd07t.as4vers    = '0000'
  and(
       dd07t.domvalue_l = 'S'
    or dd07t.domvalue_l = ''
  )
  and  dd07t.ddlanguage = $session.system_language