on 01-10-2015 4:39 PM
Hi,
I want to create customer in different sales area with one file using lsmw. I have created a lsmw to create
customer in one sales are.
Structure of my file
CC1 - SO1-GD
CC2 - SO2-GD
Is there a way to create these 2 lines for one customer ?
you did not really tell much: "I have created a lsmw" - this is as good as saying I build a house, it is not clear whether it is a block house, a bungalow or a skyscraper.
LSMW has 4 different import methods, and the most logical would be IDOC or batch input as these are flexible SAP given import methods. Which one did you use?
Further it is not clear whether the customer already exists and only needs to be extended, or if the customer has to be created with the first record and extended to another sales org with the second record.
It is as well not clear if one line in your source has all info or if GD is one line, CC another and SO again another line.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jürgen , thanks for your reply.
1- I have used batch input
2-the customer has to be created with the first line and extended with the other lines.
3- The structure of my file is :
1st line : company codedata 1 , Sales area data 1 , customerA 's old number , general dataA,
2nd line : company codedata2, Sales orga 2, customerA 's old number , general dataA
3rd line : company codedata3, Sales orga 3, customerA 's old number , general dataA
4th line : company codedata 1 , Sales area data 1 , customerB 's old number , general dataB,
5th line : company codedata2, Sales orga 2, customerB 's old number , general dataB
....
The customer old number can help for the extension ?
You need to get the general data fields to the left.
You either do this already in the source file and then define your fields in step 3 of LSMW in the new sequence of the source file.
Or, you keep the source as is, but define the fields in step 3 of LSMW in the sequence of GD - CC - SO . You make sure that the column header of the source file is identical to the field names in your step 3. In step 7 specify files you need to remove the flag for "Field order matches source file definition". SAP will then use the names to find the fields when you execute step 9 Read data.
this re-order of information will help you avoid too much ABAP.
Still you need a small ABAP command in step 5 field mapping.
You need to replace the default command "transfer_record" with "on_change_transfer_record".
This command takes care that the General data is only written when the GD in source changes, which means after the 3rd line.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.