濡備綍浣跨敤Winshuttle鏉ュ垱寤烘爣鍑嗛噰璐鍗
鏈浼氭弿杩板浣曚娇鐢╓inshuttle 鐨凾ransaction灏哅icrosoft Excel鍐呮暟鎹紝浣跨敤SAP浜嬬墿浠ｇ爜锛歁E21N锛屽湪SAP鍐呭垱寤烘爣鍑嗙殑閲囪喘璁㈠崟銆
姝ラ1锛氬綍鍒
1.棣栧厛鍙屽嚮妗岄潰涓婄殑Winshuttle Studio锛屾墦寮€Winshuttle銆
2.鐐瑰嚮鏂板缓銆
3.鐐瑰嚮 Transaction, 鐒跺悗鐐瑰嚮 Create from Recording.
4. 閫夋嫨浣犳墍闇€瑕佺櫥闄嗙殑SAP鏈嶅姟鍣紝濉叆鐩稿簲鐨勪俊鎭紝鐒跺悗鐐瑰嚮 Log On to SAP.
5. 鍦═ransaction code涓, 杈撳叆 ME21N.
6.灏嗘ā寮忓仠鐣欏湪Standard涓婏紝濡傛灉娌℃湁锛岀偣鍑籆hange锛岀劧鍚庨€夋嫨Batch Input妯″紡銆
鈥绘瘡涓ā寮忕殑鍖哄埆锛屼箣鍓嶇殑鏂囨。涓凡缁忚杞借繃銆
7.鐐瑰嚮Start Recording
8.杈撳叆Vendor鍜孌ocument Date锛岀劧鍚庣偣鍑诲洖杞︺€
9.杈撳叆Header鐨勪俊鎭暟鎹
鈥荤敱浜庢瘡瀹跺叕鍙哥殑SAP閰嶇疆绛夌殑涓嶅悓锛屼笅涓€姝ョ殑鎿嶄綔灞忓箷璺宠浆鍙兘浼氭湁鎵€涓嶅悓锛
鏈枃浠ョ幇鏈夌殑SAP鐜鏉ヤ妇渚嬨€
10.鐐瑰嚮鍥炶溅缁х画銆
11.鍦↙ine Item涓緭鍏ユ槑缁嗘暟鎹
12.鐐瑰嚮鍥炶溅鍚庯紝鐐瑰嚮宸ュ叿鏍忎笂鐨勮繃婊ゆ寜閽€
13.浠嶤olumn涓€夋嫨Item椤圭洰锛岀偣鍑诲乏绉绘寜閽紝灏咺tem绉昏嚦Filter criteria涓€
濡備笅鍥炬墍绀
14.閲囪喘璁㈠崟涓殑鏄庣粏琛屾槸涓嶅彲鑳借秴杩999琛岀殑锛堜粠鎶€鏈笂鏉ヨ涔熸槸涓嶅彲鑳界殑锛夛紝鎵€浠
鎴戜滑鍦ㄨ繖閲岃緭鍏99999鏉ョ‘淇濊Grid涓婄殑鏄┖鐨勶紝骞朵笖璁板綍浠庣涓€琛屽紑濮嬩緷娆″線
涓嬮€掑鏉ユ彃鍏ユ槑缁嗚鐨勬暟鎹殑銆傝繖鏄湰娆″綍鍒朵腑姣旇緝鍏抽敭鐨勪竴涓楠ゃ€
15.鐐瑰悗鐐瑰嚮缁胯壊鐨勫嬀鏉ョ户缁垜浠殑鎿嶄綔銆
鎴戜滑鍙互鐪嬪埌锛屾槑缁嗚鐨凣rid涓槸绌虹殑锛屾垜浠幇鍦ㄥ彲浠ユ妸鏄庣粏琛岀殑鏁版嵁缁欐坊鍔犺繘
鍘伙紝鐒跺悗鏀归〉闈笂鐨勬爮浣嶉兘浼氳璁板綍杩汿ransaction Mapper鐨勫睆骞曚腑銆
16.鐒跺悗鐐瑰嚮淇濆瓨锛岀劧鍚庡綍鍒剁幆鑺傚氨缁撴潫浜嗭紝鐒跺悗Winshuttle浼氳嚜鍔ㄨ繘鍏apping鐣岄潰銆
姝ラ2锛氭槧灏
缁撴潫褰曞埗鐜妭鍚庯紝鎴戜滑杩涘叆浜嗗仛鏄犲皠鐨勭幆鑺傘€傝繖閲屽氨鏄皢鏁版嵁涓嶴AP鐨勬爮浣嶅仛涓€涓繛鎺ャ€備负浜嗚揪鍒颁笌SAP鐨勫叧鑱旓紝Transaction鎻愪緵浜嗕竴涓狹apper骞冲彴銆
Auto Mapping浼氬皢褰曞埗鐨勬墍鏈夌殑鏍忎綅鍏ㄩ儴鏄犲皠鑷矱xcel鍐咃紝鐢变簬SAP鐨勫鏍锋€э紝鏈鐨勬搷浣滄垜浠細閫氳繃鎵嬪姩鐨勬柟寮忔潵杩涜銆
鍦∕apper涓垜浠彲浠ョ湅鍒帮細
Mapper row number: 杩欎釜鍙槸鐢ㄦ潵璁板綍琛屾暟鐨勫弬鑰冩暟瀛.
Enable flag: 鍙湁鎵撲笂鍕剧殑鎵嶄細琚玊ransaction鎵€鎵ц.
Field Description: 杩欐槸SAP鍐呰鏍忎綅鐨勫悕绉帮紝琛ㄥ唴瀵硅瀛楁鐨勬弿杩.
Field Name: SAP琛ㄥ唴鐨勫瓧娈靛悕.
Field Type & Length: 瀛楁绫诲瀷浠ュ強闀垮害.
Mapping direction: 鍥哄畾鍊硷紝鎴栬€呮槸灏咵xcel鍐呯殑鏁版嵁涓婁紶鑷砈AP锛岃繕鏄粠SAP灞忓箷涓婂皢鏁版嵁淇℃伅涓嬭浇鍒癊xcel鍐
Value: mapping鍓嶆槸SAP灞忓箷鍐呬綘鎵€杈撳叆鐨勫€硷紝mapping鍚庝細鍙樻垚Excel鍐呯殑鏍忎綅鍚嶏紙Column锛欰锛孊锛孋锛孌绛夛級
鍦―ata Set涓€鏍忎腑浣犲彲浠ョ湅鍒版湁Excel涓嶢ccess鐨勯€夐」锛岃〃鏄庢垜浠彲浠ュ皢鏁版嵁浠嶦xcel鎴栬€匒ccess涓笂浼犺嚦SAP銆傛暟鎹潵婧愬彲浠ユ槸澶氭牱鎬х殑銆
鏈鎴戜滑浣跨敤鐨勬槸Excel銆
1.鍋氭槧灏勭殑鏂瑰紡寰堢畝鍗曪紝灏辨槸涓€涓嫋鎷界殑鏂瑰紡銆傝涓婁紶鎴戜滑閫変腑Excel鐨勬爮浣嶄笉鏀撅紝鐒跺悗绉昏嚦涓婃柟鐨凪apper鐣岄潰涓嵆鍙€
2.鐒跺悗鐐瑰嚮Expert View
璇ョ晫闈㈣兘鐪嬪埌浣犳墍褰曞埗鏃跺€欎骇鐢熺殑OK-code绛変俊鎭€傞偅涔堢敱浜庢垜浠殑鏄庣粏琛屾暟鎹殑琛屾暟鏄笉纭畾鐨勶紝閭ｄ箞鎴戜滑灏遍渶瑕佸鍔犱竴涓惊鐜殑LOOP鍔熻兘鍒拌鑴氭湰涓紝璁╄剼鏈彉鐨勬洿鍏锋湁鐏垫椿鎬с€
澧炲姞寰幆鐨勬柟寮忎篃寰堢畝鍗曪紝鎵惧埌瀵瑰簲鐨勮鏁帮紝鍏ㄩ儴閫変腑锛屽涓嬪浘锛
3.鐒跺悗鐐瑰嚮Create Loop鎸夐挳銆
4.寮瑰嚭鐨凩oop鐣岄潰涓紝鎴戜滑涔熷彲浠ヤ慨鏀归渶瑕佸惊鐜殑琛屾暟锛屼互鍙婄粰浜堝叾寰幆鐨勬爣璇嗐€
濡傛灉鏁版嵁闆嗕腑鍦ㄥ悓涓€涓猻heet涓婄殑锛屾垜浠粯璁ょ殑閫夋嫨Single Sheet Loop鐨勭被鍨嬪嵆鍙紝濡傛灉鏁版嵁闆嗕腑鍦ㄥ涓猻heet涓殑锛岄偅涔堟垜浠渶瑕侀€夋嫨Multiple Sheet Loop鐨勭被鍨嬫潵杈惧埌鎴戜滑鐨勬晥鏋溿€
鍙﹀鍙互閫夋嫨灏嗘爣璇嗘斁鍦‥xcel鐨勫摢涓爮浣嶅唴锛屽涓嬪浘锛欻鏄惊鐜殑寮€濮嬶紝鏈€鍚庣殑涓€涓狣琛ㄧず鏄庣粏琛屽埌姝や负姝㈢殑璇ュ惊鐜粨鏉熴€傚鏋滄垜浠湁澶氬紶PO闇€瑕佸垱寤猴紝閭ｄ箞鎴戜滑灏遍渶瑕佸皢鏁版嵁鍋氭垚璇ュ舰寮忥細
5.鐐瑰嚮OK鍚庯紝浼氬湪Excel鍐呰嚜鍔ㄤ骇鐢烲OOP鐨勬爣璇嗭紝鐒跺悗姝ゆ椂鎴戜滑鍐嶅幓鍋氭槧灏勩€
娉ㄦ剰锛氭槧灏勫姩浣滈渶瑕佸湪LOOP鏉′欢澧炲姞瀹屼箣鍚庡啀杩涜銆
姝ラ3锛氬～鍏呮暟鎹互鍙婅繍琛岃剼鏈
1.鐐瑰嚮鑿滃崟鏍忎笂鐨凴un
2.鍙互閫氳繃鏇存敼Start Row End Row鏉ュ埗瀹氭墍闇€瑕佽繍琛岀殑鏁版嵁閲忋€
鍦ㄤ笅鏂圭殑Excel鍐呭皢鎵€闇€瑕佽繍琛岀殑鏁版嵁濉厖濂姐€傜劧鍚庢垜浠氨鍙互鐐瑰嚮Run鎸夐挳浜嗐€
鍦ㄦ涔嬪墠锛學inshuttle浼氳姹備綘淇濆瓨浣犲埗浣滅殑妯℃澘鏂囦欢锛屼互鍙奅xcel鐨凞ata File锛
閫夋嫨濂藉搴旂殑璺緞锛岀劧鍚庡鏋滄湁闇€瑕佸彲浠ユ洿鏀规ā鏉跨殑鍚嶇О锛屼綘鍙互鍗曚釜鍗曚釜鐨勬枃浠朵繚瀛橈紝鎴栬€呯洿鎺ョ偣鍑绘渶涓嬫柟鐨凷ave Both File鎸夐挳銆
濡備笅鍥炬墍绀
3.杩愯瀹屾瘯鍚庝綘鍙互鐪嬪埌杩愯鐨勬暟鎹潯鏁颁互鍙婃垚鍔熷け璐ョ殑娑堟伅锛屽涓嬪浘锛
4.鍙﹀鎴戜滑鐨勬暟鎹槸鍚﹀噯纭紝鎴戜滑鍙互寰楀埌SAP鍐呴儴鐨刲og锛屾瘮濡傛垚鍔熷悗鎴戜滑鍙互鍦‥xcel鍐呯湅鍒版垜浠墍鍒涘缓鐨凱O鍙凤紝鐒跺悗鍙互杩汼AP鍐呴獙璇佹垜浠垱寤虹殑PO淇℃伅鏄惁姝ｇ‘锛屼互涓婁究鏄娇鐢╓inshuttle鏉ュ埗浣滀竴涓爣鍑哖O鐨勫叏杩囩▼浜嗐€
棰勭煡鏇村绮惧僵鍐呭锛岃鎸佺画鍏虫敞Winshuttle瀹樻柟寰俊鎴栨悳绱腑鏂囩増瀹樻柟缃戠珯銆
浜哄伐鏅鸿兘鎶€鏈綉 鍊″灏婇噸涓庝繚鎶ょ煡璇嗕骇鏉冦€傚鍙戠幇鏈珯鏂囩珷瀛樺湪鐗堟潈绛夐棶棰橈紝鐑﹁30澶╁唴鎻愪緵鐗堟潈鐤戦棶銆佽韩浠借瘉鏄庛€佺増鏉冭瘉鏄庛€佽仈绯绘柟寮忕瓑鍙戦偖浠惰嚦1851688011@qq.com鎴戜滑灏嗗強鏃舵矡閫氫笌澶勭悊銆傦紒锛棣栭〉 > 鏂伴椈 » 濡備綍浣跨敤Winshuttle鏉ュ垱寤烘爣鍑嗛噰璐鍗