Skip to Content

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:\TEMP\BP) 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.

/wp-content/uploads/2016/03/stru1_904236.png

/wp-content/uploads/2016/03/stru2_904237.png

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.

TextElements.png

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

X

9900

0

12

Address_Email

ZZCVIS_BP_ADDRESS_EMAIL

1

0

0

X

9900

0

13

Adress_Url

ZZCVIS_BP_ADDRESS_URL

1

0

0

X

9900

0

14

Relation

ZZCVIS_BP_RELATION

1

0

0

X

9900

0

15

Cust_General

ZZCVIS_CUSTOMER_GENERAL

1

0

0

X

9900

0

16

Cust_Company

ZZCVIS_CUSTOMER_COMPANY

1

0

0

X

9900

0

17

Cust_Sales

ZZCVIS_CUSTOMER_SALES

1

0

0

X

9900

0

18

Cust_Comp_Dunn

ZZCVIS_CUSTOMER_COMP_DUNN

1

0

0

X

9900

0

19

Cust_Sales_Func

ZZCVIS_CUSTOMER_SALES_FUNC

1

0

0

X

9900

0

20

Cust_Tax_Ind

ZZCVIS_CUSTOMER_TAX_IND

1

0

0

X

9900

0

21

Cust_General_Va

ZZCVIS_CUSTOMER_GENERAL_VAT

1

0

0

X

9900

0

22

Supp_General

ZZCVIS_SUPPLIER_GENERAL

1

0

0

X

9900

0

23

Supp_Company

ZZCVIS_SUPPLIER_COMPANY

1

0

0

X

9900

0

24

Supp_Company_T

ZZCVIS_SUPPLIER_COMP_WTAX

1

0

0

X

9900

0

25

Supp_Purchasing

ZZCVIS_SUPPLIER_PURCHASING

1

0

0

X

9900

0

26

Supp_General_Va

ZZCVIS_SUPPLIER_GENERAL_VAT

1

0

0

X

5. CONFIGURE BUSINESS PARTNERS:

Configure Business Partners in your S/4HANA 1511 system according to the Best Practices Building Block Configuration Guide “J61_S4HANAX_BB_ConfigGuide_EN_XX.docx“. This guide is also included in the BP.ZIP file.

6. UPLOAD LSMW PROJECT FILE:

Using transaction LSMW -> Extras -> Import Projects upload LSMW Project File LSMW_S4H_ZLSMWCVI_BP.TXT

At the screen below please click on Import button.

LSMW import.png

7. PREPARE DATA FIELDS FOR UPLOAD:

Open all Excel Files (Templates), rows 1-4 give you description of fields. After you input all your legacy business partner data into rows 5 onwards in each file, remove rows 2,3,4 and export the file as a tab-delimited text file, retaining the file name but saving to extension .TXT.

In the resulting upload text file, row 1 must contain the field names and row 2 and above contain the data. (Note: since certain fields such as address may have a comma in the field, we do not recommend .CSV files.). Place the upload text files into the same folder (C:\TEMP\BP).

8. ASSIGN INPUT FILES:

Assign input files to LSMW data structure only if your PC upload path is not C:\TEMP\BP). As shown below execute step “Specify Files” in your LSMW Project, and switch into change mode (Ctrl+F1).
FileProperties.png
For each file, click on the file name to open the “File on FrontEnd: Maintain Properties”.  Click the drop down button of the File field, and select your input file, navigating to the pertaining upload directory of your FrontEnd PC. The other settings should remain as follows -:

  • File Contents: Data for One Source Structure (Table)
  • Delimiter: Separator Tabulator
  • File Structure: Field Names at Start of File
  • File Type: With Record End Indicator (Text File)
  • Code Page: Code Page ASCII

9. PERFORM INITIAL UPLOAD:

For the creation of new Business Partner records proceed according to standard LSMW process i.e., Read Data, Display Read Data, Convert Data, Display Converted Data and Start Direct Input Program. At the last step of Start Direct Input Program, please enter Physical filename as “ZLSMWCVI_BP_ZLSMWCVI_BP_ZLSMWCVI_BP.lsmw.conv”

/wp-content/uploads/2016/03/startdirectinput_962971.png

For each BP, the following input data has to be prepared:

          A. 01_CVIS_BP_GENERAL.xlsx file

               a. Column C BPARTNERGUID field: blank

               b. Column F OBJECT_TASK field: Enter “I” (for Insert)

          B. All input files

               a. Column A RUN_ID field: Enter the BP number for reference across multiple input files.

          C. Single entry for each BP in the following files:

               a. 01_CVIS_BP_GENERAL.xlsx (Mandatory)

               b. 15_CVIS_CUSTOMER_GENERAL.xlsx (Optional)

               c. 22_CVIS_SUPPLIER_GENERAL.xlsx (Optional)

          D. Other required master data files

               a. Multiple entries are allowed for each BP in all other files based on the business requirements.

          E. Not relevant files:

               For the data files not applicable to the business, save the blank file with only the title row into its corresponding txt file without any data.

10. PERFORMING DELTA UPLOADS:

Function module, RFC_CVI_EI_INBOUND_MAIN, called in LSMW BP upload tool only allows changes to existing data in 01_CVIS_BP_GENERAL.xlsx. Besides BP General Data, Customer General Data and Supplier General Data views, additional entries could be added to the existing BP, e.g. telephone numbers, new sales area customer SD data, additional addresses, bank accounts, etc.

For the update of existing Business Partners with changed and/or additional data records proceed as follows:

     A. 01_CVIS_BP_GENERAL.xlsx file

          a. Column C, fieldname BPARTNERGUID: Enter the BP GUID which can be extracted from BUT000 table fieldname BUT000-PARTNER_GUID.

          b. Column F fieldname OBJECT_TASK: Enter “U” (for Update).

          c. Make necessary data changes in this file.

     B. Prepare other input files to add more data views to the existing BP.

NOTE: Files 15_CVIS_CUSTOMER_GENERAL.xlsx and 22_CVIS_SUPPLIER_GENERAL.xlsx can only be uploaded once and cannot be changed by this LSMW tool. The value of the field OBJECT_TASK in these 2 files is ignored by LSMW program.

ADDITIONAL INFORMATION:

If a BP is to be created under internal number range, the BPARTNERGUID filed has to be filled with an unique sequential number in 1_CVIS_BP_GENERAL.TXT file

As LSMW tool cannot cover all the Business Partner Data structure requirements, please consider using:

1. function module CVI_EI_INBOUND_MAIN or

2. Webservices

   -BusinessPartnerSUITEBulkReplicateRequest

   -BusinessPartnerRelationshipSUITEBulkReplicateRequest

3. Use this LSMW tool to upload most of the BP data first, then create a new LSMW project to upload the remaining BP data.

Also, please refer to note 2287723 – LSMW in SAP S/4HANA on-premise edition


DATA SERVICES – Data Integrator

SAP S/4HANA customers have access to a basic Data Integrator license key that comes with the underlying SAP HANA license (HANA REAB or HANA Enterprise). This key code applied to SAP Data Services provides full ETL functionalities (Extract, Transform, Load). Thus, it replaces a mapping and load tool like LSMW with the Rapid Data Migration content. With this basic data load functionality of SAP Data Services and together with the Rapid Data Migration content, legacy data can be loaded into SAP S/4HANA (on premise) including data validation but without further Data Quality (de-duplication, data cleansing) and reporting capabilities. For this use case with the aforementioned functionality, SAP Data Services is free of charge and there is no additional cost.

For Asset Management data import workarounds, please refer:note 2208321 – FAQ for legacy data transfer in SAP_FIN 720 and subsequent

Thank you,

The S/4 HANA RIG AMERICAS TEAM

(Patrick Fiegl, Michael Foo, Jorge Baltazar & Mahesh Sardesai)

To report this post you need to login first.

119 Comments

You must be Logged on to comment or reply to a post.

      1. Mayank Verdia

        Hello Mahesh and all other Members:

        Can you please guide me why we cannot use LTMC Migration cockpit for uploading customer master from legacy system to S/4. In my case, Legacy system is a 3rd party system and not ECC. secondly, we tried T-code LTMC to upload customer using template provided by SAP  . We filled all the mandatory fields mentioned as Mandatory in the template but with no success.

        On LTMC, SAP says, for customer Master , Bank information is prerequisite . we even provided this information but with no success.

        Please guide us whether we can use LTMC for Customer Migration ? if not, why and secondly, can we use LTMC for any other Master data migration like Material , vendor etc?

        Any Blog which guides on how to decide which tool ( LTMC, Rapid data migration workbench, LSMW, BDC)  to use for which data migration in S/4 will be really helpful.

         

        thanks,

        Mayank

         

         

         

         

        (0) 
  1. Corrado Bernuzzi

    Hi Mahesh,

    we are trying to upload Vendor master, but it seems that the structure for vendor partner functions is missing and we receive an error for the mandatory ones, could you please help..

    Thanks, best regards, Corrado

    (0) 
      1. Torsten Manhardt

        Hello Mahesh,
        i just downloaded a fresh copy of BP.ZIP. I do not find a structure for vendor partner functions, only sales partner functions (ZZCVIS_CUSTOMER_SALES_FUNC). How can i set vendor functions?
        Regards
        Torsten

         

        (0) 
  2. Corrado Bernuzzi

    Hi Mahesh,

    thanks a lot for your support, we are going to try; just one more question in the meantime… we are also trying to update Customer masters following your instructions ( putting the OBJECT_TASK=U and the BUT000-PARTNER_GUID in  01_CVIS_BP_GENERAL file) but it seems that the system is going to consider the task “I” anyway(message CVI_EI007); any idea?

    thanks again, kind regards

    Corrado

    (0) 
      1. Torsten Manhardt

        Hello Mahesh,
        thank you for this helpful blog.

        I agree to Corrado, that function module RFC_CVI_EI_INBOUND_MAIN always switches into insert mode, regardless what you set in field OBJECT_TASK, at least for customer and supplier data. There was a code change, as you see in SE37 (on HANA 1511)

        This has the effect, that you cannot add company codes to existing customers or suppliers, because you will get error message CVI_EI 042 “Task Insert is not supported for the existing customer”.

        Regards
        Torsten

        (0) 
  3. Corrado Bernuzzi

    Hi Mahesh,

    sorry for chasing you, we just tried the new files/programs, but unfortunately it is not working, could you please tell me where to set the vendor partner functions to be created (I cannot find any Vendor file similar to 19_CVIS_CUSTOMER_SALES_FUNC)? Moreover the Vendor company and purhcasing data are not saved.

    Thanks again for your time, Corrado

    (0) 
    1. Mahesh Sardesai Post author

      Hi Corrado,

      File similar to 19_CVIS_CUSTOMER_SALES_FUNC for supplier  is 25_CVIS_SUPPLIER_PURCHASING.txt Please see if it contains the fields you were looking for.

      Thanks,

      (0) 
      1. A.S. van den Heuvel

        Hi Mahesh,

        I’m struggling with the same issue (trying to load mandatory Vendor Partner Functions), but I can not find a solution in the revised file-structures.

        Can you provide me more details?

        Thanks,
        Axel van den Heuvel

        (0) 
    2. A.S. van den Heuvel

      Hi Corrado,

      I was wondering whether you managed to load the Vendor Partner Functions, using this LSMW-solution, as we are facing the exact same issue.

      Thanks in advance,

      Axel van den Heuvel

      (0) 
  4. Enrique Peyro

    Any of you guys use the function to add or update a Vendor created already?

    I am trying to add Suppllier Company Withholding Tax Data.

    (0) 
      1. Mahesh Sardesai Post author

        Thanks Valente,

        This template to upload data as per your requested information is already supplied as part of BP.ZIP in file

        24_CVIS_SUPPLIER_COMPANY_WTAX.xlsx

        – Mahesh/Michael

        (0) 
  5. Aravind Kanaparthi

    Hi Mahesh,

    We are trying to upload the customer master using the above method, Though the customer is created, customer sales area is not updated. Always the sales areas fields are blank.

    We have used the templates 17 (17_CVIS_CUSTOMER_SALES) and 19 (19_CVIS_CUSTOMER_SALES_FUNC) along with other templates to create business partner. Also the partners for customer master are not getting updated.

    Could you please let us know if we are missing anything.

    (0) 
      1. Aravind Kanaparthi

        Hi Mahesh,

        We are still facing the same issue. We have used file no.s 1,2,6,8,15,17 & 19. Still the sales area is not getting. We are struggling since 1 month.

        Could you pls let us know what we are missing.

        Appreciate your help in advance!

        Thanks,

        Aravind.

        (0) 
      2. Aravind Kanaparthi

        Hi Mahesh,

        Also we see that the FM RFC_CVI_EI_INBOUND_MAIN is not released.  For that matter, none of the *CVI* Fm’s are not released.

        Could you pls let us know:

        1. Is SAP planning to release them in near future?

        2. Is it fine to use it (in LSMW or custom developments) even though it is not released?

        Appreciate your inputs.

        Thanks,

        Aravind

        (0) 
        1. Mahesh Sardesai Post author

          This blog was created to help with S/4HANA 1511 implementation as a low cost option since there was license cost for Data Services. Since then limited use of Data Integrator is allowed as per note 2287723 – LSMW in SAP S/4HANA on-premise edition.

          In future versions of S/4HANA it is PLANNED to include more migration features within the S/4HANA product and the legacy LSMW will not be developed further.

          (0) 
  6. Kiran Kumar Panda

    Hello Folks – We have a interface requirement to create business partner and also the vendor with company code data in the background . CVI configuration has also been set up for the same. We are planning to use the RFC CVI_EI_INBOUND_MAIN for creation. We tried various ways of populating the input data structure for this purpose but was unsuccessful. Can someone let me know if this is something that has been done before and help me with some guidelines document which explains how to populate the structures for the business partner creation along with the vendor data as well. Presently I am getting an error message “Specify at least one number for the business partner”. Please help.

    (0) 
    1. Malarvizhi Subbaiah

      Hello Kiran Kumar Panda,

      if you want to create the businesspartner either you should give partner number or guid. That’s why you are getting the error.

      Try to pass all the mandatory fields.

      (0) 
  7. Jonathan Buitrago

    Hi Mahesh,

    I have tried  to create a BP,  with the same IC number  to several ROL-PARTNER,  but only  some BP  were  created  at  single    ROL-PARTNER.

    Could you please tell me how I can do it?

    e.g

    The business  Process  must to  have the following:

    IC NUMBER      ROL-PARTNER        COMPANY CODE      

    0000001                FLVN00                          1000

    0000001                FLVN01                          1000

    0000001                FLVN00                          2000

    0000001                FLVN01                          2000

    Thanks in advance,

    Jonathan B.

    (0) 
  8. Vipin Nagpal

    Dear Mahesh,

    I have discussed this solution with end user. He is not happy to maintain multiples files.

    Can you please suggestion a direction, if i want to maintain single input file, then how can i proceed.

    Thanks a lot for this wonderful blog.

    Just want to add one learning here, If you are using internal number range for BP, then use  FM: GUID_CREATE (or some other FM which is latest to creat GUID) to pass guid in BPARTNERGUID.

    (0) 
    1. Mahesh Sardesai Post author

      Hi Vipin,

      You can modify the LSMW program LSMW_S4H_ZLSMWCVI_BP. However detailed discussion is outside the scope of this blog.

      Please limit questions to use of LSMW only.

      – Michael

      (0) 
  9. Andreu Mendoza

    Dear all,

    we are able to create BP successfully using the files 1 to 13. We can also create a customer with the data files 15 and 16 but we can not manage to extend the sales view (file 17 and 19).

    We are getting all the time the error: “Customer, Vendor, Personnel Number, Contact Person: Plausibility check failed” (CVI_API007).

    The SAP Note 1481777 refers to issues with the internal range number. Did anyone come accross the same? There is not much information at the logs but debugging there seems to be an error with the KUNN2 field.

    Thanks and regards,

    Andreu

    (0) 
    1. Mahesh Sardesai Post author

      Hi Andreu,

      Information provided is not sufficient. Please debug this yourself, no issues have not been reported with files 17 and 19 upload.

      Also the note number mentioned is 14877 – MF50: Graphic –> Explanation of graphics profile.

      – Mahesh

      (0) 
      1. Andreu Mendoza

        Hi Mahesh,

        we we eventually found out what were we missing debugging, alright.

        The Partner field at the file 19 had to be set to ‘##’.

        Once we set that, it worked a treat.

        Thanks,

        Andreu

        (0) 
        1. Filipe Magalhães

          Hi Andreu,

          Thanks a lot for your great tip! With this we were able to upload one business partner with both customer roles: Financial and Logistic.

          Regards,

          Filipe

          (0) 
      1. Vipin Nagpal

        Hi, documentation of FM says, “Only the operation insert is allowed, update and deletion is not supported

        Now sure how this will be supported?

        (0) 
        1. Malarvizhi Subbaiah

          Hello Vipin,

          yes you are correct. This FM is used for initial load .that means insertion is possible via this FM. if you wanna update use the “CVI_EI_INBOUND_MAIN”.

          Thanks.

          (0) 
  10. Durga Prasad R

    Hello Mahesh/Michael,

    We are not able to create sales area data for customer master while uploading through LSMW. We are uploading the following files 1,2,6,8,15,17 and 19. Program is creating the customer with only general data. We are using the role FLCU01 to upload. We having been trying different combinations to upload data but so far we are not able to upload sales area data for customer.

    Could you please let us know if there is something which we are missing out?

    Thanks n Regards,

    Durga Prasad

    (0) 
  11. Thorsten Hellmund

    Hello Mahesh,

    we are also not able to create sales area data and company code data. The program creates the general data for FLCU01 and FLCU00. It doesn´t create the salesorg, distribution and branch data. For the FLCU00 it doesn´t create the company code. We have also tried different combinations. Do you have a test example for each file, which is running?

    Thanks

    Thorsten

    (0) 
    1. Malarvizhi Subbaiah

      Hello Thorsten Hellmund,

      if the sales details are not getting created , check mds_ppo2 transaction. here you can see the errors why the company code and sales area data is not  getting created. solve those errors and finally it will be created.

      (0) 
  12. Ross Goodman

    All has been going well until I now try to load fax, phone number and email entries. I am not getting any error but the data is simply not saving. Anyone come across this?

    Thorsten’s idea of a sample of each file type known to work is a great one.

    Cheers,

    Ross Goodman

    (0) 
    1. Ross Goodman

      Success, and due mainly to the advice on using transaction mds_ppo2 to see the errors from load attempts. In my case the language iso field was not filled (even though language was) and this was causing a failure to commit the data. Funnily enough this field isn’t actually used as my partner was an organization and not a person. So basically the mandatory field content check was holding things up. Very intuitive….. NOT!

      (0) 
  13. Chirag Yadav

    I am able to upload Business partner where we can add business partner explicitly.

    can anyone please tell me how we can create business partner for  that groups where BP number generates internally like BP02 etc. ( For multiple records how will be differentiate the multiple BP data )

    (0) 
    1. Malarvizhi Subbaiah

      Hello Chirag yadav,

      The parameter “RUN_ID” is used to distinguish the multiple instance.based upon the run_id it will take the value and process accordingly.

      (0) 
  14. Vipin Nagpal

    Hello, I am using internal number range for BP.

    Now, I am searching which BP number was created from FM: RFC_CVI_EI_INBOUND_MAIN. I did not find created BP number in CT_RETURN table.

    I want to know which run_id is link with which newly created BP number.

    thanks

    (0) 
      1. Vipin Nagpal

        Hello, Earlier i was use to pass partner_guid myself. Now after implementing OSS note # 2331298

        system is creating partner_guid internally. Even i checked CT_return table no partner_guid is appearing. 🙁

        (0) 
  15. Ross Goodman

    It is official I am giving up! I cannot get anything other than the general BP created. It is so complex and incredibly time consuming to get this LSMW working that it is simply not worth the effort. Whilst I applaud the effort of the developers in attempting to provide a concise solution, this simply is not it.

    Perhaps a model data set showing the mandatory (for successful creation of the general plus sold to partner and vendor) that was used for testing before publication may have helped in light of the type of issues people are having. And perhaps an explanation of the grouping of inputs that were involved in each stage. eg files 1, 2, 5 7 for step 1 then update using files 1, 10, 11, 16 etc (not real numbers there obviously).

    Hope you get your BP’s created folks.

    (0) 
  16. ERDI Xherri

    Hi Guys.

    I am trying to create a customer linked to a business partner and i am using file 1 2 3 4 6 8 10 11 12 13 14 15 17 19.  The lsmw is creating me the business partner with role FLCU01 but is not creating (Updating) the tab of SALES AND DISTRIBUTION(17)/ PARTNER FUNCTION(19) of this customer. The function module is not returning errors. Also i checked tcode  mds_ppo2 but no errors were found. Perhaps i am doing something wrong with the mapping. I enter in run_id a unique number and also in object_task the value ‘I’.

    This are the fileds that i am trying to enter in sales and distribution tab :

    VKORG KZAZU VWERK VTWEG SPART BZIRK VKBUR WAERS KALKS  KZAZU VSBED MRNKZ BOKRE PRFRE INCO1 INCO2 ZTERM KKBER KTGRD KVGR1

    As you can see i have  entered all the necessary  obligatory fields that are needed to create the view of the customer.

    Thanks in advance  guys.

    Erdi.

    (0) 
    1. Durga Prasad R

      Hi Erdi,

      I am not sure whether you are providing the value for field KTOKD in file 15 or not.

      Could you please check by filling field KTOKD in File 15 with value ‘CUST’?

      Thanks n Regards,

      Durga Prasad

      (0) 
      1. ERDI Xherri

        Hi Durga.

        In file 15 i am adding :  Run_id(unique number), object_task = ‘I’, vbund, ktokd = ‘UEBP’ (European Union Customer Group)… i don’t know if a am missing something. Also i am trying for the moment the file 15 and 17  without 19….  i don’t know if this is a problem. The weird think is that FM is not returning any error type ‘E’ and the lsmw is still creating me, only general data tab without sales data.

        Is any problem with the mapping ? or perhaps i am missing something…

        Can you please send me a mapping example …

        Thank you,

        Erdi.

        (0) 
        1. Durga Prasad R

          Hi Erdi,


          We were able to create the customer by providing the below details.


          FILE 1

          RUN_ID – A1000080; BPARTNER – A1000080;OBJECT_TASK – I; CATEGORY – 2;

          GROUPING – BPAB ; NAME1- LSMW Test 1


          FILE 2

          Row 1

          RUN_ID – A1000080; DATA_KEY – FLCU00; ROLECATEGORY – 2

          Row 2 (Only provide values)

          RUN_ID – A1000080; DATA_KEY – FLCU01; ROLECATEGORY – 2


          FILE 8

          RUN_ID – A1000080; STANDARDADDRESS – X; CITY – Test01; POSTL_COD1 – 12301; STR_SUPPL1 – Street 01; STR_SUPPL2 – Street 2_01; STR_SUPPL3 – Street 4_01; LOCATION – Street 5_01; COUNTRY – US; REGION – PA; TAXJURCODE – PA000000000; LANGU – EN; LANGUISO – E


          FILE 9

          RUN_ID – A1000080; ADDRESSTYPE – XXDEFAULT; STANDARD – X


          FILE 12

          RUN_ID – A1000080; E_MAIL- test1@email.com


          FILE 15

          RUN_ID – A1000080; KUNNR – A1000080; OBJECT_TASK – I; KTOKD – CUST


          FILE 16

          RUN_ID – A1000080; BUKRS – XX01; AKONT – 100000


          FILE 17

          RUN_ID – A1000080; VKORG – XX01; VTWEG – 00; SPART- 10; KALKS- 01; KONDA – C1; INCO1 – EXW; INCO2- Ex-Works; VSBED- 01; WAERS – USD; ZTERM – 0001; VWERK- XX01


          FILE 19

          Row 1

          RUN_ID – A1000080; VKORG- XX01; VTWEG- 00; SPART- 10; PARVW- AG PARTNER – ##

          Row 2 (Only provide values)

          RUN_ID – A1000080; VKORG- XX01; VTWEG- 00; SPART- 10; PARVW- WE; PARTNER – ##

          Row 3 (Only provide values)

          RUN_ID- A1000080; VKORG- XX01; VTWEG- 00; SPART- 10; PARVW- RG; PARTNER – ##

          Row 4 (Only provide values)

          RUN_ID – A1000080; VKORG – XX01; VTWEG- 00; SPART- 10; PARVW- RE; PARTNER –  ##


          FILE 20

          RUN_ID- A1000080; ALAND- US; TATYP- UTXJ; TAXKD- 0


          BLANK FILES

          FILE 3 to 7,10,11,13,14,18,21 – Only Technical Names


          Thanks n Regards,

          Durga Prasad

          (0) 
          1. ERDI Xherri

            Thank you Durga. It Works perfect… Apparently  every  customer need the 4 partner function written above obligatory or it will not create a Customer.

            Thanks, Good Day!

            (0) 
          2. Michal Huber

            Hi I tried to fill template according to your example, but but when I fill kunnr in file 15_CVIS_CUSTOMER_GENERAL I’m getting error:

            When I let it empty, everything seems to be OK, but customer is not created.
            Did anyone have this issue?

            (0) 
  17. Sankalp Talware

    Hello Mahesh,

    I want to update vendor partner function,can we update via FM RFC_CVI_EI_INBOUND_MAIN?

    If yes can you tell me procedure how to update the same.

    Thank you in advance

    Regards,

    Sankalp

    (0) 
    1. Vipin Nagpal

      Hello Sankalp,

      You can not use FM RFC_CVI_EI_INBOUND_MAIN to update BP. To update BP, you must use Use class method cl_md_bp_maintain=>maintain.

      I have already asked same question to Author of this blog.

      Thanks

      (0) 
    2. ERDI Xherri

      Hi Sankalp.

      If you want to update BP, vendor or Customer  you can use Idoc :

      CVI_EI_INBOUND_MAIN_M.. Just fill :

      E101BUS_EI_HEADER-OBJECT_TASK = M,

      Partner_guid and fill all the required data of tree :  E101VMDS_EI_EXTERN (for vendors) with object_task =  ‘U’ and it should do the update for vendors and for partner function of vendors…

      Cheers!

      Erdi

      (0) 
      1. Franz Schmaußer

        Hello Erdi,

        could you tell me what process code (and assigned function modul) in partner profile for IDoc CVI_EI_INBOUND_MAIN_M.. you are using?
        In my S4HANA 1511 SP02 environment I can not find a suitable process code and inbound processing function module.
        Kind regards
        Franz
         

        (0) 
  18. Rohit Madnawat

    Hi,

    While Creating Vendor, it is giving error

    “Sales tax numbers for other countries are provided from the BP”

    if I by-pass this error in debugging, it is giving error in MDS_PPO2

    “Mandatory partner role OA is missing for purchasing org.”

    due to which I am not able to create Vendor.

    Please help.

    -Regards

    Rohit

    (0) 
    1. ERDI Xherri

      Hi Rohit.

      Uselly when you create vendor, in purchase- partner function tab automaticlly are filled some roles( in mine case are 3 ). So even if you dont upload un partner function file in your lsmw you should insert in your lsmw those obligatory partner function for every purchase row. And dont forget to do the conversion routine for this partner function.

      Hope it helps.

      By Erdi.

      (0) 
  19. Vinay Ponnekanti

    Hi,

    I am having an issue while trying to create customer. Customer Sales data is not getting populated and after looking at the comments in this blob, I did enter obligatory Partner functions which is 4 in my case. Despite having this set up, I am still getting below error. Did anyone had this same error??
    Customer ## / XXXX / XX / XX: Data is incomplete; check data.
    Customer, Vendor, Personnel Number, Contact Person: Plausibility check failed.

    (0) 
  20. Vinay Ponnekanti

    I was able to load once I set PARTNER to ‘##’.  Although I am still  trying to figure out how Vendor Partner Functions  (Obligatory)can be loaded. I don’t see anything similar to Customer_Sales_Func for Vendor creation at purchase org. Was any one successful in creating Vendor at purchase org.

    (0) 
  21. Salvatore Quidacciolu

    Hi,

    When trying to add one new company or one new sales organization for an existing Customer, I have an error. It seems that it’s not possible to use the mode update to do this kind of operation.

    It seems that it’s not possible to create one BP category 1.

    Did someone this test ?

    Thanks in advance.

    KR.

    (0) 
    1. Torsten Manhardt

      Hello,

      i have the same issue as Mr.Quidacciolu . I try to add second Company code to an existing Debtor by setting:

      CVIS_BP_GENERAL: RUN_ID + BPARTNERGUID + BPARTNER + OBJECT_TASK (= ‘U’)
      CVIS_CUSTOMER_COMPANY: RUN_ID + BUKRS + AKONT +…
      error message is: “Task Insert is not supported for the existing customer”.

      Obviously the System recognized correctly, that i want to add the Company code, but it does not support it,

      Has anybody already successfully added a second Company code to an existing debtor or creditor by LSMW? This is absolutely necessary for us to go live with S/4.

      Regards
      Torsten Manhardt

      (0) 
      1. ERDI Xherri

        Hi Torsten.

        The SAP is correct.If you want to add a new company code for the customer you need to go in modify in  business partner, and update in IT_CUST_GENERAL (here you insert the customer ) and insert in IT_CUST_COMPANY.  I have already done it and it work perfect. The logic the same for company data used in vendor.

        Hope it helps.
        Bye.
        Erdi

        (0) 
        1. Torsten Manhardt

          Hi Erdi,
          it seems that SAP made a code modification, since it doesn’t work anymore. Now customers and suplliers are always treated as INSERT task, regardless what you say in IT_BP_GENERAL or IT_BP_CUST_GENERAL.Time to make a OSS call.

          Regards,
          Torsten

          (0) 
          1. Emrah Kilic

            Hi Thorsten,

            I have the same problem. You can solve this problem? I have successfully created customers, but I can not create customer company data for existing customers.

            Thanks for any advice.

            (0) 
  22. Pranay Suyash

    Hi All,

    I have successfully used the same for new customer creation. The problems arise when i try to extend sales area data using Object_type = U as suggested in step 10. When i enter the runid and GUID of the already created customer in the 1st file i.e., general data and maintain sales area data in the sales area file and run the same, i get the following error:

    I have checked both the files and none contain any Business partner 1. I also got it debugged by an ABAPer and he could not find the cause.

    Kindly suggest, as we have around 10k customers to be extended which isn’t possible to do manually for 5 divisions.

    Thanks

    (0) 
  23. Ryan Quejano

    Hi Mahesh,

    Please help we are currently testing your solution and we are having errors.

    Entry 0063100096 does not exist in KNA1 (check entry)
    KNA1-KUNN2: Invalid value (foreign key check failed)
    Customer: Plausibility check failed
    Customer 63100096 has not been created for sales area 6310 10 00
    Customer 63100096 has not been created for sales area 6310 10 00
    The tax number for tax number category PH1 is already maintained
    Bank details with ID 0001 already exists
    Bank details PH 630040001 42372314196 in the validity period are not unique
    Business partner 63300096 already exists
    BP role FLVN00 already exists for partner 63300096
    BP role FLVN01 already exists for partner 63300096

    Did we miss anything? Do we need to configure anything? Or did we mistakenly commit any error in one of your steps?

    Really appreciate your response.

    Thanks,
    EC

    (0) 
  24. CASTRO JOSE

    Hi

    I have the next error in step “Start Direct Input Program”:

    First record in sequential file ZLSMWCVI_BP_ZLSMWCVI_BP_ZLSMWCVI_BP.lsmw.conv not a session record (type 0)
    Message no. MG004

    Diagnosis
    The first record in the sequential file must always be a session record. Otherwise, no session can be created.

    Some Help?

    Regards

    (0) 
  25. Pawel Lukianiuk

    Hi,

    I have one problem with this LSMW. How to migrate BP’s with internal number range ?

    In this case I left field “Business Partner Number” empty. As a result I get error message:

    “Specify at least one number for the business partner”.

    And of course, when I put the number to the file I get another error:

    “Grouping DEBI has internal number assignment; do not enter a number”

    Is it possible to migrate BP’s with internal number range ? I do not have any problems with external number ranges.

    Please advice.

    Thanks in advance.

    Best regards,
    Pawel.

    (0) 
  26. Rajesh Kumar Dadwal

    Thanks for the useful information in this blog. We managed to create BP General Data and Purchasing record. And for the Purchasing (Vendor Partner Functions) part, you have to use the structure ZZCVIS_SUP_PURCH_FUNCTIONS (and corresponding file for the mapping). This file is not included in the BP.ZIP file.

    (0) 
    1. Jan Willem Molenaar

      Hi Rajesh,

      How did you manage to upload the Vendor partner functions? It seems that function module RFC_CVI_EI_INBOUND_MAIN has no structure for vendor partner functions.

      Thanx,

      Jan Willem

      (0) 
      1. Rajesh Kumar Dadwal

        Hi Jan,

        The FM RFC_CVI_EI_INBOUND_MAIN has IT_SUP_PURCH_FUNCTIONS (structure –  (CVIS_SUPPLIER_PURCH_FUNC) for Vendor Partner Functions.

        Also update table SXDA2 with ZZCVIS_SUP_PURCH_FUNCTIONS and then you can map this structure in the LSMW.

         

        Regards

        (0) 
        1. Jan Willem Molenaar

          Hi Rajesh (and others),

          I got the missing link… after applying the SAP Notes 2354420 and 2331298, the structure is available in our S/4HANA 1511.

          Kind regards,

          Jan Willem

          (0) 
    1. Mahesh Sardesai Post author

      Hi  Constantin,

      Note 2287723 has been revised to include Migration Cockpit as the preferred option.

      LSMW should be used as a last option and still works as mentioned by Rajesh Kumar Dadwal.

      • Mahesh
      (0) 
  27. Zheng Liang

     

    Hi Mahesh,

    I want to creat vendor information.
    I can both uplolad general information & company code information successfully.

    for file
    25_CVIS_SUPPLIER_PURCHASING ‘ content
    I can not upload the content.

    do you have any idea about that?
    Thanks,
    Ethan

    (0) 
  28. Wiktoria Klepczynska

    Hi Mahesh,

    Thanks for a useful instruction of uploading BP Data using LSMW. I know it is dedicated for 1511 release, but I tried to implement your solution to S/4HANA 1605. It didn’t work. There is one structure missing: CVIS_BP_RETURN. I am not able to create structures using your program in BP.ZIP. Can you help me with this problem?

    Do you know any other ways of migrating BP Data to S4HANA system? RDM tool requires too much time to implement. LSMW would be the best solution.

    Regards,

    Wiktoria

    (0) 
  29. Sathish Jeevanandam

    Hi Magesh,

    Thanks for sharing detailed document.

    I am facing issue in converting data where BP_GENERAL informations are not converted. Due to this I am getting an error ‘ZLSMWCVI_BP_ZLSMWCVI_BP_ZLSMWCVI_BP.lsmw.conv not a session record (type 0)’.

    I also don’t see Form convert_001 in the conversion program.

    Thanks,

    Sathish

     

    (1) 
      1. SHUN-YU CHEN

        Hi,

        I cleared the ‘Parent segment’ for ‘General’ entry in table SXDA2 and saved Mapping and Conversion Rules again to re-generate the conversion program. Then the problem has been solved.

         

        (0) 
  30. Thorsten Hellmund

    Hello Mahesh,

    we are just trieing to create suppliers. When we run LSMW the partner role LF is missing. We are looking for a structure like supplier_purchasing_func, but this structure doesn´t exist. Do you have  a new BP.ZIP file.

    Thanks

    Thorsten

    (0) 
  31. Mine Uysal

    Hi Mahesh,

    Thanks for sharing useful document.

    We are just trying to create vendor master data. The general data of the suppliers will be transferred with program. After then we want to transfer vendor purchasing view with this LSMW. The converting step didn’t have any transactions written.

    Do I just have to upload the vendor files or should I upload all the files?

    What should I enter into the set type field?

    I appreciate your help.

    Thanks,

    Gizem

    (0) 
  32. André Ribeiro

    Hi everyone,

    Did anyone uploaded successfully the supplier company and purchasing data? I can’t get this data saved even though it’s filled on the files.

    Can someone please help me?

    Best regards.

    (0) 
    1. Annie Martinez

      Hello Andre,

      you have to filled up the supplier general file (Object_task = I) and also you have to include file for structure CVIS_SUPPLIER_PURCH_FUNC for Partner Function data since this is mandatory for purchasing data. The FM RFC_CVI_EI_INBOUND_MAIN has the table structure IT_SUP_PURCH_FUNCTIONS to pass data for partner function, just modify the upload program in BP.zip file.

       

      (0) 
  33. Mehmet Ali Sen

    Hi everyone,

    In function “RFC_CVI_EI_INBOUND_MAIN”, parameter “IT_SUP_COMPANY_ALT_PAYEE” is not optional.

    If you are getting dump message “missing parameter IT_SUP_COMPANY_ALT_PAYEE”, in program “ZLSMWDSPRG_CVI”, you will add below coding in FORM  business_partner_maintain.

      DATA: lt_cvis_supplier_alt_payee TYPE TABLE OF cvis_supplier_alt_payee WITH HEADER LINE.

    and add below coding in CALL FUNCTION ‘RFC_CVI_EI_INBOUND_MAIN’ under TABLES.

            it_sup_company_alt_payee = lt_cvis_supplier_alt_payee

    You don’t have map any data to this parameter…

    Best Regards

    (1) 
  34. Annie Martinez

    Hello everyone,

    Do anyone here created a BP successfully and able to get the exact BP number created?

    May I know how to get the created BP number? Please help.

    @ Mahesh,

    Do you have idea on how to achieve this?

    Thank you!

    (0) 
  35. Amandeep Singh Alag

    Hi Mahesh,

     

    Thanks for the blog !! I too am able to create BP general data but unable to create its sales area. Can someone help us with a sample code for the FM RFC_CVI_EI_INBOUND_MAIN parameters here please ?

    (0) 
  36. Latish Adnani

    Hello Brain Trust, has anyone tried loading the credit master and collection management role for the business partners created above. The Idoc does not have the segments to support the functionality, so how has the team created the Credit and Collections role.  thx.

    (0) 
    1. Jayesh Narwaney

      Hello Latish,

      At the moment none of the tools available load all BP roles in their entirety. I have used External Data Transfer (EDT), transaction KCLJ to load the credit master. I haven’t tried Collection Management (UDM000) yet as it is not available in KCLJ, and SAP has no plans to enhance this tool. You may want to use program UDM_COLL_BUPA for the collections mgt role.

      Thanks,

      (0) 
  37. Muhamed Azeezullah

    Hello Mahesh,

    I tried  accessing https://mdocs.sap.com/mcm/public/v1/open?shr=PCg2kHMdUqCASh5fqdBKFudWm_7PVpP8Uoa90RAb4kY but encountered error message ‘Share is no longer available; contact the owner if you need access’

    May I have access to the share?

    Thank you

    (0) 
  38. Adriana Borges

    Hi Mahesh:

    Is there a new version of this blog?

    I analized the FM RFC_CVI_EI_INBOUND_MAIN and it has parameters like  IT_CUST_COMPANY_WTAX, that I need for customer data that the program ZLSMWDSPRG_CVI not mentions.

    Thanks in advance.

     

    (0) 
  39. Gang Chen

    Hi all,

    I create a vendor, BP_GENERAL data is OK ,but  PURCHASING and COMPANY views can not be created. why ? thanks ~  I use LSMW  and also I  update the  code in CALL FUNCTION ‘RFC_CVI_EI_INBOUND_MAIN’   for IT_SUP_COMPANY_ALT_PAYEE, it’s OK.

    (0) 
  40. Partha Vemuru

    Hi All,

     

    Excellent Blog everything working but my need is to update Business partner information.is there any Remote enabled function module/IDOC to update Business partner address,telephone,email information.

     

    Please suggest.

    Thank you

    (0) 

Leave a Reply