P_ExpirationdateText

DDL: P_EXPIRATIONDATETEXT SQL: P_expdate_text Type: view BASIC

P_ExpirationdateText is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields with key fields Value, Language.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName P_expdate_text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
domname
KEY Value
KEY Language dd07t ddlanguage
Description dd07t ddtext 
@AbapCatalog.sqlViewName: 'P_expdate_text'
@ObjectModel.dataCategory: #TEXT
//@Analytics: { datacategory: #TEXT }

@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@Search.searchable: true
//@EndUserText.label: 'Value help for Expiration date'

define view P_ExpirationdateText  as select from dd07t
{ 
 --key dd07t.domname, 
  
    key  cast(dd07t.domvalue_l as ExpirationDate) as Value, 
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8  
    @Search.ranking: #HIGH
    @Semantics.language:true
    key  dd07t.ddlanguage as Language,
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8  
    @Search.ranking: #HIGH
    @Semantics.text: true
    dd07t.ddtext as Description
}
where domname ='SLED_BBD'
 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More