Talbe for Account Group - Tcode KDH3

[Former Member]

Hi,

What is the table name that holds the account group for a particular G/L account? In tcode KDH3 the screen field is GRPDYNP-NAME_COALL which is not actually a database table.

Regards,

Marc

[daniel_carvalho]

Hi Marc,

There are some tables:

- SETHEADER: It holds the Account group information.

For example: go to SE16 transaction, type SETHEADER as table and select the fields:

SETCLASS = 0109

SUBCLASS = Chart of Accounts

SETNAME = Account Group

- SETLEAF: It holds the Account group leafs (that is, the information that is linked to the Account Group).

For example: go to SE16 transaction, type SETHEADER as table and select the fields:

SETCLASS = 0109

SUBCLASS = Chart of Accounts

SETNAME = Account Group

NOTE: For the last table, all the information is stored in a "RANGE" format. That is:

a) If there is a single account linked, then VALOPTION field will be equal to EQ

b) If there is an account interval linked, then VALOPTION field will be equal to BT.

Hope it helps you.

Cheers,

Daniel.