Realignment

[Former Member]

Hi,

i am working with realignment concept.

here, i had almost 500 materials that i need to do realignment as the material numbers being chagned in my plant,

my question is, if there are few materials we can simply do manually, for a large number of materials is there any way to do other than manually entering each material??

i need to chagne two char only i.e.material and subgroup,

your suggestion are highly appreciable

thanks

Arun R Y

[Former Member]

Hi :

I am also facing the issue and trying to find a workaround to automate this whole process . I am working on possibility of writing an upload program to update this realignment table from an excel sheet .

Also there is a SAP note on this :

Populating the realignment table can be automated under the following conditions:

1) The product # is constant and does not change

2) One or more product attributes such as product group, product family brand, etc. have changed in ECC

3) The changed product attributes for product # in ECC are considered as the basis on which realignment in SCM will be executed

Business process steps to automatically populate the realignment table under the conditions mentioned above:

1) Extract current product master data from ECC into info object 0MATERIAL.

2) Compare existing CVC against ECC product master data which has been extracted out of ECC and stored in 0MATERIAL (step 1).

3) Populate realignment table based on discrepancies in product master data (based on results from step 2).

4) Execute standard realignment program /SAPAPO/TS_REALIGN_COPY based on previously populated realignment table entries

The example which is provided in this note is based on planning object structure XYZ which includes at least the following characteristics:

- 9AMATNR (Product)

- ZBRAND (Brand)

- ZFAMILY (Product Family)

- ZGROUP (Product Group)

ZBRAND, ZFAMILY and ZGROUP are customer defined characteristics and make up together the product hierarchy which is stored in ECC under MARA-PRDHA. For example, product 100-100 may be assigned to product hierarchy '100002000099999999'

In SCM, this would show up as the following characteristic value combination (CVC):

Product Brand Family Group

9AMATNR ZBRAND ZFAMILY ZGROUP

100-100 10000 1000020000 100002000099999999

In essence, the product group in SCM (ZGROUP) is the same as the product hierarchy which is stored in ECC (MARA-PRDHA).

.

[Former Member]

Hi,

If you are on SCM 4.1 the realignment steps can be imported from an excel file. Just open the realignment table an choose Utilities -> Import File.

Regards

Alper

[Former Member]

thanks for answers,

Hi Alper,

i am using scm 4.1, and in realignment screen i am able to see field called 'IMPORT FILE FROM SERVER' can i use this fuction to upload a Excel file?? and if we can, then how i need to maintain the excel file, i mean all the char's or how??? here i need to change only my material number where all other will remain same, if you have any idea pls help me

thanks a lot

Arun R

[Former Member]

Hi A R Y,

It is NOT on the main screen. You must select a Planning Object Structure and press the button Maintain Entries. Once you have opened the realignment table (up-left corner) you will have to choose Utilities (M) -> Import File.

If you are going to change only the material number you don't have to change the rest of the characteristics. Just maintain the fields source and target for the characteristic Material.

The format of the file you can find if you maintain two steps in the realignment table and then extract it to an excel. Just use the Utilities (M).

Regards

Alper Myumyun

[Former Member]

Thanks Myumyun :

This is indeed a very useful way of maintaining entries ..

it will surely help us ...thanks a lot

[Former Member]

Hi Alper,

thanks a lot, i wil go by the steps as u said, if anything i wil mail u

thanks agian

Arun R Y

[Former Member]

On which rel of APO you are?

You can write your own program in which you can read excle file in which you can store the realianment entries.

As off now readymade program or transaction is not available