AR Question

Dear Experts,

I am trying to understand AR functionality in R/3. As you know SAP uses two tables in R/3 for AR. BSID for open items and BSAD for cleared items.

Is the following statement true:

An entry/record is created in BSID table for open items/customer balance and when the customer makes a payment the entry is deleted from BSID table and a record is created in BSAD table.

I would really appreciate if you could confirm if my understanding is correct.

The reason I ask this question is:

We have a custom ABAP program (developed way back) that extracts data from BSID and BSAD based on the User Input parameters Customer Number and Evaluation Date. This program extracts records from BSID and BSAD with the following select conditions given below:

Issue:

When this ABAP Program was run in first week of May 2008 194 records were extracted. Now, in August when I run the same ABAP Program with Evaluation Date of 04/30/2008 I get 212 records. Why is there a difference in the number of records if my Evaluation Date is 04/30/2008

My Input Parameters:

P_DATE: 04/30/2008

S_CUST: 12345

Select Statement for BSID:

P_DATE is the input parameter

S_CUST is the input parameter

SELECT *

FROM BSID

WHERE KUNNR IN S_CUST AND

BUDAT LE P_DATE AND

DMBTR NE 0.

Select Statement for BSAD:

DATE2 = P_DATE + 1.

SELECT *

FROM BSAD

WHERE KUNNR IN S_CUST AND

AUGDT GE DATE2 AND

BUDAT LE P_DATE AND

DMBTR NE 0.

I would really appreciate if someone can enlighten me.

Thanks.

Regards,

Jamspam