Skip to Content
author's profile photo Former Member
Former Member

Material Group with product dimension

Dear Experts,

Table K9RHDR1000002 is contains the Material Group From, Material Group To and Product dimension. Here for a Material Group Range they are maintaining Product dimension.

I want to compare these material group range with Material group (of other DSO in BW) to get the Product dimension. With respective material group we need the product dimension. What is the BEST way to do in BW?????????????

Please Suggest.

Thanks & Regards,

Srinu.Rapolu

pastedImage_0.png (75.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 09:15 AM

    Hi Srinu,

    If your table containing Material Group details in BW then You can do lookup on DSO in transformation routine by comparing material group and you can get product dimension.

    Thanks,

    Kamal

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Srinu,

      I think you need to make yourself clear or we cannot help you at all.

      After reading all your post, I have:

      1) Table K9RHDR1000002 to look up "Product Dimension", where key is MGRP fm/to

      2) You need to look up "Product Dimension" for some material group listed in some DSO in BW

      So everyone is thinking you are trying to:

      - Use DSO mentioned in point 2 as source

      - The result will write to some kind of storage (e.g. the original/another DSO)

      In this case, the solution already there, as the transformation can process the record one by one, and you just need to copy someone idea here to lookup the value in table K9RHDR1000002.

      But you said:

      If it is not a single field to put the range in selection conditions tab.

      So what exactly you are trying to do? (Transformation? FM?)

      What is your expected input and output format?

      Regards

      Bill

  • Posted on Jan 06, 2014 at 09:41 AM

    Hi Srinu,

    If i understand your requirement correctly you want to load the product dimension data in to your DSO by comparing the material group number right?

    You can write a field level routine where you need to map material group to product dimension.

    next in the routine write a logic which compares the material group ranges and pass the product dimension value.

    For example: if we consider you first entry in your table.

    For material group range =(1000000 1499999) then the product dimension= 15

    let say material group= 1499002, now in your routine you will implement a logic which will check the material group value, as this falls in the range which had product dimension =15, then directly pass the product dimesion as 15.

    Note: as the ranges might not change you can directly hard code the ranges in routine and make use of them.

    If you feel the ranges n product dimensions may vary in future you can create a generic data source on

    the table and extract the data into a DSO in BW and can perform a look on this DSO. you can use this DSO in your logic to perform a look up.

    Regards

    KP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 06, 2014 at 10:27 AM

    HI Srinu,

    Refer to following Pseudocode:

    Select MATGRP_FROM MATGRP_TO PRD_DIM FROM X TABLE INTO TABLE IT_GRP.

    SELECT MATGRP FROM Y TABLE INTO IT_MRP.

    Sort it_grp and it_mrp.

    LOOP IT_MRP INTO WA_MRP.

    LOOP IT_GRP INTO WA_GRP.

    IF WA_MRP-MATGRP >= WA_GRP-MATGRP-FROM AND WA_MRP-MATGRP <= WA_GRP-MATGRP-TO.

    ASSIGN PRD_DIM.

    ELSE EXIT.

    ENDIF.

    ENDLOOP.

    ENDLOOP.

    Hope this will help you a little.

    Thanks & Regards,

    Vipin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 06, 2014 at 09:33 AM

    Hi Srinu,

    From data source to DSO transformation level use concatenate formula function.

    thanks,

    Phani.

    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.