I_STRPJOURNALENTRYLOG

CDS View
7 Fields 39 CDS Views

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. 39 CDS views read from this table.

CDS Views using this table (39)

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_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_StRpAstJrnlEntryItemC view_entity inner CONSUMPTION Asset Journal Entry Item for Peru - Cube
C_PE_StRpPurLdgrDmstcSuplrC view inner CONSUMPTION Purchase Ledger Domestic - 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_CO_DIANVatTaxReturnBox view_entity inner COMPOSITE
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
P_AR_PurTaxItemVATRate view from CONSUMPTION
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_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
P_StRpBPTaxItemX3 view_entity inner COMPOSITE
P_StRpTaxItmWithEUTaxClass7 view left_outer COMPOSITE
P_TR_StRpElectronicLedgerHdr view inner COMPOSITE
P_VE_WithholdingTaxItem 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 34
KEY StatryRptgEntity StatryRptgEntity 34
KEY StatryRptRunID StatryRptRunID 34
_TransactionalTaxItem _TransactionalTaxItem 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Journal entries selected by a report run
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPJOURNALENTRYLOG (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    _TRANSACTIONALTAXITEM,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More