SAP Table Editing Function
This is a SAP Trick that is possibly too powerful, if authorizations are not in place in your system you dont want to use this too liberally:
To edit the contents of a table (Virtually any table from customizing to database records):
- Use transaction SE16n or in some systems transaction n.
- Enter the table name and see the records. (Sometimes you may be able to change a tables contents depending on its attributes.)
However if you wish to change most tables regardless of table attributes/control you can do the following:
- Use transaction SE16n or in some systems transaction n.
- Then enter &sap_edit in the command field.
- You will see a message “SAP editing function is activated”.
- Now enter the table name and execute to see the records. You will now be able to change the contents of the table.
This SAP technique may be useful to maintain faulty data in your system. But should only be used by a very experienced person.
Wild cards in searches
Did you know that a wild card search in a selection such as * is not the only wild card option. A * is used as a wild card for 1 or more characters, while a + may also be used as a wild card for a single character.
Table Edit without SM30 or Maintenance Dialog
We all know you can edit table contents in SM30, but did you know you can also edit table contents in SE16N? Read more 
SAP Tips – Great tip – Data browser cross client
You know how to use SE16N to view the contents of a table. Should you desire to view the contents of a table across clients you can do this with transaction UASE16N.
SAP Tips – Upload/Download files to/from application server
You can upload a file from your PC to the SAP application server with transaction CG3Z
You can download a file from the SAP application server to your PC with transaction CG3Y
SAP Tips – SE10 – Transport Organiser Search for Requests
You may want to search for a specific Transport you can do the following:
Transaction SE10
Select Goto–>Transport Organizer Tools
Select “Search for Objects in Requests Tasks” Read more
List of fields across multiple tables
SE11 will show you 1 table with a list of fields. However if you wish to see a list of all fields for a range of tables without going into each table individually – simply use SE16N on table DD03L. Then use the tables as a range.
Great tip – SE16n Shortcut
Instead of typing SE16N to access General table display, try just typing “N” into the command field.
How to see if the system/client is locked for customising changes
Question: How do I see if the system and client is locked for customising changes and who changed the client control values last?
Answer: You can view the contents of table T000 which is the Clients table. Look at the value of “changes and transports” T000-CCCORACTIV, to see if the client can be changed, for example value 2
R0L, RTL – WM Transfer
LTAK WM transfer order header
LTAP WM transfer order item
LUBU Posting change document
KDF – Vendor Master
LFA1 General section
LFAS VAT registration numbers general section
LFB1 Company code
LFB5 Dunning data
LFBK Bank details
LFC1 Transaction figures
LFC3 Special G/L transaction figures
LFM1 Record purchasing organization data
User Data
USR01User master record (run-time data)
USR02 Logon data
USR03 User address data
USR04 User master authorizations
USR05 User Master Parameter ID
USR06 Additional data per user
USR07 Object/values of last failed authorization
check
USR08 Table for user menu entries
USR09 Entries for user menus (work areas)
USR10 User master authorization profiles
USR11 User Master Texts for Profiles (USR10)
USR12 User master authorization values
USR13 Short Texts for Authorizations
USR14 Surchargeable language versions per user
USR15 External User Name
USR20 Date of last user master reorganization
USR30 Additional Information for User Menu
USR40 Table for illegal passwords
USR41 User master: Additional data
USRCOBJ Object Filters for Exploding Product
Structures
USRM0 Material Master User Settings: User Screen
USRM1 Material Master User Settings:
Organizational Levels
USRM2 Material Master User Settings: Logical
Screens
USRMM User settings: material master
R1L, RBL, RUL – Transfer of Requirement
LTBK Transfer requirement header
LTBP Transfer requirement item
Sales Requirements
VBBE Sales Requirements: Individual Records
VBBS Sales Requirement Totals Record
Task Lists
PLKO Task list – header
PLAS Task list – selection of operations/activities
PLPO Task list – operation/activity
PLKZ Task list: main header
PLWP Allocation of Maintenance Packages to Task
List Operations
PLAB Relationships
PLFH Task list – production resources/tools
PLFL Task list – sequences
PLFT Process instructions
PLFV PI Characteristics/Sub-Operation Parameter
Values
PLMZ Allocation of bill of material items to
operations (component list)
PLPR Log collector for task lists
MAPL Allocation of task lists to materials
EAPL Allocation of task lists to pieces of
equipments
TAPL Allocation of task lists to functional locations
S1L, S2L – Storage locations and stocks
LAGP Storage bins
LEIN Storage unit header records
LQUA Quants
LQUAB Total quant counts for certain strategies
MEIK Make-to-Order Stock for Customer Order
MSCA Sales Orders on Hand with Vendor
MSKA Sales Order Stock
MBPR Stock at Production Storage Bin
MLGN Material Data per Warehouse Number
MLGT Material Data per Storage Type
SLGH Elements of Stock Population
AAV, AKV, ARV, VFV – Sales Document
VBAK Header Data
VBAP Item Data
VBAG Release Data by Schedule Line in
Sch.Agrmt.
VBUK Header Status and Administrative Data
VBUP Item Status
VBRL SD Document: Invoice List
VBPA partner
VBKD Business Data
VBKA Sales activities
VBEP Schedule Line Data
VBRK Billing: Header Data (invoice)
VBRP Billing: Item Data (invoice)
VBFA Sales Document Flow
LIKP Delivery Header Data
LIPS Delivery: Item data
RKM, RNM, POH – Reservation
RKPF Document Header: Reservation
RESB Reservation/dependent requirements
IFM, ILM, Purchasing info record
EINA Purchasing Info Record – General Data
EINE Purchasing Info Record – Purchasing
Organization Data
EIPA Order Price History, Info Record
EIKP Export/import header data
EIPO Export/Import Item Data
KONH Conditions (Header)
KONP Conditions (Item)
KONM Conditions (1 Dimensional Quantity Scales)
KONW Conditions (1 Dimensional Value Scales)
Purchase Documents
EKAN Vendor Address: Purchasing Document
EKBE History of Purchasing Document
EKBZ History of Purchasing Document – Delivery
Costs
EKET Delivery Schedules
EKKN Account Assignment in Purchasing
Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
EKPB “Material Provided” Item in Purchasing
Document
EKPV Shipping-Specific Data on Stock Tfr. for
Purch. Doc. Item
BAM, BKM, BBM – Purchase Requisition
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EBUB Index for Stock Transport Requisitions for
Material
Production resource tools
AFFH PRT assignment data for the work order
CRVD_A Link of PRT to Document
CRVD_B Link of Document to PRT
CRVE_A Assignment PRT data – equipment
CRVE_B Assignment equipment – PRT data
CRVM_A Link of PRT data to a material
CRVS_A Relationship of PRT internal number to
PRT external number
CRVS_B Relationship of PRT external number to
PRT internal number
Customizing tables:
TCF02 PRT categories
TCF03 Texts for the production resources/tools
category
TCF04 Status of the PRT master
TCF05 Language-dependent text table for PRT
status
TCF06 Field groups in the PRT master for
reference
TCF07 Language-dependent texts for field groups
in PRT master
TCF08 Assignment of PRT master fields to field
groups
TCF10 PRT control key
TCF11 Language-dependent text table for PRT
control keys
TCF12 PRT group key
TCF13 Language-dependent text table for PRT
group keys
CNJ, PSJ, IMA – Project
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element
Master Data
PRTE Scheduling Data for Project Item
ODK – Orders
AUFK Order master data
AFKO Order header data PP orders
AFPO Order item
JSTO Status object information
JEST Object status
Material document
MKPF Header: Material Document
MSEG Document Segment: Material
BSIM Secondary Index, Documents for Material
MSM – Material
MARA Material Master: General Data
MARC Material Master: C Segment
MARD Material Master: Storage Location/Batch
Segment
MAKT Material Descriptions
MAPL Allocation of task lists to materials
MARV Material Control Record
MARM Units of Measure
MBEW Material Valuation
MOFF Outstanding Material Master Records
MSTA Material Master Status
MVER Material consumption
MVKE Material Master: Sales Data
MAPR Material Index for Forecast
PROP Forecast parameters
Notifications
QMEL Quality notification
QMIH Quality message – maintenance data excerpt
Goods movement
AUFM Goods movements for order
AFFW Goods movements with errors from
confirmations
SER03 Doc.header f.serial numbers for goods
movements
CNJ – Maintenance Order
AFIH Maintenance Order Header
AFKO Order header data PP orders
AFPO Order item (not used much)
AFRU Order completion confirmations
AFVC Operation within an order
AFVV Order position data
CRCO Assignment of work center to cost center
OBJK Plant Maintenance Object List
CRHD Work Center Header
PLAF Planned order
HIKO Order master data history
HIVG PM order history: operations
Inventory document
IKPF Header: Physical Inventory Document
ISEG Physical Inventory Document Items
LINK Inventory document header in WM
LINP Inventory document item in WM
LINV Inventory data per quant
