2008 Jun 23 10:49 AM
Hi Experts,
I want to find whether an account group(KNA1-KTOKD) is assigned to a perticular Company Code(BUKRS). I want to find
the link between these two.(KNA1-KTOKD and T001-BUKRS).
Please let me know the link/table between them.
THanks,
Sreenivas
2008 Jun 23 10:55 AM
Hi Sree,
Check the below Link.
It will solvve your Query.
http://www.erpgenie.com/abap/code/abap35.htm
Regards,
Viji.
2008 Jun 23 10:57 AM
hi sreenivas ,
GO to t-code SQ02 it will ask for the info set and the give the table name as t001 and after that a screen will appear then after that give the table name which we want to link as KNA1 it will dispaly all the links that are for the table,
This transaction is used to list all the links for the particular tables.
Hope its clear to you,
Reward points if usefull,
Thanks,
Kalyan.
2008 Jun 23 10:57 AM
2008 Jun 23 10:57 AM
2008 Jun 23 11:32 AM
Hello Sreenivas,
The relation between Account Group and Company Code cannot be treated as a direct link.
Customers/Vendors of a particular nature are normally grouped under a category which is nothing but Account Group.
Customers/Vendors can be extended to multiple Company Codes, but, they always belong to one Account Group.
That is the reason why KTOKD/KTOKK fields exist in KNA1/LFA1...they are independent of Company Code views (KNB1/LFB1)
The account group determines:
a) which number range the customer account number should be
b) whether the number is assigned by the user or by the system
c) which specifications are necessary or possible in the master record.
Hope this info helps your understanding.
With Regards
Vijay Gajavalli
2008 Jun 23 11:40 AM
Hi
There's no link, the account group is data belonging to a layer upon the company code.
Every customer can have only one account group, but it can be assigned to different company codes.
Max
2011 Aug 02 7:51 AM
Hi Experts,
I got the similar kinfd of requirement ...but by existing thread i am unable to get the necessary information....
I am loading G/L Account Master Data (Company Code-Dependent Attributes ) by using the Data Source 0GL_ACCOUNT_COCD_ATTR . I need to get the respective Account groups for the G/L accounts which are Company Code based u2026please let me know from which table I can get the Account group information u2026
I know that we can get the Account group information SKA1- KTOKS u2026but I think this Account group for the G/L Accounts which are based on chart of Acountsu2026u2026u2026u2026I need the information of Account groups for the G/L Accounts which are based on company code.
Thanks
2011 Feb 25 5:36 PM