0FI_GL_12 extractor that doesn't split currency types 00, 10, 30

[Former Member]

We are implementing a treasury solution in BPC/BW. There are reports to produce cash balances are in each unique currency combination of TC, LC, GC.  In order to do this, we need to have a period 0 balance for each unique combination.  We are aggregating the data in 0FI_GL_14 to get each unique combination of TC, LC, GC for periods 1-12 but this won't get us Period 0.  Is there any standard FI extractor that doesn't split out the FI-GL Totals Table (FAGLFLEXT) into CURTYPE 00, 10, 30 records.  Or, is there a way we can extend 0FI_GL_12 so that we can aggregate the 00, 10, 30 records correctly. 

Thanks,

Anne

[sander_vanwilligen]

Hi Anne,

It is the standard behavior of FI-GL DataSources to generate multiple records for each currency. If I understand your requirement correctly, you want one record with one or several Key Figures per currency (TC, LC and GC). I suggest to "flatten" the data in BW using ABAP.

Best regards,

Sander

[Former Member]

The issue is there isn't any field in the 3 records to tie them together as one record in ABAP.  The standard fields available get you pretty close but not 100%,  The only thing we have found that each record is assigned a record number.  After you sort the other key fields, you have to assume record number 1 goes with record number 2 and 3, as so on.

In the standard table in ECC (FAGLFLEXT), OBJNRxx ties them together but are not in the standard extract structure.

Thanks,  Anne