topic Legacy System Migration Workbench in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957249#M66627 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Does anyone a sample file that can be used to upload data to R/3 using the LSMW? I need to show a simple scenario of uploading a business partner, a purchase order or something like that, into R/3.</P><P></P><P>Thanks!</P><P>Roman D.</P></BODY></HTML> Fri, 08 Jul 2005 18:19:19 GMT Former Member 2005-07-08T18:19:19Z Legacy System Migration Workbench https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957249#M66627 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Does anyone a sample file that can be used to upload data to R/3 using the LSMW? I need to show a simple scenario of uploading a business partner, a purchase order or something like that, into R/3.</P><P></P><P>Thanks!</P><P>Roman D.</P></BODY></HTML> Fri, 08 Jul 2005 18:19:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957249#M66627 Former Member 2005-07-08T18:19:19Z Re: Legacy System Migration Workbench https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957250#M66628 <HTML><HEAD></HEAD><BODY><P>The upload file can be how ever you want it. What ever fields that you need. For example, when creating a purchase order, you will need things like, vendor, delivery date, quantity, material, etc. You may not need "constant" values. These can be hardcoded in the LSMW. So in this case you can have your file as comma delimited.</P><P></P><P>Vendor,delivery_date,quantity,material</P><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Fri, 08 Jul 2005 18:29:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957250#M66628 RichHeilman 2005-07-08T18:29:55Z Re: Legacy System Migration Workbench https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957251#M66629 <HTML><HEAD></HEAD><BODY><P>When we uploaded our POs to SAP we used two comma delimtited texts file. One for the header data and one for the detail data. Here is the structure of both.</P><P></P><PRE><CODE> PORD01 Purchase Order EBELN C(010) Purchasing Document Number EKGRP C(003) Purchasing group LIFNR C(010) Vendor Account Number BEDAT C(008) Purchase Order Date ZTERM C(004) Payment Terms WAERS C(005) Currency Key WKURS C(009) Exchange rate INCO1 C(003) Incoterms INCO2 C(028) Incoterms (Part 2) PORDIT01 Purchase Order Item EBELN C(010) Purchasing Document Number EBELP C(005) Item Number of Purchasing Document EMATN C(018) Material number TXZ01 C(040) Short Text MATKL C(009) Material group WERKS C(004) Plant LGORT C(004) Storage Location KNTTP C(001) Account assignment category EINDT C(008) Item delivery date MENGE C(013) Purchase order quantity MEINS C(003) Order unit NETPR AMT3(014) Net price: Document currency PEINH C(005) Price unit BPRME C(003) Order price unit (purchasing) BPUMZ C(005) Numerator: Conversion OPUn into OUn SAKTO C(010) Cost Element KOSTL C(010) Cost center SPINF C(001) Indicator: Update info record </CODE></PRE><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Fri, 08 Jul 2005 18:42:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957251#M66629 RichHeilman 2005-07-08T18:42:29Z Re: Legacy System Migration Workbench https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957252#M66630 <HTML><HEAD></HEAD><BODY><P>Thanks Rich!</P></BODY></HTML> Fri, 08 Jul 2005 21:05:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/legacy-system-migration-workbench/m-p/957252#M66630 Former Member 2005-07-08T21:05:42Z