I_MfgActionReasonCodeTP

DDL: I_MFGACTIONREASONCODETP SQL: IMPEMFGARCTP Type: view TRANSACTIONAL

MPE Manufacturing Action Reason Code

I_MfgActionReasonCodeTP is a Transactional CDS View that provides data about "MPE Manufacturing Action Reason Code" in SAP S/4HANA. It reads from 1 data source (I_MfgActionReasonCode) and exposes 27 fields with key fields MfgActionReasonCodeGroupCtlg, MfgActionReasonCodeGroup, ManufacturingActionReasonCode, Version.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgActionReasonCode code from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMPEMFGARCTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence IMFGARCTPDRAFT view
EndUserText.label MPE Manufacturing Action Reason Code view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MfgActionReasonCodeGroupCtlg I_MfgActionReasonCode MfgActionReasonCodeGroupCtlg
KEY MfgActionReasonCodeGroup I_MfgActionReasonCode MfgActionReasonCodeGroup
KEY ManufacturingActionReasonCode I_MfgActionReasonCode ManufacturingActionReasonCode
KEY Version I_MfgActionReasonCode Version
MfgActnRsnCodeGroupCtlgForEdit I_MfgActionReasonCode MfgActionReasonCodeGroupCtlg
MfgActnReasonCodeGroupForEdit I_MfgActionReasonCode MfgActionReasonCodeGroup
MfgActionReasonCodeForEdit I_MfgActionReasonCode ManufacturingActionReasonCode
MfgActionReasonCodeName
MfgActionReasonCodeGroupName
InspSpecAdditionalCatalogText
CodeGroupStatus I_MfgActionReasonCode CodeGroupStatus
DefectClass I_MfgActionReasonCode DefectClass
Action I_MfgActionReasonCode Action
IsDeleted I_MfgActionReasonCode IsDeleted
ValidityStartDate I_MfgActionReasonCode ValidityStartDate
MfgActionReasonCodeIsUsed I_MfgActionReasonCode MfgActionReasonCodeIsUsed
CreatedByUserDescription _CreatedByUser UserDescription
LastChangedByUserDescription _LastChangedByUser UserDescription
CreatedByUser I_MfgActionReasonCode CreatedByUser
CreationDateTime
LastChangedByUser I_MfgActionReasonCode LastChangedByUser
LastChangeDateTime
_Text _Text
_Group _Group
_Catalog _Catalog
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog.sqlViewName: 'IMPEMFGARCTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:
{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
@ObjectModel:
{
  compositionRoot: true,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  draftEnabled: true,                       -- Draft enablement
  writeDraftPersistence: 'IMFGARCTPDRAFT',  -- Draft persistence
  semanticKey: ['MfgActnRsnCodeGroupCtlgForEdit', 'MfgActnReasonCodeGroupForEdit', 'MfgActionReasonCodeForEdit', 'Version']
}
@EndUserText.label: 'MPE Manufacturing Action Reason Code'
/*+[hideWarning] { "IDS" : [ "DOUBLE_JOIN" ]  } */
define view I_MfgActionReasonCodeTP
  as select from I_MfgActionReasonCode as code

{
      // key fields

      @ObjectModel.readOnly: true
  key code.MfgActionReasonCodeGroupCtlg                                                                                        as MfgActionReasonCodeGroupCtlg,
      @ObjectModel.readOnly: true
  key code.MfgActionReasonCodeGroup                                                                                            as MfgActionReasonCodeGroup,
      @ObjectModel.readOnly: true
  key code.ManufacturingActionReasonCode                                                                                       as ManufacturingActionReasonCode,
      @ObjectModel.readOnly: true
  key code.Version                                                                                                             as Version,

      // code data

      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.text.element: 'InspSpecAdditionalCatalogText'
      code.MfgActionReasonCodeGroupCtlg                                                                                        as MfgActnRsnCodeGroupCtlgForEdit,
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.text.element: 'MfgActionReasonCodeGroupName'
      code.MfgActionReasonCodeGroup                                                                                            as MfgActnReasonCodeGroupForEdit,
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.text.element: 'MfgActionReasonCodeName'
      code.ManufacturingActionReasonCode                                                                                       as MfgActionReasonCodeForEdit,

      @Semantics.text: true
      cast(_Text[1: Language=$session.system_language].MfgActionReasonCodeName as mpe_reason_code_description preserving type) as MfgActionReasonCodeName,

      @Semantics.text: true
      _Group._Text[1: Language=$session.system_language].MfgActionReasonCodeGroupName                                          as MfgActionReasonCodeGroupName,

      @Semantics.text: true
      _Catalog._InspectionCatalogText[1: Language=$session.system_language].InspSpecAdditionalCatalogText                      as InspSpecAdditionalCatalogText,

      code.CodeGroupStatus                                                                                                     as CodeGroupStatus,
      code.DefectClass                                                                                                         as DefectClass,
      code.Action                                                                                                              as Action,
      code.IsDeleted                                                                                                           as IsDeleted,
      code.ValidityStartDate                                                                                                   as ValidityStartDate,
      @ObjectModel.readOnly: true
      cast(case code.CodeIsInactive
      when ' ' then  ' '
      else 'X'
      end as qinak preserving type)                                                                                            as CodeIsInactive,
      code.MfgActionReasonCodeIsUsed                                                                                           as MfgActionReasonCodeIsUsed,

      // admin data

      @Semantics.text: true
      _CreatedByUser.UserDescription                                                                                           as CreatedByUserDescription,
      @Semantics.text: true
      _LastChangedByUser.UserDescription                                                                                       as LastChangedByUserDescription,

      @ObjectModel.readOnly: true
      @ObjectModel.text.element:  [ 'CreatedByUserDescription' ]
      @Semantics.user.createdBy: true
      code.CreatedByUser                                                                                                       as CreatedByUser,
      @ObjectModel.readOnly: true
      cast(code.CreationDateTime as mpe_create_date preserving type)                                                           as CreationDateTime,
      @ObjectModel.readOnly: true
      @ObjectModel.text.element:  [ 'LastChangedByUserDescription' ]
      @Semantics.user.lastChangedBy: true
      code.LastChangedByUser                                                                                                   as LastChangedByUser,
      @ObjectModel.readOnly: true
      cast(code.LastChangeDateTime as mpe_lchange_date preserving type)                                                        as LastChangeDateTime,

      // text association

      _Text,

      // others

      _Group,
      _Catalog,
      _CreatedByUser,
      _LastChangedByUser

}
where
     code.MfgActionReasonCodeGroupCtlg = '0'
  or code.MfgActionReasonCodeGroupCtlg = '7'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONCATALOG",
"I_INSPECTIONCATALOGTEXT",
"I_MFGACTIONREASONCODE",
"I_MFGACTIONREASONCODEGROUP",
"I_MFGACTIONREASONCODEGROUPTEXT",
"I_MFGACTIONREASONCODETEXT",
"I_USER"
],
"ASSOCIATED":
[
"I_INSPECTIONCATALOG",
"I_MFGACTIONREASONCODEGROUP",
"I_MFGACTIONREASONCODETEXT",
"I_USER"
],
"BASE":
[
"I_MFGACTIONREASONCODE"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More