Field Description instead of Field ID

[Former Member]

Hello BPCers, and happy new year.

I have a problem with a Master Data package that I would like to share with you all.

I'm trying to import an InfoObject from BW that concatenates the client and the material family (this one is the key field of the InfoObject). Moreover, there are some attributes like Family, Client_description, Employee (person in charge of this combination of client and material family), etc.

Sincé I don't have the concatenation in the InfoObject, I have to make it manually in the transformation file.

The problem appears when launching the import package: the combination of Client + Family returns the combination of Client Description + Family.

(for example, ClientDescription1_FamilyABC instead of Client1_FamilyABC), and I don't know why.

The mapping i'm using is:

ID = ID + 0CUSTOMER

Family = ID

Client = 0CUSTOMER

Client_desc = ZTXTCUSTOMER

Salesman = 0SALESEMPLY

Salesman_desc = ZTXTSALESEMPLY

In the InfoObject, the customer is a relation, not an attribute(i'm not sure if this is relevant).

Somebody have idea of why the package is returning the description and not the ID? Every help would be welcome.

Thank you in advance.

[bhagyesh_ravange · Accepted solution]

Hello Antonio,

What is the Technical name of Header which contains Client1 in BW.

Regards

Bhagyesh Ravange

[Former Member · Accepted solution]

Hello Bhagyesh,

the InfoObject which contains the information about the client is 0CUSTOMER, and is related with the object I'm triying to import.

Hope it helps.

[bhagyesh_ravange · Accepted solution]

I mean to say Field name of Client ID

And also you have used ID in mapping section twice (i.e one in ID and second time in Family), why is it? Could you share the screen shot of BW InfoObject.

[Former Member · Accepted solution]

Hello Bhagyesh,

i'm sorry for the delay, but I have been absent for two weeks. In this tima, I have solved the problem.

The package that I defined was extracting incorrect fields because in the transformation file, in the options área, the delimiter was fixed to blank, so, when the package found a space in the 0CUSTOMER field, it went to the next field. In order to solve this problema, I changed the delimiter to a character that doesn't appear in 0CUSTOMER (%), and everything worked fine.

Thank you for your interest and your support.

Best regards

[bhagyesh_ravange]

Hello Antonio,

Could you share the screen shot of the BW Info-Object

Regards

Bhagyesh Ravange