BSEG _ BSAD problems

[Former Member]

Hi,

1) BSEG -- NEBTR is in document currency. How can we convert it to local currency? Is this value already calculated by SAP or do we have to do manual calculation for this?

Scenario:

I have to pull the data in a customer statement form for all the customers who have paid their invoices in local currency. Right now the BSEG table only holds the payments in document currency. What is the fastest way of obtaining the NEBTR in local currency?

2) Also is there a way to know in BSAD whether the payments made are full/partial/residual payments? I know there there is a field called REBZT but it is not getting populated in this table. Is there a way for us to know the fully paid cleared items?

3) Any way to know the fully paid cleared items?

Thanks and points will be assigned

[Former Member]

Hi,

Based on the co.code, get the currency code from t001 and use fm: BAPI_GET_EXCHANGERATE to fetch the exchange rate for that currency, and then calculate to get the local currency or group currency amount.

Regards

Subramanian

[Former Member]

1) Use FM CONVERT_TO_LOCAL_CURRENCY to get the local currency amount.

2) If the document is in BSAD, it's cleared.

Rob

[Former Member]

Hi Lakshman,

look at BKPF-WAERS and BKPF-KURSF.

Perhaps also BSEG-DMBTR and BSEG-WRBTR will help.

Regards, Dieter