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: 

Company Code(BUKRS)-Account Group(KTOKD) link.

Former Member
0 Kudos
3,390

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

8 REPLIES 8

Former Member
0 Kudos
629

Hi Sree,

Check the below Link.

It will solvve your Query.

http://www.erpgenie.com/abap/code/abap35.htm

Regards,

Viji.

Former Member
0 Kudos
629

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.

GauthamV
Active Contributor
0 Kudos
629

hi,

use tables KNA1 and KNB1.

KNA1-KTOKD

KNB1-BUKRS.

ThomasZloch
Active Contributor
0 Kudos
629

.

Former Member
0 Kudos
629

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

Former Member
0 Kudos
629

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

0 Kudos
629

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

Former Member
0 Kudos
629

This message was moderated.