2008 Jan 29 11:28 AM
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.
2008 Jan 30 2:11 AM
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
2008 Jan 30 4:15 AM
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
2008 Jan 30 6:11 AM
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
2008 Jan 30 4:16 AM
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....
2008 Jul 16 5:19 AM