topic BSEG _ BSAD problems in Application Development and Automation Discussions

BSEG _ BSAD problems

Former Member — Tue, 16 Jan 2007 00:02:35 GMT

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

Re: BSEG _ BSAD problems

Former Member — Tue, 16 Jan 2007 00:07:19 GMT

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

Re: BSEG _ BSAD problems

Former Member — Tue, 16 Jan 2007 14:54:42 GMT

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

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

Rob

Re: BSEG _ BSAD problems

Former Member — Tue, 16 Jan 2007 15:24:56 GMT

Hi Lakshman,

look at BKPF-WAERS and BKPF-KURSF.

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

Regards, Dieter