SAP LSMW制作帮助Word文件下载.docx

SAP LSMW制作帮助Word文件下载.docx

《SAP LSMW制作帮助Word文件下载.docx》由会员分享，可在线阅读，更多相关《SAP LSMW制作帮助Word文件下载.docx（17页珍藏版）》请在冰豆网上搜索。

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）.

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

FortheDemoexample2,Iwilllistonlythosestepsthataredifferentfromthefirstdemoexample.

YouwillbeupdatingthecustomermasterrecordswiththehelpofStandardBatchInput;

therefore,chooseradio-buttonStandardBatch/DirectInputasshowninFigure21.EnterObject‘0050’forCustomerMasterrecordsanddefaultmethod‘0000’andclickonSave.

Figure21StandardBatch/DirectInputObjectAttributes

SalesviewofCustomerMasterisstoredintableKNVV.Accordingly,youneedtoupdatestructureBKNVV.However,inaddition,theStandardObject‘0050’alsorequiresupdatestoBGR00,BKN00andBKNA1structures.（IfyoudonotmaintainStructurerelationsformandatoryentries,youmightgetamessagesuchas‘TargetstructureBKNA1needsarelationtoasourcestructure’.）

Eventhoughyoudon’twanttoupdateanyfieldsinthesestructures,youneedtocreatearelationshipwithsourcestructures.Inall,youneedtocreaterelationshipforfourtargetstructures.

CreaterelationshipbetweensourcestructuresXD02Swiththesetargetstructureswithicon‘CreateRelationship’

.

KeepCursoronthesefourtargetstructuresandclickonicon‘CreateRelation’andstructurerelationsaremaintainedasshowninFigure22.

Figure22StructureRelation

--Keepyourcursoron‘TCODE’fieldandclickon‘InsertRule’icon

Figure23LSMWConversionRules

Chooseradiobutton‘Constant’（Figure23）toentervalue‘XD02’transactioncode.

--Keepyourcursoronfield‘KUNNR’andclickon‘Assignsourcefield’icon

Choosesourcefield‘Customer’fromso