General ledger accounts
SKA1 G/L accounts master (chart of accounts)
SKAS G/L account master (chart of accounts: key
word list)
SKAT G/L account master record (chart of
accounts: description)
SKB1 G/L account master (company code)
SKM1 Sample G/L accounts
SKMT Sample account names
SKPF Header Data: Inventory Sampling
Functional location
IFLOT Functional Location (Table)
IFLOTX Functional location: short texts
IRLOTX Reference functional location: short texts
TAPL Allocation of task lists to functional locations
Customizing tables
T370R Reference functional location category
Equipment status
EQUI Equipment master data
JSTO Status object information
JEST Object status
TJ30 User status
TJ30T Texts for user status
TJ02 System status
TJ02T Texts for system status
Equipment
EQUI Equipment master data
EQKT Equipment short texts
EQUZ Equipment time segment
EAPL Allocation of Task Lists to Pieces of
Equipment
Customer
KNA1 General Data in Customer Master
KNAS Customer master (VAT registration numbers
general section)
KNB1 Customer master (company code)
KNB4 Customer payment history
KNB5 Customer master (dunning data)
Cost elements, centres, activities
CSKA Cost elements (data dependent on chart of
accounts)
CSKB Cost elements (data dependent on
controlling area)
CSKS Cost center master
CSKT Cost center texts
CSKU Cost element texts
CSLA Activity master
CSLT Activity type texts
CSSK Cost center /cost element
CSSL Cost center / activity
Configuration
CUCO Additional Data for Configurable Objects
CUCVRNT Variants of Constraints
CUEX Dependency Storage – Compilation
CUFM Customizing: Class/Config: Screendesigner
Form
CUKB Administrative Information for Dependency
Maintenance
CUKBT Text Table for Dependency Maintenance
Admin. Information
CUKN Dependency Storage -
Variants/Configuration
CUOB Link between Object and Dependency
CUPE Extension to BOM Item for Variants
CURSADD Dependency Net Additional Data
CUVT Variant Table
CUXREF Object Dependency Cross References
Classification Characteristics
CABN Characteristic
CAWN Characteristic values
Classification continued
TCLA Class Types
TCLAT Class Type Texts
TCLT Classifiable Objects
LTCLTT Classifiable Objects: Texts
Classification
CABS Result of the Statistical Analysis of Table
AUSP
CUFM Customizing: Class/Config: Screendesigner
Form
TCME Validity for Global Characteristics
KLAH Class Header Data
KLAT Classes: long texts
KSML Characteristics of a Class
AUSP Characteristic values
SWOR Classification System: Catchwords
KSSK Allocation Table: Object to Class
TCLG Class groups
TCLO Key Fields of Objects
TCLS Classes: Organizational areas
TCLST Classes: Org. Areas (Texts)
TCLU Class Status
COCC PP-PI attributes for characteristics
COFV Process management – process instr. charact.
in ctrl. recipe
COME Process management – message
characteristics
CORE Process mgmt.- display characteristics of the
eval. version
PLFV PI Characteristics/Sub-Operation Parameter
Values
POH – Bill Of Material
MAST Material to BOM Link
EQST Equipment to BOM Link
STAS BOMs header
STKO BOM header
STPN BOM follow-Up control
STPO BOM item
STPU BOM sub-item
STST Standard BOM link
STVB Bills of material – Serialization of posting
STZU Permanent BOM data
KBED Capacity requirements record
BRM – Accounting documents
BKPF Accounting document header
BSEG Accounting document segment
BSET Tax data document segment
BSEC One-time account data document segment
Accounting
BSAD Accounting: Secondary index for customers
(cleared items)
BSID Accounting: Secondary index for customers
BSIW Index table for customer bills of exchange
used
BSIX Index table for customer bills of exchange
used
BSAK Accounting: Secondary index for vendors
(cleared items)
BSIK Accounting: Secondary index for vendors
BSIP Index for vendor validation of double
documents
BSAS Accounting: Secondary index for G/L
accounts (cleared items)
SD_SALES_DOCUMENT – Logical database
VAKPA SD document: Indices
VBUK SD document: Header status and
administration
VBAK Sales Document: Header Data
VBKD Sales Document: Business Data
FPLA SD document: Billing plan
FPLT SD document: Billing plan dates
VBUV SD document: Incompletion log
VBPA SD document: Partner
VBADR Address work area
VEDA SD document: Contract data header
VFPLA SD document: Billing plan payment cards
VFPLT SD document: Billing plan payment cards
VBUP Sales Document: Item Status
VBAP Sales Document: Item Data
VBKDPO SD document: Business item data
FPLAPO SD document: Billing plan
FPLTPO SD document: Billing plan dates
VBPAPO Item partner for SD document
VBADRPO Address work area
VEDAPO SD document: Contract data item
VBEP Sales Document: Schedule Line Data
VBFA Sales Document Flow
VBFAVG Sales document: Cumulative
records,followed by doc
KONV Conditions (Transaction Data)
VAV – Logical Database RV: Sales Documents
VBAK Sales Document: Header Data
VBUK Sales Doc.: Header Status and
Administrative Data
VBKD Sales Document: Business Data
VBPA Sales Document: Partner
VBUV Sales Document: Incompletion Log
VBAP Sales Document: Item Data
VBUP Sales Document: Item Status
VBKDPO Sales document: Business item data
(POSNR > 0)
VBPAPO Item partner of sales document (for
LDB)
VBEP Sales Document: Schedule Line Data
VBFA Sales Document Flow
VBFAVG Sales document: Cumulative records,
followed by doc
KONV Conditions (Transaction Data)
AAV – Logical Database RV: Sales Documents
VBUK Sales Doc.: Header Status and
Administrative Data
VBAK Sales Document: Header Data
VBFA Sales Document Flow
NAST Message status
VBKD Sales Document: Business Data
VBUP Sales Document: Item Status
VBAP Sales Document: Item Data
VBEP Sales Document: Schedule Line Data
KONV Conditions (Transaction Data)
VBPA Sales Document: Partner
SADR Address Management: Company data
VBUV Sales Document: Incompletion Log
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
CDHDR Change document header
CDPOS Change document items
Table contents transport
Q – How do I delete table values from a client. For example I have 969 values in client 2 and 966 values in client 1. I want to move all 966 values to client 2, and therefore delete the surplus values in client 2.
Answer – This is easily done by using a asterix in the key in the transport. Create a transport for the table, eg: R3TR TABU and the key of the from client with a * in the next field of the key. The result will be the target client will have the values of the table deleted and all the values of the source client copied into the target client.
Dont forget to test you can use SCC1, between your development client and a sandbox/test client.
SE16 or SE16n
Dont forget there are differences between SE16 and SE16N. SE16N is much more fun! There are many advantages of using SE16N as opposed to SE16, for example:
- With SE16N you can check number of entries in background – good for production environments where the table is very large and timeouts occur.
- You can see technical names and descriptions for fields.
- You are not limited to table width.
- The results are displayed in ALV grid format.
How do I get a list of all Z* tables?
How do I get a list of all Z* tables?
A better solution is to do the following, use SE16n on table DD02T and search on all Z* tables. (This will give the table and table text.)
Can I compare the values inside a table across clients?
Hi There, I have a table with many entries in it. Is there a way to compare the data values across clients without having to export both tables and do a Vlookup / Hlookup in excel?
