Partner Types and their Tables

Home / Blog / Partner Types and their Tables

I swear, once every few months I have to go digging for this, so it’s time to add it to my digital notebook.  If you do any technical stuff in SAP and you deal with partner types, I’m sure you have dealt with this subject.  When you deal with many different partner types you’ll notice some that customers, some are vendors, some are users or even organization units within HR.  Each of those references a different table.  Here’s the check list.  First go to table: TPAR and get the field NRART.  This will let you narrow down what type of partner you are dealing with.  From here, you can use the following list to find the correct master table.

When AP: KNVK

When KU: KNA1

When LI: LFA1

When O:  HRP1000 (where OTYPE = O)

When PE: PA0001

When US: USR01

Hope this helps you, I know I’ll be referring back to this post again in a few months 🙂
Thanks for reading,

As always, thanks for reading and don't forget to check out our SAP Service Management Products at my other company JaveLLin Solutions,
Mike

Leave a Reply

Your email address will not be published. Required fields are marked *