Database Table for "Financial Statement Items"

[Former Member]

Hi,

I am looking for SAP Tables where the information about "Financial Statement Items" are stored. I know that T011 stores the information about the encapsulating Financial Statement Views. But I wasn't able finding the positions/items.

The positions/items contain account ranges and texts which define the location for each account in the balance sheet later on (e.g. sales/revenue, liabilities, ...)

I need the tables in the releases starting from 4.6c, 4.7 and ECC 5.0/6.0.

Best Regards,

Sebastian

Edited by: Sebastian Stöckle on Oct 1, 2008 3:43 PM

[iklovski]

Hi Sebastian,

The items are stored in tables SETNODE and SETLEAF. You can access them with set class '0109' in order to see the FSV items and sub-groups.

Regards,

Eli

P.S. Alternatively, it would be stored in FAGL_011* tables.

[Former Member]

Thanks Eli.

I tried to enter new items for existing views but I wasn't able to find them in the SETNODE/SETLEAF Tables? However it seems that these are indeed the right tables.

Regards,

Sebastian

[iklovski]

Hi Sebastian,

Strange, indeed. Please, notice that the items are not stored in a traditional way, but in ranges.

Regards,

Eli

[Former Member]

Hi Eli,

Can you tell me that the "Text" for each financial statement items are stored in which tables?

Regards,

Anek

[iklovski]

Hi,

You can look at SETHEADERT table.

Regards,

Eli