on 06-29-2009 9:25 AM
Hi SAP Gurus,
In material type FERT some materials are maintained classfication view and some not.
How to find from MARA table the list of materials with non-classifcation view and with classfication view.
What is the single key field with which i can sort easily.
Thanks,
Navin
Hi Navin ,
There is a field maintenance status (Field - PSTAT).
If there exists a value " C " then Classification view is maintained else not.
Regards
Ramesh Ch
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Navin,
The Material master has different views inaddtional , therefore u find different statuses .
Eg : User department Maintenance status
Work scheduling A
Accounting B
Classification C
MRP D
Purchasing E
Production resources/tools F
Costing G
Basic data K
Storage L
Forecasting P
Quality management Q
Warehouse management S
Sales V
Plant stocks X
Storage location stocks Z
You need to enter the material type FERT and in the maintainenace status enter C , this will give u all the materials which has classfication as one of the view inaddtion to other views.
Regards
Ramesh Ch
hi,
U find the KEL right that means...K- Basic data,E-Purchasing,L-Storage... in that way if u find c then it means that calssification view is maintained,
The other option is in SE11 after u click contentes then in the menu bar..goto settings-Feilds for selection-and select PSTAT and then after which in the PSTAT give -C and then click execute..u cld find the all the material with Classfication view
Regards
Sravanthi
Edited by: Sravanthi683 on Jun 29, 2009 3:06 PM
If you will press F1 on this field PSTAT, u can see the C means Classification view are maintained.
In the selection screen of table MARA, if you will enter C in the field PSTAT , system will give u the all materials where classification view is maintained.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Tcode SE11 table MARA
execute
for any material click on the value in column under "PSTAT" and then press F1. You get a list.
compare this list with the alphabets appearing for ur item under column "PSTAT".
Views wrt the alphabets are maintained .. others are not.
For classification alphabet is "C"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
use MM50, enter Maintenance status as "C", and material type as "FERT", execute, system will display the list of materials for which classification view is not maintained.
Regards,
Vikas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.