topic Re: GL upload through BAPI_ACC_DOCUMENT_POST in Application Development and Automation Discussions

GL upload through BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 23 Jan 2007 11:05:26 GMT

I am uploading GL data from external file. Every thing is fine, but only one error message is comming in error table.

Error in document: BKPFF $ DEVCLNT110

Can any one plz help.

Thanks in advance.

Sharat

Re: GL upload through BAPI_ACC_DOCUMENT_POST

former_member772790 — Tue, 23 Jan 2007 11:17:06 GMT

hi,

this is the only error u r getting or else other than this any more errors u r getting in the status record. once check in the data records for data , it will say which field entry is wrong.

Re: GL upload through BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 23 Jan 2007 11:50:31 GMT

Hi Pesi,

Thanks for early reply.

The other error message is "G/L account 113000 is not defined in chart of accounts 1000"

Can u plz put some light on this

Thanks,

Sharat

Re: GL upload through BAPI_ACC_DOCUMENT_POST

former_member404244 — Tue, 23 Jan 2007 12:22:00 GMT

Hi sarat,

check the below code...

REPORT znam_bapi_test_2 .

DATA: g_documentheader TYPE bapiache08,

g_bapi_wait LIKE bapita-wait,

ta_accountgl TYPE STANDARD TABLE OF bapiacgl08,

ta_currencyamount TYPE STANDARD TABLE OF bapiaccr08,

ta_return TYPE STANDARD TABLE OF bapiret2,

ta_extension1 TYPE STANDARD TABLE OF bapiextc,

wa_accountgl TYPE bapiacgl08,

wa_currencyamount TYPE bapiaccr08,

wa_extension1 TYPE bapiextc,

wa_return TYPE bapiret2.

Parameters:

c1_item LIKE wa_currencyamount-itemno_acc DEFAULT '0000000001',
c1_type LIKE wa_currencyamount-curr_type DEFAULT '00',
c1_curr LIKE wa_currencyamount-currency DEFAULT 'EUR',

c1_amt LIKE wa_currencyamount-amt_doccur DEFAULT '1',

c1_sign TYPE char1 DEFAULT '-',

c2_item LIKE wa_currencyamount-itemno_acc DEFAULT '0000000002',
c2_type LIKE wa_currencyamount-curr_type DEFAULT '00',
c2_curr LIKE wa_currencyamount-currency DEFAULT 'EUR',

c2_amt LIKE wa_currencyamount-amt_doccur DEFAULT '1',

c2_sign TYPE char1 DEFAULT '+',

field1 LIKE wa_extension1-field1 DEFAULT '1'.

g_documentheader-username = 'LKS'.

g_documentheader-header_txt = 'Default text in header'.

g_documentheader-comp_code = '1005'.

g_documentheader-ac_doc_no = ' '.

g_documentheader-fisc_year = '2006'.

g_documentheader-doc_date = '20060818'.

g_documentheader-pstng_date = '20060818'.

g_documentheader-doc_type = 'SA'.

g_documentheader-ref_doc_no = ' '.

wa_accountgl-itemno_acc = '0000000001'.

wa_accountgl-gl_account = '0000220000'.

wa_accountgl-item_text = 'ITEM TEXT Default 1'.

APPEND wa_accountgl TO ta_accountgl.

wa_accountgl-itemno_acc = '0000000002'.

wa_accountgl-gl_account = '0000220000'.

wa_accountgl-item_text = 'ITEM TEXT Default 2'.

APPEND wa_accountgl TO ta_accountgl.

wa_currencyamount-itemno_acc = '0000000001'.

wa_currencyamount-curr_type = '00'.

wa_currencyamount-currency = 'EUR'.

IF c1_sign = '-'.

wa_currencyamount-amt_doccur = c1_amt * -1.

ELSE.

wa_currencyamount-amt_doccur = c1_amt.

ENDIF.

APPEND wa_currencyamount TO ta_currencyamount.

wa_currencyamount-itemno_acc = '0000000002'.

wa_currencyamount-curr_type = '00'.

wa_currencyamount-currency = 'EUR'.

wa_currencyamount-amt_doccur = c2_amt.

IF c2_sign = '-'.

wa_currencyamount-amt_doccur = c1_amt * -1.

ELSE.

wa_currencyamount-amt_doccur = c1_amt.

ENDIF.

APPEND wa_currencyamount TO ta_currencyamount.

IF field1 IS NOT INITIAL.

wa_extension1-field1 = field1.

APPEND wa_extension1 TO ta_extension1.

ENDIF.

CALL FUNCTION 'BAPI_ACC_GL_POSTING_POST'

EXPORTING

documentheader = g_documentheader

IMPORTING
OBJ_TYPE =
OBJ_KEY =
OBJ_SYS =

TABLES

accountgl = ta_accountgl

currencyamount = ta_currencyamount

return = ta_return

extension1 = ta_extension1.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = g_bapi_wait

IMPORTING

return = wa_return.

LOOP AT ta_return INTO wa_return.

WRITE: / wa_return-type, wa_return-id, wa_return-number,

wa_return-message.

ENDLOOP.

regards,

nagaraj

Re: GL upload through BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 23 Jan 2007 12:32:41 GMT

Hi Sharat,

This error is coming because of either Cost Center you have provided is not correct. If it is ok then tell functional consultant to fix the error you are getting. "The other error message is "G/L account 113000 is not defined in chart of accounts 1000".

Ashevn

Re: GL upload through BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 23 Jan 2007 12:35:55 GMT

Hi Sharat,

In my opinion, there are two options :

- 113000 is not defined in SKA1 for chart of account 1000. ( check it )

- You'll have to use FM for conversion :

  CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
    EXPORTING
      input  = w_gl_account
    IMPORTING
      output = w_vendor_no.

* in order to complete the account with the leading '0'

Hope this helps,

Erwan

Re: GL upload through BAPI_ACC_DOCUMENT_POST

former_member772790 — Tue, 23 Jan 2007 13:07:30 GMT

hi Sharath,

once check it out for the field GL A/C number in the table:SKB1.

because gl account numbers are defined under different chart of accoutns.

Re: GL upload through BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 23 Jan 2007 13:22:00 GMT

Hi Erwan LE BRUN,

You a are right. Now i am not able to see that error message.

But a new error message has come up 'Balance in transaction currency'

Plz help what should i have to do

Sharat.

Re: GL upload through BAPI_ACC_DOCUMENT_POST

Former Member — Tue, 23 Jan 2007 17:09:35 GMT

'Balance in transaction currency' is the classic msg when the balance of your

account post is not 0 !

The ( + ) lines must be equal to the ( - ) in order that the balance is correct.

Erwan