2005 Aug 02 8:45 AM
Hi,
I am developing a report and need to display Operation Number which is displayed next to Network Number in Transaction MB03. As well display Work breakdown structure element (WBS element) Description.
which tables store these values.
I am selecting Network number and WBS element from MSEG table based on Material Document Number.
2005 Aug 02 9:01 AM
Hi Pratibha,
Check PRTX and PRTXS tables for WBS element texts.
And you can get the operation number using AUFNR field in MSEG table from AFKO and AFVC tables.
Thanks
Lakshman
Message was edited by: Lakshman Tandra
Hi,
I am developing a report and need to display Operation Number which is displayed next to Network Number in Transaction MB03. As well display Work breakdown structure element (WBS element) Description.
which tables store these values.
I am selecting Network number and WBS element from MSEG table based on Material Document Number.
2005 Aug 02 8:48 AM
if i understood right then:
if you know the field is in a tcode, just take control to that field with tab or shift-tab. then press F1. then press technical spec. and you can see which table that field belong to.
hope this help.
regards.
2005 Aug 02 8:53 AM
Hi Surpreet,
The text descriptions are displayed in comments format and not in text boxes so with F1-Technical Spec. no Table details displayed.
Most of the cases with F1-Technical Spec. structure names are displayed instead of table names.
2005 Aug 02 8:54 AM
PRPS-POST1
table PRPS
field POST1
will hold the WBS element description
Regards
Raja
2005 Aug 02 8:57 AM
Hi Pratibha,
Text descriptions are stored as textids ,that would be a concatenation of some parameters. This texts are accessed by means of using FM read_text , edit_text etc.
Regards,
Abhishek
2005 Aug 02 8:58 AM
2005 Aug 02 9:00 AM
2005 Aug 02 9:01 AM
Hi Pratibha,
Check PRTX and PRTXS tables for WBS element texts.
And you can get the operation number using AUFNR field in MSEG table from AFKO and AFVC tables.
Thanks
Lakshman
Message was edited by: Lakshman Tandra
2005 Aug 02 9:10 AM
Hi Lakshman,
Thanks for your response.
AUFNR is order number.
For Operation Number field name is VORNR.
Any idea which table holds this?
2005 Aug 02 9:21 AM
Hi Pratibha,
Please check in the table AFRU(Order Confirmations) table for the operation number VORNR.
Thanks
Abhishek
2005 Aug 02 10:08 AM
check out this view
VIAUF_AFVC
and operation text is in LTXA1 field.
Regards
Raja
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |