SAP Knowledge Base Article - Public

3759818 - Period "000" balance carryforward not visible in CDS view I_ACCOUNTINGDOCUMENTJOURNAL - SAP S/4HANA Cloud Public edition

Symptom

GL balance carryforward values are not visible in posting period "000" when querying the CDS view I_AccountingDocumentJournal.

Environment

 SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Open the Customer Data Browser application.
  2. Navigate to CDS Views.
  3. Search for the CDS view I_AccountingDocumentJournal.
  4. Run the view with parameter P_LANGUAGE as required.
  5. Observe that fiscal period "000" does not appear in the results after balance carry forward.

Cause

The CDS view I_AccountingDocumentJournal sources from I_JournalEntryItemCube, which by design excludes technical balance carryforward postings (period 000, document status C). See Journal Entry Item Cube | SAP Help Portal 

Resolution

To retrieve all balance carryforward postings, please use one of the following CDS views instead:

• I_GLAccountLineItemRawData: see G/L Account Line Item - Raw Data | SAP Help Portal 

• I_GLAccountLineItem: see G/L Account Line Item Cube | SAP Help Portal 

See Also

Refer to: KBA 3016757 - Balance Carryforward Postings - S/4HANA Cloud Public Edition

Keywords

period 000, balance carryforward, opening balance, i_accountingdocumentjournal, i_journalentryitemcube, i_glaccountlineitem, i_glaccountlineitemrawdata, cds view, gl balances, customer data browser, posting period 000, bstat c, poper 000, missing period, s/4hana cloud , KBA , FI-GL-IS-2CL , Information System (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions