08-02-2005 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.
08-02-2005 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
08-02-2005 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.
08-02-2005 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.
08-02-2005 8:54 AM
PRPS-POST1
table PRPS
field POST1
will hold the WBS element description
Regards
Raja
08-02-2005 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
08-02-2005 8:58 AM
08-02-2005 9:00 AM
08-02-2005 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
08-02-2005 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?
08-02-2005 9:21 AM
Hi Pratibha,
Please check in the table AFRU(Order Confirmations) table for the operation number VORNR.
Thanks
Abhishek
08-02-2005 10:08 AM
check out this view
VIAUF_AFVC
and operation text is in LTXA1 field.
Regards
Raja