Skip to Content
Author's profile photo Krishna Kumar

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.

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.

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo swadhin ghatuary
      swadhin ghatuary

      Thanks a lot  for your effort .

      it is help to identify and recognize the table by it's name.

      Author's profile photo KRISHNA KUMAR
      KRISHNA KUMAR
      Blog Post Author

      Thank you Swadhin.

      Author's profile photo Former Member
      Former Member

      Thanks:)

      Author's profile photo TW Typewriter
      TW Typewriter

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

      Author's profile photo KRISHNA KUMAR
      KRISHNA KUMAR
      Blog 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.

      Author's profile photo TW Typewriter
      TW Typewriter

      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.

      Author's profile photo KRISHNA KUMAR
      KRISHNA KUMAR
      Blog 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.

      Author's profile photo Jürgen L
      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.

      Author's profile photo TW Typewriter
      TW Typewriter

      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!

      Author's profile photo Jürgen L
      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

      Author's profile photo TW Typewriter
      TW Typewriter

      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!

      Author's profile photo KRISHNA KUMAR
      KRISHNA KUMAR
      Blog 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.