BDC FOR VENDOR INVOICE FB60

[Former Member]

Hi,

I need to make a BDC to upload transaction data for Vendor invoice thru fb60. Can someone help me with making this BDC. I have multiple invoice line items where G/L Accounts can be same for multiple line items.

plz any help soon will be appreciated ...

[Former Member]

hi Raj,

Here a Example:

report ZTEST

no standard page heading line-size 255.

include bdcrecx1.

start-of-selection.

perform open_group.

perform bdc_dynpro using 'SAPMF05A' '1100'.

perform bdc_field using 'BDC_OKCODE'

'=DUMMY'.

perform bdc_field using 'RF05A-BUSCS'

'R'.

perform bdc_field using 'BDC_CURSOR'

'INVFO-XMWST'.

perform bdc_field using 'INVFO-ACCNT'

'4711'. "LIFNR

perform bdc_field using 'INVFO-BUDAT'

'07.07.2006'.

perform bdc_field using 'INVFO-WRBTR'

'1000'.

perform bdc_field using 'INVFO-WAERS'

'EUR'.

perform bdc_field using 'INVFO-XMWST'

'X'.

perform bdc_field using 'INVFO-MWSKZ'

'V4'.

perform bdc_dynpro using 'SAPMF05A' '1100'.

perform bdc_field using 'BDC_OKCODE'

'=BU'.

perform bdc_field using 'RF05A-BUSCS'

'R'.

perform bdc_field using 'BDC_CURSOR'

'INVFO-XBLNR'.

perform bdc_field using 'INVFO-ACCNT'

'4711'. "LIFNR

perform bdc_field using 'INVFO-XBLNR'

'test'.

perform bdc_field using 'INVFO-WRBTR'

'1.000,00'.

perform bdc_field using 'INVFO-XMWST'

'X'.

perform bdc_field using 'INVFO-MWSKZ'

'V4'.

perform bdc_dynpro using 'SAPMF05A' '1100'.

perform bdc_field using 'INVFO-BLDAT'

'07062006'.

perform bdc_field using 'INVFO-XBLNR'

'TEST'.

perform bdc_field using 'ACGL_ITEM-HKONT(01)'

'467000'.

perform bdc_field using 'ACGL_ITEM-WRBTR(01)'

' 1000'.

perform bdc_field using 'ACGL_ITEM-KOSTL(01)'

'1000'.

perform bdc_transaction using 'FB60'.

perform close_group.

OR Also u can use the

U can use the std batchinput RFBIBL00 (or a BAPI, like BAPI_ACC_DOCUMENT_POST ) instead of to write an own BDC program for FB60.

FB60 is enjoy trx and it couldn't support the BDC for all its functionalities.

For more infor abt the BDC

http://www.sap-img.com/abap/learning-bdc-programming.htm

Assing the points if helpfulll

ranjit

null

null

[Former Member]

Hi Ranjit,

thanks for the program, I think thats a simple recording from SHDB for a BDC for one entry but i need to include multiple table entries in the same invoice. Now my problem is how do i loop through these multiple values as the GL A/C is not unique.

plz help me out on this.

[Former Member]

Have a look to RFBIBL00 and the help there.

Proces;

File from extern system

ABAP that transfer the fields from the file to the structure in RFBIBL00 and this abap submit RFBIBL0.

This program create FB01 postings and not FB60.

Paul

[Former Member]

Thanks Paul,

But I have written small BDC programs before, this fb60 one includes table controls and data where i dont have an unique key to have acontrol loop over multiple table entries.

How should i go ahead with this ..

I didnt quite understand RFBIBL0. If i run the program for every file it give file check failed.