topic Re: Problem in create billing document thr VF01 in Application Development and Automation Discussions

Problem in create billing document thr VF01

Former Member — Thu, 18 May 2006 13:22:46 GMT

Hi,

I create a billing document for the delivery order number using VF01 through BDC batch input session. Here is the program flow,

1. perform open_bdc.

2. perform populate_bdc_data.

3. perform insert_bdc_session.

4. perform call_transaction_using_VF01 - only to capture return error messages.

5. perform event_trigger - trigger an event which starts a job that is defined to run when the event is raised. The job will execute the RSBDCSUB.

6. perform close_bdc.

7. perform process_bdc - process the bdc session through

SUBMIT RSBDCSUB.

My problem is, when creating billing document, the program not able to capture the return error message if there is any error occurs. The message tab (after CALL TRANSACTION) gives error message with message type as 'S'. so the program was not able to capture/display error records.

Is there any way to capture the return error message correctly?

Or Any suitable BAPI available?

Pl help me to sort out the issue.

Thanks in advance.

Re: Problem in create billing document thr VF01

Former Member — Thu, 18 May 2006 13:27:46 GMT

use format_meessage

CALL TRANSACTION 'PA30' USING IT_BDCDATA MODE 'A'

UPDATE 'S'

MESSAGES INTO IT_MSG.

LOOP AT IT_MSG WHERE MSGTYP = 'E' .

PERFORM CREATE_SESSION.

PERFORM INSERT_INTO_SESSION.

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = IT_MSG-MSGID

LANG = SY-LANGU

NO = IT_MSG-MSGNR

V1 = IT_MSG-MSGV1

V2 = IT_MSG-MSGV2

V3 = IT_MSG-MSGV3

V4 = IT_MSG-MSGV4

IMPORTING

MSG = V_MSG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

plz reward if useful

Re: Problem in create billing document thr VF01

Former Member — Thu, 18 May 2006 13:28:23 GMT

Hi,

you can try with GN_INVOICE_CREATE, generally this is used to create invoices.

Regards

vijay

Re: Problem in create billing document thr VF01

Former Member — Thu, 18 May 2006 13:31:29 GMT

WELCOME TO SDN

Use Format_message fm

i.e,

LOOP AT IT_MSGS WHERE MSGTYP = 'E' .

perform create_session.

perform insert_bdc_session.

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = IT_MSGS-MSGID

LANG = SY-LANGU

NO = IT_MSGS-MSGNR

V1 = IT_MSGS-MSGV1

V2 = IT_MSGS-MSGV2

V3 = IT_MSGS-MSGV3

V4 = IT_MSGS-MSGV4

IMPORTING

MSG = W_MSGS

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDLOOP.

Re: Problem in create billing document thr VF01

Former Member — Thu, 18 May 2006 13:45:56 GMT

Check these out

BAPI_BILLINGDOC_CREATE

BAPI_BILLINGDOC_CREATEFROMDATA

BAPI_BILLINGDOC_CREATEMULTIPLE

Re: Problem in create billing document thr VF01

Former Member — Fri, 19 May 2006 04:06:44 GMT

Thanks for the replies.

Of course i am doing,

LOOP AT IT_MSG WHERE MSGTYP = 'E'.

CALL FUNCTION 'FORMAT_MESSAGE'

*capture the error message

ENDLOOP.

This is not my issue.

After call transaction, ff the transaction fails, there are error messages like

'billing document were not created: see log' in IT_MSG. But the MSGTYP is 'S'. That was the problem.

Since the MSGTYP is 'S', the program not able to capture the error records. I want to capture all error records and send it to recycle table to be re-processed in next batch run.

Regading BAPI_BILLINGDOC_CREATE, I tried it, it just internally execute call transaction VF01 and the returns the copy of IT_MSG(MESSAGE TAB).

Regarding GN_INVOICE_CREATE, I haven't tried. Will update you soon. will it reurn any error msg or return table.

Re: Problem in create billing document thr VF01

Former Member — Sun, 21 May 2006 10:14:57 GMT

I tried with GN_INVOICE_CREATE...it doesn't work...it creates invoice based on that data but not on delivery oder...

Actually my program create invoice based on the reference delivery order number through VF01.

Is there any other FM/BAPI wich creates invoice with return status?

Re: Problem in create billing document thr VF01

Former Member — Tue, 23 May 2006 11:42:58 GMT

I tried the FM: rv_invoice_create which creates Invoice for a delivery order number. It is working fine.

Anyway, thanks for your replies.

Re: Problem in create billing document thr VF01

Former Member — Thu, 22 Jun 2006 09:59:07 GMT

we are facing the same problem. We are trying to create invoice from delivery number using RV_INVOICE_CREATE but we are getting runtime error for duplicate data in VBUK table. We are trying to put some data in XVBRK-ZUONR field as well. Any help is appreciated as we don't want to use BDC for VF01.

Panchdev Sharma