Skip to Content
author's profile photo Former Member
Former Member

differentiate between BSAD and BSID tables

I know that BSAD table will be populated for cleared line items of a customer invoice

and BSID for partial invoices clearing

But i want to know how exactly these two tables will be populated for customer invoice clearing documents

Bcoz i need to develop a report to show customer invoice balances

i am not getting how to fetch correct data from these tables..

Please clarify ...

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2009 at 05:50 AM

    Hi Lavanya,

    Plz go through the link given in order to know "how to populate BSID tables"

    Also check this link,

    BSID and BSAD Table??

    Hope it might help you.

    Thanks,

    Sarita Singh

    Edited by: Sarita Rathour on Aug 17, 2009 8:34 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2009 at 06:04 AM

    you already have answered your question. when ever a document is completely cleared a entry is created in BSAD. till its open or partially cleared it will stay in BSID. the time document is created its present in BSID. when its cleared its removed from this and an entry is created in BSAD

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2009 at 06:48 AM

    If you want to create a customer balance report based on a key date , you can use the following logic.

    Fetch all data from BSID with posting date LE key date.

    Fetch all data from BSAD with posting date LE key date and clearing date GT key date.

    Rgds

    Sathar

    Add a comment
    10|10000 characters needed characters exceeded

    • For cleared items :

      - Fetch all data from BSAD with posting date LE key date and clearing date LE key date.

      For non-cleared items

      - Fetch all data from BSID with posting date LE key date.

      - Fetch all data from BSAD with posting date LE key date and clearing date GT key date.

      Also look at

      3007                           Customer account business object                                   
      BAPI_AR_ACC_GETBALANCEDITEMS   Customer account clearing transactions in a given time period      
      BAPI_AR_ACC_GETCURRENTBALANCE  Closing balance of customer account in current fiscal year         
      BAPI_AR_ACC_GETKEYDATEBALANCE  Customer account balance at a key date                             
      BAPI_AR_ACC_GETOPENITEMS       Customer account open items at a key date                          
      BAPI_AR_ACC_GETPERIODBALANCES  Posting period totals per customer account in current fiscal year  
      BAPI_AR_ACC_GETSTATEMENT       Customer account statement for a given period

      Regards

      Raymond

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.