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_StRpPurchaseVATRateDetC view inner CONSUMPTION Argentina Purchase VAT Rates Detail - Cube
C_AR_StRpPurImprtDispatchVATC view inner CONSUMPTION AR Purchase Import Dispatch - Cube
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_BE_DomesticSalesListCube view left_outer CONSUMPTION Domestic Sales List for Belgium
C_CL_StRpJournalEntryItemCube view inner CONSUMPTION Jrnl Entr Items for Chile Reporting Cube
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_StRpPurLdgrDmstcSuplrC view inner CONSUMPTION Purchase Ledger Domentic - Cube
C_PE_StRpPurLdgrFrgnSuplrC view inner CONSUMPTION Purchase Ledger Foreign Vendors - Cube
C_PE_StRpSalesLedgerCube view inner CONSUMPTION Sales Ledger Peru - 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_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_StRpWhldgTaxItem view_entity left_outer COMPOSITE Withholding Tax Item View For Statutory Reporting
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
P_AR_StRpJournalEntryLogDetail view inner CONSUMPTION
P_AR_StRpJrnlLdgrJrnlEntryItem view inner CONSUMPTION
P_CL_JournalEntryItemDocAmount view inner CONSUMPTION
P_CO_DIANInvoiceFinDocument view inner CONSUMPTION
P_CO_DIANJrnlEntrInvcFinDocLog view inner CONSUMPTION
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_PE_StRpJournalEntryItem view inner CONSUMPTION Journal Entry Item for Peru in StRp
P_PL_StRpReportingGroupsCr view left_outer CONSUMPTION Reporting Groups - Correction Run
P_StRpTaxItmWithEUTaxClass7 view left_outer COMPOSITE
P_TR_StRpElectronicLedgerHdr view inner COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 9
KEY CompanyCode CompanyCode 9
KEY FiscalYear FiscalYear 9
KEY StatryRptCategory StatryRptCategory 31
KEY StatryRptgEntity StatryRptgEntity 31
KEY StatryRptRunID StatryRptRunID 31
_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 )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPJOURNALENTRYHEADERLOG",
"I_STRPJOURNALENTRYTAXITEMLOG",
"I_STRPWHLDGTAXITEMLOG"
],
"ASSOCIATED":
[
"I_TRANSACTIONALTAXITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More