C_GLJrnlEntrToBeVerifiedWrkFlw

DDL: C_GLJRNLENTRTOBEVERIFIEDWRKFLW SQL: CGLJEVERWF Type: view CONSUMPTION

Jrnl entry to be verified and work item

C_GLJrnlEntrToBeVerifiedWrkFlw is a Consumption CDS View that provides data about "Jrnl entry to be verified and work item" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 7 fields with key field WorkflowTaskInternalID.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask _WorkflowTask from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CGLJEVERWF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Jrnl entry to be verified and work item view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
AccountingDocument _JournalEntryToBeVerified AccountingDocument
CompanyCode _JournalEntryToBeVerified CompanyCode
FiscalYear _JournalEntryToBeVerified FiscalYear
ObjectKey _JournalEntryToBeVerified ObjectKey
DocumentDate _JournalEntryToBeVerified DocumentDate
PostingDate _JournalEntryToBeVerified PostingDate 
@AbapCatalog.sqlViewName: 'CGLJEVERWF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Jrnl entry to be verified and work item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#OUTPUT_EMAIL_DATA_PROVIDER]

define view C_GLJrnlEntrToBeVerifiedWrkFlw
  as select from           I_WorkflowTask            as _WorkflowTask
    left outer to one join I_WorkflowTaskApplObject  as _WorkflowTaskApplObject   on  _WorkflowTaskApplObject.WorkflowTaskInternalID = _WorkflowTask.WorkflowTaskInternalID
                                                                                  and _WorkflowTaskApplObject.WorkflowObjectRole     = '01'
    left outer to one join I_GLJrnlEntryToBeVerified as _JournalEntryToBeVerified on _JournalEntryToBeVerified.ObjectKey = _WorkflowTaskApplObject.TechnicalWrkflwObject

{
  key _WorkflowTask.WorkflowTaskInternalID,
      _JournalEntryToBeVerified.AccountingDocument,
      _JournalEntryToBeVerified.CompanyCode,
      _JournalEntryToBeVerified.FiscalYear,
      _JournalEntryToBeVerified.ObjectKey,
      _JournalEntryToBeVerified.DocumentDate,
      _JournalEntryToBeVerified.PostingDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLJRNLENTRYTOBEVERIFIED",
"I_WORKFLOWTASK",
"I_WORKFLOWTASKAPPLOBJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More