I've spent the past few weeks mapping Native Instrument's Traktor Scratch to my Akai MPD-32 and this is the end result. I found quite a few mappings online, but they seemed to focus more on triggering samples when I just needed access to hot cues, looping functions, and effects. In essence, I set these up with a turntablist mindset, that is assuming that you're using digital vinyl and an outboard mixer.
As you can see from the images above, I'm using two different pad banks. Bank A contains the following mappings for each deck:
Sync (yes, I press this sometimes)
Loop (loops a pre-set length, duh!)
Hot Cues 1, 2, 3, 4
Clear Last Cue
Bank B consists of the following mappings for each deck:
Unload Deck (this just clears the deck)
Duplicate Deck (copies A to B or vice versa)
Load Next + Load Selected (via the browser)
The faders and buttons on the MPD have been mapped to control FX1, FX2, and FX3 (on/off, effect parameters, wet/dry), and the last two buttons on the right will simply play and stop decks A and B without the use of DVS. The top set of knobs are for selecting the effect for FX1 and FX2 on decks A and B, and the bottom knobs control the track position and the loop size on each deck. Unfortunately, the effect selector for FX3 isn't mapped, however I usually keep the peak filer loaded, but realistically, you can have any effect inserted here.
You have two options; you can either manually create these via the assign and learn process within Traktor's settings, or you can download the template via the link below. Now, I cannot guarantee that the template will work as I've only been able to load and test on my system, but it should be as simple as importing the file via Traktor's controller setup.