This post is to be used in conjunction with our live SAP Training class where the instructor has discussed the business importance of product hierarchy and how it is used. This post only describes product hierarchy from the technical perspective. For full fledged understanding, please visit our SAP SD Training class online. This post is also useful for students undergoing SAP MM Training as well.
Product hierarchy is based on the database structure PRODHS. It is 18 characters in length and the standard breakdown is as shown below.
PRODH1 CHAR 5
PRODH2 CHAR 5
PRODH3 CHAR 8
If you wanted to customize this structure you would have to change the PRODHS structure which is outside of the scope of this post and is done by an SAP ABAP consultant. However, if you choose to add new hierarchies based on the already existing structure of ( 5 , 5 and 8 characters ) , you can do the following.
Step No. 1 : Go to [ spro -> IMG -> Logistics General -> Material Master -> Settings for Key Fields -> Data Relevant to Sales and Distribution -> Define Product Hierarchies ]
Step No. 2 – Click on Maintain Product Hierarchy.
Step No. 3 – You can create your own product hierarchies at any level you like.
For example, the following are the standard hierarchies available as part of the standard SAP IDES System.
If you want to add one more to it, say “Welding Services”, you can do so by going to Step 3. above in the SAP Screen and add
You can see the added SAP product hierarchy if you re-open the material again or wish to create a new one.
Exercise : A company has chosen to offer welding services as a separate product line and wishes to add that to the product hierarchy. Create a new product hierarchy as follows. If they already exist ( have been created by other SAP Training students ) please create your own , by substituting XXX for your own number.
00XXX Welding Services
00XXX Gas Welding
0000XXXX Aceylne Welding
0000XXXX Ethylene Welding
00XXX Arc Welding
0000XXXX Spark Welding
00XXX Electric Welding
0000XXXX A/C Welding
0000XXXX D/C Welding
I am gettting this error when i am trying to create another entry.
I had first created one entry and then saved it. Later when i tried to create another entry without saving it, i got this error. “Please create the preceding node first”
LikeLike
00999 Welding services
LikeLike
Created Level 1 -pain killer and subsequent levels of pharmaceutical chemicals. Used 5, 10 ,18 characters for each level from 1-3.
Pointer to anybody else who does this. Save each level before going to the next level as it gives an error saying ‘Please create the previous node first’. Save the first level by creating a customizing request.
LikeLike
Good Tip Banu.
Thanks
Siva
LikeLike
What is this means when u r creating a product Heirarchy?
Create the preceeding node first?
LikeLike
HI SIVA , i am haing a same problem as zahid had.
What is this means when u r creating a product Heirarchy?
Create the preceeding node first?
LikeLike
As discussed in the class, create the first 5 characters of the product hierarchy, save it, go back and come again to add the next 5+5 . If you still have problems, please let me know and I will show it to you int he class
LikeLike
hi Siva ,
product hierarchy tried to add it is saying the same msg ( please create the preceding node first)
and have you got any detailed note on product hierarchy what is the main role as we didn’t discuss this ….
thx
LikeLike
I got it right
00667 Welding Services (1)
00337 Gas Welding (2)
00003371 Aceylne Welding (3)
00003372 Ethylene Welding (3)
00227 Arc Welding (2)
00002271 Spark Welding (3)
00117 Electric Welding (3)
00001171 A/C Welding (3)
00001172 D/C Welding (3)
LikeLike
Got it right
00667 Welding Services (1)
00337 Gas Welding (2)
00003371 Aceylne Welding (3)
00003372 Ethylene Welding (3)
00227 Arc Welding (2)
00002271 Spark Welding (3)
00117 Electric Welding (2) not level 3
00001171 A/C Welding (3)
00001172 D/C Welding (3)
LikeLike
00149 Welding Services
0014900151 Gas Welding
001490015100152 Aceylne Welding
001490015100153 Ethylene Welding
0014900154 Arc Welding
001490015400155 Spark Welding
0014900156 Electric Welding
001490015600157 A/C Welding
001490015600158 D/C Welding
LikeLike
The original setting for material HDD250GB was Hardware/PC/Drive (00125/00100/00000130), I created a new hierarchy of Hardware/drive (00125/00130) because although related to PC’s as a component piece it is not a subset of PC’s.
LikeLike
Siva
In product Hierarchy,what if the requirement is to increase the maximum character length of Description field from 40 characters to lets say may be 45.is that possible?If yes then how do we do this?
Many Thanks,
Pooja.
LikeLike
Also,has the hierarchy level changed from 5,5,8 (3 Levels) to 3,3,3,3,3,3 (6) level?
Thanks for your time.
LikeLike
Are you asking if this has been changed ?
LikeLike
Yes,I think I read it somewhere?
LikeLike
yes, you are right. This can be changed. Currently its not changed in our system. System default is 5/5/8
LikeLike
Hi Siva,
Can you please explain how to setup product hierarchy in system.
thanks,
Mital
LikeLike
I got it
LikeLike
Hi Siva,
Exercise : A company has chosen to offer welding services as a separate product line and wishes to add that to the product hierarchy. Create a new product hierarchy as follows. If they already exist ( have been created by other SAP Training students ) please create your own , by substituting XXX for your own number.
00XXX Welding Services
00XXX Gas Welding
0000XXXX Aceylne Welding
0000XXXX Ethylene Welding
00XXX Arc Welding
0000XXXX Spark Welding
00XXX Electric Welding
0000XXXX A/C Welding
0000XXXX D/C Welding
Answer: Created product hierarchy for above example as follow.
00999 Welding Services
0099900997 Gas Welding
009990099700009995 Acetylene Welding
009990099700009996 Ethylene Welding
0099900998 Arc Welding
009990099800009997 Spark Welding
0099900999 Electric Welding
009990099900009998 A/C Welding
009990099900009999 D/C Welding
Thanks,
Mital
LikeLike
00030 Level 1 Personal Comps-MD
Level 2
0003000012 Laptop-MD
0003000013 Desktop-MD
Level 3
000300001200000012 – Hardware-Lvl3-MD
000300001300000012 – DesktopHardware-Lvl-3-MD
Created Material MD-HDD250GB-FP and assigned Product hierarchy.
LikeLike
Created product hierarchy:
000500066500556677
LikeLike
Wi-Fi (most likely will be exactly the same as the Ouya ,
but with no ethernet port). The Android developers can customize the multimedia applications according to the requirement of users.
It will help you create and maintain a great rapport with your clients by having latest
applications.
LikeLike