Skip to Content

Need Brands (0MATL_GRP_4 (Material group 4)) Text into Production Order Cube...

Dear All,

I'm working on SAP NetWeaver 7.3 and I need Brands Text (Material Group 4 (0MATL_GRP_4)) into "Production Order InfoCube" for my new reporting requirements. For that purpose, I used InfoObject: Material (Sales) (0MAT_SALES) and added it into Production Order InfoCube and in the transformation I mapped it with Material field of the DataSource. Since, this InfoObject is having "Compounding InfoObject" Sales Organization and Distribution Channel and therefore, I used constant for these InfoObject. I can see "Brands Text" into "ListCube" t-code after turning "Material Group 4" Navigational at InfoObject level and InfoProvider level too. But I could not find "Brands Text" in my Business Layer or in IDT Universe and it says the table is missing.

1. How can I get brand text (0MATL_GRP_4) into Production Order InfoCube?

2. Why am I unable to see the brand text in business layer of "Universe" and getting error table is missing?

3. Is the SID or Mater Data Table created or linked to F-table?

4. I have Material Field into my DataSource and I do not want to use Material (Sales) InfoObject to get (0MATL_GRP_4) as its having compounding InfoObject and do not have Sales Organization and Distribution Channel fields into my DataSource of Production Order. What could be the workaround?

I will appreciate your reply.

Many thanks!!!

Tariq Ashraf

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Mar 25, 2015 at 10:59 AM

    Dear Tariq,

    I would try to answer your 4th question.

    See you can use material group 4 without using the mat_sales in your cube. You can make 0material_grp4 as an attribute of 0material and load the material group4 data from 0mat_sales_attr.

    The above holds good only if material group 4 maintained in different sales area for a particular material is same in all the sales area . Otherwise the material group 4 data will get overwritten when you load it to 0material and will lead it wrong reporting.

    Regards

    Gajesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.