topic Re: BAPI_ACC_DOCUMENT_POST in Application Development and Automation Discussions

BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 13:22:02 GMT

I am using the BAPI_ACC_DOCUMENT_POST for my Account Payable data load.

I am unable to find the field "amount in local currecny" and "amount in group currency" in the bapi structures.

I found only "amount is document currency" in CURRENCYAMOUNT table.

Please help me where can we find in the above BAPI.

Note: standard transaction used for this load in FB01.

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 13:35:56 GMT

All amount data have to be loaded in CURRENCYAMOUNT table parameter, the field CURRENCYAMOUNT-CURR_TYPE indicates the currency type:

00 - Document Currency

10 - Internal Currency

11 - Internal and group currency

.....

See the fix values of domain CURTP

So if yuo need to indicate the amount in document and internal currency, u have to append two records in CURRENCYAMOUNT for each item: one with CURR_TYPE = 00 and one with CURR_TYPE = 10.

Max

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 13:41:18 GMT

Max,

Thank you very much for your help.

i will go ahead with this information.

I have one question.

I want to upload only one record. not two.

for same record uploading document currency, local currency, group currency is not possible?

Please help me.

Edited by: puneindian on Aug 11, 2009 3:53 PM

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 14:10:33 GMT

you need to pass single record with multiple times like

00 Document currency

append internal table with same data without currency, just change currency

10 Company code currency

again append internal table with same data without currency, just change currency

11 Company code currency, group valuation

12 Company code currency, profit center valuation

20 Controlling area currency

30 Group currency

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 14:14:59 GMT

Reddy,

Thank you.

If I append multiple times, multiple line items will be stored. Right?

For one line item, is it not possible to upload the data of therre currencies?

when user checks thru FB03 Tcode, all three currencies are to be displayed for one line item.

I think, three line items will be displayed as per your suggestion.

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 14:24:14 GMT

No! Only one item will be stored in BSEG.

U should considere the system will calculate the amount in internal currency using the rate of the day, I suppose it will do for group currency too.

U can transfer all data in document, internal and group currency the the system wll insert only oner record in BSEG and

- Local currency will be stored in BSEG-WRBTR

- Internal currency will be stored in BSEG-DMBTR

- Groupt currency will be stored in BSEG-DMB* (I don't know the field)

Anyway u should considere If you don't need to specify the amount in internl and group currency while posting the document online by FB01, u don't need to do it by BAPI too.

It usually transfer the amount in internal currency only if it need to use a particular change rate.

Max

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 14:33:55 GMT

Max,

thanks for the help .

assume document currency is INR (indian rupees), local currency is also INR, group currency is USD.

My code will be like this.

wa_CURRENCYAMOUNT-CURR_TYPE = '00'.

wa_CURRENCYAMOUNT-AMT_DOCCUR = '1000'. (actually get from file)

wa_CURRENCYAMOUNT-CURR_TYPE = '10'.

wa_CURRENCYAMOUNT-AMT_DOCCUR = '1000'. (actually get from file)

wa_CURRENCYAMOUNT-CURR_TYPE = '30'.

wa_CURRENCYAMOUNT-AMT_DOCCUR = '23'. (actually get from file)

append wa_CURRENCYAMOUNT to gt_CURRENCYAMOUNT.

1)this means, only one record with different currencies uploaded?

2) for group currency(30), based on exhange rate, data is to be populated. how can we achieve this

2a) based on date 31-Oct-2009, group currency is to be calculated based on doc/local currency. how to achieve this?

please help me.

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 14:45:58 GMT

assume document currency is INR (indian rupees), local currency is also INR, group currency is USD.

In this situation u don't need to transfer the record for local currency, but only document and group currency:

wa_CURRENCYAMOUNT-CURR_TYPE = '00'.
wa_CURRENCYAMOUNT-AMT_DOCCUR = '1000'. (actually get from file)

wa_CURRENCYAMOUNT-CURR_TYPE = '30'.
wa_CURRENCYAMOUNT-AMT_DOCCUR = '23'. (actually get from file)

1)this means, only one record with different currencies uploaded?

Yes, only one record

2) for group currency(30), based on exhange rate, data is to be populated. how can we achieve this
2a) based on date 31-Oct-2009, group currency is to be calculated based on doc/local currency. how to achieve this?

I think the system uses the same change date in order to get the exchange rate for internal and/or group currency, if any date is indicate as exchange date, the current date will be used.

If you need a different date u need to insert it in the header data DOCUMENTHEADER-TRANS_DATE;

If you need a different rate u need to insert it in the record for the currency:

wa_CURRENCYAMOUNT-CURR_TYPE = '30'.

wa_CURRENCYAMOUNT-EXCH_RATE = .......

Max

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 11 Aug 2009 14:55:33 GMT

Thanks for your help.

Re: BAPI_ACC_DOCUMENT_POST

Former Member — Wed, 12 Aug 2009 13:07:48 GMT

Hi,

When i try to upload three different currencies,

only final one(group currency doc type "30") is getting appended.

program is dumping . reason is amount for type "00" is not available.

Please help me.