I_MfgActionReasonCodeToGroupTP

DDL: I_MFGACTIONREASONCODETOGROUPTP SQL: IMPEMFGARCGCATP Type: view TRANSACTIONAL Package: MPE_CORE

Assignment of Reason Code to Group

I_MfgActionReasonCodeToGroupTP is a Transactional CDS View that provides data about "Assignment of Reason Code to Group" in SAP S/4HANA. It reads from 1 data source (I_MfgActionReasonCode) and exposes 18 fields with key fields MfgActionReasonCodeGroupCtlg, ManufacturingActionReasonCode, MfgActionReasonCodeGroup, Version. It has 1 association to related views. Part of development package MPE_CORE.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgActionReasonCode assgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MfgActionReasonCodeGroupTP _Root $projection.MfgActionReasonCodeGroupCtlg = _Root.MfgActionReasonCodeGroupCtlg and $projection.MfgActionReasonCodeGroup = _Root.MfgActionReasonCodeGroup

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPEMFGARCGCATP 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.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.writeDraftPersistence IMPEARCGCADRAFT view
EndUserText.label Assignment of Reason Code to Group view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MfgActionReasonCodeGroupCtlg I_MfgActionReasonCode MfgActionReasonCodeGroupCtlg
KEY ManufacturingActionReasonCode I_MfgActionReasonCode ManufacturingActionReasonCode
KEY MfgActionReasonCodeGroup I_MfgActionReasonCode MfgActionReasonCodeGroup
KEY Version I_MfgActionReasonCode Version
InspSpecAdditionalCatalogText
CodeIsInactive I_MfgActionReasonCode CodeIsInactive
CodeGroupStatus I_MfgActionReasonCode CodeGroupStatus
MfgActionReasonCodeName
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_Text I_MfgActionReasonCode _Text
_Catalog I_MfgActionReasonCode _Catalog
_Group I_MfgActionReasonCode _Group
_CreatedByUser I_MfgActionReasonCode _CreatedByUser
_LastChangedByUser I_MfgActionReasonCode _LastChangedByUser
_Root _Root 
@AbapCatalog.sqlViewName: 'IMPEMFGARCGCATP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType:
{
  serviceQuality: #C,
  sizeCategory:   #S,
  dataClass:      #CUSTOMIZING
}
@ObjectModel:
{
  createEnabled: false,
  updateEnabled: false,
  deleteEnabled: false,
  writeDraftPersistence: 'IMPEARCGCADRAFT',   -- Draft persistence
  semanticKey: ['MfgActionReasonCodeGroupCtlg', 'ManufacturingActionReasonCode', 'MfgActionReasonCodeGroup', 'Version']
}
@EndUserText.label: 'Assignment of Reason Code to Group'
define view I_MfgActionReasonCodeToGroupTP
  as select from I_MfgActionReasonCode as assgmt

  // association to root view

  association [1..1] to I_MfgActionReasonCodeGroupTP as _Root on  $projection.MfgActionReasonCodeGroupCtlg = _Root.MfgActionReasonCodeGroupCtlg
                                                              and $projection.MfgActionReasonCodeGroup     = _Root.MfgActionReasonCodeGroup

{
      @ObjectModel: {
        readOnly: true,
        text.element: ['InspSpecAdditionalCatalogText']
      }
  key assgmt.MfgActionReasonCodeGroupCtlg                                                                                        as  MfgActionReasonCodeGroupCtlg,
      @ObjectModel: {
        readOnly: true,
        text.element: [ 'MfgActionReasonCodeName' ]
      }
  key assgmt.ManufacturingActionReasonCode                                                                                       as  ManufacturingActionReasonCode,
      @ObjectModel.readOnly: true
  key assgmt.MfgActionReasonCodeGroup                                                                                            as  MfgActionReasonCodeGroup,
      @ObjectModel.readOnly: true
  key assgmt.Version                                                                                                             as  Version,

      @ObjectModel.readOnly: true
      _Catalog._InspectionCatalogText[1: Language=$session.system_language].InspSpecAdditionalCatalogText                        as  InspSpecAdditionalCatalogText,
      @ObjectModel.readOnly: true
      assgmt.CodeIsInactive                                                                                                      as  CodeIsInactive,
      @ObjectModel.readOnly: true
      assgmt.CodeGroupStatus                                                                                                     as  CodeGroupStatus,

      @ObjectModel.readOnly: true
      cast(_Text[1: Language = $session.system_language].MfgActionReasonCodeName as mpe_reason_code_description preserving type) as  MfgActionReasonCodeName,
      
      @ObjectModel.readOnly: true
      CreatedByUser                                                                                                              as  CreatedByUser,
      @ObjectModel.readOnly: true
      CreationDateTime                                                                                                           as  CreationDateTime,
      @ObjectModel.readOnly: true
      LastChangedByUser                                                                                                          as  LastChangedByUser,
      @ObjectModel.readOnly: true
      LastChangeDateTime                                                                                                         as  LastChangeDateTime,

      assgmt._Text,
      assgmt._Catalog,
      assgmt._Group,
      assgmt._CreatedByUser,
      assgmt._LastChangedByUser,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _Root
}

Learn More