How to replace a value in the BEX report with out changing in the back end Info provider

[Hari_Krishana]

HI Experts,

I have a  Company code which is already existing and that is going to be changed example 1234 (old one ) to 5678 (new one )

I want all the reports to show the new value with out changing the entire data set in the info providers.

Any Bex variable or any suggestions??

Regards,

Hari Krishna

[ccc_ccc]

Hi Hari,

There are few approaches which we can achieve this problem.

Approach 1.

1. Create two customer exit variables for company code Var1 and Var2
2. Var1 ready for input
3. Var2 not ready for input
4. Write logic in VAR2 variable read what user enter values (like 5678) and fill the VAR2 variable as like below

        if company code 5678 then update 1234

   5.  delete VAR1 values or set blank

Approach 2

1. Create dummy formula variable called VAR1
2. VAR1 ready for input and dimension is number
3. Crate Customer exit variable for company code VAR2
4. Read values from VAR1 and like (5678) and update VAR2 (1234)
5. Either leave VAR1 as it is since its dummy variable it nothing restrict

Approach 3.

1. Create new infoobject called ZNCOMP and add in infocube.
2. Crate Virtual characteristics and write logic if comp_cd = 1234 then update zncomp = 5678

Please check above all.

Thank you,

Nanda

[yasemin_kilinc]

Hi Nanda,

I think virtual Characteristic approach is great and fits best in this case. I liked your document, thanks for sharing.

And

Hi hary,

If the approach comes too difficult to implement, and if you have only a few number of company codes you can think of creating a structure on company code. Add nodes for each company. And you can simply write the text as 5678 and restrict that node with 1234 company code.

Hope it gives an idea

Regards

Yasemin...

[ccc_ccc]

Thanks Yasemin.

Regards

Nanda

[Former Member]

Hi,

Masterdata needs to be updated in cube.

If you select the particular company code value, it will show the data and combination will exist in the infoprovider.

If the combination is not available , you will not get data.

Regards,

Amit