I_MANUFACTURINGACTIONSETTING

CDS View

Action Settings

I_MANUFACTURINGACTIONSETTING is a CDS View in S/4HANA. Action Settings. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SASAction view left_outer CONSUMPTION

Fields (2)

KeyField CDS FieldsUsed in Views
MfgActionReasonCodeGroup MfgActionReasonCodeGroup 1
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 1 
@AbapCatalog.sqlViewName: 'IMPEACTIONSET'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #CUSTOMIZING}
@VDM.viewType: #BASIC
@EndUserText.label: 'Action Settings'
define view I_ManufacturingActionSetting
  as select from mpe_action_sett as sett
  association [1..1] to I_Plant                    as _Plant                    on  $projection.Plant = _Plant.Plant
  association [1..1] to I_MfgProcgExecAction       as _MfgProcgExecAction       on  $projection.MfgProcgExecAction = _MfgProcgExecAction.MfgProcgExecAction
  association [1..1] to I_SystemObjectType         as _ObjectType               on  $projection.MfgObjectType = _ObjectType.MfgObjectType
  association [0..1] to I_MfgActionReasonCodeGroup as _MfgActionReasonCodeGroup on  $projection.MfgActionReasonCodeGroupCtlg = _MfgActionReasonCodeGroup.MfgActionReasonCodeGroupCtlg
                                                                                and $projection.MfgActionReasonCodeGroup     = _MfgActionReasonCodeGroup.MfgActionReasonCodeGroup
  association [0..1] to I_MfgActionReasonCodeRqmt  as _MfgActionReasonCodeRqmt  on  $projection.MfgActionReasonCodeRequirement = _MfgActionReasonCodeRqmt.MfgActionReasonCodeRequirement
  association [0..1] to I_MfgActionNoteRequirement as _MfgActionNoteRequirement on  $projection.MfgActionNoteRequirement = _MfgActionNoteRequirement.MfgActionNoteRequirement
{
      @ObjectModel.foreignKey.association: '_MfgProcgExecAction'
  key sett.action_name          as MfgProcgExecAction,
      @ObjectModel.foreignKey.association: '_ObjectType'
  key sett.object_type          as MfgObjectType,
      @ObjectModel.foreignKey.association: '_Plant'
  key sett.werks                as Plant,
      @ObjectModel.foreignKey.association: '_MfgActionReasonCodeRqmt'
      sett.reason_type          as MfgActionReasonCodeRequirement,
      @ObjectModel.foreignKey.association: '_MfgActionNoteRequirement'
      sett.note_type            as MfgActionNoteRequirement,
      sett.katalogart           as MfgActionReasonCodeGroupCtlg,
//      @ObjectModel.foreignKey.association: '_MfgActionReasonCodeGroup'

      sett.codegruppe           as MfgActionReasonCodeGroup,
      sett.certfn_chk_is_rqd    as CertificationCheckIsRequired,
      @Semantics.user.lastChangedBy: true
      sett.changed_by           as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      sett.changed_at           as LastChangeDateTime,

      _MfgProcgExecAction,
      _ObjectType,
      _MfgActionReasonCodeGroup,
      _MfgActionReasonCodeRqmt,
      _MfgActionNoteRequirement,
      _Plant

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MPE_ACTION_SETT"
],
"ASSOCIATED":
[
"I_MFGACTIONNOTEREQUIREMENT",
"I_MFGACTIONREASONCODEGROUP",
"I_MFGACTIONREASONCODERQMT",
"I_MFGPROCGEXECACTION",
"I_PLANT",
"I_SYSTEMOBJECTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More