Skip to Content
0
Apr 07, 2011 at 10:27 PM

Flat File Vs ECC load

25 Views

Hi,

We have an IO XXX (char 3) which is master data with attributes loading from Flat file. Now for this IO few of the attributes should be derived from ECC Z table with routines/some other logic.

There is a 4 char lenghth field in the Z table with the first 3 characters as the IO value. Can any one let me know how to achieve this.... These two attributes are tme depandant values and

I need to use the From and To dates available from ECC Z table to update these values ....

Example: XXX has 333 Z table has 333A with other attributes info.

I created a DS using the above Z table and derived the XXX value and brought all other fields in to an ODS, Now I'm loading this ODS first then the IO XXX, so that I can read this ODS table in UR

to get the two attribute values dynamically...Please let me know if this is correct or if there ia any other solition for this req....Thanks