Turning off - line item display for recon accounts:

[former_member96283]

Hello experts:

The 'Line Item Display' is currently enabled for customer/vendor/asset recon accounts.

As it's not recommended to have the line item display enabled for recon accounts, the client wants to look at turning it off.

Please advise on the impact of  'turning the line item display off' on these recon accounts.

Also, suggest the best route to go about for making this change.

Thank you very much for your support.

Regards

Jal Aeleti

[Former Member · Accepted solution]

Hello Jal Aeleti,

As you have stated it is not recommended to activate the Line Item Display flag for Reconciliation Accounts as this creates many BSIS entries in the system which are not actually required.

Check and apply SAP Note 178487.Once you have deactivated the line item display for certain G/L accounts, the existing entries (created in the past) become obsolete. You should take immediate action to delete these items from table BSIS. Once you have deactivated the line item display for a specific account, you must execute program RFSEPA04 ('Reduction of Line Item Display after Master

Data Change') to delete the obsolete old records from BSIS.

Regards,

Martin Cahill

[former_member96283 · Accepted solution]

Thank you very much Martin.

Please suggest, if there is any further impact to be considered after the deactivation of the line item display and deleting the obsolete records via RFSEPA04.

Thanks again.

Regards

Jal.

[João_FI_FIN-CS]

Hi Jal,

According to Gouse, you've to block this GL account and is needed to run this process e.g on sunday, because this execution can takes serveral hours. On sunday because the invoice's volume is not too much.

JPA

[former_member96283]

Thank you very much JPA and Gouse for valuable inputs.

Regards

Jal.

[Former Member]

Hi Jal,

When line item display is activated, use program RFSEPA01 to retroactively generate line items from the documents that have already been posted.
Before you start the program, the account must be locked for posting. When line item display is deactivated, any existing indexes may be deleted with program RFSEPA04.

Regards

Gouse

[João_FI_FIN-CS]

Hi Jal Aeleti,

Once this flag is deactivated, you can't display these line items in the FI-AP even is not recommended, because somebody makes the check.

JPA

[former_member96283]

Thanks JPA

Do you mean, deactivating the line item display is not recommended ?

Even if it's deactivated at the G/L account (recon G/L) level, the detailed line items are available at the subsidiary ledger right (customer/vendor/asset).

Could you further clarify on your perspective ?

Thanks

Jal.

[João_FI_FIN-CS]

Hi Jal,

I created two scenarios below with line item display flag and without this flag. But first, you've to understand the difference in the entry view and GL view.

The entry view is where you can see documents in the subledgers AP and AR. The GL view is where you can see these documents independent of subledgers. Always will be displayed by GL.

Technically, if the flag is marked these line items will be copied to subledgers or entry view. If does not has the flag, e.g BSIK or BSAK (opened line items and cleared line items tables) won't displayed this lines items and FBL3N or FAGLL03 in the entry view can't be displayed.

FBL3N has only entry view. FAGLL03 has two views: entry view and GL view. FAGLB03, FS10 and FS10N are displayed the balance independent of the flag. But to display line items by these transactions, will be checked in the master data GL account if the flag is marked or not.

Check the screenshots below:

Without flag GL account 2010000000:

FBL3N

FAGLL03 for entry view

FAGLL03 GL_view without flag but with GL view

GL account with flag

FAGLL03 with GL view for the GL acount with flag

FAGLL03 with entry view for the GL account with flag

FBL3N (only has entry view)

Note when there's not flag for FAGLL03 when the GL view is displayed, the documents appears because the program check BSEG table and not BSIS/BSAS. This action increase performance because there're a lot of documents in the table.

When you've to run FAGL_ACTIVATE_IT tcode or the RFSEPA01 program, is copied the line items from BSEG to BSIS or BSAS.

JPA

[former_member96283]

Thank you very much JPA.

In conclusion, would you not recommend deactivating the flag?

Regards

Jal.

[João_FI_FIN-CS]

Hi Jal,

The impacts are in the tables. These line items will increase the tables. But these tables has autogrow function, i.e, will increase space automatically according with needed.

If was me, I'd talk to Basis about if there's a problem to let as is. Also, I'd talk to user if he really need that. And in my opinion he'll say yes.

Research about autogrow tables.

JPA