Import sales order

[Former Member]

Hi gurus

Customer was using fox pro earlier and they have many sales orders from the legacy system, now they wanted to upload all the previous sales order in to SAP B12007 using DTW , I tried using the Orders template provided in DTW templates ,each time its showing different error msgs,

It would be of grate help if some one provide some sample templates for sales orders or sample formats which would be great help to me

Thanks

sri

[Former Member · Accepted solution]

Hi Sri,

I believe there is no simple solution for your problem. The fact is: in the legacy system, it may allow all kinds of order entries without consistent data. You have to make sure all data need to be imported to B1 have consistent contents.

What errors have you got most often?

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon

Thanks for your quick reply,mostly this errors occurs" date deviates from specific range" ,while googling i found a way to directly enter the data in to SQL2005 by using SQL BI connector but i i dont have clue if i follow this will it be rite one to upload the data from the excel sheet

Regards

sri

[Former Member · Accepted solution]

You need to stick on DTW only. Otherwise, it may violate the support contract. The date format should be YYYYMMDD for all records. And all the periods for those orders have to be defined in advance.

[Former Member · Accepted solution]

Thanks a lot for all your response , had a look at the defined examples and tried the same but its not of no use ,is there any SAP notes of how to use the template or is there any alternate way to upload data other than DTW templates ,

Regards

sri

[former_member583013 · Accepted solution]

Srinivasan

First identify what data you are trying to import and share it here. From there I will help you identify the fields they should map too.

Best wishes

Suda

[Former Member · Accepted solution]

am trying to upload a sales order ,items with excise tax and i was using the document template for header and additionallines templates for line items .. and receiving this error

There are Non-excisable items with CENVAT tax code application defined or object defined error oOrders

[Former Member · Accepted solution]

Can u let me know the Mandatory fields which should be filled in the sales order template 0orders

[Former Member · Accepted solution]

Hi

Please take a look at this

How can I determine which fields are mandatory in a Data Transfer Workbench (DTW) template?

https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=36438280

Hope this helps

Bishal

[Former Member · Accepted solution]

Hi

Can u let me know where to get the account code , there is a column to be filled up in the o0rders template

Regards

srini

[Former Member · Accepted solution]

For item type documents, you may not have options to upload account codes. They are associated with Items by G/L Account determination method.

[Former Member · Accepted solution]

HI

Attaching the txt file for line documents

RecordKey LineNum AccountCode Address BackOrder BarCode BaseEntry BaseLine BaseType CommisionPercent ConsumerSalesForecast CorrInvAmountToDiffAcct CorrInvAmountToStock CorrectionInvoiceItem CostingCode CountryOrg Currency DeferredTax DiscountPercent DistributeExpense ExciseAmount Factor1 Factor2 Factor3 Factor4 FreeText Height1 Height2 Height2Unit Hight1Unit ItemCode ItemDescription Lengh1 Lengh1Unit Lengh2 Lengh2Unit LineTotal Price PriceAfterVAT ProjectCode Quantity Rate RowTotalFC SWW SalesPersonCode SerialNum ShipDate ShipToCode ShippingMethod SupplierCatNum TaxCode TaxLiable TaxPercentagePerRow TaxType TransactionType UnitPrice UseBaseUnits VatGroup VendorNum Volume VolumeUnit WarehouseCode Weight1 Weight1Unit Weight2 Weight2Unit Width1 Width1Unit Width2 Width2Unit

RecordKey LineNum AccountCode Address BackOrder BarCode BaseEntry BaseLine BaseType CommisionPercent ConsumerSalesForecast CorrInvAmountToDiffAcct CorrInvAmountToStock CorrectionInvoiceItem CostingCode CountryOrg Currency DeferredTax DiscountPercent DistributeExpense ExciseAmount Factor1 Factor2 Factor3 Factor4 FreeText Height1 Height2 Height2Unit Hight1Unit ItemCode ItemDescription Lengh1 Lengh1Unit Lengh2 Lengh2Unit LineTotal Price PriceAfterVAT ProjectCode Quantity Rate RowTotalFC SWW SalesPersonCode SerialNum ShipDate ShipToCode ShippingMethod SupplierCatNum TaxCode TaxLiable TaxPercentagePerRow TaxType TransactionType UnitPrice UseBaseUnits VatGroup VendorNum Volume VolumeUnit WarehouseCode Weight1 Weight1Unit Weight2 Weight2Unit Width1 Width1Unit Width2 Width2Unit

1 0 _SYS00000000059 1 1 1 1 1 1 1 1 A00001 production 2 2 2 2 1 100 10 20050104 1 tNO botrntComplete tYES 1 12 1 1 100 1 100 1 10 1 10 1

2 0 _SYS00000000060 1 1 1 1 1 1 1 1 A00002 production 2 2 2 2 1 200 20 20050104 1 tNO botrntComplete tYES 1 12 1 1 100 1 100 1 10 1 10 1

3 0 _SYS00000000061 1 1 1 1 1 1 1 1 A00003 production 2 2 2 2 1 210 30 20050104 1 tNO botrntComplete tYES 1 12 1 1 100 1 100 1 10 1 10 1

from where do we get the account code

[Former Member]

CLOSED

[Former Member]

hi

C:\Program Files\sap\Data Transfer Workbench\Templates\Data preparation examples\10. Testcase1_Test Data for Import function\oOrders

Please view above list address there som basic template .

Thanks

Kevin