I_STRPJOURNALENTRYLOG

CDS View

Journal entries selected by a report run

I_STRPJOURNALENTRYLOG is a CDS View in S/4HANA. Journal entries selected by a report run. It contains 7 fields. 38 CDS views read from this table.

Used by 38 CDS view(s) 7 fields

CDS Views using this table (38)

ViewTypeJoinVDMDescription
C_AR_StRpPurTaxItemLogCube view inner CONSUMPTION Argentina Purchase VAT Tax Item - Cube
C_AR_StRpSalesTaxItemLogCube view inner CONSUMPTION Cube View for AR Sls Scenario with Reptd Item Log Data
C_AR_StRpSalesVATRateDetailC view inner CONSUMPTION Argentina Sales VAT Rates Detail Cube
C_AR_StRpVATPrintPurJrnlEntrC view inner CONSUMPTION Argentina VAT Print Purchase - Cube
C_AR_StRpVATPrintSlsJrnlEntrC view inner CONSUMPTION Argentina VAT Print Sales - Cube
C_AR_StRpVATPrintTaxDetailC view inner CONSUMPTION Argentina VAT Print Tax Details - Cube
C_CL_StRpSalesLedger view_entity inner CONSUMPTION Chile Sales Ledger Entry
C_GB_StRpParkedDocTxItmBoxCube view left_outer CONSUMPTION Parked Items for Statutory Reporting
C_InventoryGLAcctBalCube view left_outer CONSUMPTION Turkey Inventory CDS cube view
C_NL_StRpAcceptedTaxItemCube view inner CONSUMPTION [Obsolete] NL VAT - Reported Tax Items
C_PE_CashFlowIndirectCube view_entity inner CONSUMPTION Peru Cash Flow Indirect Method - Cube
C_PE_StRpPurLdgrFrgnSuplrC view inner CONSUMPTION Purchase Ledger Foreign Vendors - Cube
C_PL_StRpTxItmWithEUTxClCrrtnC view left_outer CONSUMPTION EU Sales Tax Item View - Correction Run
C_StRpWhldgTaxItmForClearing view from CONSUMPTION Withholding Tax Open Line Items with clearing run status
I_CO_DIANVatTaxReturnBox view_entity inner COMPOSITE Colombia DIAN VAT Tax Return Box
I_ID_StRpTaxItemCube view left_outer COMPOSITE Tax Item Statutory Reporting for ID
I_IN_StRpGSTAnnexCube view left_outer COMPOSITE Tax Item Details for GST Returns
I_StRpAccountingDocumentItmC view inner COMPOSITE Accounting Document Item Cube for Statutory Reporting
I_StRpRunDetails view from COMPOSITE Reporting Periods of Reporting Documents
I_TH_AssetDepreciationCube view left_outer COMPOSITE Cube View for Thailand Depreciation List
I_TH_AssetDisposalCube view left_outer COMPOSITE Thailand: Disposal List Cube
I_TR_StRpElectronicLedgerItem view inner COMPOSITE Electronic Ledger Documents Reporting
P_AR_InvoiceAcctgDocuments view left_outer COMPOSITE Relevant Documents Of Official Document Numbering
P_AR_PurTaxItemVATRate view from CONSUMPTION Argentina Purchase Tax Item - VAT Rate
P_AR_StRpJournalEntryLogDetail view inner CONSUMPTION Selected Journal Entries for Reporting with Details
P_AR_StRpJrnlLdgrJrnlEntryItem view inner CONSUMPTION Argentina Journal Entry Item for Journal Ledger Report
P_BE_DomesticSalesListUnion view inner CONSUMPTION Test Domestic sales list Union
P_CO_DIANInvoiceFinDocument view inner CONSUMPTION DEPRECATED - DO NOT USE!
P_CO_DIANJrnlEntrInvcFinDocLog view inner CONSUMPTION DEPRECATED - DO NOT USE!
P_CO_DIANStRpJournalEntryItemC view inner CONSUMPTION G/L Formats - BP Logic for Journal Entry
P_CZ_StRpRptdTxItmWithEUTxClfn view left_outer CONSUMPTION Previously Reported Tax Items - Corr.
P_FINSTATEMENTACCBALBYPERIODLG view_entity inner COMPOSITE Financial Statement with Comparison Period Query by Period
P_GLACCTBALWITHCOMPRNPERIODLG view_entity inner COMPOSITE GL Account Line Items in Report Period and Comparison Peirod
P_PL_StRpReportingGroupsCr view left_outer CONSUMPTION Reporting Groups - Correction Run
P_SI_StstcsFinAccount view_entity inner COMPOSITE Slovenian SFR report
P_StRpBPTaxItemX view_entity inner COMPOSITE Business Partner Tax Item (Journal Entry Item Branch 2)
P_StRpBPTaxItemX3 view_entity inner COMPOSITE Business Partner Tax Item (Journal Entry Item Branch 2)
P_StRpTaxItmWithEUTaxClass7 view left_outer COMPOSITE EU Sales tax Item View for Statutory Reporting

Fields (7)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 12
KEY CompanyCode CompanyCode 12
KEY FiscalYear FiscalYear 12
KEY StatryRptCategory StatryRptCategory 33
KEY StatryRptgEntity StatryRptgEntity 33
KEY StatryRptRunID StatryRptRunID 32
_TransactionalTaxItem _TransactionalTaxItem 1 
@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 )

Learn More