P_TimeShtPartialDmndKey

DDL: P_TIMESHTPARTIALDMNDKEY SQL: PTIMESHTPARDMND Type: view COMPOSITE Package: ODATA_HCM_CATS_APPROVE

Partial key of demand

P_TimeShtPartialDmndKey is a Composite CDS View that provides data about "Partial key of demand" in SAP S/4HANA. It reads from 1 data source (I_WBSElementBasicData) and exposes 4 fields with key fields PersonWorkAgreement, WBSElementExternalID, WorkItem, ActivityType. Part of development package ODATA_HCM_CATS_APPROVE.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_WBSElementBasicData WBS inner

Parameters (1)

NameTypeDefault
P_WorkflowTaskInternalID sww_wiid

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PTIMESHTPARDMND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement Cats PersonWorkAgreement
KEY WBSElementExternalID I_WBSElementBasicData WBSElementExternalID
KEY WorkItem Cats WorkItem
KEY ActivityType Cats ActivityType 
@AbapCatalog.sqlViewName: 'PTIMESHTPARDMND'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Partial key of demand'

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_TimeShtPartialDmndKey
  with parameters
    P_WorkflowTaskInternalID : sww_wiid
  as select distinct from P_TimeShtEntriesForApprvl(P_WorkflowTaskInternalID: $parameters.P_WorkflowTaskInternalID) as Cats
    inner join            I_WBSElementBasicData                                                                     as WBS on Cats.WBSElementInternalID = WBS.WBSElementInternalID
{
  key Cats.PersonWorkAgreement,
  key WBS.WBSElementExternalID,
  key Cats.WorkItem,
  key Cats.ActivityType
}

Learn More