on 07-29-2014 5:01 AM
Dear Experts,
How to retrieve the total list of catalogs and codes by using table??
can any one give me the table name to retrieve the complete list of catalogs and codes ??
Please do the needful.
Thanks ,
Sunil Boya
Sunil,
If you see this join picture you'd understand that the answer to your question is tables: T352C, QPGR, QPCD.
If you are looking for individual tables then
VIQMFE - for Object part and Damage
VIQMUR - for Causes
VIQMSM - for Tasks
VIQMMA - for Activites
QPGT - for Code Group texts
QPCT - for Code texts
If you want to know more you may ask.
Best of Luck
Jogeswara Rao K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil,
You could just check in these tables whether you meet your expected reply : VIQMEL, VIQMFE, VIQMUR, VIQMSM, VIQMMA.
Refer the below link also:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The following View tables are also useful: V_QPCD_KAT, V_QPCD_F4, V_QPGR_KAT
PeteA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Create SQVI query using table QPGT & QPCT.
Define input selection for catalog, code group & language.
Output list catalod, code group, Code group text, code & code text.
Run the query.
Regards
Santosh
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.