I_StRpJournalEntryLog

DDL: I_STRPJOURNALENTRYLOG SQL: ISRJRNLENTRLOG Type: view COMPOSITE

Journal entries selected by a report run

I_StRpJournalEntryLog is a Composite CDS View (Cube) that provides data about "Journal entries selected by a report run" in SAP S/4HANA. It reads from 1 data source (I_StRpJournalEntryHeaderLog) and exposes 7 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpJournalEntryHeaderLog I_StRpJournalEntryHeaderLog from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISRJRNLENTRLOG view
EndUserText.label Journal entries selected by a report run view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity
KEY StatryRptCategory StatryRptCategory
KEY StatryRptRunID StatryRptRunID
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
_TransactionalTaxItem _TransactionalTaxItem 
@AbapCatalog.sqlViewName: 'ISRJRNLENTRLOG'
@EndUserText.label: 'Journal entries selected by a report run'
@VDM.viewType: #COMPOSITE
@Analytics: { dataCategory: #CUBE }
@AccessControl.authorizationCheck: #CHECK 
@ClientHandling.algorithm: #SESSION_VARIABLE 
//Documentation about annotations can be found at http://help.sap.com searching for CDS annotations 

@ObjectModel.usageType.sizeCategory: #XL 
@ObjectModel.usageType.serviceQuality: #X 
@ObjectModel.usageType.dataClass: #MIXED 
@AbapCatalog.preserveKey:true
@Metadata.allowExtensions: true


define view I_StRpJournalEntryLog as 
  select from I_StRpJournalEntryHeaderLog 
association[1..*] to I_TransactionalTaxItem as _TransactionalTaxItem
   on
   (I_StRpJournalEntryHeaderLog.CompanyCode = _TransactionalTaxItem.CompanyCode
   and I_StRpJournalEntryHeaderLog.FiscalYear = _TransactionalTaxItem.FiscalYear 
   and I_StRpJournalEntryHeaderLog.AccountingDocument = _TransactionalTaxItem.AccountingDocument )
  
  {
    key StatryRptgEntity as StatryRptgEntity,
    key StatryRptCategory as StatryRptCategory,
    key StatryRptRunID as StatryRptRunID,
    key CompanyCode as CompanyCode,
    key AccountingDocument as AccountingDocument,
    key FiscalYear as FiscalYear,
    _TransactionalTaxItem
  }
  
  union all
  
  select distinct 
  StatryRptgEntity, 
  StatryRptCategory, 
  StatryRptRunID, 
  CompanyCode, 
  AccountingDocument, 
  FiscalYear,
  _TransactionalTaxItem
  from I_StRpJournalEntryTaxItemLog
  association[1..*] to I_TransactionalTaxItem as _TransactionalTaxItem on
   (I_StRpJournalEntryTaxItemLog.CompanyCode = _TransactionalTaxItem.CompanyCode
   and I_StRpJournalEntryTaxItemLog.FiscalYear = _TransactionalTaxItem.FiscalYear 
   and I_StRpJournalEntryTaxItemLog.AccountingDocument = _TransactionalTaxItem.AccountingDocument )
  
          
  union all
  
  select distinct 
  StatryRptgEntity, 
  StatryRptCategory, 
  StatryRptRunID, 
  CompanyCode, 
  AccountingDocument, 
  FiscalYear,
  _TransactionalTaxItem
  from I_StRpWhldgTaxItemLog          
  association[1..*] to I_TransactionalTaxItem as _TransactionalTaxItem on
   (I_StRpWhldgTaxItemLog.CompanyCode = _TransactionalTaxItem.CompanyCode
   and I_StRpWhldgTaxItemLog.FiscalYear = _TransactionalTaxItem.FiscalYear 
   and I_StRpWhldgTaxItemLog.AccountingDocument = _TransactionalTaxItem.AccountingDocument )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPJOURNALENTRYHEADERLOG",
"I_STRPJOURNALENTRYTAXITEMLOG",
"I_STRPWHLDGTAXITEMLOG"
],
"ASSOCIATED":
[
"I_TRANSACTIONALTAXITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More