Skip to Content

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.

44.PNG

(given only daily used tables)

Customer

KN*

Sales

VB*,VA*,VK*

Shipping

VT*,VB*,VE*

Delivery

LI*

Material Master

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

Billing

VB*,VR*,VK*

Pricing

KO*

Purchasing

EK*,EI*

Vendor Master

LF*

FI tables

BS*

Cost  centre Accounting

CO*CS*

Organisational elements

T001*

Hope this will be helpful.

Comments and suggestions are welcome.

Regards,

Krishna.

To report this post you need to login first.

12 Comments

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

  1. Typewriter TW

    KRISHNA,

    Sales

    VB*,VA*,VK*

    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.)?

    (0) 
    1. Krishna Kumar Post author

      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

      Regards,

      Krishna.

      (0) 
      1. Typewriter TW

        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.

        (0) 
        1. Krishna Kumar Post author

          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.

          Regards,

          Krishna.

          (0) 
  2. Jürgen L

    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.

    (0) 
    1. Typewriter TW

      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!

      (0) 
      1. Jürgen L

        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

        SE16NF4.JPG

        (0) 
        1. Typewriter TW

          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!

          (0) 
          1. Krishna Kumar Post author

            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.

            Regards,

            Krishna.

            (0) 

Leave a Reply