SAP系统LSMW Demo教材.docx
- 文档编号:30146484
- 上传时间:2023-08-05
- 格式:DOCX
- 页数:18
- 大小:799.27KB
SAP系统LSMW Demo教材.docx
《SAP系统LSMW Demo教材.docx》由会员分享,可在线阅读,更多相关《SAP系统LSMW Demo教材.docx(18页珍藏版)》请在冰豆网上搜索。
SAP系统LSMWDemo教材
Step-by-StepGuideforusingLSMWtoUpdateCustomerMasterRecords
byMitreshKundalia,SeniorFI/COConsultant
Note!
ThescreenprintsinthisarticlearefromIDESRelease4.6.Theymaydifferslightlyinotherversions.
DemoExample1
LSMWtoUpdateCustomerMasterRecordswithTransactionRecording
CallLegacySystemMigrationWorkbenchbyenteringtransactioncodeLSMW.EveryconversiontaskisgroupedtogetherasProject/Subproject/Objectstructure.CreateaProjectcalledLSMW_DEMOandaSubprojectasCUSTOMERSandObjectasCUST_RECasshowninFigure1.
Figure1ConversionTaskwithProject,SubprojectandObject
ThemainscreenofLSMWprovideswizard-likestep-by-steptasks,asshowninFigure2.Tocompleteyourdataconversion,youneedtoexecutethesestepsinsequence.Onceastepisexecuted,thecursorisautomaticallypositionedtothenextstep.
NotethatthesestepsmaylookdifferentdependinguponyourPersonalmenusettings.Youcouldmakestepnumbersvisibleby‘Numberson’iconorhiddenby‘Numbersoff’icon.Youcanexecuteastepbydouble-clickingontherow.Toggleicon‘Doubleclick=Display’or‘Doubleclick=Edit’,makesthestepin‘display’modeor‘change’mode.
Figure2LSMWWizard–initialscreen
Step1:
MaintainObjectattributes
Inthisexample,youwillbeupdatingthecustomermasterrecordswiththehelpofrecordingatransaction(XD02).ChooseradiobuttonBatchInputRecordingandclickontherecordingoverviewicontorecordtheR/3transaction.EntertheRecordingnameasXD02_REC,thedescriptionasCustomerMasterUpdatesRecording,andthetransactioncodeasXD02.
Figure3Objecttype‘TransactionRecording’
ThesystemcallsthetransactioncodeXD02andpromptsyoutocompletetheChange
Customertransaction,asshowninFigure4.Enterthekeycustomerinformation(Ienteredcustomernumber1000,salesorganization1000,distributionchannel01,anddivision00)andchoose‘Sales’viewwithin‘Salesareadata’.Makechangestothesethreefields(Ientered,salesoffice1010,salesgroup110,andcustomergroup01)andsavethetransaction.
Figure4TransactionrecordingforTransactionCode‘XD02’
Oncethetransactioniscompleted,R/3recordstheflowofscreensandfieldsandsavestheinformation,asshowninFigure5.
Figure5Transactionrecordingoverview
Notethatthefieldsarepopulatedwithdefaultvalues.Thevaluesyouenteredwhenyourecordedthetransactionaresetbydefault.
Notethatifyouhavemorefieldsintherecordingthanneeded,youcanremovethembyclicking‘RemoveScreenfield’icon.
Observethatthetransaction-recordingprocessstoresfieldnamesinatechnicalformat.BypressingtheF1keyonindividualscreenfieldsandthenpressingtheF9key,thesystemdisplaystechnicalnames.Youthencanreplacethetechnicalnameswithdescriptivenames.Double-clickonthefieldRF02D-KUNNRandenterthenameasKUNNRandthedescriptionasCustomerAccountNumberandremovethedefaultvalue.(SeeFigure6.)
Figure6Fieldattributes
Similarly,double-clickonallotherfieldswithdefaultvaluesandmakeappropriatechanges.Onceyouhavemadechanges,therecordingoverviewscreenlookslikewhatyouseeinFigure7.
Figure7TransactionRecordingOverview–withscreenfieldattributes
Saveyourchanges.Whenyougobacktotheinitialscreen,youwillseethattheinitialscreenstepshavechanged.SinceyouwanttoimportdataviatheBDCmethod,theDirectInputandIDoc-relatedstepsarehidden,astheyarenotrelevant.
Step2.MaintainSourceStructures
Giveanameandadescriptiontothesourcestructure(Figure8).
Figure8SourceStructure
Step3.MaintainSourceFields
Inthisstep,youneedtolistwhatfieldsarepresentinthesourcestructure.Theeasiestwayistoclickon‘TableMaintenance’icontoenterFieldname,TypeandLengthforeachfield
asshowninFigure9.
Figure9SourcefieldsofsourceStructure
Notethatyourinputfilewillhavefourfieldsaskeyfieldsandyouneedtoupdatethreefieldsinthesystem.
Step4:
MaintainStructureRelations
Executeastepto‘MaintainStructureRelations’.(SeeFigure10.)Since,thereisonlyoneSourceandTargetStructure,therelationshipisdefaultedautomatically.
Figure10StructureRelation
Step5:
Maintainfieldmappingandconversionrules
FieldRF02D-D0310representsthatyouchose‘Salesview’forthecustomerMasterscreenaccordinglyitsvalueshouldbesettoX.KeepyourcursoronfieldRF02D-D0310andclickonConstantruleicontochoosetheconstantvalueof‘X’.
Ifyoursourcefilealreadyhasthefieldvalue,youchooserule‘SourceField’.
Keepcursoronfield‘KUNNR’andclickon‘AssignSourcefield’icontochoosesourcefieldCUSTOMERfromstructureXD02SasshowninFigure11.
Figure11Assignsourcefields
Similarly,assign‘SourceField’rulestotheremainingfields.
Onceallthefieldsaremapped,youshouldhaveanoverviewscreenasshowninFigure12.
Figure12FieldmappingandConversionrulesoverview
Step6:
Maintainfixedvalues,translations,user-definedroutines
Youcanalsomaintainre-usabletranslationsanduser-definedroutines,whichcanbeusedacrossconversiontasks.Inthiscase,thatstepisnotrequired.
Step7:
Specifyfiles
Inthisstep,wedefinehowthelayoutoftheinputfileis.Theinputfileisa[Tab]delimitedwiththefirstrowasfieldnames.ItispresentonmyPC(localdrive)asC:
\XD02.txt.(SeeFigure13.)
Figure13Fileattributes
CreateanExcelfile(Figure14)withyourdataandsaveitasaTab-delimitedtextfileonyourlocaldrive(C:
\)andnameitXD02.txt.
Figure14SourcedatainExcelfile(savedasTabdelimitedfile)
Step8:
Assignfiles
Executestep‘AssignFiles’(Figure15)andthesystemautomaticallydefaultsthefilenametothesourcestructure.
Figure15AssignfiletoSourceStructure
Step9:
Readdata
Inthisstep,LSMWreadsthedata(Figure16)fromthesourcefile(fromyourPC’slocaldrive).YouhavetheoptiontoreadonlyselectedrowsandconvertdatavaluestoInternalformat.
Figure16ReadData
Step10:
Displayreaddata
Thisstep(Figure17)isoptional.Ifrequired,youcanreviewthefieldcontentsfortherowsofdataread.
Figure17DisplayReadData
Step11:
Convertdata
Thisisthestepthatactuallyconvertsthesourcedata(insourceformat)toatargetformat.Basedontheconversionrulesdefined,sourcefieldsaremappedtotargetfields.
Step12:
DisplayConverteddata
AgainthisisanoptionalsteptoviewhowthesourcedataisconvertedtointernalSAPformat(Figure18).
Figure18DisplayConvertedData
Step13:
Createbatchinputsession
Oncethesourcedataisconvertedinaninternalformat,youcancreateabatchsessiontoprocessupdates(Figure19).
Figure19CreateBatchInputSession
Step14:
RunBatchInputSession
YoucanexecutetheBDCsessionbyRunBatchinputsession.ExecutingabatchinputsessionisastandardSM35transactionformanagingBDCsessions.Onceyouhavesuccessfullyexecutedthebatchinputsession,thecustomermasterrecordsareupdatedinthesystem.Youcanconfirmthisbyviewingthecustomermasterrecords(XD03).
Note!
Browsingthruthese14steps,youmaygetafeelingthatthisisaverylengthyandtime-consumingactivity.However,forthepurposesofdemonstration,Ihavemadeitdetailed.Althoughitlookslengthy,actuallyittakeshardlyfewhoursfromstart-to-finish!
AfterplayingaroundwithfewsimpleLSMWscripts,youwillfinditsoeasytochangeandcreatemorecomplexones.
DemoExample2
LSMWtoUpdateCustomerMasterRecordswithStandardObject
Asanalternativetousing‘TransactionRecording’,youcouldalsouseastandardSAPobjecttoupdateCustomerMasterRecords.BusinessObject‘0050’isalreadypre-definedinthesystemwithstandardBatchInputInterfaceProgram‘RFBIDE00’.
CreateanObjectCUST_OBJwithinProjectasLSMW_DEMOandSubprojectasCUSTOMERSasshowninFigure20.
Figure20LSMWObjectwithStandardSAPObject
Note!
FortheDemoexample2,Iwilllistonlythosestepsthataredifferentfromthefirstdemoexample.
Step1:
MaintainObjectattributes
YouwillbeupdatingthecustomermasterrecordswiththehelpofStandardBatchInput;therefore,chooseradio-buttonStandardBatch/DirectInputasshowninFigure21.EnterObject‘0050’forCustomerMasterrecordsanddefaultmethod‘0000’andclickonSave.
Figure21StandardBatch/DirectInputObjectAttributes
Step4:
MaintainStructureRelations
SalesviewofCustomerMasterisstoredintableKNVV.Accordingly,youneedtoupdatestructureBKNVV.However,inaddition,theStandardObject‘0050’alsorequiresupdatestoBGR00,BKN00andBKNA1structures.(IfyoudonotmaintainStructurerelationsformandatoryentries,youmightgetamessagesuchas‘TargetstructureBKNA1needsarelationtoasourcestructure’.)
Eventhoughyoudon’twanttoupdateanyfieldsinthesestructures,youneedtocreatearelationshipwithsourcestructures.Inall,youneedtocreaterelationshipforfourtargetstructures.
CreaterelationshipbetweensourcestructuresXD02Swiththesetargetstructureswithicon‘CreateRelationship’
.
KeepCursoronthesefourtargetstructuresandclickonicon‘CreateRelation’andstructurerelationsaremaintainedasshowninFigure22.
Figure22StructureRelation
Step5:
Maintainfieldmappingandconversionrules
--Keepyourcursoron‘TCODE’fieldandclickon‘InsertRule’icon
Figure23LSMWConversionRules
Chooseradiobutton‘Constant’(Figure23)toentervalue‘XD02’transactioncode.
--Keepyourcursoronfield‘KUNNR’andclickon‘Assignsourcefield’icon
Choosesourcefield‘Customer’fro
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SAP系统LSMW Demo教材 SAP 系统 LSMW Demo 教材