P_RSHMaintSchedExecStatusTxt

DDL: P_RSHMAINTSCHEDEXECSTATUSTXT SQL: PRSHSCHDEXECSTAT Type: view CONSUMPTION

Maintenance Execution Status Text

P_RSHMaintSchedExecStatusTxt is a Consumption CDS View that provides data about "Maintenance Execution Status Text" in SAP S/4HANA. It reads from 1 data source (I_RSHGetDomainText) and exposes 2 fields with key field MaintOrdSchedExecutionStatus.

Data Sources (1)

SourceAliasJoin Type
I_RSHGetDomainText I_RSHGetDomainText from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRSHSCHDEXECSTAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Maintenance Execution Status Text view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY MaintOrdSchedExecutionStatus
MaintOrdSchedExecutionStatTxt I_RSHGetDomainText DomainText
@AbapCatalog.sqlViewName: 'PRSHSCHDEXECSTAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@EndUserText.label: 'Maintenance Execution Status Text'

/*
CONTRACT*************************************************************************************************************************
Name:                       Maintenance Scheduling Execution Status Text
Specification:              This view returns execution status text
Requires:                   NA
Ensures:                    Execution Status Text is returned
Owners:                     AN, PRP
Contributors:
Unit Test required Y/N:     Y
Additional comments         None
END OF CONTRACT******************************************************************************************************************
*/

define view P_RSHMaintSchedExecStatusTxt
  as select from I_RSHGetDomainText
{
//      @UI.hidden: true

  key cast ( I_RSHGetDomainText.DomainValue as rsh_eam_track_execution_status ) as MaintOrdSchedExecutionStatus,

      //Schedule Status text

      I_RSHGetDomainText.DomainText                                             as MaintOrdSchedExecutionStatTxt

}
where
  I_RSHGetDomainText.DomainValueName = 'RSH_MAINT_SCHED_EXEC_STATUS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RSHGETDOMAINTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/