05-17-2011 4:52 AM
Hi,
In the excel file I have made the dropdown of all the House Bank from Master table. I am uploading the data in SAP through BDC.
BOBA - BOBUJJAIN , HDFCD - HDFCFORTEF, SBS - SBSKOSAMBA in this way . Now I want to upload BOBA,HDFCD,SBS in Vendor master TCODE xk01.Since HKONT field is 5 char long it is taking SBS - in the relevant case.How to get the alphabets only not special characters.
Regards,
Bharti Jain
05-17-2011 6:46 AM
Hi Bharti,
You could split the field on '-' (if that is the pattern for all your entries) in Fields F1 and F2 and then use F1 as field value in BDC.
In case of SBS - SBSKOSAMBA, F1 = SBS; F2 = SBSKOSAMBA.
Hope this helps!
Regards,
Shyam
05-17-2011 6:35 AM
hi ,
Remove that - "hyphen from
BOBA - BOBUJJAIN , HDFCD - HDFCFORTEF, SBS - SBSKOSAMBA in this way . Now I want to upload BOBA,HDFCD,SBS in
or before passing data to hkont
replace - with Space
regards
Deepak.
05-17-2011 6:46 AM
Hi Bharti,
You could split the field on '-' (if that is the pattern for all your entries) in Fields F1 and F2 and then use F1 as field value in BDC.
In case of SBS - SBSKOSAMBA, F1 = SBS; F2 = SBSKOSAMBA.
Hope this helps!
Regards,
Shyam