C_RSHJobText

DDL: C_RSHJOBTEXT SQL: CRSHJOBTEXT Type: view CONSUMPTION Package: RSH_CDS_RES

Job Text

C_RSHJobText is a Consumption CDS View that provides data about "Job Text" in SAP S/4HANA. It reads from 1 data source (P_RSHResource) and exposes 8 fields with key fields Job, StartDate. Part of development package RSH_CDS_RES.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_RSHResource P_RSHResource inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRSHJOBTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Job Text view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Job JobText Job
KEY StartDate JobText StartDate
EndDate JobText EndDate
JobName JobText JobName
CompanyCode _ResDetail CompanyCode
CostCenter _ResDetail CostCenter
IsBusinessPurposeCompleted _ResDetail IsBusinessPurposeCompleted
AuthorizationGroup _ResDetail AuthorizationGroup 
@AbapCatalog.sqlViewName: 'CRSHJOBTEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Job Text'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED

/*
CONTRACT**********************************************************************************************************************

Name:                       RSH own view for Job Text View
Specification:              This View returns the country key and country description
Ensures:                    Country are returned
Owners:                     TR
Contributors:               TR
Unit Test required Y/N:     No
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/
define view C_RSHJobText
  as select distinct from I_JobText                                                                            as JobText
    inner join            P_RSHResource ( P_StartDate: $session.system_date, P_EndDate: $session.system_date ) as _ResDetail on _ResDetail.Job = JobText.Job
{

      //I_JOBTEXT

  key JobText.Job,
  key JobText.StartDate,

      //key EndDate,


      JobText.EndDate,
      JobText.JobName,
      /* Associations */
      //I_JOBTEXT

     
      @Consumption.hidden: true
      _ResDetail.CompanyCode,
      @Consumption.hidden: true
      _ResDetail.CostCenter,
      @Consumption.hidden: true
      _ResDetail.IsBusinessPurposeCompleted,
      @Consumption.hidden: true
      _ResDetail.AuthorizationGroup


}
where
  Language = $session.system_language
  and JobText.StartDate <= $session.system_date
  and JobText.EndDate   >= $session.system_date

Learn More