I_MfgActionReasonCodeText

DDL: I_MFGACTIONREASONCODETEXT SQL: IMPERSNCCODET Type: view BASIC

MPE Reason Code Text

I_MfgActionReasonCodeText is a Basic CDS View that provides data about "MPE Reason Code Text" in SAP S/4HANA. It reads from 1 data source (qpct) and exposes 8 fields with key fields MfgActionReasonCodeGroupCtlg, MfgActionReasonCodeGroup, ManufacturingActionReasonCode, Version, Language. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
qpct qpct from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_MfgActionReasonCode _MfgActionReasonCode $projection.MfgActionReasonCodeGroupCtlg = _MfgActionReasonCode.MfgActionReasonCodeGroupCtlg and $projection.MfgActionReasonCodeGroup = _MfgActionReasonCode.MfgActionReasonCodeGroup and $projection.ManufacturingActionReasonCode = _MfgActionReasonCode.ManufacturingActionReasonCode and $projection.Version = _MfgActionReasonCode.Version

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPERSNCCODET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
EndUserText.label MPE Reason Code Text view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MfgActionReasonCodeGroupCtlg katalogart
KEY MfgActionReasonCodeGroup codegruppe
KEY ManufacturingActionReasonCode code
KEY Version version
KEY Language sprache
MfgActionReasonCodeName kurztext
_MfgActionReasonCode _MfgActionReasonCode
_Language _Language 
@AbapCatalog.sqlViewName: 'IMPERSNCCODET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: ['MfgActionReasonCodeGroupCtlg', 'MfgActionReasonCodeGroup', 'ManufacturingActionReasonCode', 'Version']
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType:
{
  serviceQuality: #B,
  sizeCategory:   #S,
  dataClass:      #CUSTOMIZING
}
@Search.searchable: true
@EndUserText.label: 'MPE Reason Code Text'

define view I_MfgActionReasonCodeText
  as select from qpct
  association [0..1] to I_Language            as _Language            on  $projection.Language = _Language.Language
  association [0..1] to I_MfgActionReasonCode as _MfgActionReasonCode on  $projection.MfgActionReasonCodeGroupCtlg  = _MfgActionReasonCode.MfgActionReasonCodeGroupCtlg 
                                                                      and $projection.MfgActionReasonCodeGroup      = _MfgActionReasonCode.MfgActionReasonCodeGroup
                                                                      and $projection.ManufacturingActionReasonCode = _MfgActionReasonCode.ManufacturingActionReasonCode
                                                                      and $projection.Version                       = _MfgActionReasonCode.Version
{

  key katalogart as MfgActionReasonCodeGroupCtlg,
  key codegruppe as MfgActionReasonCodeGroup,
      @ObjectModel.text.element: 'MfgActionReasonCodeName'
  key code       as ManufacturingActionReasonCode,
  key version    as Version,
      @Semantics.language: true
  key sprache    as Language,

      @Semantics.text: true
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      kurztext   as MfgActionReasonCodeName,

      _MfgActionReasonCode,
      _Language
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"QPCT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MFGACTIONREASONCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More