Updation of account descriptions using DM package

[Former Member]

Dear Friends,

I would like to bring account ID and description from BW (0GL_ACCOUNT) to BPC.

BW record:

555666(BW characteristic value) and its Description is Salary.

BPC: 3 members are like this and below are manually maintained.

ID               EvDesription

555666        Salary

A555666      ASalary

B555666      BSalary

If BW side 555666 description is changed to Salary1, would like to see

BPC members as in below through DM package

ID               EvDesription

555666        Salary1

A555666      ASalary1

B555666      BSalary1

How can I achieve this in BPC conversion/transformation file?

Thanks,

Kumar

[former_member186338 · Accepted solution]

Sorry, but not clear...

Can you explain once again what do you want to achieve?

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Initially maintained BPC master data(ACCOUNT dimension) manually as in below.

BPC:

ID               Desription

555666        Salary

A555666      ASalary

B555666      BSalary

Accounts A555666  & B555666 not exists in BW/ECC side, only 555666 exists in ECC/BW.

Allocation logic distributes amount in 555666 to accounts A555666 & B555666.

Client asked to update BPC master data descriptions as per ECC. We brought ECC master data to BW infoobject 0GL_ACCOUNT.

Now in BW, record looks like this

555666(G/L account) and Description is Salary1.

Now I need to update this into BPC side using DM package (Import master data attribute/text from BW infoobject). That means

ID               Description

555666       Salary1

A555666     ASalary1

B555666      BSalary1

Thanks,

Kumar

[former_member186338 · Accepted solution]

Sorry, but what is the issue - just perform master data load from BW in update mode...?

[Former Member · Accepted solution]

Hi Vadim,

How to update two account's  A555666  & B555666 descriptions in BPC as they are not available in BW side?

In transformation file, I have to read description of G/L account 555666 and that description(i.e. Salary1) I have to append to both accounts descriptions(i.e. ASalary1 & BSalary1).

Thanks.

[former_member186338 · Accepted solution]

Ups, now I understand the question

May be using text file?

First update 555666 descr from BW

Then export master data to text file.

Then using VBA macro update description for A... and B...

Then load text file

Vadim

[former_member186338 · Accepted solution]

If you need some permanent solution - then create routine badi with the required logic...

[former_member186338 · Accepted solution]

Hi Kumar,

There is no magic:

3 solutions:

1. Maintain descriptions of A... and B... manually.

2. Semiautomatic - if you know VBA - you can write a simple code to update descriptions in text file and upload it back.

3. Full automatic - if you know ABAP - write routine badi to do the job.

Vadim

[former_member200327]

Hi Kumar,

How did you initially create A555666 and B555666?

Regards,

Gersh

[former_member186338]

From the first post it looks like - manually!

[Former Member]

Hi Gersh,

Maintained manually.

[former_member200327]

Then why you don't want to maintain manually changes to those members?

If every member has 2 clones then I think routine BADI is the easiest way to maintain those, but if only some - then you should continue your manual activities.

-Gersh