A/R Tables and Process

[Former Member]

Hi,

Can any of you pls let me know , what the flow of data is in A/R process i mean for open items and cleared items.

1. If a open item is cleared will the document still be in BSIDand BSAD or BSAD only.

2. what is the link which we can use to tie the records in BSID and BSAD.

any help would be appreciated and points will be awarded.

Thanks

Priya

[andreas_mann3]

...<i>1. If a open item is cleared will the document still be in BSIDand BSAD or BSAD only.</i> -> in BSAD (and BSEG with augbl and auddt filled) only

(look 2. partial payment; in this case there can be items in bsid and bsad)

<i>2. what is the link which we can use to tie the records in BSID and BSAD.</i>->possibly is a partly clearing: so if there' are 2 or more items in one document and 1 is paid the other not; link is the key bukrs belnr gjahr

A.

Message was edited by:

Andreas Mann

[Former Member]

Hi,

1.After clearing the item will be only in BSAD.

Regards,

Sai

[Former Member]

Hi Priya,

1.) If a open item is cleared then the item is moved to table BSAD and is deleted from table BSID. Table BSEG is cluster table for BSAD and BSID. which contains both cleared as well as open items.

2.) To get both cleared as well as open items for a given selection criteria you need to query both BSAD and BSID table based upon the clearing Date along with other selection crietria as per your requirement.

e.g. If you want to get open items for a particular company code on 20.11.2007 then you need to query these two tables in the following way :

Select Bukrs,.....

from BSID

into gt_BSID

where Bukrs eq p_bukrs

and .......

and <b>Budat LE P_OPEN.</b>

Select Bukrs,.....

from BSAD

appending corresponding fields of table gt_BSID

where Bukrs eq p_bukrs

and .......

and <b>Budat LE P_OPEN</b>

and <b>AUGDT GT P_OPEN</b>.

• Here P_OPEN is the date on which you want to see the open items for a cust. As mentioned in this example it can be 20.11.2007

Please try this. Should help you, In case some more information is needed please revert back.

Regards.

Lalit kabra

[Former Member]

Thanks everybody for the prompt answers, espeically Andreas/Lalit , before i close the topic as answered, i want to clarify one more aspect on this.

1. If it is a partial payment , will the BELNR be same for both the entries, i.e Original balance and the partial payment, i think it comes with two different BELNR, correct me if i am wrong

2. Also will the the invoice no and the BELNR be the same or different, this is becuase i want to list out all the transactions from BSID/BSAD all the open invoices and the balances paid such as down payments, partial payments etc.,

Thanks again

Priya

[Former Member]

Hi Priya,

1.) Accounting Document Number BELNR would be differernt for bach transaction you make. whether it is partial payment or full paymnet.

2.) The Invoice no and Belnr is same in FI. The two documents can be related by a field called Clearing Document ( AUGBL) which is same for the two related documents.

The nature of payment can be checked with field DEBIT/CREDIT Indicator ( SHKZG).

Based upon the value in this field ( S or H ) you can come to know whether Payment has been made or some purchase has been done by the customer and then you can do the final calculation.

Hope this answers your questions.

Reward if helpful!

Regards,

Lalit Kabra

[Former Member]

continuation from previous message.

in summary i want to calculate at any point for a Customer how much she/he owes and the breakup of invoices on the amount he/she owes.

[Former Member]

Hi Priya,

hope this would have solved your problem.

Regards,

Lalit Kabra

Message was edited by:

Lalit Kabra

[Former Member]

Hi Priya,

I am an ABAP consultant i cant explain wht u need but i can help u

with a link where u can find the doc related to ACCOUNTS RECEIVABLE

here is the link

http://www.mwr.navy.mil/mwrprgms/sap/accounts_receivable_july2005.pdf

I hope u can download this and gothrough once

hope this is helpful for u

Reward points if it is useful...

Regards,

Sreenivas

[Former Member]

thanks , everybody for the help, i have assined points to all the relevant answers.

once again thanks