I_SuplrActTaskLifecycleStsPTT

DDL: I_SUPLRACTTASKLIFECYCLESTSPTT SQL: ISUPTSKLCSTPTT Type: view BASIC

Supplier Activity Task Lifecycle Status Process Task Text

I_SuplrActTaskLifecycleStsPTT is a Basic CDS View that provides data about "Supplier Activity Task Lifecycle Status Process Task Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields with key fields SuplrActyTaskLifecycleStatus, Language.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Annotations (11)

NameValueLevelField
EndUserText.label Supplier Activity Task Lifecycle Status Process Task Text view
AbapCatalog.sqlViewName ISUPTSKLCSTPTT view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey SuplrActyTaskLifecycleStatus view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SuplrActyTaskLifecycleStatus
KEY Language ddlanguage
SuplrActyTaskLifecycleStsName
_SuplrActTaskLifecycleStsPT _SuplrActTaskLifecycleStsPT 
@EndUserText.label: 'Supplier Activity Task Lifecycle Status Process Task Text'
@AbapCatalog.sqlViewName: 'ISUPTSKLCSTPTT'
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass:  #META
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.representativeKey: 'SuplrActyTaskLifecycleStatus'

define view I_SuplrActTaskLifecycleStsPTT as select from dd07t 
 association[0..1] to I_Language as _Language on $projection.Language = _Language.Language
 association[1..1] to I_SuplrActTaskLifecycleStsPT as _SuplrActTaskLifecycleStsPT
  on $projection.SuplrActyTaskLifecycleStatus = _SuplrActTaskLifecycleStsPT.SuplrActyTaskLifecycleStatus
{
   key cast ( substring( domvalue_l, 1, 2 ) as /srmsmc/tsk_lifecycle_stat_cd preserving type ) as SuplrActyTaskLifecycleStatus,

  @Semantics.language: true
  key ddlanguage as Language,

  @Semantics.text: true
  cast(ddtext as /srmsmc/status_descr preserving type) as SuplrActyTaskLifecycleStsName,
  
  _SuplrActTaskLifecycleStsPT
}
where domname = '/SRMSMC/TSK_UI_STATUS_ID'
and as4local = 'A'
and ddlanguage = $session.system_language  
and domvalue_l != '01'    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_SUPLRACTTASKLIFECYCLESTSPT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More