topic Re: Question on Table relations in Application Development and Automation Discussions

Question on Table relations

Former Member — Thu, 03 May 2007 13:12:51 GMT

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.

Re: Question on Table relations

Former Member — Thu, 03 May 2007 13:18:53 GMT

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

Re: Question on Table relations

Former Member — Thu, 03 May 2007 13:23:05 GMT

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

Re: Question on Table relations

Former Member — Thu, 03 May 2007 13:25:25 GMT

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.

Re: Question on Table relations

Former Member — Thu, 03 May 2007 13:30:26 GMT

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.

Re: Question on Table relations

Former Member — Thu, 03 May 2007 13:56:46 GMT

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