Material Group with product dimension

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

HI,

Material Group Range is coming in Two fields. If material group with single field your solution is good, Please suggest for my issue.

For Ex:

Client  MGRP Fr MGRP To  Product dimension

100    1000000    1499999    15

100    1500000    1599999    11

100    2000000    2999999    15

100    3000000    3000009    15

100    300010    300010    10

100    3000100    3000100    15

100    300020    300020    10

100    3000200    3000200    15

100    300030    300030    10

100    3000300    3000300    15

100    300040    300040    10

100    300041    300041    1

100    300050    300050    10

100    3000500    3000500    15

100    300051    300051    1

100    300060    300060    2

100    3000600    3000600    15

100    300061    300061    2

100    300070    300070    4

100    3000700    3000700    15

Thanks & Regards,

Srinu.Rapolu

[anshu_lilhori · Accepted solution]

How the material group is stored in your dso in two fields or single fields.

Please confirm.

[Former Member · Accepted solution]

Hi Srinu,

In range also you can use like comparison you can use conditions in select like material group>= "material group from"  and material group >= "Material group to". This solution will work.

Thanks,

Kamal

[Former Member · Accepted solution]

Hi,

Now showing in two fields with product dimension. Now I need to get product dimension in to other DSO having actual material group.

Thanks & Regards,

Srinu.Rapolu

[Former Member · Accepted solution]

Hi,

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

Thanks & Regards,

Srinu.Rapolu

[anshu_lilhori · Accepted solution]

I would also suggest what prashant has suggested.

Keeping performance factor in mind the only thing which can be amended-- instead of field level routine you can do this in End routine.

Do a lookup on this dso where dimension are stored you can use the GE and LE operators to compare the range values.

In case you need any assitance related to code then let us know.

Regards,

AL

[Former Member · Accepted solution]

Hi Srinu,

Its very simple. Please find the below sample code how to compare the single fields with range:

Select product dim

from table K9RHDR1000002

into table internal_table where

materialgroup >= material_group_from and

materialgroup<= material_group_to.

That will suffice your purpose. You will get the correct product dimension by this code.

Thanks,

Kamal

[Former Member · Accepted solution]

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

[former_member229708]

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

[former_member182516]

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

[KodandaPani_KV]

Hi Srinu,

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

thanks,

Phani.