Skip to Content

Importing Masters through SAP B1 Import Export Utility

Hi guys,

I am using Import and export utility to import BPs and Items. If anyone has used it please tell me if there any issues / future implications regarding it or it is just ok.

Thanks and regards

Pardeep

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:53 PM

    Pardeep,

    The Data Import and Data Export options within SAP is just another way to import/export data.

    There is going to be no Implecation or problems by importing data using this tool.

    Good luck

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 06:37 AM

    hi pradeep,

    Only limited amount of columns(limited no. of data) can be

    imported through the import from excel.

    Date from excel should be mapped exactly with

    as with columns and fields in Import from excel for both BP/Items.

    Excise and other tax information in BP can't be uploaded

    through import from excel,this can be possible in DTW.

    Excisable,Material Type,Chapter ID and assesable value

    can't be uploaded through import from excel,this is also not

    possible in SAP B1.

    You need to set warehouses manually if

    "Auto add all warehouse to New Warehouses" is not ticked,this

    is possible in DTW using template oWarehouses.

    Considering above limitations you can better opt for DTW

    to import datas to SAP B1.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

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.