on 03-29-2013 4:59 AM
Hi,
I was doing LSMW to upload data using IW21 against Reference Notifications.
We have added fields under the User Status head in IW21 as per screen shot below:
the fields Equipment Hand Over and Equipment Take back Time fields above are custom fields i.e Z fields showing data values also.
During the step Field Mapping and Conversion Rules it shows all the fields and especially the above two fields as ZZEHT and ZZETBT but not showing their Field names below in front of the yellow pencil icon:
When i made the excel file it shows something like this
Again in above screen Field names of both fields are missing.
In display Conversion data it shows something like this
Once i have completed all steps and new Notification is generated without errors, the data from these two fields are not copied and shows blank.
This is my main concern, any ideas?
Thanks
Faisal
Hello Faisal,
please follow the below steps to get the field names in the display conversion/field mapping step.
Step 1: Go to the corresponding recording for the lsmw.
Step 2: find out the field, for which you would like to have field name.(Ex:"ZZEHT").
Step 3: once you find the field name, double click on it, there you will get below three text boxes.
(i ) Field name, (ii) Field Discription (iii) Field Value.
Step 4: Type the field name and field Description for the corresponding text boxes and remove the value from third column to avoid wrong data updation, when you try to pass blank for the field from the load file.
step 5: Now save the recoding and come to field mapping or conversion rules step and see now, you must get the field names.
Regards,
Mohanraj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Still awaiting for replies.
Thanks
Faisal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
check whether you have entered the field name in source fields for Z fields also kindly specify what the 2 fields reflects in the notification screen.
also in the excel there is no value specified for input, kindly check.
I think the LSMW is recorded one. kindly check the fields name once again in the object overview with tables
Regards
Thyagarajan
Hi,
Answer to your queries:
The first screen shot in my previous message shows the two fields with values 24 and 20 respectively with labels "Equipment Hand Over" (ZZEHT) and "Equipment Take Back Time" (ZZETBT).
The Excel file shows the two rows with Field Name and their Labels. The Labels for these two fields is missing by default. Even the help key (F1) on these fields do not work in IW21. Please see below the excel file showing all three rows i.e Fields Name,Label Name and Values being passed. As values for ZZEHT and ZZETBT needs to be copied thus I have put " / " for its values.
You asked regarding" check whether you have entered the field name in source fields for Z fields". Please elaborate.
Just in case please find below screen shot of Source structure showing the problematic two fields at the bottom of screen
Thanks
Faisal
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.