R_MNGJRNLENTRYWORKFLOWSTATUS

CDS View

Journal Entry Workflow Status

R_MNGJRNLENTRYWORKFLOWSTATUS is a CDS View in S/4HANA. Journal Entry Workflow Status. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MngJrnlEntryWorkflowStatus view_entity from CONSUMPTION Journal Entry Workflow Status

Fields (4)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
AcctgDocumentWorkflowStatus AcctgDocumentWorkflowStatus 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Journal Entry Workflow Status'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #MIXED
}

@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type:#SAP_INTERNAL_API
}

define view entity R_MngJrnlEntryWorkflowStatus
as select from P_ManageJournalEntry  as _JournalEntry

  association [0..1] to I_DocSingleWorkflowInfo        as _Status       on  $projection.CompanyCode        = _Status.CompanyCode
                                                                        and $projection.AccountingDocument = _Status.AccountingDocument
                                                                        and $projection.FiscalYear         = _Status.FiscalYear                                                                 
  
{
  key _JournalEntry.CompanyCode,
  key _JournalEntry.FiscalYear,
  key _JournalEntry.AccountingDocument,
  
  cast( 
    // normal document with wf

    case when ( _JournalEntry.TransactionCode = 'FBVB' ) 
           and ( _JournalEntry.AccountingDocumentCategory =  '' 
             or  _JournalEntry.AccountingDocumentCategory =  'L' 
             or  _JournalEntry.AccountingDocumentCategory =  'U' ) 
           and ( _Status.WorkItem <> '000000000000' )
           and ( _Status.AccountingDocument is not null ) 
              then _Status.AccountingDocumentStatus
         // parked with wf

         when ( _JournalEntry.TransactionCode = 'FBDC_P001'
             or _JournalEntry.TransactionCode = 'FBDC_P050'
             or _JournalEntry.TransactionCode = 'FBDC_P051' )
           and( _JournalEntry.AccountingDocumentCategory =  'Z'
             or _JournalEntry.AccountingDocumentCategory =  'V' )
           and ( _Status.AccountingDocument is not null ) 
               then _Status.AccountingDocumentStatus
         else
           // other documents mapped as Not Workflow Relevant

           'Q'
            end as fac_mje_wf_status preserving type )                     as AcctgDocumentWorkflowStatus
            

}

Learn More