023 SAP FICO 運(yùn)維項(xiàng)目實(shí)例-FI-SD信貸檢查及信貸更新程序

1、Page|Page| /FI-SD情景SD創(chuàng)建銷售訂單時(shí)，要進(jìn)行信貸檢查，如果未清訂單openorders(表S066-OEIKW)，未清交貨opendelivery(表S067-OLIKW)，未清發(fā)票openbilling(表S067-OFAKW)，未清項(xiàng)openitems等超過了信貸額度/某個(gè)百分比，銷售訂單就會(huì)被block鎖定，需要VKM3進(jìn)行釋放。如果在FD32處對(duì)信貸限額、風(fēng)險(xiǎn)類別等進(jìn)行了更改，則會(huì)出現(xiàn)如下提示:Externaldata匚numberPaymentindexLaetext.reviewRatingIIn1tn1i-匚reditlimitforcontr

2、olareaBFD-Pistobereset為了使FD33中各項(xiàng)數(shù)字保持準(zhǔn)確，同時(shí)便于分析銷售訂單鎖定原因，需要定期運(yùn)行信貸重組程序：RVKRED77及F.28(RFDKLI20)/手工/Ad-hoc運(yùn)行RVKRED77運(yùn)行信貸更新程序需要鎖定SD的表VBAK,LIKP及VBRK.應(yīng)事先選擇一個(gè)systemquiettime以確保不會(huì)有更新這三張表的操作產(chǎn)生，或者先SE38運(yùn)行程序RVKREDSP來鎖定這三張表,如下圖保持在此界面，RVKRED77運(yùn)行完之前不要退出(F3或后退)SM12顯示已經(jīng)鎖定的table:LockEntryListRefresh3Details0BQ站屏羽屠婦冬圉爵Hn

3、ClientUsernameTimeLockmodeTableLockArgumentUseCount.UseCount.100IBMKAUDREY14:14:4-4-ELIKP100#01100IBFmIKAUDREY14:14:4-4-EVBAK100$%Asdbatch1100IBMKAUDREY14:14:4-4-EVBAK100#1100IBMKAUDREY14:14:4-4EVBRK100#01如果退出了RVKREDSP則此處會(huì)為空白。表被鎖住時(shí)做相關(guān)操作會(huì)報(bào)錯(cuò)：再運(yùn)行RVKRED77適應(yīng)quiettime時(shí)間或提升效率，也可按照客戶號(hào)等分段運(yùn)行，待運(yùn)行完之后再退出RVKREDSP

4、Batchjob運(yùn)行RVKRED77/RVKRED07RVKREDSP不適用于batchjob，因其在batchjob模式下運(yùn)行完之后會(huì)自動(dòng)把表解鎖，對(duì)后續(xù)的RVKRED07運(yùn)行沒有意義。應(yīng)參考SAPnote755395，編寫適合batchjob的程序/report來鎖定表，此程序(Z_RVKRED77_PARALLEL)運(yùn)行后會(huì)自動(dòng)調(diào)用RVKRED07直到其運(yùn)行結(jié)束才解除對(duì)表的鎖定2sapnote_0000755395.pdfABAPEditor:DisplayReportZ_RVKRED77_PARALLEL囹目miniisini畫圈團(tuán)囹區(qū)iniigmii圈厠麗面訂|蘭目諛聞目如駅|Rep

5、ortZRVKKED77FARALLELActkfe1日*_,+*&PeportZ_PVKRED77_PAMLLEL*3*X156亠FgxaxnName;SEVERED?7_PARALLEL亠*ProgMniFftierCreditJ?eorgBatchJob*g亡PiogiamtypeRepazt*9*Module:FI*10*CiateDate:10/28/2013*11*AnthornsNanerArjunG*f2*Descript!on:J?eport5holdsthelocks口ntilthejobwithRVKRED07*13*15completed.SeI已匸七variantsd

6、efinedforPITCREDO?*14*verassignedtothisreportJ?epqi?七setsthelocksat*15*C2：eJbeginningjrE2ienstaresjojdsrorRVKRED07*16*automatically匚hyourselectionvariantsandholds*27thelockstintillalljcIdsstartedBythezepoTtaj?e*兮*sonipleted.ReferOSSnotes-755395*19*20*-*21*._一*Mod.fDateIAuthor|Deso,ReferenceCTS*1.運(yùn)行頻

7、率一般每月或每季度一次，詢問BASIS在系統(tǒng)的quiettime運(yùn)行以免影響其它程序，根據(jù)運(yùn)行時(shí)間長短可酌情分成幾段存為不同變式分段運(yùn)行。SM36運(yùn)行RVKRED88模擬程序RVKRED88是RVKRED77的模擬運(yùn)行程序，顯示正確的信貸值，與FD32中的當(dāng)前值進(jìn)行對(duì)比，即可知道二者差別，要做真正的更新，需要運(yùn)行RVKRED77SM37查看Job等到Job運(yùn)行結(jié)束：dUSpoollogJ；FEtap呼Uppctmns;口rvnrs溜旳下邑Q金QWftiviewfiDlliOI/29-/Oi4b*GlCOI04/2S/2014BisciSelearedjobnutiE31*SeleatidU9z

8、nuw9nMMTM工EOHEWiEctteduled回Risl亡.smlU回Kcul”亡S3rinisJiedl?JCanc-eldlEvbt：口口ntEC!LlfldEvratIDtOJISJiJrrnor-sr.ProgsnmnazisnJobSpool召口D閃口TubCrtHcdBSCHtUffEt-ar-凸h工亡SrazttLh十Djza-lsnr3ect、DtLayCJ4Qi1LZ3SMEEEM-SAO；WIFCAHFKSytnlstie-dD4/39/Zai4OCrl-：-;1Z|1.3CC|0*5innaryis?ao0可以看到用了1900秒大約32分鐘在SWBP中查看結(jié)果Inb

9、oxClassTitleDaterece.TAuthorr04/9/201|jDaterece.TAuthorr04/9/201|jlPrabhakarMandnikarAttStaffi目RVKRED88OutputHTMLSE38運(yùn)行程序RVKRED07進(jìn)入selectionscreen，創(chuàng)建變式并保存SD:ReorganizationofCreditValuesafterUpdateErrorsSaledocumenttoSale5organizationtoDistributionchanneltoDivisiontoGalesofficetcSsle-sgrouptoPurchase

10、orderno.toCreatedbytlDateofcrestionto0Orders0Inquiries0Quotations0Schedulingagreements0ContractsHAsG&rtments復(fù)選框都勾上，KNKLI為creditaccount(customernumber),KKBER為信貸控制范圍,PROTB=LOG=X,NOBLOCK=X記下變式variant名0VariantZRVKRED07-1savedSE38運(yùn)行程序ZRVKRED77PARALLEL把之前保存的變式填上，保存GotoVariantsSaveasVariant0VariantZRVKRED7

11、75aved6.SM36創(chuàng)建batchjob點(diǎn)Step匚&Crie-a-tie-Step-1xLJ&QrIMMTPrizijgi-ai-iivaluABAPPTopram曰ernmluorwnanOExtermprogramabapprooramName|ZRVTCB.E1D77A-C4JkLIELLVariantZR.rKHElDf77|1Langlis口七1ELW1EzKternaluperrraicicornm-Bnidpre-deFinedtyystemadminIstratorNameRaramors口I口aratln口uyaT-ar口alt4arEzKtamsl口oaramtdir

12、aeztcon-imandInputtsysyctamacimlrtictratorjNainiaaParametecTargethotUlimuk：T|QI11匚二F1iirrt匸teri_BXProgram應(yīng)為Z_RVKRED77_PARALLEL,Variant填在Z_RVKRED77_PARALLEL中創(chuàng)建的變式，Z_RVKRED77_PARALLEL會(huì)鎖定表VBAK,LIKP和VBRK，之后使用變式ZRVKRED07-1調(diào)用RVKRED07保存點(diǎn)后退按鈕（如果Z_RVKRED77_PARALLEL中還創(chuàng)建了其它變式需要添加，繼續(xù)點(diǎn)Step，所有步驟創(chuàng)建完成后）點(diǎn)Startcondit

13、ion點(diǎn)Date/Time設(shè)置運(yùn)行時(shí)間，點(diǎn)PeriodicJob設(shè)置運(yùn)行頻率（每天/每周/每月等）DelineBackgroundJobstartcondmonstep/.Jobselectionownjobsstartcondmonstep/.JobselectionownjobsJoewizardstandardjobs&IZQ(iyiOQStartTimeIrrimediiateate/TimeIrrimediiateate/TimeAfterjoDMereventDatetimeScheduledslartate10/28/20131Time23:30:60ioStartAfterat

14、e10/2&/2013Time2i：OD：00Atoperationmode&IZQ(1X100Per.HourlyScheduledslartate10/28/20131Time23:30:60ioStartAfterate10/2&/2013Time2i：OD：00Atoperationmode&IZQ(1X100Per.Hourlyaih/1Weel(hrMontnivGtherpsnod設(shè)置好后保存7.SM37查看JobActive表示Job正在運(yùn)行，待運(yùn)行結(jié)束，歷時(shí)1006秒大約17分鐘：JobGrangeiyQ9SSpocriJoblugJobGrangeiyQ9SSpocriJo

15、blugJStapApplicatmwrygrs雍血5F馬日J(rèn)obDrviewrramt0-4/29/2CI14曲隘s:!GO：G4/29/ZQ14dL：:SSeleccedjotfinest*Selected=biUOlIKkRJFJXJotDdcJotace;3B兀日“-laxe禮anTHloxalfaecJiHlayjaec.ld3O429_0933S2Fimshtd.04/29/22140S;3:520jRiiPREK?Miwjum鈕眈Finishr-dd4/29/2CJl.i06:12:12lr9DDQ|Z_RVyREO77_FXRALLELFlmshMl口4/Z?/2口It09!3

16、3=52irasD口*5immary3r9E0_Scheduled&e丄SEeedy0JtctLv-1pLniahedCane-ltdLE?r=-n.tcontz-sllEdSXtDEID:AHAFprogramErarairinnmes8.查看所作的更改可以在SBWP中查看收到的spool:RVKRED77.htrri可以在FD32的status查看單個(gè)客戶的數(shù)據(jù)|曙十|CustomerCreditManagementDisplay:StatusCustomer3E039CreditControlAreaBFDFCustomer3E039CreditControlAreaBFDF畫畫匱Tex

17、ts.AdministrativedataCredjlimEdataCreditlimitirrjoorooo.ooReceibles515,129-57Creditaccount3S039Specialliabil.421P708.44Creditlimitused105.12舍Salesvalue124,341.51CredithorizondateC&/29/2016回Creditexposure1F01f179.62Sec.receivablesO.QQInternaldmta”RiskcategoryCreditrep.group002131MediumRiskCustomerARC

18、hinaCreditGroup廠BlockedETextsexistCust.cred,groupTextsCustomergroupLastint.reviewReferencedateNextint.review10/01/2015ExternaldataCnumberPaymentindex或者S_ALR_87012215查看多個(gè)客戶的：Displ&ytoNanagcmcntDTTSDi.MTT23LfjlDNSSialcziEsgc-JTBFEFQg由于鎖表的操作是雙向的，即Job運(yùn)行時(shí)會(huì)鎖表，其它用戶/Job在此期間不能有對(duì)表的操作；同樣，如果Job開始運(yùn)行時(shí)有其他用

19、戶/Job在操作對(duì)應(yīng)表，會(huì)造成RVKRED77不能順利鎖表而Cancel，如發(fā)生此情況可SM12查看細(xì)節(jié)并采取措施一一改運(yùn)行時(shí)間等。運(yùn)行F.28ta匸ustomerSDfta匸ustomerSDfFliRecreationofCreditDataafterOrffanizationafChangesCredt匚ontroJsreaFurthersei.opdons-OnlRecreaceFlData7?OnlyRecreieSDData*RecreateFandsFData|心曰H5DGidn嗣DocumentsI?1TestrunLayout先在測試模式下運(yùn)行：SO,FI：Rccraatmn

20、OfCreditDaWaftciQrffonizationiChanges同色目耶SQ巒處宙曾融ft囲也眷U3FIRecreationofQeditDataCuEtomerCCftrGed.senfecevabfeCr*ft?cewbfe(aSOK.cwr5翊Spec.ccrnnt.Coid)Uff-o1TnecnewjV-aFrec.toWriE呦BFDP+5L37Q.330.W2SMH0.56a.ooawa.wo.ooUSDL2冊(cè)BFOPLWiSDAOLS.40e,4ia.oooooQJM0.00USD13095BFOPL3W55t32.B76.2LL&9.691.76(LOOaQ000.

21、00USD13114BFOP13L143Q1413.4G3S.37fl.L3a.ao.wO.|USD13573BFOPL3573D.iJi旳卅陰帀(LOOawa.o.iU531357BPOPL3597O.UU9,570.45山00a山000.00USD13WBPOPL3MD.)552.50-a.wQOOa.wD.WUSD134LLBPOPl36O.i3i34,171.72-a.aa.a.ooUSD3956LBPOP3956L.696.23】砂山00aooa.0.00USD2951GFDP3S5623.516.02515.4a.co0.00Q-|D.ODUSD3956JBFOP39565斗函如斗

22、附西a.co0.00Q-MD.ODUSD3957QBFOP3SBXIA4B；11SH2JSa_oo0.00QJ山00USD3957BFOP29576七52山嶺493.740.000.WQ-W(LOGUSD刑融BFOP彳06&915J7-15*G.000.00QjXiUSDKFDPTIP的QFDPJCFPTrSli“L%禹2770.000.00(LOOD.00USD在考慮未清開票、未清交貨等后重新計(jì)算了應(yīng)收。測試無誤后實(shí)際運(yùn)行，“CreditlimitforcontrolareaBFDPistobereset”信息不會(huì)再出現(xiàn)。FD33各處數(shù)據(jù)說明及與上述程序關(guān)系FD33信貸數(shù)據(jù)：恿+1Custo

23、merCreditManagementDisplay:StatusH圈眩TmxtsAdministntivQdmta|Customer43694CreditControlAreaEFLFCustomer43694CreditControlAreaEFLFUSDCreditlimitdataCreditlimit3sorooo.ocReceivables4,903.27Creditaccount43694SpecialiQbil.0.00Creditlimitused1.40%Sblesvalue0.00Credithorizondate1回Creditexposure4,903.27Sec.r

24、eceivables0.00Creditlimit為信貸額度,Creditexposure即已用的信用額度,creditlimitused=creditexposure/creditlimit*100%;creditexposure=receivables+specialliabilities+salesvalue信貸更新程序中，RFDKLI20(F.28)更新的是Receivables及Specialliabil.卜1RecreationofCreditDataCUEtomerOed-acct亠R.ewwbfes(new-：OcpBFDP117.67232.5-0.000.000.000血U

25、SD4E-6J6BFDP4&5067,977.717,771790.00D.DOD.DQD.DdU5D46625BFDP4662521.16335205?00.00n.QUQ.DUQ00USD46632BFDP4阪229t.-303.452?5?8-300.00n.Qun.uun.DDUSD4739BFDP4739Ki.LQtt,Q00.00D.QUn.uoQ,00U5D4B033BFDP+BO33142.050.00o.m0.000.000血USD4ALD9*BFDP4AL04130.50-0.0D0.00o.ao0.00。血USD4G135QFDP4BL3523.72D.DO000D.DO

26、D.DQD.DflUSD4B196BFDP斗肌并49s62D.DO000D.DOD.DQD.DdU5D+B233BFDP4B2333J17.932,57830.00n.QUD.DUQ00USD呻4今BFDP呻482r?13.O52.3+2410.00D.QUQQQ.DDUSD464巧BFDP4175-35.000.000.Mo.ao0.000血USDBFDP斗怕毎驗(yàn).日？斗K,7352Ei0.Moo0.000血USD4B036.4niBFDPacnn46936.4mvn0.0Dmf*eneD.DO2B952-nre29Q02-nnn0UQnnnD.00nnfiUSD1IUE而RVKRED77更

27、新的是salesvalue:RecerbliesD53.35Specialliabil.C.30Sesvslue171P203.45Creditexposure255P242BOSec,receivablesQ.DO園|3|同w園|3|同w禺羯園.圖H|HCCAr|Cred,acctICurr,liafesCHje,|=OpenorderseOpendel.BOpenb.BFDP-11259USD2091128.633.90O.DflQ.ODbbDP41259USD2213540.0039.526.100.0JBFDP41259USD22135497L360-000.0DEFDP41259US

28、D22135.546.01100-000.0DBFDP1259USD224121726.990.000.0DEFDP41259USD2241210-000.0DBFDP1259USD22506&2,304.500.000.0DEFDP磯259USD22750545,744.6QO.OQ0.0D:FFrJ5RLFreoneDPC3D11259JJjUSO131,275.3539,929.100.00BFDP-1417USD21255D629.16D.DOO.ODSalesvalue=openorders+opendelivery+openbillingFD33各處數(shù)據(jù)說明及與信貸檢查設(shè)置關(guān)系Cr

29、edftlimitdataCreditlimitlm00R-eceh/ables000Creditaccourrt:61764S-pecialliabil.lrL5S76-Creditlimitused9S3.99吿Salesvalue7,435.52匚Edithorizondateu2/2t,-2uL7匚redrtexposue6,276.76S-ec.receivableE0.00InternaldataRiskntego-ryCreditrep.group003131HighRiskCustomerAR.ChinaCreditGroupI-BlockedI-TextsexistCust.

30、cred,groupTextsCusto-iriergroupLa戎int.reviewReferencedateNextint.review0VA8中，選擇客戶對(duì)應(yīng)的信貸控制范圍BFDP及Riskcategory003：DisplayViewTIViewfarMaintenanceafAutamcSeem匚CAr1Riskcat.匚GCreditcontrol|B00010011HighRiskSalesOrdersE000100102HighRiskDeheriesE00010013HighRiskGoodsIssueBFCE0011LowRiskCustomerSalesOrd|erBF

31、CP0021MediumRiskCustomerSalesOrdBFCE00301HighRiskCustomerSalesOrder雙擊最后一條：DisplayViewViewforMaintenanceafAutomaticCreditControl1sSEstaticEDynamicllDocumentvaluestaticEDynamicllDocumentvalueCriticalfields01忖extReviewdateFlOpenitemsoldestOpenttemI-High.dunn.levelCA0E00Horizon2Max.doc.value9,999,99.00N

32、umberofdays0Max.o-pen.item%10N&Daysopenl30Daysoldestltem30High.dunn1CO-peno-rdersOopendeliveries:caRkcCreditcontrolCurr.Update3FDF301HighRiskCustomerSalesOrderusd000012Socumentcontrolling/ReleaseddocumentsarestilluncheckedNocreditcheck0Devstionin%1C匡ItemcheckNumberofdays1C匚reditlimtseasonalfictor毛FromToChe匚Iceinfinancial日匚counting/ald打Rsummary廠PayerPermitteddays0Permittedhours00|ClMinusChecksReactionStatusfQloclc如上圖高亮處，三項(xiàng)檢查前打鉤，表明對(duì)此類客戶的銷售訂單要進(jìn)行三項(xiàng)檢查