10-03-2007 7:12 AM
HI,
I am using the t-code mb5b which is used for displaying material stocks. i used to fill d material no. and den it displays it but i want to check where the following fields come from which table :-
1.) Quantity
2.) Values
when i press F1 d msg displays dat it is only data element.plz help me its urgent and he or she will be definately rewarded.
10-03-2007 8:04 AM
The answer depend on the parameters checked on initial screen
1-<b>Storage loc/Batch stock </b>
MARD, MKPF and MSEG
2-<b>Valuated Stock</b>
MBEW (and EBEW, OBEW), MKPF and MSEG, BSIM and BKPF
3-<b>Special Stock</b>
Depend of the type of stock,
e.g. MSKA and MSPR, MKPF and MSEG
Try to use ST05 SQL trace, to get a list of database tables accessed by transaction with different variants.
Regards
10-03-2007 7:24 AM
hi.,
Quantity comes from MSEG-MENGE
and i didnt find values field in that.
tell me where you find that values filed
so that i can try to get the corresponding table name fro values
<b><i>reward [points if useful</i></b>
Chandra
10-03-2007 7:37 AM
thanks but d <b>value fields means amount of d quantities which is displayed on initial scree</b>n as we run mb5b ,when i double click d material no.. d detail list shown and den it shows amount field(value) which is taken from BSIM - DMBTR but i want to know about d values which is displayed on initial screen when we run mb5b.
le
10-03-2007 8:04 AM
The answer depend on the parameters checked on initial screen
1-<b>Storage loc/Batch stock </b>
MARD, MKPF and MSEG
2-<b>Valuated Stock</b>
MBEW (and EBEW, OBEW), MKPF and MSEG, BSIM and BKPF
3-<b>Special Stock</b>
Depend of the type of stock,
e.g. MSKA and MSPR, MKPF and MSEG
Try to use ST05 SQL trace, to get a list of database tables accessed by transaction with different variants.
Regards