topic Re: BAPI for FB50 in Application Development and Automation Discussions

BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:07:29 GMT

Hi Experts,

Is there any BAPI for FB50. BDC is giving me error. When i enter more than 7 items through SHDB recording any i click on insert button, enter the record and then save, it gives me error Specify account number because when i click on insert button, the business area gets applied to all line items, then i have to manually clear the business area. Then only it gets saved. Please suggect me if there is any BAPI for FB50.

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:12:25 GMT

try this BAPI :BAPI_ACC_GL_POSTING_POST

Regards

Shiva

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:15:54 GMT

hi,

plz use : BAPI_ACC_DOCUMENT_POST

BAPI_ACC_GL_POSTING_POST

also refer:

regards

rahul

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:16:35 GMT

Hi,

Goto Se37 and Type BAPI_ACC* then press f4 Key you will get list of BAPI's for GL Posting choose as per your requirement.

Vikas

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:17:52 GMT

I had previously referred to this BAPI but was not able to pass the parameters. Can you tell me how do i pass the parameters.

At header level i need to pass Doc. Date, Reference, Doc. Header text, Document Type

At item level i need to pass G/L Account, D/C, Amount in Doc. curr, Tax code, Company code and WBS element.

Thanks in advance.

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:20:48 GMT

check

BAPI_ACC_DOCUMENT_CHECK

regards,

Ramya

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 06:29:19 GMT

Hi Priti,

Go through the Documentation of the BAPI you will get the clear Idea How to proceed.

If that is not understood, please feel free to reply.

Regards

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 11:45:09 GMT

Hi Vikas,

As i have already mentioned the fields which i want to upload, can u tell me which BAPI to use

BAPI_ACC_GL_POSTING_POST or BAPI_ACC_DOCUMENT_POST and can u tell me the parameters i need to pass especially at the item level.

Re: BAPI for FB50

Former Member — Thu, 18 Dec 2008 14:26:57 GMT

Hi Priti,

USE BAPI_ACC_DOCUMENT_POST

"At header level i need to pass Doc. Date, Reference, Doc. Header text, Document Type"

ALL These Fields are available in Structure DOCUMENTHEADER Import Parameter.

"At item level i need to pass G/L Account, D/C, Amount in Doc. curr, Tax code, Company code and WBS element."

To populate items fields you have to use Structure ACCOUNTGL and CURRENCYAMOUNT in Tables tab.

Please do remember to populate some mandatory fields like BUS_AREA etc. You will come to know about the mandatory fields by clicking on the structures in BAPI Documentation.

Regards.

Re: BAPI for FB50

Former Member — Thu, 25 Dec 2008 12:15:13 GMT

But on execution it is giving me the following errors.

Num Message

609 Error in document: BKPFF $ DEVCLNT300

014 FI/CO interface: Line item entered several times

What values do i have to give in OBJ_TYPE and OBJ_KEY.

If i give value in OBJ_TYPE as 'BKPF' then it is giving me 5 errors which includes

609 Error in document: BKPF

Re: BAPI for FB50

Former Member — Thu, 25 Dec 2008 16:38:54 GMT

Hi Priti,

Try This.

OBJ_TYP = BEBD.

OBJ_KEY = "Object Key should be any 10 digits".

In case the problem is not solved. Please revert with your code and flat file structure of one record.

Regards,

Vikas

Re: BAPI for FB50

Former Member — Fri, 26 Dec 2008 04:27:16 GMT

Hi Vikas,

I am executing the FM directly through SE37 for test purpose. Now while checking, I have given OBJ_TYP = BEBD and OBJ_KEY = 1400000010. Now its giving me the following error.

609 Error in document: BEBD 1400000010

602 Required field OBJ_SYS was not transferred in parameter DOCUMENTHEADER

602 Required field BUS_ACT was not transferred in parameter DOCUMENTHEADER

Re: BAPI for FB50

Former Member — Fri, 26 Dec 2008 05:02:36 GMT

Hi Priti,

Are you passing

OBJ_SYS

BUS_ACT to DOCUMENTHEADER properly. Hope you are not using inverted commas with these values.

If you miss a single parameter you will get Error609. Please check and as i said send the code and flat file to me.

Regards,

Vikas

Re: BAPI for FB50

Former Member — Fri, 26 Dec 2008 05:05:55 GMT

See this Sample Code..


*&---------------------------------------------------------------------*
*& Report  ZBAPIACCDOCUMENTPOST1                                       *
*&                                                                     *
*&---------------------------------------------------------------------*
*&                                                                     *
*&                                                                     *
*&---------------------------------------------------------------------*

REPORT  ZBAPIACCDOCUMENTPOST1                   .

*&---HEADER DECLARATION
DATA: HEADER TYPE BAPIACHE09. " HEADER DATA


*&----G/L ACCOUNT ITEM
DATA: ACCOUNTGL TYPE STANDARD TABLE OF BAPIACGL09.


*&----ACCOUNTS PAYABLE ITEMS

DATA: ACCOUNTPAYABLE TYPE STANDARD TABLE OF BAPIACAP09.
DATA: WA_ACCOUNTPAYABLE TYPE BAPIACAP09.

*&---CURRENCY ITEMS
DATA: CURRENCY_AMOUNT TYPE STANDARD TABLE OF BAPIACCR09.

*&----RETURN PARAMETER
DATA: RETURN TYPE STANDARD TABLE OF BAPIRET2 with header line.
**********************************************************************
*	WORK-AREA DECLARATION
**********************************************************************
*&----WORKAREA FOR G/L ACCOUNT ITEM
DATA: WA_ACCOUNTGL TYPE BAPIACGL09.

*&---WORKAREA FOR CURRENCY ITEMS
DATA: WA_CURRENCY_AMOUNT TYPE BAPIACCR09.
**********************************************************************
	INITIALIZATION.
**********************************************************************
HEADER-OBJ_TYPE = 'BEBD'.
HEADER-OBJ_KEY = '1000000050'.
HEADER-OBJ_SYS = 'B3TCLNT800'.
HEADER-HEADER_TXT = 'TEST HEADER'.
HEADER-USERNAME = 'DEVELOPER'.
HEADER-COMP_CODE = 'JKT1'.
HEADER-FISC_YEAR = '2008'.
HEADER-DOC_DATE = SY-DATUM.
HEADER-PSTNG_DATE = SY-DATUM.
HEADER-TRANS_DATE = SY-DATUM.
HEADER-DOC_TYPE = 'KR'.
HEADER-BUS_ACT = 'RMRP'.


*WA_ACCOUNTGL-ITEMNO_ACC = '0000000010'.
*WA_ACCOUNTGL-GL_ACCOUNT = '0000400200'.
*WA_ACCOUNTGL-ITEM_TEXT = 'SO_DOC'.
*WA_ACCOUNTGL-DE_CRE_IND = 'S'.
*wa_accountgl-costcenter = 'JK000'.
*WA_ACCOUNTGL-VENDOR_NO = 'A125'.
*WA_ACCOUNTGL-REF_KEY_3 = '31'.
*
*APPEND WA_ACCOUNTGL TO ACCOUNTGL.
*CLEAR WA_ACCOUNTGL.
*
*WA_ACCOUNTGL-ITEMNO_ACC = '0000000020'.
*WA_ACCOUNTGL-GL_ACCOUNT = '0000400200'.
*WA_ACCOUNTGL-ITEM_TEXT = 'SO_DOC'.
*WA_ACCOUNTGL-DE_CRE_IND = 'H'.
*wa_accountgl-costcenter = 'JK000'.
*WA_ACCOUNTGL-REF_KEY_3 = '40'.
*
*APPEND WA_ACCOUNTGL TO ACCOUNTGL.
*CLEAR WA_ACCOUNTGL.


WA_ACCOUNTPAYABLE-ITEMNO_ACC = '10'.
WA_ACCOUNTPAYABLE-VENDOR_NO = 'A125'.
WA_ACCOUNTPAYABLE-REF_KEY_3 = '31'.
WA_ACCOUNTPAYABLE-BUS_AREA = 'JKTD'.

APPEND WA_ACCOUNTPAYABLE TO ACCOUNTPAYABLE.
CLEAR WA_ACCOUNTPAYABLE.


WA_ACCOUNTPAYABLE-ITEMNO_ACC = '20'.
WA_ACCOUNTPAYABLE-GL_ACCOUNT = '400200'.
WA_ACCOUNTPAYABLE-REF_KEY_3 = '40'.
WA_ACCOUNTPAYABLE-BUS_AREA = 'JKTD'.

APPEND WA_ACCOUNTPAYABLE TO ACCOUNTPAYABLE.
CLEAR WA_ACCOUNTPAYABLE.



WA_CURRENCY_AMOUNT-ITEMNO_ACC = '0000000010'.
WA_CURRENCY_AMOUNT-AMT_DOCCUR = '500'.
WA_CURRENCY_AMOUNT-CURRENCY = 'INR'.
APPEND WA_CURRENCY_AMOUNT TO CURRENCY_AMOUNT.
CLEAR WA_CURRENCY_AMOUNT.

WA_CURRENCY_AMOUNT-ITEMNO_ACC = '0000000020'.
WA_CURRENCY_AMOUNT-AMT_DOCCUR = '-500'.
WA_CURRENCY_AMOUNT-CURRENCY = 'INR'.
APPEND WA_CURRENCY_AMOUNT TO CURRENCY_AMOUNT.
CLEAR WA_CURRENCY_AMOUNT.

**************************************************************
*	START-OF-SELECTION
**************************************************************

START-OF-SELECTION.
CALL FUNCTION 'BAPI_ACC_DOCUMENT_POST'
  EXPORTING
    DOCUMENTHEADER          = HEADER
*   CUSTOMERCPD             =
*   CONTRACTHEADER          =
* IMPORTING
*   OBJ_TYPE                =
*   OBJ_KEY                 =
*   OBJ_SYS                 =
  TABLES
*   ACCOUNTGL               = ACCOUNTGL
*   ACCOUNTRECEIVABLE       =
   ACCOUNTPAYABLE          = ACCOUNTPAYABLE
*   ACCOUNTTAX              =
    CURRENCYAMOUNT          = CURRENCY_AMOUNT
*   CRITERIA                =
*   VALUEFIELD              =
*   EXTENSION1              =
    RETURN                  = RETURN
*   PAYMENTCARD             =
*   CONTRACTITEM            =
*   EXTENSION2              =
*   REALESTATE              =
          .


IF return-type EQ 'S'.

COMMIT WORK.
*CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
** EXPORTING
**   WAIT          =
* IMPORTING
*   RETURN        = RETURN
*          .
WRITE:/ RETURN-TYPE.
write:/ return-message.

ELSE.
WRITE:/ RETURN-TYPE.
write:/ return-message.

ENDIF.

Code Formatted by: Alvaro Tejada Galindo on Dec 26, 2008 11:09 AM

Re: BAPI for FB50

Former Member — Fri, 26 Dec 2008 06:30:19 GMT

Thanks a lot Vikes. Its working

Re: BAPI for FB50

Former Member — Fri, 26 Dec 2008 06:44:00 GMT

Great.

ALL THE BEST.

Vikas.

Re: BAPI for FB50

Former Member — Tue, 30 Dec 2008 12:33:22 GMT

Hi,

Is it possible to get the document no. generated by this BAPI???

Re: BAPI for FB50

Former Member — Wed, 31 Dec 2008 08:41:31 GMT

Hi,

how do i get the document no. generated by this BAPI??

Re: BAPI for FB50

Former Member — Wed, 31 Dec 2008 09:23:56 GMT

Hi Priti,

This BAPI is used for posting FI Documents for Certain Transaction's like FB50, F-02 etc..

The Document No. gets generated internally, to see that you have to refer the DBTAB which is getting updated by this BAPI...

Vikas

Re: BAPI for FB50

Former Member — Wed, 31 Dec 2008 09:41:20 GMT

Hi Vikas,

I know that i will need to refer the dbtab. but is there any other way out. Or if i need to refer the dbtab i.e. BKPF or BSEG, then what are the parameters i will need to pass for the same