Skip to Content
author's profile photo Former Member
Former Member

value mapping from a combined source field to LookUp[Qualflat](multival)

Hi,

I am unable to do value mapping (unable to add the source value) from a source field which is a combination of 3 source field to a Multivalued Qualified field on the main table.

This is my scenario.

Initial Source file structure prior to partitioning:

Field / Value

Name / Test

Sales / 00

Division /100

District /AA

Source File After combining using partitioning:

Field / Value

Name / Test

Sales [[partition]] - I combined Sales,name,division on this field/ 00;Test;100

Division /100

District/ AA

Destination Field on the main table (Lookup [Qualified Flat](multi valued)

Field Level - Sales Area<Sales;Name;Division>

Already Existing Value Level - NULL Sales; NULL Name;NULL Division

I am unable to add the value mapping from the combined source field to multivalued qualified destination field.

Any Help!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2008 at 08:09 PM

    The above description might be confusing .This is what I have to do

    "Mapping from a multiple corresponding source fields to a compound lookup field"

    In my case the compound lookup field is Qualified Lookup Field.SAP recommends map-within-a-map mechanism. Does anybody have any idea on this???

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Just try one thing dont merge the fields by using Partitioning.

      First map the fields one to one like Sales with Sales and so on. Then select all the three fields right click on it and check whether Create Compound option allows you to create the compound field.

      Regards,

      Jitesh Talreja

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2008 at 06:45 AM

    Hi,

    Creation of compound fields come into picture only when your Sub table(Qualified Flat) has more than one Non-Qualifiers Fields that too with Display Fields.

    So in this case you dnt need to do Partioning, just map these source fields with corresponding Destination Non-Qualifier Display fields one by one then selecting all these on right click you will get option Create Compound field, so this Compound field automatically map with your target destination Sales Area<Sales;Name;Division> then here you can map or add source values then import.

    Other thing you can do, instead three Non-qualifiers as Display Field, just Create one Non- Qualifier as Display Field say name, firstly map Source Non-Qualifiers with Destination Non-Qualifiers on Selecting Subtable Qualified Flat as your Current Table then import, in this way your Non-Qualifiers get imported,after importing this, then Select Main Table as your Current Destination table map all the Qualifiers, here also map

    source field name with Field in main table (which is lookup to Subtable (Qualified Flat)) and map its values too and also your other main table fields corresponding to your source fields.

    Hope it will Help you,

    Rewards if Useful........

    Mandeep Saini

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Aravind,

      Creation of compound fields come into picture only when your Sub table(Qualified Flat) has more than one Non-Qualifiers Fields that too with Display Fields.

      Genarally compound field will be created when lookup table has morethan one display field.

      After we import the data into lookup table which contains multiple diplay fields(Example: Name and age), import the data into main table.

      While importing the data into maintable , map all the individual fields (With display

      fields in lookup table) and just right click on the mapped fields so that you can

      see the create compund field option and use that option.As soon as you choose that

      option compound field which contains muliple display fields (Ex: Name;age) is

      automatically mapped to destination side field ( Name;age).

      The same is applicable to qualified lookup tables;Here in qualifed lookup table,

      Compond field need to be created for non-qualifier diaplay fields.

      Hope solved your problem

      Thanks

      Narendra

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.