Question on Table relations

[Former Member]

Hi all,

I have a question related to tables...........

Lets take an example Customer master General table KNA1.

It has an account group KTOKD field has the configured data in T077D, and it looks like 001,002,003, DEBI etc.......

I have a ZTABLE (table control) has data for Legacy Customer account group information IR,IP,TR,IC etc.........

How this table is maintained as a cross-refernce table to KNA1, while loading Legacy data to SAP? I mean legacy data file has IR,IP,TR, IC as account groups, but in SAP it has been maintained as 001,002,003 etc.....

Please explain me how does this concept works..........

Answers will be appreciated by rewarding points....

Mili.

[Former Member]

Hi

Since the KNA1-KTOKD values are not acceptable to the client,

they might have created a new ztables with the new values for KTOKD field, as they were not maintained in T077D table.

and might have kept the same type of links as KTOKD field of T077D table to that Ztable.

Reward points if useful

Regards

Anji

[Former Member]

Hi AnjiReddy,

Thank you for the quick response......

If I am not wrong, what I understood is instead of maintaining T077D as a cross-refernce table, they will maintain ZTABLE as a cross-refernce table to maintain KNA1-KTOKD values...........

Please correct me If I am wrong.....

Mili.

[Former Member]

Hi

The table ZTABLE should be have a structure lie this:

[code]MANDT (LIKE MANDT) key

KTOKD_OUT (CHAR02) key

KTOKD (LIKE KTOKD) [code]

KTOKD_OUT is account group code of your legacy, in this way here u can create a link between SAP and Lagacy Account Group codes.

Max

[Former Member]

Hi Max,

Thank you for the quick response.....

Yes, you are correct.I am maintaining ZTABLE as you said....

So my question is instead of maintaining T077D table they will maintain ZTABLE.

I really appreciate your input.

Rewarded points.......

Mili.

[Former Member]

Hi

Yes, you're right.

The T077D is standard and customizing table so it's better not to change it, you have a your own ZTABLE, so you should maintain it.

So it has to remember if a new account group is created in SAP, the ZTABLE will have to be maintained too.

Max