Legacy System Migration Workbench

[Former Member]

Hi All,

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.

Thanks!

Roman D.

[Former Member]

Hi All,

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.

Thanks!

Roman D.

[RichHeilman]

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.

Vendor,delivery_date,quantity,material

Regards,

Rich Heilman

[RichHeilman]

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.

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                                                                                

Regards,

Rich Heilman

[Former Member]

Thanks Rich!