SWD_GET_WORKFLOW_LEADOBJ

CDS View

Leading objects of workflow

SWD_GET_WORKFLOW_LEADOBJ is a CDS View in S/4HANA. Leading objects of workflow. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WrkflwScenDefSAPObjNodeType view inner COMPOSITE Exposes SONT to a Workflow Scenario 
@AbapCatalog.sqlViewName: 'SWDVLEADOBJ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Leading objects of workflow'
define view SWD_GET_WORKFLOW_LEADOBJ 
//  get workflow properties as char (table function), value contains name of leading object  

    as select distinct from swd_get_workflow_propts as propts
//  container index table provides object type and category for name        

       left outer join swdscntidx  as idx    on  idx.otype    = substring( propts.WorkflowDefinitionID, 1, 2 )
                                             and idx.objid    = substring( propts.WorkflowDefinitionID, 3, 8 )
                                             and idx.wfd_id   = ' '
                                             and idx.element  = upper( propts.PropertyValue )  
{
// provides scenario, leading object name, object category (BO/CL) and object type    

    key propts.WorkflowDefinitionID as WorkflowScenarioDefinition,
        upper( propts.PropertyValue )       as LeadingObjectName,
        idx.catid                   as LeadingObjectCatid,
        idx.typeid                  as LeadingObjectTypeid    
}
where propts.PropertyName = 'sap.bc.bmt.wfm.flex.leading.object' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SWDSCNTIDX"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More