topic Cross reference table in Application Development and Automation Discussions

Cross reference table

Former Member — Mon, 09 Jul 2007 20:15:26 GMT

hello experts,

how to crate the cross reference table with the given legacy values and assigned sap system values...

please can anyone give me some step by step process to this

Thanks a lot for your anticipation

SRI

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:28:55 GMT

We did the same thing about twelve years ago. Creating the table is not that difficult, but the first step is to decide just what you need it to do. In our case, we mapped account numbers from the old legacy system to SAP Cost Centers and GLs (and in some cases customerfs and vendors).

Then the functional team has to map each legacy account to it's new SAP equivalent.

Rob

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:35:57 GMT

Ya Rob,

It is almost same requirement like the legacy entry type should be mapped to sap document type.... they gave all the values and while uploading the data i have to use that cross reference table and pick the corresponding values....

so can u tell me how to create this cross reference table......

thanks a lot for your reply rob...

SRI

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:40:05 GMT

In SE11, create a transparent table and use the legacy system account number as the key. Put every SAP field that an account might be mapped to as the other fields in the table.

This is the easy part. The hard part is the mapping.

Rob

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:43:17 GMT

can u tell me that mapping part also Rob if possible....I think this is not the way to ask but i am not aware of this thing Rob.... can give me some guidance

sorry to trouble u like this...

SRI

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:48:41 GMT

It's not your problem (or it shouldn't be anyway). The people who decided that the reference table is needed will have to assign functional people to do this.

Rob

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:51:24 GMT

Ya.... may be Rob but they asked me to do that too... thats what i am wondering....

Rob do u have any sample program to upload this AR line item data... i know the standard program RFBIBL00 might useful some extent but how do the extra coding in that......?

can send me the sample code if u have any for the same

SRI

Re: Cross reference table

Former Member — Mon, 09 Jul 2007 20:55:56 GMT

If they give you a spreadsheet, you can upload it an update the table. But the users have to do the actual mapping; how is an abaper supposed to know which legacy account maps to which new SAP accounts?

Rob