I_MFGACTIONREASONCODE

CDS View

Reason Code

I_MFGACTIONREASONCODE is a CDS View in S/4HANA. Reason Code. It contains 18 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 18 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_MfgActionReasonCode view from CONSUMPTION
C_ProdnHoldReasonCodeVH view from CONSUMPTION Production Hold Reason Code Value Help
C_ProdnHoldRelReasonCodeVH view from CONSUMPTION Release Reason Code Value Help
I_MfgActionReasonCodeStdVH view from COMPOSITE Reason Code
I_MfgActionReasonCodeToGroupTP view from TRANSACTIONAL Assignment of Reason Code to Group
I_MfgActionReasonCodeTP view from TRANSACTIONAL MPE Manufacturing Action Reason Code
I_MfgActionReasonCodeVH view from COMPOSITE MPE MFG Action Reason Code Value Help

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ManufacturingActionReasonCode ManufacturingActionReasonCode,MfgActionReasonCodeForEdit 4
KEY MfgActionReasonCodeGroup MfgActionReasonCodeGroup,MfgActnReasonCodeGroupForEdit 4
KEY MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg,MfgActnRsnCodeGroupCtlgForEdit 4
KEY Version Version 3
_Catalog _Catalog 1
_CreatedByUser _CreatedByUser 1
_Group _Group 1
_LastChangedByUser _LastChangedByUser 1
_Text _Text 1
Action Action 1
CodeGroupStatus CodeGroupStatus 2
CodeIsInactive CodeIsInactive 1
CreatedByUser CreatedByUser 1
DefectClass DefectClass 1
IsDeleted IsDeleted 1
LastChangedByUser LastChangedByUser 1
MfgActionReasonCodeIsUsed MfgActionReasonCodeIsUsed 1
ValidityStartDate ValidityStartDate 1 
@AbapCatalog: {
  sqlViewName: 'IMPERSNCODE',
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser']
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: ['MfgActionReasonCodeGroupCtlg', 'MfgActionReasonCodeGroup', 'ManufacturingActionReasonCode', 'Version']
@VDM.viewType: #BASIC
@ObjectModel.usageType:
{
  serviceQuality: #B,
  sizeCategory:   #S,
  dataClass:      #CUSTOMIZING
}
@Search.searchable: true
@EndUserText.label: 'Reason Code'
define view I_MfgActionReasonCode
  as select from qpcd as code
  association [0..*] to I_MfgActionReasonCodeText  as _Text              on  $projection.MfgActionReasonCodeGroupCtlg  = _Text.MfgActionReasonCodeGroupCtlg
                                                                         and $projection.MfgActionReasonCodeGroup      = _Text.MfgActionReasonCodeGroup
                                                                         and $projection.ManufacturingActionReasonCode = _Text.ManufacturingActionReasonCode
                                                                         and $projection.Version                       = _Text.Version

  association [0..1] to I_MfgActionReasonCodeGroup as _Group             on  $projection.MfgActionReasonCodeGroupCtlg = _Group.MfgActionReasonCodeGroupCtlg
                                                                         and $projection.MfgActionReasonCodeGroup     = _Group.MfgActionReasonCodeGroup

  association [0..1] to I_Inspectioncatalog        as _Catalog           on  $projection.MfgActionReasonCodeGroupCtlg = _Catalog.InspectionCatalog

  association [0..1] to I_User                     as _CreatedByUser     on  $projection.CreatedByUser = _CreatedByUser.UserID

  association [0..1] to I_User                     as _LastChangedByUser on  $projection.LastChangedByUser = _LastChangedByUser.UserID

{
      // key fields

      @ObjectModel.foreignKey.association: '_Catalog'
  key code.katalogart        as MfgActionReasonCodeGroupCtlg,
      @ObjectModel.foreignKey.association: '_Group'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgActnRsnCodeGrpStdVH', element: 'MfgActionReasonCodeGroup' } } ]
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key code.codegruppe        as MfgActionReasonCodeGroup,
      @ObjectModel.text.association: '_Text'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key code.code              as ManufacturingActionReasonCode,
  key code.version           as Version,

      // for compatibility reasons

      ''                     as MfgActionReasonCodeCategory,

      // code data

      code.fehlklasse        as DefectClass,
      code.folgeakti         as Action,
      code.geloescht         as IsDeleted,
      code.gueltigab         as ValidityStartDate,
      code.inaktiv           as CodeIsInactive,
      _Group.CodeGroupStatus as CodeGroupStatus,
      code.verwendung        as MfgActionReasonCodeIsUsed,

      // admin data

      @ObjectModel.foreignKey.association: '_CreatedByUser'
      code.ersteller         as CreatedByUser,
      code.e_datum           as CreationDateTime,
      @ObjectModel.foreignKey.association: '_LastChangedByUser'
      code.aenderer          as LastChangedByUser,
      code.a_datum           as LastChangeDateTime,

      // text associations

      _Text,

      // others

      _Group,
      _Catalog,
      _CreatedByUser,
      _LastChangedByUser

}
where
     code.katalogart = '7'
  or code.katalogart = '0'
  or code.katalogart = '9'

Learn More