I_GLJrnlEntryToBeVerified

DDL: I_GLJRNLENTRYTOBEVERIFIED SQL: IGLJEVER Type: view COMPOSITE

Interface View of GL JE to be verified

I_GLJrnlEntryToBeVerified is a Composite CDS View that provides data about "Interface View of GL JE to be verified" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 24 fields with key fields CompanyCode, AccountingDocument, FiscalYear. It has 1 association to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry _Header from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DocSingleWorkflowInfo _Status _Header.CompanyCode = _Status.CompanyCode and _Header.AccountingDocument = _Status.AccountingDocument and _Header.FiscalYear = _Status.FiscalYear

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IGLJEVER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Interface View of GL JE to be verified view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
WorkItem _Status WorkItem
Workflow _Status Workflow
TaskProcessingStatus _Status TaskProcessingStatus
OriginalReferenceDocument
ObjectKey I_JournalEntry OriginalReferenceDocument
DocumentReferenceID DocumentReferenceID
AccountingDocumentHeaderText AccountingDocumentHeaderText
CompanyCodeCurrency CompanyCodeCurrency
TransactionCurrency I_JournalEntry TransactionCurrency
AccountingDocumentType AccountingDocumentType
LedgerGroup LedgerGroup
DocumentDate DocumentDate
PostingDate PostingDate
AccountingDocumentCreationDate AccountingDocumentCreationDate
AccountingDocumentCategory AccountingDocumentCategory
ParkedByUser _Status ParkedByUser
CreatedByUser _Status CreatedByUser
AccountingDocumentStatus _Status AccountingDocumentStatus
ReversalReason I_JournalEntry ReversalReason
PlannedReversalDate I_JournalEntry PlannedReversalDate
_Status _Status 
@AbapCatalog.sqlViewName: 'IGLJEVER'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Interface View of GL JE to be verified'
define view I_GLJrnlEntryToBeVerified
  //remove distinct by I337033 2020-08-24

  as select from I_JournalEntry as _Header //distinct

  association [0..1] to I_DocSingleWorkflowInfo as _Status on  _Header.CompanyCode        = _Status.CompanyCode
                                                           and _Header.AccountingDocument = _Status.AccountingDocument
                                                           and _Header.FiscalYear         = _Status.FiscalYear

{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
      _Status.WorkItem,
      _Status.Workflow,
      _Status.TaskProcessingStatus,
      concat( CompanyCode, concat (LPad(AccountingDocument, 10, '0'), FiscalYear )) as OriginalReferenceDocument,
      _Header.OriginalReferenceDocument                                             as ObjectKey,
      DocumentReferenceID,
      AccountingDocumentHeaderText,

      CompanyCodeCurrency,
      _Header.TransactionCurrency,

      AccountingDocumentType,
      LedgerGroup, // 20210930, i530367

      DocumentDate,
      PostingDate,
      AccountingDocumentCreationDate,

      AccountingDocumentCategory,
      _Status.ParkedByUser,
      _Status.CreatedByUser,
      _Status.AccountingDocumentStatus,
      //      case when _Status.AccountingDocumentStatus <> 'R'

      //        and _Status.AccountingDocumentStatus <> 'N'

      //        and _Status.AccountingDocumentStatus <> 'S'

      //        and _Status.AccountingDocumentStatus <> 'W'

      //        and _Status.AccountingDocumentStatus <> 'F'

      //        and _Status.AccountingDocumentStatus <> 'R'

      //        and AccountingDocumentCategory = ' '

      //          then _Status.ParkedByUser

      //          else _Status.CreatedByUser end                                                                                        as ParkedByUser,

      //

      //      case when _Status.AccountingDocumentStatus <> 'R'

      //        and _Status.AccountingDocumentStatus <> 'N'

      //        and _Status.AccountingDocumentStatus <> 'S'

      //        and _Status.AccountingDocumentStatus <> 'W'

      //        and _Status.AccountingDocumentStatus <> 'F'

      //        and _Status.AccountingDocumentStatus <> 'R'

      //        and AccountingDocumentCategory = ' '

      //          then _Status.CreatedByUser

      //          else ' ' end                                                                                                          as CreatedByUser,

      //

      //      case AccountingDocumentCategory

      //        when 'Z' then 'D'

      //        else _Status.AccountingDocumentStatus end                                                                               as AccountingDocumentStatus,


      // auto reversal

      _Header.ReversalReason,
      _Header.PlannedReversalDate,

      _Status

}
/* add by i337033 2021-05-28
   performance tuning */
where
  (
    (
         _Header.AccountingDocumentCategory =  'Z'
      or _Header.AccountingDocumentCategory =  'V'
    )
    and(
         _Header.TransactionCode            =  'FBDC_P001'
      or _Header.TransactionCode            =  'FBDC_P050'
      or _Header.TransactionCode            =  'FBDC_P051'
    )
  )

  or(
    (
         _Header.AccountingDocumentCategory =  ''
      or _Header.AccountingDocumentCategory =  'L'
      or _Header.AccountingDocumentCategory =  'U'
    )
    and(
         _Header.TransactionCode            =  'FBVB'
    )
    --and  _Status.WorkItem                   <> '000000000000'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCSINGLEWORKFLOWINFO",
"I_JOURNALENTRY"
],
"ASSOCIATED":
[
"I_DOCSINGLEWORKFLOWINFO"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More