on 06-19-2012 12:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.