SAP upgrade to address 999 issue ?

[Former Member]

Hello All..looking for some insight and help!

I was told (can't verify) that the new release/upgrade to SAP would be addressing the issue (that I KNOW everyone has run into) of the 999 line limitation on Journal Entries.

Does anyone know if this is TRUE? when is the potential roll out? I can not find anything to verify this - and currently the work around is gruesome to split large files.

ANY INSIGHT would be appreciated...

[ravi_nagh · Accepted solution]

HI,

Still in higher versions also There is a limit of (999) line items which can be posted per FI document. This is because the line item number (BSEG-BUZEI) field length is defined as (3) numeric positions, i. e., (999) line items.

The most commonly used workarounds are as follows:

1) Implement FI summarization (per note 36353). But as you wrote, you cannot accept this kind of solution.

2) Cancel the original billing document and split it into smaller documents using different payment terms but actually with the same terms.

This will avoid the (999) line item limit for FI postings. notes 11162 and 111813 with reference to invoice splitting.

Please assign points if it useful.

Regards

Ravinagh Boni

[Former Member]

Hi Carrie,

The limitation in BSEG-BUZEI still exists in new release (ECC5.0 + 6.0). Therefore the data entry can only be upto 999 entries, but the number of line items can be more than 999 in NewGL side of the document.

Br, Kyoko

[Former Member]

SO if I am understanding you correctly -

If I am taking the EDI 810 or 820 and importing it thru the translator- converting to iDoc...my paremeters really dont change. The limitation still exists - the change will be inside the FI module allowing additional lines in the GL.

I may be a little slow here...but does that make sense? LOL...you are allowing more lines - but not a way to get them there?

I have a HUGE customer this is impacting and again..like we all know...the work around solutions can be come gruesome and I hate manipulating financial data much.

[Former Member]

Hi Carrie,

In NewGL, there's a functionality called "document split". For example if there's one customer line item without business are assignment and 2 offsetting sales items have business area A and B, then the customer line item gets divided into 2 lines with business area A and B automatically on NewGL document. That's why the system must allow more than 999 items in NewGL.

BUT !!! The limitation on BSEG still exists as I mentioned. This means all documents created from external modules SD, MM, IDoc etc.. (also FI) still can not exceed 999 items when the data gets passed to FI.

The workaround of reducing the number of items is available by summarization. Note 36353, 310837 explains this functionality.

Kind regards, Kyoko

[Former Member]

If you need more than 999 entries in FI, then the new GL does not work.

You can however split the information in document splitting by Segment, Profit Center or another bespoke field.

But be warned you cannot split by material, and the new GL fields in FAGLFLEX tables do not contain material or plant.

[Former Member]

What I have happening is and 820 is being taken..mapped thru translator to look like 810 and then fed into the clients SAP idoc. It is actually a corporate credit card statement.

So since each card would actually be its own GL account in SAP- I am thinking that maybe it could be split like that..? THOUGHTS? currently the file is generating around 7-800 lines. Once it is converted we are doubling because of the iDoc requirements and it is causing issue obviously popping the 999.

ANY thoughts? We send this as a monthly file currently and I realize we could send it more frequently but the issue here is meeting the clients needs of 30 day cycle...