apart MARA / MARM tables also check material characteristics (which are stored on Classification tab in your material master in tcode MM03), in case you keep any of information speicified there. In such case, search in tables MARA, INOB and AUSP.
There is no SAP Standard Report which shows all these but in VA05 and VA05N you can see the first three but if you want to see the conversion then you will have to go to the relevant order, select the required material and click on F8 the system will display the material master.
Else create a query as mentioned in the earliesr threads.
In sqvi i ahve joined the table MAKT and MARM it is coming as per the reqiurement but some different materials which i dont require are coming. I want only finished good, how to go about?
I Have creted a query SQVI and selected MARA table and joined with MARM but once excuted nothing is coming moreover my client needs a report on finished goods as Material number, material description, sales unit (say CAR) and conversion factor say (1car=100nos). So kindly suggest.
How do you differentiate the Finished Materials like starting with F* so then you can give in input Parameter as F* in Material Number. Else you can give Material Type for Finished Goods in Field MTART (Material Type).
As per your suggestion I have created a query joining the tables MARA MARM MAKT . You have mentioned as "then in the list design set your selection screen field as MARA-MTART what does it mean once we insert three tables we have to select the MTART from table MARA, if that is so i have but i am unable to meet my reqiurement, kindly if possible explain me in detail "then in the list design set your selection screen fiel as MARA-MTART.waiting for your reply.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.