P_JOB_Parameter_Analytics

DDL: P_JOB_PARAMETER_ANALYTICS SQL: PPARAJOBANA Type: view BASIC

P_JOB_Parameter_Analytics is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (tbtc_task_params, tbtc_task) and exposes 2 fields with key fields jobname, selname.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
tbtc_task_params params from
tbtc_task task inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPARAJOBANA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY jobname tbtc_task jobname
KEY selname selnamevar 
@AbapCatalog.sqlViewName: 'PPARAJOBANA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#NOT_REQUIRED

@VDM.viewType: #BASIC
@VDM.private: true
@VDM.lifecycle.contract.type: #NONE

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
//@EndUserText.label: 'Parameter for Jobs'

define view P_JOB_Parameter_Analytics
  as select from tbtc_task_params as params
    inner join   tbtc_task        as task on params.taskid = task.taskid
 
{
  key task.jobname,
  key selnamevar as selname
}
where
  (
       selnamevar = 'P_SEL'
    or selnamevar = 'P_DEL'
  )
  and  lowvar     = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TBTC_TASK",
"TBTC_TASK_PARAMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More