on 01-31-2011 7:22 AM
Dear Experts,
I am trying to use SQVI for making a report on Catalogs using tables VIQMEL, VIQMFE, VIQMUR, VIQMSM, VIQMMA.
I am not able find the fields for Code Texts for all catalgs in any of these table. when I use QPCT table, I am able to get Code Text for only one catalg.
Because his exercise is code-independent, ABAP alternatives like using Structure RIWO00 are not relevant for my requirement.
Please give an idea to solve this problem using table route.
Regards
Jogeswara Rao
Thank you Pete
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The data has to be there somewhere in the system...
Can you give more details on what you are trying to achieve?
PeteA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I use to develop non-standard reports using tools SQVI and Infoset Query (SQ03, SQ02 and SQ01).
For this, I need to know the tables to design selection and output screens.
Present attempt is to create a report which displays the combined report of IW29, IW65, IW67 & IW69 fields.
For this work, the tables VIQMEL, VIQMFE, VIQMUR, VIQMSM, VIQMMA fulfill most of the requirement. But 5no. of fields (TXTCD**) said before are not present in any of the s above tables. They are part of Structure RIWO00. Structure fields can not be used in this process without using ABAP code.
So I have been trying to get these fields from SAP-tables.
Hope I made myself understood this time.
Thank you
Regards
Jogeswara Rao
Yopu have to make by transaction QS41 is a convination of Catalog C and 5
Then in the Functional Location and Equipement you have to Assign The Goup code just created
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jogeswara Rao
A quick Google search found [this|http://thebeautiful.narod.ru/download/SAP-PM_Tables.pdf]
PeteA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not 100% sure what your question is. But the Catalog/Catalog Code tables are below:
QPGR/QPGT Catalogs
QPCD/QPCT Catalog Codes
PeteA
Thanks again Pete,
My requirement is as below:
I am trying to develop a report through non-ABAP methods (SQVI, SQ02,SQ01 etc) which is a combination of IW29, IW65, IW67, and IW69.
During this I am not able to get the 'Code Text' fields for different catalogs (namely TXTCDOT, TXTCDFE, TXTCDUR, TXTCDSM, TXTCDMA)
Regards
Jogeswara Rao
It seems the fields I require (given in my previous reply) are not to be contained by any of the SAP-Table.
Instead they appear in Structures (RIWO00), which can not be used without ABAP Code either in an ABAP Report program or in an Infoset Query.
Such features of SAP become constraints to the functional persons and makes them dependent on technical persons.
Thank you for your time Pete.
I am open to any further ideas.
Regards
Jogeswara Rao
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.