What is SOFFCONT1 table in SAP?
The table SOFFCONT1 is the database table used by SAPoffice and KPRO to store content related to storage category SOFFDB, that contains the attachments from all messages that are sent from SAP (fax, email etc..) and this is why it will become quite large.
How do I get a list of table names in SAP?
Use t-code SE16 and click f4 on table name, then click on info system and put * in table name. Don’t have access to SAP at the moment, but I believe that the table which contains a list of the tables is DD02T. Use SE16 to look at the table.
How do I find table descriptions in SAP?
Use t-code SE84 or SE15. You can see an initial screen is appearing for Object Navigator. ABAP Dictionary-Fields-Table Fields.
How do I memorize a table in SAP?
Remember Sap Tables Starting with:
- L*-> Vendor Tables ( LFA1 , … ) K* -> Customer Tables ( KNA1 , … ) V* -> Sales Tables ( VBAK , … )
- Table name contains. *K* -> Header Table ( VBAK , EKKO , … )
- Tables name contains: *I* -> GL Open Item ( BSIS , … )
- Or if Tables name ends with. *D -> Customer Related.
What is Dbtablog table in SAP?
DBTABLOG is a standard DB-Independent Database Interface Transparent Table in SAP Basis application, which stores Log Records of Table Changes data.
How do I find the fastest growing table in SAP?
The fastest growing tables appear at the top of the list. Tables that have been reduced in size are displayed at the bottom of the list. Use this screen to determine which tables are growing rapidly.
How do I view table data in SAP?
Tables can be displayed and edited using transactions SM30 and SM31. Maintenance dialogs can be used in “View Cluster Maintenance” (transaction SM34).
What are SAP table names?
SAP Table Name Tables
| # | TABLE | Functional Area |
|---|---|---|
| 1 | MARA | Logistics – Material Master |
| 2 | VBAK | SD – Sales |
| 3 | BSEG | FI – Financial Accounting |
| 4 | EKPO | MM – Purchasing |
How do we get field Details of a table?
On the Home tab, in the Views group, click View, and then click Datasheet View. On the Fields tab, in the Add & Delete group, click More Fields. Select a field in the More Fields list to insert the new column. Access places the field to the right of the column where your cursor is currently located.
How do you view table entries in SAP?
Just go to t-code UASE16N. Enter the table name that you want to display, check “Client Dependent Selection” checkbox and execute. You can view the table entries from all the clients.
How do I check my Dbtablog?
You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition….SAP Table: DBTABLOG – Log Records of Table Changes
- Database Interface, Database Platforms.
- DB-Independent Database Interface.
- DBTABLOG.
How do you clean a Dbtablog?
Clean up of table logging. Table logging is stored in table DBTABLOG. Deletion can be done using transaction SCU3 and then choosing the option Edit/Logs/Delete, or by using program RSTBPDEL.