cancel
Showing results for 
Search instead for 
Did you mean: 

How to map PRODH to 0PROD_HIER in 0MATERIAL_ATTR data source

Former Member
0 Kudos

Hi Every body,

This is regarding “Product Hierarchy”

In ECC we have the “Product Hierarchy (PRODH)” with 6 levels as shown below.

Now, we need to implement the same in BW system, means we need to map the PRODH to 0PRODH_HIER attribute of 0material in 0MATERIAL_ATTR.  In our reporting requirement, we need to display the key figure values for 6th level of this hierarchy node ZZPRODH6.

How can we achieve mapping for all these 6 hierarchy levels from PRODH.

For your information: We observe the data is available for 0PROD_HIER in 0MATERIAL_ATTR .

For ex: the value for 0PROD_HIER in 0MATERIAL_ATTR  is  002002005005004015.

From this How can we achieve mapping for all these 6 hierarchy levels from PRODH?

Please provide us step by step procedure to achieve this issue.

Thanks in advance.

regards,

Ajay

Accepted Solutions (0)

Answers (1)

Answers (1)

jagadeesh_mandepudi2
Active Contributor
0 Kudos

Hi

We can achive this by using even with formauls in transformations.

You have to include Prod Hier 1 -6 obejcts in 0MAT_ATTR obejct and then mapp 0PROD_HIER to all these obejects each mapping you have to use formula to populate the data.

SUBSTRING( PRDHA, 0, 1 )

SUBSTRING( PRDHA, 1, 3 )

SUBSTRING( PRDHA, 4, 3 )

SUBSTRING( PRDHA, 7, 3 )

SUBSTRING( PRDHA, 10, 3 )

SUBSTRING( PRDHA, 13, 3 )

Normally 16 car only will use if the clients wnats 18 car then change formaul accordingly.

Jagadeesh

Former Member
0 Kudos

Thanks Jagadesh for the response, we will try this and let u know the result.

one more doubt, do we need to create 6 info objects for each level for example: ZPROD1,ZPROD2..ZPROD6 in bw , and maintain them as external characteristics for the info object 0PROD_HIER.

and later in the Transformation rules for each of this external characteristics, do we have to write the code or formula in the transfer rule for each of these hierarchy variables (ZPROD1, ZPROD2..ZPROD6), as you have suggested.. am I correct? 

looking forward for the valuable response.

regards.

Ajay.

jagadeesh_mandepudi2
Active Contributor
0 Kudos

Hi

No need to create custom objects since we have already standard those are 0PRODH1 --6

remaining what assuemd is correct.

Go and do teh changes and let me know if any issues.

Jagadeesh.M

Former Member
0 Kudos

Hi jagadesh,

         Sure.. once we do, we will let u know the result..

regards

Ajay.

jagadeesh_mandepudi2
Active Contributor
0 Kudos

Hi

Did you implemented the above solution.

Jagadeesh.M