Skip to Content
avatar image
Former Member

Field Description instead of Field ID

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 02, 2015 at 02:38 PM

    Hello Antonio,

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

    Regards

    Bhagyesh Ravange

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Bhagyesh Ravange

      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

  • Jan 02, 2015 at 02:45 PM

    Hello Antonio,

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

    Regards

    Bhagyesh Ravange

    Add comment
    10|10000 characters needed characters exceeded