Skip to Content

SAP Standard Tables

When we process the business requirement sometimes it’s difficult to find out right table in particular area, so instead of search all the tables we can limit our search by provide initial two letters.

Go to T-code: SE16N

Type first two letters then put third letter as * then press F4

Will get list of table which is related to a particular segment.


(given only daily used tables)









Material Master

MA*, MB*, MK*, MS*, MV*







Vendor Master


FI tables


Cost  centre Accounting


Organisational elements


Hope this will be helpful.

Comments and suggestions are welcome.



You must be Logged on to comment or reply to a post.



    Could you please explain / inform which tables you are referring to with VA* and VK* for sales? And where can these tables be used (especially by a SD functional consultant / SD key-user etc.)?

    • Hi,

      Sales- VA*-VAKPA-Sales Index: Orders by Partner Function

                        VAKCR-Sales Index: Orders in Credit Management

                    VK*-VKDFS-SD Index: Billing Initiator

                           VKAOF-Sales Index: Open Sales Activities



      • KRISHNA,

        E.g. VAKPA in what context would it be helpful?

        Can we not get the information from table VBPA?

        In my opinion, it could be more helpful to give some input related to how (in what situation) the tables would be helpful, instead of just giving  the table names.

        • Hi TW,

          (just check small example in you system)

          ex: 1.what are the partner functions used in a sales document-

          in VBPA give VBELN and Execute

          you will get necessary partner functions used in a sales document and address details

          2.list of sales order with respect to particular sales organisation (just like VA05N)

          in VAKPA- give PARVW- SP ,VKORG-give your sales organisation.

          here with respect to SP it display list of sales documents with sales area details.

          the main difference:

          In VBPA -you can identify what are the Partner functions used in a particular sales document ,partner role and Address and country but not Sales area details

          where as in VAKPA-  will get Sales area details  with respect to Sold to party

          with respect to SP we can easily segregate sales documents/sales area details/sales document types/address details/

          same like a  list of sales orders(VA05N)

          Hope it clear now.



  • partners in a vendor master are stored in table WYT3, how would that fit into the given logic?

    Have you ever seen the button SAP application in the pop-up of F4 search help for tables?

    Here you get a tree like in the SAP IMG and can navigate into the specific area and you get all tables that are used for a certain function.

    • Jurgen,

      “Have you ever seen the button SAP application in the pop-up of F4 search help for tables?

      Here you get a tree like in the SAP IMG and…”

      Where exactly is this?

      In SE16N, field table, I give F4….but…

      Please explain in a little more detail.

      Thank you!

      • SAP automatically adds the last table that you pulled from a F4 help and used into a “input help personal value list”

        and when you next time press F4 (without giving any entries like V* – just F4), then this personal value list appears first, and there you get this button.

        In any case quicker than first going to SCN and opening this or other documents which lists tables


        • Jurgen,

          This is a new learning for me!

          I have viewed the tree (via SAP applications), there is too much information there. Probably one would have to learn how to navigate and get the required information from there or else it would be too mcuh information to be useful!

          By any chance do you know of a “tree” with all the t-codes, structured in the similar way to the tree for table names?

          Thank you!

          • Hi TW,

            once you get list of tables after choosing F4, select desired table and click on it.

            it will take you through the table.