Technical Articles
999 line limit in FI, MM etc
Did you know that the 999 line limit has been solved?
Our best developers in Germany have come up with solutions to post FI and MM documents (among others) with more than 999 lines.
This feat is achieved vi the BAPI technology, not through online transaction processing.
For GL documents the BAPI is BAPI_ACC_DOCUMENT_POST
For MM-LIV documents the BAPI is BAPI_INCOMING_INVOICE_CREATE
Simply search OSS using one of the following keywords to find documentation:
Incoming invoice, maximum number of line items in an FI document, 999, F7 727, newGL, new G/L, General Ledger Accounting (new), PRCTR, KOSTL
I found it!
It was not easy, it is very well hidden, as is normal on the SAP support portal, but the tenth note I found was the correct one.
My guess is you are referring to OSS Note 1353125 which in the "other terms" section contains the exact string of words starting with "Incoming invoice" above.
Do I win a prize for finding it?
Cheersy Cheers
Paul
Lol, yes you do. I didn’t put in a particular note number because there
are so many notes on this subject. If you hit the wrong one first, you might
think it doesn’t work for your situation.
Thanks for reading my blog, you are first! Karma to you.
Regards,
PS, another good note to read is: 1497092
Are there plans in the future to increase the current 999 limit for BAPI_ACC_DOCUMENT_POST?
Kari, yes the note above does exactly that. By applying note 1353125 and a few others, you can post documents with BAPI_ACC_DOCUMENT_POST that are larger than 999 lines.
Hi David,
Most, if not all, SAP notes related to 1353125 all pertain to the split posting coming from invoices. The way we're using BAPI_ACC_DOCUMENT_POST is that we use it directly in our custom programs to post an FI document (without any relation to invoices/MM documents). The notes above don't seem to allow this scenario to post more than 999 line items (but in case I'm wrong, I'd be happy to be referred to the right direction! 🙂 )
Hi Karl, you are correct. I believe they only addressed invoices because they must legally be entered exactly as presented by the invoicing party. For GL journals I think they expect one to split the journal into multiple entries and use a balancing item to an offset account. I think there is even configuration to automate this part, yes take a look at the 999 split logic available in Idocs from HR postings, you can use this logic:
511614 - HR: HR clearing lines in FI document w/ document split in FI
PS. there is a good FAQ note now:
2078335 - FAQ: Error F5 727 when posting via Accounting Interface
I hope this helps,
Thanks David! This is useful. I guess my Christmas wish is for SAP to increase BUZEI to 4 characters. 🙂
HI David,
It is good to know because i guess all clients have the same problem if it is possible or not.
Thanks.
JPA