topic Re: BAPI_ACC_DOCUMENT_POST for FB50 posting in Application Development and Automation Discussions

BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Thu, 03 Feb 2011 11:37:40 GMT

Hi,

I am using BAPI_ACC_DOCUMENT_POST for FB50 posting . In return [] I am getting message saying "Document posted successfully: ZBKPF OFDOPN7111901 0000000100" . Ahter this I have used 'BAPI_TRANSACTION_COMMIT' but when I am checking in BKPF I am not getting any records. It seems the database is not getting updated

Please help me this.

Thanks,

Shweta

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

former_member404244 — Thu, 03 Feb 2011 11:42:01 GMT

Hi,

Try to pass WAIT = 'X' in the function mdoule "BAPI_TRANSACTION_COMMIT" and see.

Regards,

Nagaraj

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Thu, 03 Feb 2011 11:53:55 GMT

Yes I am passing WAIT = X.

is it due to wait time?

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

former_member404244 — Thu, 03 Feb 2011 12:08:51 GMT

Hi,

After doing that also the record is not updated?

Regards,

Nagaraj

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Thu, 03 Feb 2011 12:36:12 GMT

No its not updating. I even gave Wait time of 10 secs eventhough its not

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Thu, 03 Feb 2011 13:06:26 GMT

After executing your program, can you check transaction FB03 to see the latest accouting document created.

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 05:32:48 GMT

Hi ,

No it is not showing anything in FB03.

I am very confused , actually Bapi is not even updating the FI tables.

Thanks

Shweta

Edited by: Shweta . on Feb 4, 2011 6:33 AM

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 05:51:04 GMT

What is the contents in RETURN structure ? Does it contain the record with message id RW and message no : 605 (Document posted successfully) ?

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

former_member404244 — Fri, 04 Feb 2011 05:51:11 GMT

Hi,

can you please paste your code..Please have alook at the below code for your reference which works perfectly.



* Prepare Header Information
      wa_dochead-bus_act    = text-018.
      wa_dochead-username   = sy-uname.
      wa_dochead-comp_code  = p_comp.
      wa_dochead-pstng_date = wa_bseg_temp-budat.
      wa_dochead-doc_date   = sy-datum.
      wa_dochead-fisc_year  = lv_year.
      wa_dochead-doc_type   = lc_zi.
      wa_dochead-ref_doc_no = text-019.
      wa_dochead-header_txt = text-027.


* Prepare Item information
      wa_accgl-itemno_acc = lv_count.
      wa_accgl-gl_account = wa_bseg_temp-hkont.
      wa_accgl-costcenter = p_cost.
      wa_accgl-pstng_date = wa_bseg_temp-budat.
      wa_accgl-value_date = sy-datum.
      wa_accgl-acct_type  = 'S'.
      wa_accgl-fisc_year  = lv_year.
      wa_accgl-de_cre_ind = wa_bseg_temp-shkzg.
      wa_accgl-bus_area   = wa_bseg_temp-gsber.
      APPEND wa_accgl TO t_accgl.

* Prepare Currency Information
      wa_curramt-itemno_acc = lv_count.
      wa_curramt-currency   = wa_bkpf-waers.
      IF wa_bseg_temp-shkzg EQ 'S'.
        wa_curramt-amt_doccur = wa_bseg_temp-wrbtr.
      ELSEIF wa_bseg_temp-shkzg EQ 'H'.
        wa_curramt-amt_doccur = wa_bseg_temp-wrbtr * -1.
      ENDIF.
      APPEND wa_curramt TO t_curramt.

      CLEAR : wa_curramt,
              wa_accgl,
              wa_bseg_temp.

      lv_count = lv_count + 1.

*    ENDLOOP.

      AT END OF budat.
*  Call bapi for posting document.
        IF t_accgl[] IS NOT INITIAL.

          CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'
            EXPORTING
              documentheader = wa_dochead
            TABLES
              accountgl      = t_accgl
              currencyamount = t_curramt
              return         = t_return1.

          APPEND LINES OF t_return1 TO t_return.

          READ TABLE t_return1 WITH KEY type = 'S' TRANSPORTING NO FIELDS.
          IF sy-subrc EQ 0.
            w_success = c_x.
            CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
              EXPORTING
                wait = 'X'.
            v_hold_time = sy-uzeit.
          ELSE.
            CLEAR w_success.
            CALL FUNCTION 'BAPI_TRANSACTION_ROLLBACK'.

          ENDIF .
        ENDIF. " t_accgl IS INITIAL
        CLEAR : wa_dochead.
        REFRESH : t_accgl,
                  t_curramt,
                  t_return1.


      ENDAT.
    ENDLOOP. " bseg TMP

Regards,

Nagaraj

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 07:17:43 GMT

hi,

just use BAPI 'BAPI_TRANSACTION_COMMIT' without giving any exporting parameter and check it once and also check the READ statement on t_return1 whether the sy-subrc value is zero or not in debugging.

rgds

shivraj

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 08:36:27 GMT

I am using below code

Header

ls_header-obj_type = p_objtyp.

ls_header-obj_key = p_objkey.

ls_header-obj_sys = p_objsys.

ls_header-bus_act = p_busact.

ls_header-username = p_usernm.

ls_header-header_txt = p_txt.

ls_header-comp_code = p_compcd.

ls_header-doc_date = p_docdte.

ls_header-pstng_date = p_pstgdt.

ls_header-trans_date = p_trnsdt.

ls_header-fisc_year = p_fy.

ls_header-fis_period = p_period.

ls_header-doc_type = p_doctyp.

Accounting Table

CLEAR ls_account.

ls_account-itemno_acc = p_item.

ls_account-gl_account = p_gl_acc.

ls_account-stat_con = p_acctyp.

ls_account-co_busproc = p_busprc.

APPEND ls_account TO lt_account.

CLEAR ls_account.

ls_account-itemno_acc = p_item2.

ls_account-gl_account = p_glacc2.

ls_account-stat_con = p_actyp2.

ls_account-co_busproc = p_busprc.

ls_account-func_area = p_func.

APPEND ls_account TO lt_account.

Currency Table

CLEAR ls_currency.

ls_currency-itemno_acc = p_item.

ls_currency-curr_type = p_curtyp.

ls_currency-currency = p_curncy.

ls_currency-currency_iso = p_dctype.

ls_currency-amt_doccur = p_amdccr.

APPEND ls_currency TO lt_currency.

CLEAR ls_currency.

ls_currency-itemno_acc = p_item2.

ls_currency-curr_type = p_crtyp2.

ls_currency-currency = p_crncy2.

ls_currency-currency_iso = p_dcype2.

ls_currency-amt_doccur = p_amdcr2.

APPEND ls_currency TO lt_currency.

Criteria

CLEAR ls_criteria.

ls_criteria-itemno_acc = p_item2.
ls_criteria-fieldname = p_fldnam.
ls_criteria-character = p_char.
APPEND ls_criteria TO lt_criteria.

CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'

EXPORTING

documentheader = ls_header

CUSTOMERCPD =
CONTRACTHEADER =
IMPORTING
OBJ_TYPE =
OBJ_KEY =
OBJ_SYS =

TABLES

accountgl = lt_account

ACCOUNTRECEIVABLE =
ACCOUNTPAYABLE =
ACCOUNTTAX =

currencyamount = lt_currency

CRITERIA = lt_criteria

VALUEFIELD =
EXTENSION1 =

return = lt_return

PAYMENTCARD =
CONTRACTITEM =
EXTENSION2 =
REALESTATE =
ACCOUNTWT =

if sy-subrc = 0.

COMMIT WORK and wait.

WAIT UP TO 10 SECONDS.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = 'X'.

endif.

I tried it with exporting parameter in BAPI_TRANSACTION _COMMIT also

But it is not shouing any record in BKPF.

Thanks.

Shweta

Edited by: Shweta . on Feb 4, 2011 9:37 AM

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

former_member404244 — Fri, 04 Feb 2011 08:56:17 GMT

Hi,

Did you tried my piece of code.. comment these three and see.. Don't use sy-subrc check, go for reading return table as i have used.


ls_header-obj_type = p_objtyp.
ls_header-obj_key = p_objkey.
ls_header-obj_sys = p_objsys.

Regards,

Nagaraj

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 09:05:44 GMT

Hi Nagaraj,

When I commented these 3 line I am getting below error:

Error in document: BKPFF $ ERP100

FI/CO interface: Inconsistent FI/CO document header data for updating

In your code how you are getting BKPF and BSEG values.

Edited by: Shweta . on Feb 4, 2011 10:07 AM

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

former_member404244 — Fri, 04 Feb 2011 09:11:54 GMT

Hi,

Ok then uncomment it and do the read for the return table and see if you are getting any error in the return table..

Bseg and bkpf data comes from same bseg and bkpf tables.

Regards,

Nagaraj

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

KiranJ — Fri, 04 Feb 2011 09:27:35 GMT

DATA: gs_documentheader  TYPE  bapiache09, "Header
      gs_accountgl  TYPE  bapiacgl09,
      gt_accountgl  TYPE TABLE OF   bapiacgl09,
      gs_currencyamount TYPE bapiaccr09 ,
      gt_currencyamount TYPE  TABLE OF  bapiaccr09,
      gs_return TYPE bapiret2,
      gt_return TYPE TABLE OF  bapiret2.
DATA: v_itemno_acc LIKE   gs_accountgl-itemno_acc,
      gv_year TYPE char04 .

TYPES : BEGIN OF ty_data,
        level TYPE i,
*        dtype like  gs_documentheader-doc_type,      " Doc Type
        bukrs LIKE  gs_documentheader-comp_code,     " Company Code
        monat LIKE  gs_documentheader-fis_period,    " Period
        year LIKE  gs_documentheader-fisc_year,      " Fiscal Year
        rmwi LIKE gs_documentheader-bus_act,         " Transaction Area

  "Item
*        ITEMNO_ACC like   gs_accountgl-ITEMNO_ACC,   " Item In GL A/C
        kostl LIKE  gs_accountgl-costcenter,         " Cost Center
*        prctr like gs_accountgl-profit_ctr ,         " Profit Center
        mat LIKE gs_accountgl-gl_account,            " Gl Account
*        pstng_date  like    gs_accountgl-pstng_date, " Psoting Date
*         ITEM_TEXT	like gs_accountgl-ITEM_TEXT,

*        cposnr like gs_currencyamount-itemno_acc,     " Item Number
*        pswsl like  gs_currencyamount-currency ,      " Currency
        amt LIKE gs_currencyamount-amt_doccur ,       "Amount

     END OF ty_data.

DATA : gt_data TYPE TABLE OF ty_data ,
       gs_data TYPE ty_data.

DATA v_int type i.


**---selection screen
PARAMETERS:p_file TYPE ibipparms-path OBLIGATORY.
*
**---f4 help for the file from PC
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
*
  PERFORM get_f4help.
*
*--start-of-selection .
START-OF-SELECTION.
*
  PERFORM upload_file_itab.
  CLEAR v_int.
  LOOP AT gt_data INTO gs_data.
    if v_int eq 3.
      v_int = 0.
    endif.
    IF gs_data-level = 0.
      v_int = v_int + 1.
*      CLEAR v_ITEMNO_ACC.
      CLEAR gs_documentheader.
* Fill the data for docheader for BAPI
      gs_documentheader-pstng_date =  '20100331'.
      gs_documentheader-doc_type =   'SA'.
      gs_documentheader-comp_code = gs_data-bukrs.          "'1947'.
      gs_documentheader-doc_date = '20100331'.
      gs_documentheader-username = sy-uname.
*      gs_documentheader-ref_doc_no = 'reference'.
      gs_documentheader-fis_period = gs_data-monat.         " '01'.
      gs_documentheader-fisc_year =  gs_data-year.          "'2009'.
      gs_documentheader-bus_act =  gs_data-rmwi.                 "'RFBU'.
*
    ELSEIF gs_data-level = 1.
*for each line item
      v_int = v_int + 1.
      v_itemno_acc = v_itemno_acc + 1.

      CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
        EXPORTING
          input  = v_itemno_acc
        IMPORTING
          output = v_itemno_acc.

      gs_accountgl-itemno_acc = v_itemno_acc.          " '0000000003'.
      gs_accountgl-costcenter = gs_data-kostl.           "'DEPT A'.
*      gs_accountgl-profit_ctr = gs_data-prctr .
      gs_accountgl-gl_account = gs_data-mat.           "'0000400000'.
      gs_accountgl-pstng_date =  '20100331'." gs_data-pstng_date.           "'20090401'.
      gs_accountgl-item_text = 'Initial Upload'.
      APPEND gs_accountgl TO gt_accountgl.
      CLEAR gs_accountgl.
*
*      gs_accountgl-ITEMNO_ACC = gs_data-ITEMNO_ACC  " '0000000004'.
*      gs_accountgl-costcenter = 'DEPT A'.
*      gs_accountgl-profit_ctr = gs_data-prctr .
*      gs_accountgl-gl_account = '0000410000'.
*      gs_accountgl-pstng_date = '20090401'.
*
*      APPEND gs_accountgl TO gt_accountgl.
*      CLEAR gs_accountgl.

      gs_currencyamount-itemno_acc = v_itemno_acc. " '0000000003'.
      gs_currencyamount-currency = 'INR'.
      gs_currencyamount-amt_doccur = gs_data-amt.           " 5000.


      APPEND gs_currencyamount TO gt_currencyamount.
      CLEAR gs_currencyamount.

*      gs_currencyamount-ITEMNO_ACC = '0000000004'.
*      gs_currencyamount-currency = 'INR'.
*      gs_currencyamount-amt_doccur = -5000.
*
*      APPEND gs_currencyamount TO gt_currencyamount.
*      CLEAR gs_currencyamount.

      IF v_int EQ 3.
        CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'
          EXPORTING
            documentheader = gs_documentheader
          TABLES
            accountgl      = gt_accountgl
            currencyamount = gt_currencyamount
            return         = gt_return.
        BREAK-POINT.
        READ TABLE gt_return INTO  gs_return WITH KEY type = 'E'.

        CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
          EXPORTING
            wait = 'X'.
        COMMIT WORK.
      ENDIF.


    ENDIF.

  ENDLOOP.

Use this code in my this code wored fine

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 13:55:14 GMT

Hi Shweta,

You can try posting a document through the BAPI itself first in SE37.

If it works then there is some problem in your code.

Thanks,

Manish

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Fri, 04 Feb 2011 14:52:19 GMT

I have a question:

Has been recently altered a numerical range of financial documents using transaction code SNRO?

That might be one reason for the error you reported.

Regards.

Rafael Rojas.

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

jim_kasper — Fri, 04 Feb 2011 15:05:25 GMT

Sree99 - What object type (obj_type) are you usign in your code? BKPFF?

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Sat, 05 Feb 2011 07:14:58 GMT

Your report is perfect you just declare and pass only extension1 as follow:


daa : extension1 LIKE bapiacextc   OCCURS 0 WITH HEADER LINE,

CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'
      EXPORTING
        documentheader = documentheader
      TABLES
        accountgl      = accountgl
        currencyamount = currencyamount
        return         = return
        extension1     = extension1
      EXCEPTIONS
        OTHERS         = 1.

Re: BAPI_ACC_DOCUMENT_POST for FB50 posting

Former Member — Mon, 07 Feb 2011 06:46:26 GMT

Hi ,

I have a difficulty in passing the extensiom parameter.

What is this extension [] parameter for and what I would be required to pass in it.