详细LSMW完全教程

Lsmw详细教程1.输入lsmw命令输入lsmw命令，进入legacysystemmigrationworkbenchLegacySystemMigrationWorkbenchMyObjectsAllProjectObjectsProjectDo匚umentation□回区］& 0LegacySystemMigrationWorkbenchMyObjectsAllProjectObjectsProjectDo匚umentation□回区］& 0E）|©@©目間閔丨超昭町罔I國唱LSMWorkbenchEditGotoExtrasSettings系统（工）帮助（旦）ProjectSelectionProjectCHINALIFEprojectSub口roje匚tWorkflowim口ortingdataObjectImportinguseremailadress®旦圄［AllObjects点击新建口,点击一I点击新建口,点击一I，2.点击新建□分别输入project,description（为project的描述内容）。填写subproject和description（为subproject的描述内容）。点击対,填写object和name（为object的描述内容）.LE7LSMWorkbenchEditGotoExtrasSettings垂统世）帮助（旦）& [ raB）I©@®IQtM閔丨超町QQIH]0I©fflLegacySystemMigrationWorkbench画IWlI再IOljjm匚£~||My。匕|再IPrujmiztObjm匚估]|PrujmiztDu匚uirentati□门|ProjectSelectionProjectFMODULE③财务管理SubprojectFA财务管理ObjectADMINISTRATOR各省财务管理员创建好项目之后，点击⑨■，进入下一界面。LE7LSMWorkbenchEditGotoExtras垂统（工）帮助（旦）&「 一自I<H） ®I些闔閔丨迺哲心SII（DBLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省财务管理员防]|UserMenuNumberingOffDoubleClick=Display2ObjectOverview ActionLogPrci匚那StepMaintainObjectAttributesMaintainSour匚eStructuresMaintainSourceFieldsMaintainStructureRelationsMaintainFieldMappingand匚□nversionRulesMaintainFixedValueSjTranslationSjUser-DefinedRoutinesSpecifyFilesAssignFilesReadDataDisplayReadData匚onvertDataDisplay匚cirwertmclDataCreateBatchInputSessionRunEistchInputSession

3．选择MaintainObjectAttributes,双击进入，点“更改按钮”園。園。选择Batchinputrecording项，点击LE7ObjectAttributesEditGoto系统(工)帮助(旦)&] 哥o旦©©©Ts-ffilKI II®BLSMWorkbench:ChangeObjectAttributes|警Di£|zi4yw-a匚hanqm[厨Duizunrentsti□门112DiEinlsyIntmrfs匚笳|AttributesObjectADMINISTRATOR各省财务管理员OwnerCHENGYMCHENGYMDataTransfer®Once-OnlyOPeriod匚FileNames□System-DependentOStandardBatch/DirectInputObjectMethodProgramNameProgramType®BatchInputRmoordingRm匚匚irdingOBusinessObjectMethod(BAPI)BusinessObje匚tMethodMessageTypeBasi匚TypeOlDo匚(IntermediateD匚cument)MessageTypeBasi匸TypeEnhancmmmrit□AllowStructureAssignmentforEDIDC40进入下一界面，点击新建口,输入recording，建议采用事务代码，在此例中t-code为“suOl”

通过recording，将记录在su01的操作，进入该事务代码的实际操作界面，做一组真实数据录制之后如下图记录的具体的操作步骤如下：

双击 ，进行添加变量根据实际情况双击，添加需要的变量的名称name和描述name,双击 ，进行添加变量根据实际情况双击，添加需要的变量的名称name和描述name,添加结果如上上图所示。（简单方法也可以点DefaultallCreateRecordingDefaultDefaultAllReset@：ScreenField5曰SAFLSUID_MAINTENANCE1050EDC_CURSOR让系统自动匹配，对匹配不对的地EDC_CURSOR让系统自动匹配，对匹配不对的地方进行手工修改），保存，点击©，后退至如下图:LizfObjectAttributesEditGoto系瓠工）帮助（旦）<1H©@©Qtats1 ®BLSMWorkbench:ChangeObjectAttributes|讐DiEplayc-a匚hanqe11廚Dcjojmentatiizin112DiEplayInterfaizgeAttributesObjectADMINISTRATOR各省财务管理员OwnerCHENGYM匚HENGYMDataTransfer®Once-OnlyOPeriodi匚FileNames厂System-DependentObjectTypeandImportMethodOStandardBatch/DirectInput点击，选择本项目的object名称，点击进行保存，点击◎，后退。4．选择maintainsourcestructures,双击LSMWorkbenchEditGotoExtras^Jc(Y)帮助(出& ”<ihBe©©Bq(Mta ®n@sLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省财务管理员|UserMenuNumberingOffDoubleClick=Display11 ObjectOverview|⑥ActionLogPrci匚觀StepOMaintainObject.AtVfibutesj@MaintainSciur匚mStructuresOMaintainSourceFieldsOMaintainStructureRelationsOMaintainFieldMappingand匚cinumr引□门RulesOMaintainFixedValueSjTranslationSjUser-DefinedRoutinesOSpecifyFilesOAssignFilesOReadDataODisplayReadDataO匚onvertDataODisplay匚ciriumrtEdDataO匚reateEistchInputSessionORunBatchInputSession在下个界面先点“修改'，再点击新建口，创建sourcestructure.,表长度至少4个字符创建结果如下图：

点击kl进行保存，点击◎，后退。5．点击objectoverviewLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省财务管理员|⑨11UserMenuNumberingOffDouble匚lick=DisplayWQObjectOverview!}^ActionLog 二^二■-十Pro匚那StepOMaintainObjectAttributes@MaintainSciurceStructuresOMaintainSourceFieldsOMaintainStructureRelationsOMaintainFieldMappingand匚□□Ymrgi□门RulesOMaintainFixedValueSjTranslations,User-DefinedRoutinesOSpecifyFilesOAssignFilesOReadDataODisplayReadDataO匚onvertDataODisplay匚cnYmrtmdDataO匚reateBatchInputSessionORunBatchInputSession选择table，

出现以下界面后，复制红色框内文件到XLS表LSMWorkbench:ObjectOverview(Table)OverviewinListFormatDEMO-测试员工■测试员工StructureStructureDes匚riptiorTargetFieldNameFieldDescription TypeTargetLengthSourceFieldNameDEMOdemo|TABNAME表名CHAR000030|TCODE爭务代码CHAF：000020|BNAME账号CHAR000012|titlemedi称谓文本CHAF：000030|namelast姓CHAF：000040jNAMEFIRSTCHAR000040[USTYP用户类型CHAF!000001|PASSWORD新密码CHAF：00004U|PASSWORD2新密码CHAF：000040|DATFM日期格式CHAF!000001|TIMEFM时间格式（12-扭牛小时规格）CHAF!000001|tzone用户的时区CHAF：ooooot.实际复制时，会复制这几列的全部内容，需要在xls表中，删除tabname和tcode这2行的内容。保存之后，点击◎，退出选择maintainsourcefields,双击LSMWorkbenchEditGotoExtras^Jc(Y)帮助(出& ”oh[e©©BqK m®BLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省财务管理员|UserMenuNumberingOffDoubleClick=Display11 ObjectOverview|⑥ActionLogPrci匚购StepOMaintainObjectAttributesOMaintainSciur匚mStructures⑥MaintainSourceFieldsOMaintainStructureRelationsOMaintainFieldMappingandConversionRulesOMaintainFixedValueSjTranslationSjUser-DefinedRoutinesOSpecifyFilesOAssignFilesOReadDataODisplayReadDataO匚□rivmrtDataODisplay匚ciriumrtEdDataO匚reateEistchInputSessionORunEimt匚hInputSession先点修改按钮，选中下方spurcefields在点击吒，弹出如图所示对话框。&SourceFieldsEditGoto 帮助（巴枣 f石旦0©居越|□聞囲］豎1QA3罔［寓樹（©fflSourceFieldsforSourceStructureOBJECTFieldNameTypeLe...Fielddes匚ription□EEEEE▼BEBEEEEEEBEBEEEEEEBEBEEEEEE&&&打开刚才粘贴的.Xis文件。ABCDE1TABNAME表名CHAR302TCODE事务代码CHAR203BNAME账号CHAR124TITLEMEDI称谓文本CHAR305NAMELAST姓CHAR406NAMEFIRST名CHAR407USTYP用户类型CHAR18PASSWORD新密码CHAR409PASSWORD2新密码CHAR4010DATFM日期彳懵式CHAR111TIMEFM时间彳懵式（12-/24-小时规格）CHAR112TZONB用户的时区CHAR613调整.xls文件的内容和格式，删除tabname和tcode行以上的部分将CHAR替换为C（C为字符串类型）ABT"DIBNAME账号CHAR12TITLEMEDI称谓文本CHAR30NAMELAST姓CHAR40NAMEFIRST名CHAR40USTYP用户类型CHAR1PASSWORD新密码CHAR40PASSWORDS新密码CHAR40DATFM日期彳陪式CHAR1TIMEFM时间彳帘式〔12-/24-小时规格）CHAR1TZONE用户的时区CHAR6L将第二列调整至最后一列下图调整后样式）ABNAMETITLEMEDINAMELASTNAMEFIRSTUSTYPPASSWORDPASSWORD2DATFMTIMEFMTZONEC1230404040账号称谓文本姓名用户类型新密码新密码日期格式时间格式〔12-/24-小时规格）用户的时区调整完以上内容之后，将如上数据粘贴至maintainsourcefields打开的对话框中，如下图所示。&gpurizeFields旦批Goto系统（工）帮助（ e *石旦◎越U目聞囲H豎眄町罔R園凰U②国SourceFieldsforSourceStructureOBJECTFieldNameTypeLe..Fieldde吕匚riptionUsername二12各省管理员用户名last40名字FIRST二40姓RIGHT330权限GROUPC12组别PASSWORD340密码PSSC40确认BBEEEBE点击进行保存，点击◎后退；再点击I』进行保存，点击◎后退，进入如下界面选择maintainstructurerelations,双击Le7LSMWorkbenchEditGotoExtras系统（工）帮助（旦）@—一~<iHJLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省財务管理员画|UserMenuNumberingOffDoubleClick=Display11 ObjectOverview壓ActionLogProcessStepOMaintainObjectAttributesOMaintainEciurcmStructuresOMaintainSourceFieldsMaintainStructureRelationsMaintainFieldMappingand匚cin"mr£icinRulesOMaintainFixedValueSjTranslationSjUser-DefinedRoutinesOSpecifyFilesOAssignFilesOFleadDataODisplayReadDataO匚□nvmrtDataODisplay匚cinrErtEdDataO匚reateBatchInputSessionOFlunBatchInputSession

点击kl进行保存，点击◎后退。选择maintainfieldmappingandconversionrules,双击LSMWorkbenchEditGotoExtras丢统（工）帮助（旦）& ”<lH||e@© S4D^3Us®||®BLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省財务管理员馬11UserMenuNumberingOffDoubleClick=Display ObjectOverview園此匚tionLogProem砧StepMaintainObjectAttributesMaintainSour匚eStructuresMaintainSour匚已FieldsMaintainStructurmRelationsMaintainFieldMappingand匚ciri"mr£icnRulesMaintainFixedValueSjTranslationSjUser-DefinedRoutinesSpecifyFilesAssignFilesReadDataDisplayReadData匚onvertDataDisplay匚cirirErtmdData匚reateBatchInputSessionRunBatchInputSession中LSMWorkbench:ChangeFieldMappingandConversionRules9SourceField舉Rule|^| |口Scjur匚己Fidul『MODULE-FA-ADMINISTRATOR國 圍固［3话各省财务管理贯FieldMappingandRule中LSMWorkbench:ChangeFieldMappingandConversionRules9SourceField舉Rule|^| |口Scjur匚己Fidul『MODULE-FA-ADMINISTRATOR國 圍固［3话各省财务管理贯FieldMappingandRule一ADMINISTRATOR一耳FieldsUSERNAMELASTFIRSTRIGHTGROUPPASSWORDPSS各省管理员用户名名字权限组别密码确认先点“修改按钮”选中fields的一个字段，点击sourcefield,在弹出的对话框内选择与被选字段一致的内容（找到和字段名相同的字段双击。将每个字段分别和系统字段连接上。）最简单方法：将光标置于一个目标字段，选择Extras—Auto-Fieldmapping（字段自动映射）功能（图3-69）,系统会给出字段匹配建议。选择后一直回车，直到系统匹配完。）图3-69操作之后的结果如下图所示点击kl进行保存，点击◎后退。9．选择maintainfixedvalues,translations,user-definedroutines,双击LE7LSMWorkbenchEditGotoExtras系统（工：i帮助i：H）& ”<j~Hn©©©Da£]^||LSMWorkbench:FMODULE,FAfADMINISTRATOR:各省财务管理员I®5!|UserMenuNumberingOffDoubleClick=Display ObjectOverview⑥此匚tionLogPrcic时StepMaintainObjectAttributesMaintainSour匚eStructuresMaintainSourceFieldsMaintainEtru匚tureRelationsMaintainFieldMappingand匚□nversionRulesMaintainFixedValueSjTranslationSjUser-DefinedRoutinesSpecifyFilesAssignFilesReadDataDisplayReadData匚oriUErtDataDisplay匚cinrmrteclData匚reateBatchInputSessionRunEimtchInputSessionAdministrationEditGotoUtilities（M）丢统（工）帮助〔旦）LSMWorkbench:FixedValue$yTranslationS/UserDefinedRoutinesEKZi®®siffia辺]画mtnSubtree]HPositionReusableRules一QFMODULE 财务管理FixedValuesTranslationsUser-DefinedRoutines点击◎后退。10•选择specifyfiles,双击旨LSMWorkbenchEditGotoExtras丟统（工）帮助（旦）LSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省財务管理员馬11UserMenuNumberingOffDoubleClick=Display112ObjectOverview⑥ActionLogPm匚己立StepMaintainObjectAttributesMaintainSourceStructuresMaintainSciurcmFieldsMaintainStructureRelationsMaintainFieldMappingand匚□ri”mr£i□门RulesMaintainFixedValueSjTranslationSjUser-DefinedRoutinesSpecityFilesAssignFilesReadDataDisplayReadData匚□门vmrtDataDisplay匚ciriHmrtmdData匚reateEiat匚hInputSessionRunBatchInputSession先点修改，再双击onthepc选择导入数据的路径，在选择之前要根据导出的模板做好数据，只能是TXT格式，日期格式为20160101格式，不能为其他格式

r~~ \如果TXT文件有表头，则第一项选择，无丄表头就不选丿点击进行保存，点击◎后退。11．选择assignfiles,双击LSMWorkbenchEditGotoExtras系统（工）帮助（旦）&+不o[©© 袖閔n齬诂町黏Ha囲LSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省财务管理员⑨11UserMenuNumberingOffDoubleClick=Display ObjectOverview⑥ActionLogProc时StepMaintainObjectAttributesMaintainEciurcmStructuresMaintainSourceFieldsMaintainStructurmRelationsMaintainFieldMappingand匚匚inversionRulesMaintainFixedValueSjTranslationSjUser-DefinedRoutinesSpeciRFilesAssignFilesReadDataDisplayReadData匚cin”mrtDataDisplay匚ciriYErtEdData匚reateBatchInputSessionRunBmtizhInputSession确认导入数据的路径无误后，点击◎后退。12.选择readdata,双击LSMWorkbenchEditGotoExtras^Jc(Y)帮助(出& ”oh[e©©Bq(MK m®BLSMWorkbench:FMODULE,FA,ADMINISTRATOR:各省财务管理员|UserMenuNumberingOffDoubleClick=Display11 ObjectOverview|⑥ActionLogPrci匚购StepMaintainObjectAttributesMaintainSciur匚mStructuresMaintainSourceFieldsMaintainStructureRelationsMaintainFieldMappingand匚口门丫曰引□门RulesMaintainFixedValueSjTranslationSjUser-DefinedRoutinesSpecifyFilesAssignFilesReadDataDisplayReadData匚□rivmrtDataDisplay匚ciriumrtEdData匚reateEistchInputSessionRunEimt匚hInputSession在读取数据之前，准备好批量创建的数据先在.xls文件中，将添加的变量转置为如下:USERNAMELASTFIRSTRIGHTGROUPPASSWORDPSS各省管理员名字姓权限组别密码确认在.txt文件中按着上图的字段的排列顺序准备数据Finance,tzt—记事本文件(F)漏辑迢)格式(j0)查看(V)SUPER123456123456SUPER123456123456SUPER123456123456SUPER123456123456SUPER123456123456SUPER123456123456SUPER123456123456SUPER123456123456SUPER123456123456111000931130036113200226135147811370031014400285145000651510017216100151zFico_111OadmusrzFico_113OadmusrzFico_132OadmusrzFico_135OadmusrzFico_137OadmusrzFico_1UUOadmusrzFico_145OadmusrzFico_151OadmusrzFico_161Oadmusr111000931130036113200226135147811370031014400285145000651510017216100151准备好数据之后，点击⑨，执行

执行完毕之后，结果如下，提示读出9行数据List編辑⑥转到迫）系统⑴帮助凹LSMWorkbench:ImportDataForFINANCEMODULE,FAZADMINISTRATORLSMWorkbench:ImportDataForFINANCEMODULE,FA,ADMINISTRATOR2000.11.05-14:37:30File(s)Read: E:\sapsupport\data\Finance\Finance.txtFile壮itten: FINANCE_MODULE_FA_ADMINISTRATOR.lsmw.readSourceStructure Read Written NotWrittenOBJECT 99 0TransactionsRead:9RecordsRead:9TransactionsWritten:9RecordsWritten:9点击◎后退，再点击◎后退。•选择displayreaddata,双击&LSMWorkbenchEditGotoExtras罢统（工）帮助（旦）©—一<]HJ©@®IQ間囲丨②町站亦7区]0I©BLSMWorkbench:FINANCEMODULE,FA,ADMINISTRATOR:各省財务管理」画|UserMenuNumberingOffDouble匚lick=（Zhange思ObjectOverview蚩凸匚tionLogProcessStepOMaintainEciurcmStructuresOMaintainSourceFieldsOMaintainStructureRelationsOMaintainFieldMappingand匚□nversionRulesOMaintainFixedValueSjTranslationSjUser-DefinedRoutinesOSpecifyFilesOAssignFilesOReadData©DisplayReadDataO匚□□YErtDataODisplay匚onvertedDataO匚reateBatchInputSessionORunBatchInputSession在fromline填入1（也可以不填）（这里FromLine输入1,因为此处是实际执行的数目）点击&Toline这里默认是10000，即1万行数据，数据太多了要改大面是读出的信息ImportedDataEditGoto.系统（丫）帮助（旦）Je@©||qtats <0©||國畠©aLSMWorkbench:ImportedData|昼Fi^ldQj门tents||陞Cha门qeDisplay||園Displmy匚ulciLir1_曰？已门日|FINANCEMODULEFAADMINISTRATOR,lsmw.readStructurConts・LSMWFINANCEMODULEFAADMINISTRATORED3738WANGLANQINGOBJECT|OBJECTOBJECTFINANCEMODULEFAADMINISTRATOR,lsmw.readStructurConts・LSMWFINANCEMODULEFAADMINISTRATORED3738WANGLANQINGOBJECT|OBJECTOBJECTOBJECTOBJECTOBJECTOBJECTOBJECTOBJECT111000931130036113200226135147811370031014400285145000651510017216100151金吴高黄周姚侯汤秦莹军炎华爽皓翔明广棣毅静幼选中其中的任意一条信息，查看详细信息。确认没有问题，点击◎后退，再点击◎后退，进入下一步骤。•选择convertdata,双击LSMWorkbenchEditGotoExtras系统i：工）帮助（H）0+a昌 些間閔i话诂町罔圍闔窗国LSMWorkbench:FINANCEMODULE,F凡ADMINISTRATOR:各省财务管理」防|UserMenuNumberingOffDoijtileCli匚|<=匚hdnqe盘Obje匚tOverview⑥A匚tionLogPro匚essStepOMaintain,Object.AttributesjOMaintainSour匚eStructuresOMaintainSour匚eFieldsOMaintdinStructureRelationsOMaintainFieldP・2口口门qandConversionRulesOMaintainFixedValues^TranslationSjUser-DefinedRoutinesOSpecifyFilesOAssignFilesOReadDataODisplayReadData@ConvertDataODisplayConvertedDataO匚reateE；mt匚hInputSessionORunE£t匚hInputSession点击⑨，执行点击◎后退，再点击◎后退，进入下一步骤。

旨LSMWorkbenchEditGotoExtras系统（工）帮助（旦）&— - <1H）©©®IQ（MOI II@BLSMWorkbench:FINANCEMODULE,FAyADMINISTRATOR:各省财务管理宦閒|UserMenuNumberingOffDoubleClick=匚hange ObjectOverview⑥ActionLogPrcicmHStepO匝五垣或诬回应屋OMaintainSourcmStructuresOMaintainSourceFieldsOMaintainStructureRelationsOMaintainFieldMappingand匚ciri