I_MDGovChangeRequestGenStatusT

DDL: I_MDGOVCHANGEREQUESTGENSTATUST SQL: IMDGCRGENSTST Type: view BASIC

MDG Change Request General Status Text

I_MDGovChangeRequestGenStatusT is a Basic CDS View that provides data about "MDG Change Request General Status Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields with key fields MDGovChgReqGeneralStatus, Language. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDGCRGENSTST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey MDGovChgReqGeneralStatus view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label MDG Change Request General Status Text view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MDGovChgReqGeneralStatus Change Request General Status Code
KEY Language ddlanguage
MDGovChgReqGeneralStatusName Change Request General Status
_Language _Language 
@AbapCatalog.sqlViewName: 'IMDGCRGENSTST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'MDGovChgReqGeneralStatus'
@ObjectModel.usageType: { sizeCategory: #S, dataClass: #CUSTOMIZING, serviceQuality: #C }
@VDM.viewType: #BASIC
@Search.searchable: true
@EndUserText.label: 'MDG Change Request General Status Text'
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view I_MDGovChangeRequestGenStatusT
  as select from dd07t
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
      @EndUserText.label: 'Change Request General Status Code'
  key cast ( left( domvalue_l, 1 ) as analytics_cr_general_status preserving type )                          as MDGovChgReqGeneralStatus,
  
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key ddlanguage                                                                                             as Language,
  
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #HIGH }
      @Semantics.text
      @EndUserText.label: 'Change Request General Status'
      cast( ddtext as val_text preserving type )                                                             as MDGovChgReqGeneralStatusName,

      _Language
}
where
      domname  = 'ANALYTICS_CR_GENERAL_STATUS'
  and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More