T006 Table - CUNI - Adding a new UoM Problem.

[Former Member]

Hi Geeks,

Let me explain with an example,

I checked some UoM's which is not maintained in T006 table.So I added few as below and but for some cases like

I wanted to add a new UoM called 'ABC' in CUNI .

When I add I get a Pop-Up 'ABC' is already available.

So I checked T006 , when I entered 'ABC' in Int. meas. unit and Checked No. of Entries is 1 but,

It automatically changed to 'ABD' and when I execute.

It gives the Details of 'ABD'.

So in the Menu->Settings->User Parameters -> Data Browser Tab -> Format list CheckBox ( Check Conversion Exits )

It is getting changed to 'ABC' again. but still when I double click and see . It shows 'ABD'.

So could anyone explain why this happens and more about Conversion Exits.

How I can maintain 'ABC' in T006' table ?

Thanks,
Nethaji Guru

[MGrob · Accepted solution]

Hi

So all the CUNI are in T006A while T006 holds all relations right?

And the internal measurement unit format is automatically converted into the format that is put in "Technical" format for screen output.

Check what ABC's technical Unit is. It's probably ABD

hope it helps

Martin

[Former Member · Accepted solution]

Yes, I can see the relation and 'ABC' Tech Unit is 'ABD'.

But, Why I get error record, during Cube loading that

No SID found for value 'ABC ' of characteristic 0UNIT

When it is avaiable in T006 table ?

[RamanKorrapati · Accepted solution]

Hi Nethaji,

Have you checked bw side  table T006 and T006A. if avaible at bw side, error won't come. if not in bw tables then you need to transfer from ecc to bw side.

RSA1. Source system, select respective source system link --> right click transfer global settings, measure of units, choose update and execute it.

Please check this,

http://scn.sap.com/docs/DOC-42512

Thanks

[MGrob · Accepted solution]

Hi

Have you tried to replicate as Ram suggested? If that doesn't help:

As there is a conversion exist on field MSEHI in table T006, you can only see the internal format if you deactivate the conversion exit in the display (Settings > User Parameters > DataBrowser > Apply Conversion Exit should NOT be selected).

SAP Note 619987 has more details.

hope it helps

Martin

[KamalMehta · Accepted solution]

You are getting error " No SID found for value 'ABC ' of characteristic 0UNIT" because the value 'ABC' is not maintained for the characteristics 0UNIT.

If the same is maintained in source system then goto RSA1 - Source system - R click - Transfer Global Settings . This should update the same in BW.

thanks

[Former Member]

In RSA1 run Transfer global setting

source system-->right click --> Transfer global settings in next screen select unit and mode update table and execute it .

Follow this document:

http://scn.sap.com/docs/DOC-42512

[Former Member]

Hi Nethaji,

This is because the Conversion Routine is written for the field.

The external commercial formt is maintained in the table T006,whereas the equivalent Internal UOM is maintained in T006B table as per the business scenario.

Regards,

Kalpana

[snitwipro]

Hi,

  The external display is the one which is the outcome of the conversion routine. For 0UNIT, the conversion exit is CUNIT. The function module which is available for the conversion is CONVERSION_EXIT_CUNIT_OUTPUT. The input and output length along with the field type is defined in the domain MEINS.

Regards

Sourav

[Former Member]

No .. Even When it is updated in BW side. I'm getting this error.

Thanks for your suggestions.. yet to find a root cause

[RamanKorrapati]

Hi,

if you maintained master data for 0UNIT, please run attribute change run(unit) and  try to load data to cube.

You can check data at 0unit, right click--> display data, check for ABC.

http://scn.sap.com/message/1027519

Thanks

[Former Member]

Units of measure can be maintained in each system individually ....

there are two ways to do this :

1. SPRO ->Reference IMG -->SAP Netweaver --> General Settings -->Check Units of Measure

Here select units of measure and you can maintain your own UOMS - these will have to be transported

Caution - once you transport these - DO NOT transfer units from the R/3 source - these transported entries wil get deleted.

2. Run program SAPMUNIT to achieve the same and transport the entries.

[RamanKorrapati]

Hi Nethaji,

Units/exchange rates/currrencies are maintained by functional or source team. if your BW Consltant you can check data at ecc side and bw side using tables. if those are not in sync, do the transfer global settings/exchnage rates.

At Ecc side while maintain rates/units/currencies we may need to enter those properly otherwise we may face problems like this.

If you have source/function team at your location, directly you can check with them.

Thanks

[Former Member]

hope this will be helpful.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/cf/21ee19446011d189700000e8322d00/content.htm

I can see the ABC is well maintained in the T006 table where as conversion exit is converting it..

Try to find out the function module and see how to use

●  CONVERSION_EXIT_xxxxx_INPUT

●  CONVERSION_EXIT_xxxxx_OUTPUT

to find the exact values.

Thank-You.

Regards,

VB