BSAD - Payment terms

[Former Member]

Hi friends,

Im currently working on Receipt register report based on Sales employee & Brokers on their billed orders.The problem here I'm facing is there are two types of payment that one is Partial payment and Residual payment.So Im struggling to get the receipts of one invoice(RV) payment if paid thru residual payment ,So I need the term/type how to get or identify that this RV(invoice) is collected by residual or partial.

Pls help me to post the field or the term name of the payments to identify which is Partial & residual payments.

Note: In case of residual payments, the RV doctype has been changed to BR/AB doctype of the balance outstanding amount of one party.

Pls advise.

thanks & regards

sankar.

[Former Member]

Hi friends,

Im currently working on Receipt register report based on Sales employee & Brokers on their billed orders.The problem here I'm facing is there are two types of payment that one is Partial payment and Residual payment.So Im struggling to get the receipts of one invoice(RV) payment if paid thru residual payment ,So I need the term/type how to get or identify that this RV(invoice) is collected by residual or partial.

Pls help me to post the field or the term name of the payments to identify which is Partial & residual payments.

Note: In case of residual payments, the RV doctype has been changed to BR/AB doctype of the balance outstanding amount of one party.

Pls advise.

thanks & regards

sankar.

[Jelena_Perfiljeva]

This is not really an ABAP question and you might want to ask you FI consultant. Also it might work differently in different systems, due to the configuration. So, again, your FI person would be your best source of information.

From experience, I know that it could be very painful trying to get together all the payment information on the invoice. Keep in mind that BSAD is not the only table involved, there is also BSID. The data sort of moves between them. Sometimes you have to look in both places to get the whole picture.

Check if the billing document (invoice) number (originated from VBRK-VBELN) is stored in any field. It could be in VBELN, ZUONR, XBLNR. IMHO only by using that number you'll be able to tie everything together.

[Former Member]

I have a similar problem. We are saving the invoice number using the KIDNO, payment reference, field on both BSID and BSAD. Retrieving accounting documents based solely on that field can cause time-out's, especially when selecting on BSAD, as the BSAD table is only growing and making the problem worse over time.

We are very reluctant to create indeces, which tend to be the quick-fix for an issue like this and can be seen as the advice to several nodes here at SDN. Indeces can quite often cause a worse longterm problem and just fix the issue at hand right here, right now.

Does anyone have any additional information on how to address these, and other similar tables, without creating the indeces. Some tables in SD have shadow tables for this very purpose, which in reality is just an index table, but no changes are made to the system.

Thanks in advance

Dennis

[Jelena_Perfiljeva]

BSAD already is a "shadow" table. For example, table VAKPA is an index table (by partner #) for VBAK. Similarly, BSAD is sort of an index table for BKPF/BSEG. The major difference is that BSAD contains only cleared items, so it is not exactly the same.

If the task is just to provide a report, you might want to consider creating a custom (Z) table, which would be populated 1-2 times daily. Then the users will run the reports on that table, not on BSAD, BSID, etc. I've used this option once and it worked just fine. Sometimes the data is scattered so much that there is just no other option. Even without an index one full table read will take much less time and resources then trigger-happy users running on-demand reports.

Another, more risky and difficult option, is to populate a Z table during the accounting document / payment creation (in a user exit, for example).

I would also check if there is a standard report available. Sometimes information is available not on one report but two. In this case the management will have to evaluate whether it makes sense to spend resources to provide merely a convenience to some users.

[Former Member]

Hi

It depends on how the residual payment is done, anyway u should consider the invoice will be considerate as cleared item (so BSID table) as soon as it will be payed fully.

So the payment will be splitted in several moments, at least two:

- The first one is the partial payment: in this case the system will create a (partial) payment document with the fields REBZG, REBZJ, REBZZ having the number, fyscal year and item number of invoice; this new document shouldn't be cleared.

- The second one is the residual payment: in this case the system will create a (residula) payment document that will clear all documents: the invoice and the partial payment.

Now all documents should be cleared so u should find all document in BSAD and the invoice and partial document should have the residual document as clearing document (field AUGBL).

This should be real if the partial and residula payment are done by standard trx.

Max

[Former Member]

Solved

[Former Member]

Can i know how u solved that. actually i am abap fresher consultant. my first object is payment advice. In that there are two payments they are full payment and part payment. i dono if they are giving part payment the balance amount of that bill where will be stored.if u know that table name please reply me....

Regards,

M.P.Rathish