on 2007 Aug 27 8:09 AM
Hi,
I want to find the table to which the structures RMQAM, RMMG1 are getting updated?
Plz tell me how to find the tables based on the structure?
Thanks
Request clarification before answering.
HI,
The Structure RMQAM is getting Updated in Tables,
QMAT Inspection type - material parameters
QMHU QM Link Between Inspection Lot and Handling Unit Item
QMTB Inspection method master record
QMTT Inspection Method Texts
QPAC Inspection catalog codes for selected sets
QPAM Inspection catalog selected sets
QPMK Inspection characteristic master
QPMT Master Inspection Characteristics Texts
QPMZ Assignment table - insp. methods/master insp. characteristic
The Structure RMMG1 is getting Updated in Tables,
MBEWH Material Valuation: History
MCHBH Batch Stocks: History
MSCAH Sales Order Stock at Vendor: History
MSKAH Sales Order Stock: History
MSKUH Special Stocks at Customer: History
MSLBH Special Stocks at Vendor: History
MSPRH Project Stock: History
MSSAH Total Sales Order Stocks: History
MSSQH Total Project Stocks: History
USRM0 Material Master User Settings: Screen Reference "User"
USRM1 Material Master User Settings: Organizational Levels
USRM2 User Settings for the Material Master: Logical Screens
Regards,
Padmam.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The tables used are listed besides the structure.
<b>RMQAM:</b> QMAT.
<b>RMMG1:</b> MARA, MARC, MBEW, MVKE.
<b>Reward points if this helps,</b>
Kiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
good
1. Check out the fields of ur Structure
in SE15 you can use these Field Names to Find out all the tables which has this Field.
2. Open the Source code of the Program and Search for this Structure name throughout the Program .. You will be able to find the Link.
Bcoz at some point in the code the data of the Structure fields in used to Update the Table.
thanks
mrutyun^
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
To find tables based on structure.
we have to go to that structure and go to entry help/check tab.
In check tables we can find list of tables used for that structure.
Reward point if found useful
sudha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
goto SE11
give the sturcture name in datatype option
and choose where used list button in the toolbar(CTRLSHIFTF3)
then chose Tables ...it will give the list of tables where the stuircture has been used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
RMQAM:
Tables are : QMAT, T000, TQ30, MARA, T001W
RMMG1:
Tables are: MARA, T001W, T001L, T001, T001K, TVKO, TVTW, T300, T301,
T001Y, T002, T137, MDIP, MPRP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.