3FI_GL_XX_SI: Clearing date is not properly updated in delta mode.

Hi,

Did it work for you in the past ?

We use 3FI_GL_xx_SI for N1 (IAS) data only, <-- no issues

for 0L data we use standard 0figl_10/14. <-- no issues.

May be there are some issues.

Regards, Leszek

Hi,

That looks like this http://scn.sap.com/thread/3524924 unfortunately there's no solution either.

Hi,

As of now , You can do repair full request with proper selections.

Load those two records.Later do the reporting and see.

if there is no issues no problem. if any key fig values are doubled then at cube level you can do selective deletion of old data.

Regarding delta issue please raise to SAP.

Seems like your delta loads will worked based on delta point settings.

based on delta settings will pull the records. if clearing date was changed along with delta relevant fields then changed records will be pulled other wise it won't.

Thanks

hi maybe you should still to assign the datasource to the general ledger with transaction

RGUCBIW1_PI - Assign DataSource to a Ledger

SAP procedure

Requirements

DataSources can be generated in the customer namespace (3FI*) only.

An extract structure needs to have been generated in transaction FAGLBW01 for customer-defined totals tables of new General Ledger Accounting. Note: No extract structure needs to have been generated in transaction FAGLBW01 for totals record DataSources for table FAGLFLEXT and for line item DataSources of new General Ledger Accounting.

An extract structure needs to have been generated in transaction BW01 for FI-SL totals tables or FI-SL line item tables.

Output

After starting the transaction, you receive a list of all selectable ledgers for which you can generate or maintain DataSources for the totals records and/or line items. If the ledger that you require does not appear, you may not have generated an extract structure yet for the underlying table. Call transaction FAGLBW01 or BW01 to do so.

The list contains the following information (columns from left to right):

• Ledger

• Description of ledger

• Table (totals table that the ledger is based on)

• Totals record DataSource

• Delta procedure of totals record DataSource

• Status of totals record DataSource

• Line item DataSource

• Status of LI DataSource

The status is shown by the status indicator on the right hand side, in the column next to the field of the DataSource in question. You can generate or maintain any DataSource by double-clicking the appropriate field in the corresponding column (totals record DataSource or line items DataSource).

When a new DataSource is created, the system proposes a name in the subsequent dialog box. For totals record DataSources, the proposed name follows the convention 3FI_GL_xx_TT in new General Ledger Accounting (or 3FI_SL_xx_TT in FI-SL); for line item DataSources, it follows the convention 3FI_GL_xx_SI (or 3FI_SL_xx_SI), whereby "xx" serves as a placeholder for the ledger in question. You can change the proposed name (but the initial "3" must remain). Nevertheless, we strongly recommend that you retain the proposed convention.

For totals record DataSources in new General Ledger Accounting, you can select a delta procedure. For more information, see the online documentation on the relevant radio button.

We recommend using the delta queue.

In processing mode, you can exclude individual fields of the ledger from the selection or from the data transfer to BI. When you choose "Save", the system generates the DataSource.

In the transaction ASSIGN data source to general ledger select ADD method

Hope it Helps

Hi,

it seems that the following SAP-Note fix the Problem:

1802912

Please also implement SAP Note 1691854.

Thanks a lot to the SAP Support! 😊