Variant Configuration – CU60E – Uploading to a Variant Table

Home / Blog / Variant Configuration – CU60E – Uploading to a Variant Table

Hey everyone, I figured it was about time I drifted back to VC for a while.  I’ve been posting about business and service a lot lately, so here’s a little tidbit that has come in very handy for me.  Often time when you’re loading in a variant table, there can quite a few entries.  So SAP built in a pretty little cool utility.  It’s CU60E.  The only problem with it is that isn’t intuitive exactly how it works, so here’s how you can make use of it.

1.    The characteristics in your file must be listed in the same order as they appear in the variant table.

2.    The file must be saved in a ‘;’ delimited file (Use CSV, and then do a find a replace).

3.    Validate the CSV file to make sure there are no quote marks included.  If there are, they need to be deleted.

4.    The upload should only be done for the initial load of the table.   When it runs, it wipes out the existing contents, and uploads the file.  You cannot append to an existing table using this transaction.

If you follow those 4 simple steps, you’ll be able to upload to any variant table using CU60E.

happy configuring!

Remember, if you need any help with variant configuration, service management or production planning, please use the contact us button above, and let us know how we can help,

thanks,

Mike

1.    the variant table.

2.    The file must be saved in a ‘;’ delimited file (Use CSV, and then do a find a replace).

3.    Validate the CSV file to make sure there are no quote marks included.  If there are, they need to be deleted.

4.    The upload should only be done for the initial load of the table.   When it runs, it wipes out the existing contents, and uploads the file.  You cannot append to an existing table using this transaction.

As always, thanks for reading and don't forget to check out our SAP Service Management Products at my other company JaveLLin Solutions,
Mike

3 thoughts on “Variant Configuration – CU60E – Uploading to a Variant Table

  1. Hi Mike.

    Appreciate your kind information share. I need you a favor that I was plan to upload a variant table via CU60E.

    It run successed by following your guide. But it’s only for 1:1:N mode. My requirement is uploading variant table which with N:N mode. Could you pls tell me how to organize the CSV file? I have no idea what the format is..

    Thanks in advanced.

    1. Hi Jim,
      I’m sorry to say, but I don’t believe that CU60E can do the N:N mode (I think you’re asking for the functionality that lets you pull open the dropdown list and select multiple items within a single line). To the best of my knowledge (and please anyone out there correct me), that CU60E can only work in a single line format.
      Thanks,
      Mike

Leave a Reply

Your email address will not be published. Required fields are marked *