Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Account Group Table ?

Former Member
0 Kudos

Hi,

What is the table name for Account Groups?

The reference Tcodes is KDH1 / KDH2 / KDH3.

Here we make our account groups and assing GLs to that group.

Thanks & Regards,

Dhanunjaya Reddy.

5 REPLIES 5

Former Member
0 Kudos

Hi,

Can you check table: SETHEADER.


Parameters: SETCLASS = ''0109' -> for Account Group, 
            SUBCLASS = <chart of accounts in usage>, 
            SETNAME is the Account group.

Regards

Eswar

Former Member
0 Kudos

Thank you Eswar for your quick response. This is the table I am looking for.

Can you explain how the GLs are grouped into an account group? I mean how to combile different GLs into an account group.

Thanks & Reagards,

Dhanunjaya Reddy

0 Kudos

Hi,

Try using the flow as below:

SETHEADER -> SETLEAF

In SETLEAF you get the set names and their intervals.

Next get the valid G/L accounts from table SKA1 for all ranges of SETLEAF.


SELECT saknr FROM SKA1
     INTO TABLE <itab>
     WHERE KTOPL = <chart of accounts>
     AND SAKNR BT ( valfrom, valto ).  " VALFROM and VALTO are values from SETLEAF

Hope this helps you understand the relation.

Alternatively you can explore FM: K_RACCT_VALUES_GET

Regards

Eswar

Note: Dont forget to appreciate the SDN way

Former Member
0 Kudos

Reddy,

Check below tables and field names.

Table name Field name

HRP1270 GRPNAME

PCMH GPROZGR

RPM_VAL GROUPNO

TCNDS HIENM

TKB9E SETNR

TKB9G SETNR

TKECRMC SETNAME

TSC0C SETNAME

TSC0I SETNAME

Don't forget to reward if useful....

Former Member
0 Kudos

thanks to all of you.