EPM10NW: Import Master Data from BW

[Former Member]

Hi experts,

Hope someone could help

I try to import Master Data using this package : /CPMB/IMPORT_IOBJ_MASTER

In my transformation file, i put VALIDATE RECORDS to NO.

and, in the Mapping Section, I have written : ID=ID

While executing the package i get this error :

Task name MASTER DATA TARGET:

Error in Admin module or a component used by Admin module

Member '1000100' attribute value is invalid: 'ACCTYPE' = ''.

Obviously, in BW, my infoobject '0COSTELEMNT' do not have that attributes as it is a BPC specific property.

I clearly imagine I miss something.... but what ?

could you help ?

Tks a lot

Olivia.

[Former Member · Accepted solution]

Hi experts,

Ok then, I find that i need to create mapping et conversion for my property ACCTYPE which is, I believe , a Mandatory property.

Now , i face another Error Message , if someone could help to solve it 😕 :

Tks a lot for your help,

The message :

Task name TXT DATA TARGET:
/CPMB/DRDHR2J : Data record 4 ('400002                          F') : Duplicate data record
/CPMB/DRDHR2J : Data record 13 ('407000                          F') : Duplicate data record

Regards,

Olivia.

[Former Member · Accepted solution]

Olivia,

You may have multiple (more than one ) controlling area in your source. Try to filter CO_AREA while loading it will filter the same data from other CO_AREA's.

Thanks

Rushi

[Former Member · Accepted solution]

Yes, I think tou re right.

But, do you know how can I make a filter ? Do i need to filter first in BW ... or can I directly filter in my Conversion File of BPC ? In my conversion file do not really know how I can filter my controlling area ?

Can you help on this ?

Tks a lot,

Rgds,

Olivia.

[former_member187255 · Accepted solution]

You can filter in your Data Manager while loading using Set Filter...

[Former Member · Accepted solution]

Yes That's true. But, I cannot make filter based on Field :-(. The only list that appears is made of Attributes...

Tks for your help,

Olivia.

[Former Member · Accepted solution]

The thing is, that i'd like to make filter on Field Not Attributes... as my Cost Element are Time Dependant, I have for each, 2 lines, like this :

BE01	609180	EN	31.12.1996	01.01.1000		KK4CLNT200
BE01	609180	EN	31.12.9999	01.01.1997	1	KK4CLNT200			Inc./dec.diff.suppls

And I'd like to filter my import on the base of the field "VALID TO" = 31/12/999

Tks for your help,

Olivia.

[Former Member · Accepted solution]

Ok, Problem solved

I think the System BW is quite smart....  i think while importing it automatically checks the VALID TO field..

Anyways,

Tks.

Rgds,

Olivia.

[Former Member · Accepted solution]

Hi,

I've just one other and maybe last question to well understand :

Is it possible to import only some Cost Element : I mean, for example, only Cost Element that begin by 6* and 7* ?

I tried to make a conversion rule in my Conversion File, but, it does not seem to take the rule.

Here what i wrote :

EXTERNAL	INTERNAL
*	*
1*	*SKIP
1*	*IGNORER

Tks for your help

Rgds,

Olivia

[former_member186498 · Accepted solution]

Hi Olivia,

you must use an IF instruction in combination with js instruction (js: %external%.substring(0,1)), please see

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/81/94a8a5febd40268d5c59b4fc31be37/content.htm

Kind regards

     Roberto

[Former Member · Accepted solution]

Yes. Tks Roberto

But, if I but something like this, it should work no ?

EXTERNAL	INTERNAL
*	*
8*	*skip

Tks for your help,

Olivia.

[former_member186498 · Accepted solution]

Hi Olivia,

no it should be something like

EXTERNAL	INTERNAL
*	*
*	if(js: %external%.substring(0,1)="8" ...

give a  look at the link for the correct syntax.

Kind regards

     Roberto