topic Re: FB70 Error in BDC SESSION. in Application Development and Automation Discussions

FB70 Error in BDC SESSION.

Former Member — Mon, 01 Oct 2007 03:56:22 GMT

Hi,

I am using BDC Session method to post customer invoice by using Tcode FB70.

I have to schdule this session in background.

I read some posts in forums saying that, FB70(Enjoy Transaction) Won't support BDC SESSION in background scheduling.

If it is true, Then what is the other suitable method.

I checked some BAPIs like, BAPI_ACC_DOCUMENT_POST and BAPI_INCOMING_INVOICE.

But some of my required fields are not available in those BAPIs.

Here are my required fields.

Header_text(18) TYPE c, "Invoice No

altkn(17) TYPE c, "Cust No

bldat(8) TYPE c, "Invoice Date

wrbtr(13) TYPE c, "Gross Amount

s_amt(13) TYPE c, "Sales Amount

sgtxt(40) TYPE c, "Customer Order No

gl_acc(10) TYPE c, "Group

zterm(8) TYPE c, "Pay Terms

So please help in find some solution to my problem.It's very urgent for me.

If possible send me some sample code.

Thanks in Advance!!

I will reward points for the useful answers.

Re: FB70 Error in BDC SESSION.

Former Member — Mon, 01 Oct 2007 07:19:16 GMT

hi,

Are you reading the file from presentation server.....??? In that case it wont run in background mode. You will have to use <b>Open dataset and read dataset</b> statements , after loading the file to application server.

It might work then.

<b>Hope this is helpful, Do reward.</b>

Re: FB70 Error in BDC SESSION.

Former Member — Mon, 01 Oct 2007 07:31:53 GMT

From the description you give, you may find transaction FB01 is suitable for your needs - it can be used to post almost any type of FI document so long as you know your debits and credits, and posting keys and GL accounts etc. So create a recording with SHDB for this transaction to create the type of document you need... but are you sure the BAPI_ACC_DOCUMENT_POST isn't sufficient - the fields will have different names and the customer lines and GL lines will need to go into different internal tables, but it should work too.

Jonathan

Re: FB70 Error in BDC SESSION.

Former Member — Mon, 01 Oct 2007 08:47:16 GMT

Jonathan,

It is not a FI Document. It is customer invoice(FB70). I have to read data from Application server. So is this BAPI (BAPI_ACC_DOCUMENT_POST)serves my purpose??

Re: FB70 Error in BDC SESSION.

Former Member — Tue, 02 Oct 2007 00:33:07 GMT

FB70 is an entry point to SAPMF05A - this handles all manner of documents that relate to finance processing, so I consider them FI documents... Yes, one side of the document ends up against a customer, but the documents created are stored in BKPF, BSEG and all their friends and customer and vendor postings still also hit the relevant reconcilation accounts.

In BAPI_ACC_DOCUMENT_POST you will see tables for:

*"  TABLES
*"      ACCOUNTGL STRUCTURE  BAPIACGL09 OPTIONAL
*"      ACCOUNTRECEIVABLE STRUCTURE  BAPIACAR09 OPTIONAL
*"      ACCOUNTPAYABLE STRUCTURE  BAPIACAP09 OPTIONAL

which is where you separate out the different line types for the BAPI call.