WARNING: PLEASE NOTE THIS BLOG IS ONLY FOR MIGRATION TO S/4HANA 1511. PLEASE USE MIGRATION OBJECT MONITOR INSTEAD OF LSMW FOR S/4HANA 1610 ONWARDS.

You want to mass migrate Business Partner data from your existing system to S/4HANA 1511. This blog explains how to import data from tab delimited text files residing on FrontEnd computer (PC) using transaction code LSMW – Direct Input method together with a custom program provided.

Please note that the LSMW tool is to be used for creating and updating Business Partner data directly in S/4HANA system with New Implementation. It is not intended to be used for ECC to S/4HANA conversion.

1. DOWNLOAD AND EXTRACT FILES:

Download file BP.ZIP and extract into a dedicated folder ( e.g. C:TEMPBP) on the FrontEnd Computer (PC). Each Excel file listed below corresponds to different Master data segments of the Business Partner Object as input parameters of function module RFC_CVI_EI_INBOUND_MAIN::

          01_CVIS_BP_GENERAL.xlsx

          02_CVIS_BP_ROLES.xlsx

          03_CVIS_BP_INDUSTRY.xlsx

          04_CVIS_BP_IDENT_NUMBERS.xlsx

          05_CVIS_BP_BANK_DETAILS.xlsx

          06_CVIS_BP_TAX_NUMBER.xlsx

          07_CVIS_BP_TAX_NUMBER_COMMON.xlsx

          08_CVIS_BP_ADDRESS.xlsx

          09_CVIS_BP_ADDRESS_USAGE.xlsx

          10_CVIS_BP_ADDRESS_TELENO.xlsx

          11_CVIS_BP_ADDRESS_FAXNO.xlsx

          12_CVIS_BP_ADDRESS_EMAIL.xlsx

          13_CVIS_BP_ADDRESS_URL.xlsx

          14_CVIS_BP_RELATION.xlsx

          15_CVIS_CUSTOMER_GENERAL.xlsx

          16_CVIS_CUSTOMER_COMPANY.xlsx

          17_CVIS_CUSTOMER_SALES.xlsx

          18_CVIS_CUSTOMER_COMP_DUNNING.xlsx

          19_CVIS_CUSTOMER_SALES_FUNC.xlsx

          20_CVIS_CUSTOMER_TAX_INDICATOR.xlsx

          21_CVIS_CUSTOMER_GENERAL_VAT.xlsx

          22_CVIS_SUPPLIER_GENERAL.xlsx

          23_CVIS_SUPPLIER_COMPANY.xlsx

          24_CVIS_SUPPLIER_COMPANY_WTAX.xlsx

          25_CVIS_SUPPLIER_PURCHASING.xlsx

          26_CVIS_SUPPLIER_GENERAL_VAT.xlsx

2. CREATE STRUCTURES IN S/4HANA SYSTEM:

You can use program in BP.ZIP (file ZLSMW_STRUCTURES.TXT) to create structures. Activate the structures.

Alternatively you can manually create structures (SE11) according to specifications in provided Excel files as described below. Choose a transportable package in customer namespace and put this into new transport request.

Using transaction SE11 generate the following structures with “CHAR” data types copying the exact parameter name and data type length in the “Z” structure. Name the “Z” structures as defined in the following table:

 

SAP DELIVERED Z STRUCTURE
CVIS_BP_ADDRESS ZZCVIS_BP_ADDRESS
CVIS_BP_ADDRESS_EMAIL ZZCVIS_BP_ADDRESS_EMAIL
CVIS_BP_ADDRESS_FAXNO ZZCVIS_BP_ADDRESS_FAXNO
CVIS_BP_ADDRESS_TELENO ZZCVIS_BP_ADDRESS_TELENO
CVIS_BP_ADDRESS_URL ZZCVIS_BP_ADDRESS_URL
CVIS_BP_ADDRESS_USAGE ZZCVIS_BP_ADDRESS_USAGE
CVIS_BP_BANK_DETAILS ZZCVIS_BP_BANK_DETAILS
CVIS_BP_GENERAL ZZCVIS_BP_GENERAL
CVIS_BP_IDENT_NUMBERS ZZCVIS_BP_IDENT_NUMBERS
CVIS_BP_INDUSTRY ZZCVIS_BP_INDUSTRY
CVIS_BP_RELATION ZZCVIS_BP_RELATION
CVIS_BP_ROLE ZZCVIS_BP_ROLE
CVIS_BP_TAX_NUMBER ZZCVIS_BP_TAX_NUMBER
CVIS_BP_TAX_NUMBER_COMMON ZZCVIS_BP_TAX_NUMBER_COMMON
CVIS_CUSTOMER_COMP_DUNNING ZZCVIS_CUSTOMER_COMP_DUNN
CVIS_CUSTOMER_COMPANY ZZCVIS_CUSTOMER_COMPANY
CVIS_CUSTOMER_GENERAL ZZCVIS_CUSTOMER_GENERAL
CVIS_CUSTOMER_GENERAL_VAT ZZCVIS_CUSTOMER_GENERAL_VAT
CVIS_CUSTOMER_SALES ZZCVIS_CUSTOMER_SALES
CVIS_CUSTOMER_SALES_FUNC ZZCVIS_CUSTOMER_SALES_FUNC
CVIS_CUSTOMER_TAX_INDICATOR ZZCVIS_CUSTOMER_TAX_IND
CVIS_SUPPLIER_COMPANY_WTAX ZZCVIS_SUPPLIER_COMP_WTAX
CVIS_SUPPLIER_COMPANY ZZCVIS_SUPPLIER_COMPANY
CVIS_SUPPLIER_GENERAL ZZCVIS_SUPPLIER_GENERAL
CVIS_SUPPLIER_GENERAL_VAT ZZCVIS_SUPPLIER_GENERAL_VAT
CVIS_SUPPLIER_PURCHASING ZZCVIS_SUPPLIER_PURCHASING

 

For example, structure CVIS_BP_ROLE will match ZZCVIS_BP_ROLE component names as shown below.

 

Make sure that you set all data types to “CHAR” in the “ZZ” structures and add component STYPE to all structures as the first component in the structure. Activate the Structures.

 

 

3. CREATE REPORT PROGRAM IN S/4HANA SYSTEM:

 

Using LSMW Program source code provided in BP.ZIP (file ZLSMWDSPRG_CVI.TXT), create a program (SE38). Create a transportable package in customer namespace, adding to above transport request. Remember to add the text elements specified in the LSMW Program text elements file. Activate the program. You do not need to execute the program, it will be run by LSMW.

 

 

 

4. MAINTAIN LSMW CUSTOMIZING TABLES:

 

Using transaction code SM30, maintain tables SXDA0, SXDA1, and SXDA2 as below:

 

Add following entry for Business Partner in table SXDA0.

DXOBJ 9900
DX obj. short text Business Partner
DX type D
Object type BUS1006

 

Add following entry in table SXDA1.

DXOBJ 9900
SUBDX 0000
DXPRG ZLSMWDSPRG_CVI
DXPTY D
FILENAME ZLSMWCVIBPOUT

If you have problems to maintain entries in table SXDA1 check the following note:2192586 – Table maintenance dialog of SXDA1 dumps.

Please use SE16 SXDA1 and then /h to edit table in debug mode to add record.

 

Create following entries in table SXDA2:

Data transfer object DX Object Subcat. Item + Import Structure Hierarchy level Parent segment? Mandatory segment Minimum number Maximum number Active
9900 0 1 General ZZCVIS_BP_GENERAL 1 X X 1 1 X
9900 0 2 Role ZZCVIS_BP_ROLE 1 0 0 X
9900 0 3 Industry ZZCVIS_BP_INDUSTRY 1 0 0 X
9900 0 4 Ident_Numbers ZZCVIS_BP_IDENT_NUMBERS 1 0 0 X
9900 0 5 Bank_Details ZZCVIS_BP_BANK_DETAILS 1 0 0 X
9900 0 6 Tax_Number ZZCVIS_BP_TAX_NUMBER 1 0 0 X
9900 0 7 Tax_Num_Common ZZCVIS_BP_TAX_NUMBER_COMMON 1 0 0 X
9900 0 8 Address ZZCVIS_BP_ADDRESS 1 0 0 X
9900 0 9 Address_Usage ZZCVIS_BP_ADDRESS_USAGE 1 0 0 X
9900 0 10 Address_Teleno ZZCVIS_BP_ADDRESS_TELENO 1 0 0 X
9900 0 11 Address_Faxno ZZCVIS_BP_ADDRESS_FAXNO 1 0 0