‎2008 Jul 09 10:34 AM
hi experts,
i want to post a FI document through BDC. i've an excel file like this,
podate curr accno amount
1/1/2007 rmb 10067 100.58-
1/20/2007 rmb 10068 120.68
1/2/2007 rmb 10069 20.1-
if the net amt is 0 then we have post the document.
is it possible to post all the items as a single document thru BDC?
if possible then give some example code.
please help me regarding this.
thanks®ards,
nag.
‎2008 Jul 09 10:43 AM
Hi
U can use the BI std RFBIBL00: it needs a file with the data to generate BDC session.
The file is structurated in according to the std structure BGR00, BBKPF and BBSEG:
- BGR00 has the data for the session;
- BBKPF has the header data;
- BBSEG has the item data;
I don't know the mean of the data field, perhaps it's due date(?), anyway if the total amount is zero:
OPEN DATASET <FILE> IN TEXT MODE.
-> Fill BGR00
TRANSFER BGR00 TO <FILE>.
-> Fill BBKPF
TRANSFER BBKPF TO <FILE>.
LOOP AT FILE.
---> Fill BBSEG.
TRANSFER BBSEG TO <FILE>.
ENDLOOP.
CLOSE DATASET <FILE>.
SUBMIT RFBIBL00 WITH DS_NAME = <FILE>
WITH CALLMODE = 'B' AND RETURN.Max
‎2008 Jul 09 10:43 AM
If it's not too late, don't even start with BDC, use BAPI_ACC_DOCUMENT_POST instead.
You can post up to 999 items in one document.
Thomas
‎2008 Jul 09 10:47 AM
hi,
my requirement is to do with BDC only ,
Is it possible through BDC or not?
rgds,
nag.
‎2008 Jul 09 10:49 AM
‎2008 Jul 09 11:08 AM
hi venkat,
u told check this,
but u didn't find any thing.
rgds,
nag