I_MAINTPHASECONTROLCODE

CDS View

Phase Control Code

I_MAINTPHASECONTROLCODE is a CDS View in S/4HANA. Phase Control Code. It contains 13 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 13 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintenanceOrderPhaseControl view inner COMPOSITE Maintenance Order Phase Controls
I_MaintObjectPhaseControl view inner COMPOSITE Maintenance Object Phase Control Code
I_MaintOrderOpPhaseControl view inner COMPOSITE Maintenance Order Op Phase Controls

Fields (13)

KeyField CDS FieldsUsed in Views
KEY EAMBlockerCodeEntityType EAMBlockerCodeEntityType 3
KEY MaintenanceOrderType MaintenanceOrderType 1
KEY MaintenancePhaseControlName MaintenancePhaseControl,MaintenancePhaseControlName 3
_ConfignDeprecationCode _ConfignDeprecationCode 1
_StatusCode _StatusCode 3
_StatusProfile _StatusProfile 3
ConfigDeprecationCode ConfigDeprecationCode 1
EAMOverallStatusProfile EAMOverallStatusProfile 3
MaintenancePhaseControlText MaintenancePhaseControlText 3
MaintenanceUserStatusCode MaintenanceUserStatusCode 3
MaintPhaseControlAuthorityCode MaintPhaseControlAuthorityCode 3
MaintPhseCtrlIsSetAutomly MaintPhseCtrlIsSetAutomly 3
MaintUserStatusProfileCode MaintUserStatusProfileCode 3 
@AbapCatalog: { sqlViewName: 'IMAINTPHCTRLCD',
                compiler.compareFilter: true ,
                preserveKey: true,
                buffering: {
                  status: #ACTIVE,
                  type: #FULL }
               }
@ClientHandling.algorithm:#SESSION_VARIABLE

@ObjectModel: {
                representativeKey: 'MaintenancePhaseControlName',
                usageType: {
                dataClass: #CUSTOMIZING,
                serviceQuality: #A,
                sizeCategory: #M }
               }
@VDM.viewType: #BASIC
@EndUserText.label: 'Phase Control Code'

define view I_MaintPhaseControlCode
  as select from eam_usrsts_asgn

  association [0..*] to I_MaintPhseCtrlActvtnProcValue as _PhseCtrlCodePhase on  $projection.MaintenanceOrderType        = _PhseCtrlCodePhase.MaintenanceOrderType
                                                                             and $projection.EAMBlockerCodeEntityType    = _PhseCtrlCodePhase.EAMBlockerCodeEntityType
                                                                             and $projection.MaintenancePhaseControlName = _PhseCtrlCodePhase.EAMBlockerCode

  association [0..1] to I_ConfignDeprecationCode       as _ConfignDeprecationCode     on  $projection.ConfigDeprecationCode = _ConfignDeprecationCode.ConfigurationDeprecationCode
  association [0..1] to I_StatusProfile                as _StatusProfile     on  $projection.MaintUserStatusProfileCode = _StatusProfile.StatusProfile

  association [0..1] to I_StatusCode                   as _StatusCode        on  $projection.MaintenanceUserStatusCode  = _StatusCode.StatusCode
                                                                             and $projection.MaintUserStatusProfileCode = _StatusCode.StatusProfile
{
      //eam_usrsts_asgn

  key maintenanceordertype           as MaintenanceOrderType,
  key eamblockercodeentitytype       as EAMBlockerCodeEntityType,
      @ObjectModel.text.element: 'MaintenancePhaseControlText'
  key eamblockercode                 as MaintenancePhaseControlName,
      @ObjectModel.foreignKey.association: '_StatusProfile'
      eamblockercodeuserstsprofile   as MaintUserStatusProfileCode,
      @ObjectModel.foreignKey.association: '_StatusCode'
      eamblockercodestatus           as MaintenanceUserStatusCode,
      @Semantics.text:true
      eamblockercodedesc             as MaintenancePhaseControlText,
      @Semantics.booleanIndicator
      eamisblockercodeactive         as MaintPhseCtrlIsSetAutomly,
      eamoverallstatusprofile        as EAMOverallStatusProfile,
      eamblockercodeauthorizationkey as MaintPhaseControlAuthorityCode,
      @ObjectModel.foreignKey.association: '_ConfignDeprecationCode'
      configurationdeprecationcode   as ConfigDeprecationCode,

      //    Associations

      _PhseCtrlCodePhase,
      _ConfignDeprecationCode,
      _StatusProfile,
      _StatusCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EAM_USRSTS_ASGN"
],
"ASSOCIATED":
[
"I_CONFIGNDEPRECATIONCODE",
"I_MAINTPHSECTRLACTVTNPROCVALUE",
"I_STATUSCODE",
"I_STATUSPROFILE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More