Skip to Content
avatar image
Former Member

Import block prices in one field?

Hello everybody,

I have another question an this time it is about the MDM Import Manager and a possibility to import an article with block prices [lower bound]; [purch org]; [price]; [currency]

Source File

Priceinformation

1;Dynamo Zentraler Einkauf;15.00;EUR;100;Dynamo Zentraler Einkauf;13.50;EUR;1000;Dynamo Zentraler Einkauf;11.50;EUR;1500;Dynamo Zentraler Einkauf;10.00;EUR;

Destination structure: [Screenshot|http://www.deutsche-bc.com/temp/MDM_Cons.jpg]

Is it possible to get the source information in a structure like the one in the screenshot? -

I tried the partitioning in the import manager and create for the lower bound, purch org, price/amount and currency a combined field but I was not able to map it or create a compound field for the u2018priceinformationu2019.

Regards,

Andi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 13, 2009 at 05:10 PM

    Hello Andi

    Can you transform you source data file to that format:

    purch org; lower bound; currency; price;

    as

    Dynamo Zentraler Einkauf;15.00;EUR;100;

    Dynamo Zentraler Einkauf;13.50;EUR;1000;

    Dynamo Zentraler Einkauf;11.50;EUR;1500;

    Dynamo Zentraler Einkauf;10.00;EUR;

    then import it without problem

    and about "compound filed" - What do you mean?

    Regards

    Kanstantsin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      First use the option split multiple fields delimiter string (In your case semi column ; )for the field you want to split it in the source structure.

      After that, use option split in to multiple fields option in souce structure.

      Hope it will solve your issue.

      Thanks,

      Narendra

  • avatar image
    Former Member
    Oct 14, 2009 at 09:54 AM

    Hi,

    You are trying to import Qualified look up table basically.Follow the steps below

    1)In Import Manager select the destination table(Price) and the source table (table containing info specified by you)

    2)Map the Non Qualifier lower bound and Purchasing org.Do the value mapping for Purchasing Org(since it is a look up table).Perform the import.

    3)In Import manager ,select the source table and then destination table as Main table

    4)Map all main table fields.Map all non Qualifiers(lower bound and Porg).Map the Qualifiers (Price and Currency).

    5)In the Source table fields right Click on Say Price ->Create Compound Field.Now Map the created Compound field on Source side with Destination Price Information field(Main Table).Do the Value mapping.

    6)Perform the import as per the Matching field.

    You can refer following documents

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/00a15239-684e-2b10-b8ae-b936b7d1c1fe

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c03240fa-cc3e-2b10-aa9a-a5798e319a6e

    Regards

    Nisha

    Edited by: Nisha L on Oct 14, 2009 11:58 AM

    Add comment
    10|10000 characters needed characters exceeded