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)
|
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.
Thanks a lot for your effort .
it is help to identify and recognize the table by it's name.
Thank you Swadhin.
Thanks:)
KRISHNA,
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.)?
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.
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.
Regards,
Krishna.
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.
Regards,
Krishna.