I_WrkflwScenDefSAPObjNodeType

DDL: I_WRKFLWSCENDEFSAPOBJNODETYPE Type: view COMPOSITE

Exposes SONT to a Workflow Scenario

I_WrkflwScenDefSAPObjNodeType is a Composite CDS View that provides data about "Exposes SONT to a Workflow Scenario" in SAP S/4HANA. It reads from 3 data sources (SWD_GET_WORKFLOW_LEADOBJ, I_WorkflowScenarioDefinition, I_SAPObjectNodeTypeRprstn) and exposes 6 fields with key field WorkflowScenarioDefinition. It has 2 associations to related views.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
SWD_GET_WORKFLOW_LEADOBJ Object inner
I_WorkflowScenarioDefinition Scenario from
I_SAPObjectNodeTypeRprstn Sont inner

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_WorkflowScenarioDefText _WorkflowScenarioDefText $projection.WorkflowScenarioDefinition = _WorkflowScenarioDefText.WorkflowScenarioDefinition
[0..*] I_SAPObjectNodeTypeText _SAPObjectNodeTypeText $projection.SAPObjectNodeType = _SAPObjectNodeTypeText.SAPObjectNodeType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWSCENDEF view
AbapCatalog.buffering.type #NONE view
EndUserText.label Exposes SONT to a Workflow Scenario view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey WorkflowScenarioDefinition view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkflowScenarioDefinition I_WorkflowScenarioDefinition WorkflowScenarioDefinition
SAPObjectNodeType I_SAPObjectNodeTypeRprstn SAPObjectNodeType
SAPObjectType I_SAPObjectNodeTypeRprstn SAPObjectType
SONTRepresentativeCDSView I_SAPObjectNodeTypeRprstn SONTRepresentativeCDSView
_WorkflowScenarioDefText _WorkflowScenarioDefText
_SAPObjectNodeTypeText _SAPObjectNodeTypeText 
@AbapCatalog : {
  sqlViewName: 'IWRKFLWSCENDEF',
  buffering.type: #NONE
}
@EndUserText.label: 'Exposes SONT to a Workflow Scenario'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel : {
  usageType : {
    dataClass: #META,
    serviceQuality: #C,
    sizeCategory: #S
  }
}
@ObjectModel.representativeKey: 'WorkflowScenarioDefinition'
define view I_WrkflwScenDefSAPObjNodeType 
  as select from I_WorkflowScenarioDefinition as Scenario
//   determine leading object for workflow scenario   

     inner join  SWD_GET_WORKFLOW_LEADOBJ     as Object   on Object.WorkflowScenarioDefinition = Scenario.WorkflowScenarioDefinition
//   get corresponding SONT and SOT from leading object type       

     inner join  I_SAPObjectNodeTypeRprstn    as Sont     on ( ( Object.LeadingObjectCatid    = 'BO' and
                                                                 Sont.SONTWorkflowBORRprstn   = Object.LeadingObjectTypeid )
                                                              or
                                                               ( Object.LeadingObjectCatid    = 'CL' and 
                                                                 Sont.SONTWorkflowClassRprstn = Object.LeadingObjectTypeid )
                                                              )
//   texts                                           

  association [0..*] to I_WorkflowScenarioDefText as _WorkflowScenarioDefText on $projection.WorkflowScenarioDefinition = _WorkflowScenarioDefText.WorkflowScenarioDefinition
  association [0..*] to I_SAPObjectNodeTypeText as _SAPObjectNodeTypeText on $projection.SAPObjectNodeType = _SAPObjectNodeTypeText.SAPObjectNodeType 
{
  @ObjectModel.text.association: '_WorkflowScenarioDefText'
  key Scenario.WorkflowScenarioDefinition as WorkflowScenarioDefinition,  
      Sont.SAPObjectNodeType              as SAPObjectNodeType,
      Sont.SAPObjectType                  as SAPObjectType,
      Sont.SONTRepresentativeCDSView      as SONTRepresentativeCDSView,
     
  _WorkflowScenarioDefText,
  _SAPObjectNodeTypeText 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPOBJECTNODETYPERPRSTN",
"I_WORKFLOWSCENARIODEFINITION",
"SWD_GET_WORKFLOW_LEADOBJ"
],
"ASSOCIATED":
[
"I_SAPOBJECTNODETYPETEXT",
"I_WORKFLOWSCENARIODEFTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More