Hi dccmich, The drain pipe for the sink is hidden by the face front of the cabinet..The water and the drain come up through the wall.
You can also box the pipes in with the same material as your cabinet so the pipes cannot be seen still leaving access for repairs..