Well, it’s still good to go back to your roots from time to time, and this is one of those areas that still serves me well on a daily basis. Using SE16N and these tables (plus some Excel vlookups) is used at least weekly, if not more often. So I thought I’d share my list of tables with you. I’ll do my best to break it up into sections that make sense.
This diagram is also around PM, rather than CS/SM, so it’s not complete with everything you would care about, but it is a great place to start. Perhaps someday, I’ll get around to building a full Visio of this stuff, but for not, I’ll give you the places to start, and you can see the relationships 🙂
Equipment:
- EQUI – equipment head
- EQKT – text
- EQUZ – time related stuff
- ILOA – additional data
- EQBS – stock information
- IHPA – partner details
Functional Location:
- IFLOT – header
- IFLOTX – text
- ILOA – additional data
- IHPA – partners
Notification:
- QMEL – header
- QMIH – service data
- IHPA – partners
- QMMA – Activities
- QMSM – Tasks
- QMUR – Causes
- QMFE – Items
Service Orders:
- AUFK – header
- AFKO – additional header details
- AFPO- order items (not used much for service)
- AFIH – service data
- PMSDO – sales data in the order
- AFRU – order confirmations
- AFVC – operations
- RESB – components
- AFVV – Operation data
- AFFH – PRT assignments
This not an exhaustive list, and I often find new tables with obscure data that I need for a random project, but if you start with the tables listed above, you will be in good shape.
Thanks for reading,
Mike
As always, thanks for reading and don't forget to check out our SAP Service Management Products at my other company JaveLLin Solutions,
Mike