SAP Knowledge Base Article - Public

3666752 - CDS view to retrieve bank account details linked to general ledger accounts in SAP S/4HANA Cloud Public Edition

Symptom

  • The user is seeking a CDS view that provides bank account details linked to general ledger accounts for use in SAP Analytics Cloud (SAC) to determine bank-related general ledger account balances.
  • The user has checked multiple CDS views related to the bank master but could not find the general ledger account linked to the bank account ID.
  • The user has attached a file containing a screenshot of the required details available in the standard app "Manage Bank Account".
  • The user attempted to consume an API (Overview | General Ledger Account | SAP Business Accelerator Hub) to obtain general ledger account details but encountered an issue with the Communication Arrangement due to the absence of a Communication Scenario.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Attempt to locate a CDS view that provides bank account details linked to general ledger accounts for use in SAC.
  2. Check multiple CDS views related to the bank master.
  3. Verify that the general ledger account linked to the bank account ID is not available in the identified CDS views.
  4. Attempt to consume the API (Overview | General Ledger Account | SAP Business Accelerator Hub) to obtain general ledger account details.
  5. While maintaining the Communication Arrangement, observe that the required Communication Scenario is unavailable, preventing further progress.

Cause

Resolution

  1. Utilize the CDS view "I_HouseBankAccountLinkage" to retrieve the required bank account details linked to general ledger accounts.
  2. Confirm that the necessary data is available in the CDS view for use in SAC to determine bank-related general ledger account balances.

See Also

Overview | General Ledger Account | SAP Business Accelerator Hub

Keywords

cds view, bank account details, general ledger account, sac, sap s/4hana cloud public edition, manage bank account, communication arrangement, communication scenario, I_HouseBankAccountLinkage, bank-related gl account balances , KBA , FIN-FSCM-CLM-BAM-2CL , Bank Account Management (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions