Skip to Content
avatar image
Former Member

IS-Banking tables

Hi,

Does anyone have any documentation about tables/data model of the Banking solution?

I'm new to this solution and frankly I don't know where sap is saving the data... debugging here is quite impossible.

Thanks in advance.

Ling

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 01, 2008 at 07:59 PM

    Hi Ling,

    Did you find the tables? I'm also searching for them all over the web but there ir no answer.

    Thanks,

    Maria

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 02, 2008 at 04:33 PM

    Hi Ling,

    all bank tables start with B.. Bknf, bkpf...., take a look here :

    http://www.erpgenie.com/abap/tables_fi.htm

    if helpfull reward point are appreciated

    Edited by: Pierluigi Demaria on Oct 2, 2008 6:33 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2008 at 11:25 AM

    Hi Ling,

    I am not sure what you need the database tables for. From my point of view, it would be much more appropriate to look at the BAPIs, BADIs and services that SAP for Banking provide.

    Manipulating database tables directly is a potential problem, as you would bypass the consistency checks provided by the software. The BAPIs call these checks, hence ensuring consistent data.

    Please be aware that in the current Banking Services, the data model is quite complex, especially in the master data for transactional banking and in the analytical banking. The risk of breaking something by bypassing the business logic layer is very high.

    Could you elaborate on your need for direct access to / understanding of the database tables?

    Thanks and kind regards,

    Joerg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Ling,

      appreciate that you're asking here, before launching an OSS message!

      This is to make you aware there is a lot of documentation available out-of-the-box

      SAP provides inside the system.

      Knowing that there are no "big picture" models shared on the internet on entity relationships, data, database tables and the connection between BDT views and database tables,

      here are some examples how you can find out yourself:

      E.g. on your very question about the link between account holder and account master:

      1. Starting with the knowledge that the SAP client file, BP is an application-independent static data area, it is obvious that the link can only be found inside the static data of the account master.

      2. Call any account master

      3. Click on the "Technical documentation" button in the upper symbol bar

      4. Choose the hyperlink for contract framework

      5. Find the entry for all links between the account master and data external to the account master, BCA_CN_LINK

      This is your answer in a technical sense, as its input and output are by GUID's, not external numbers or names.

      If you want a clear name and external ID:

      1. IN BCA_CN_LINK, use the account GUID to find the link to the BP's GUID under the BCA010 entry (this role represents the account holder)

      2. Search BUT000, the central data 1 table for BP data, using the BP's GUID as input.

      For other relations inside the account master, search in step

      4. choose the hyperlink for contract elements

      As a conclusion, the prime source for identifying the tables is using the available technical documentation inside the system.

      Whether this leads you to searching via SE54 or via the technical F9 help drilling down to SE11/17, SE37 for function modules is not needed necessarily.

      Furthermore, to excel, you possibly might want to consider a BDT course and a course for "banking services from SAP" course made for developers.

      regards Ralf

      Edited by: Ralf Fischer on Oct 8, 2008 12:43 PM

      Edited by: Ralf Fischer on Oct 8, 2008 12:49 PM