023 SAP FICO 运维项目实例-FI-SD信贷检查及信贷更新程序

1、Page|Page| /FI-SD情景SD创建销售订单时，要进行信贷检查，如果未清订单openorders(表S066-OEIKW)，未清交货opendelivery(表S067-OLIKW)，未清发票openbilling(表S067-OFAKW)，未清项openitems等超过了信贷额度/某个百分比，销售订单就会被block锁定，需要VKM3进行释放。如果在FD32处对信贷限额、风险类别等进行了更改，则会出现如下提示:Externaldata匚numberPaymentindexLaetext.reviewRatingIIn1tn1i-匚reditlimitforcontr

2、olareaBFD-Pistobereset为了使FD33中各项数字保持准确，同时便于分析销售订单锁定原因，需要定期运行信贷重组程序：RVKRED77及F.28(RFDKLI20)/手工/Ad-hoc运行RVKRED77运行信贷更新程序需要锁定SD的表VBAK,LIKP及VBRK.应事先选择一个systemquiettime以确保不会有更新这三张表的操作产生，或者先SE38运行程序RVKREDSP来锁定这三张表,如下图保持在此界面，RVKRED77运行完之前不要退出(F3或后退)SM12显示已经锁定的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则此处会为空白。表被锁住时做相关操作会报错：再运行RVKRED77适应quiettime时间或提升效率，也可按照客户号等分段运行，待运行完之后再退出RVKREDSP

4、Batchjob运行RVKRED77/RVKRED07RVKREDSP不适用于batchjob，因其在batchjob模式下运行完之后会自动把表解锁，对后续的RVKRED07运行没有意义。应参考SAPnote755395，编写适合batchjob的程序/report来锁定表，此程序(Z_RVKRED77_PARALLEL)运行后会自动调用RVKRED07直到其运行结束才解除对表的锁定2sapnote_0000755395.pdfABAPEditor:DisplayReportZ_RVKRED77_PARALLEL囹目miniisini画圈團囹區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.运行频

7、率一般每月或每季度一次，询问BASIS在系统的quiettime运行以免影响其它程序，根据运行时间长短可酌情分成几段存为不同变式分段运行。SM36运行RVKRED88模拟程序RVKRED88是RVKRED77的模拟运行程序，显示正确的信贷值，与FD32中的当前值进行对比，即可知道二者差别，要做真正的更新，需要运行RVKRED77SM37查看Job等到Job运行结束：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中查看结果Inb

9、oxClassTitleDaterece.TAuthorr04/9/201|jDaterece.TAuthorr04/9/201|jlPrabhakarMandnikarAttStaffi目RVKRED88OutputHTMLSE38运行程序RVKRED07进入selectionscreen，创建变式并保存SD:ReorganizationofCreditValuesafterUpdateErrorsSaledocumenttoSale5organizationtoDistributionchanneltoDivisiontoGalesofficetcSsle-sgrouptoPurchase

10、orderno.toCreatedbytlDateofcrestionto0Orders0Inquiries0Quotations0Schedulingagreements0ContractsHAsG&rtments复选框都勾上，KNKLI为creditaccount(customernumber),KKBER为信贷控制范围,PROTB=LOG=X,NOBLOCK=X记下变式variant名0VariantZRVKRED07-1savedSE38运行程序ZRVKRED77PARALLEL把之前保存的变式填上，保存GotoVariantsSaveasVariant0VariantZRVKRED7

11、75aved6.SM36创建batchjob点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应为Z_RVKRED77_PARALLEL,Variant填在Z_RVKRED77_PARALLEL中创建的变式，Z_RVKRED77_PARALLEL会锁定表VBAK,LIKP和VBRK，之后使用变式ZRVKRED07-1调用RVKRED07保存点后退按钮（如果Z_RVKRED77_PARALLEL中还创建了其它变式需要添加，继续点Step，所有步骤创建完成后）点Startcondit

13、ion点Date/Time设置运行时间，点PeriodicJob设置运行频率（每天/每周/每月等）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设置好后保存7.SM37查看JobActive表示Job正在运行，待运行结束，历时1006秒大约17分钟：JobGrangeiyQ9SSpocriJoblugJobGrangeiyQ9SSpocriJo

15、blugJStapApplicatmwrygrs雍血5F马日JobDrviewrramt0-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查看单个客户的数据|曙十|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查看多个客户的：Displ&ytoNanagcmcntDTTSDi.MTT23LfjlDNSSialcziEsgc-JTBFEFQg由于锁表的操作是双向的，即Job运行时会锁表，其它用户/Job在此期间不能有对表的操作；同样，如果Job开始运行时有其他用

19、户/Job在操作对应表，会造成RVKRED77不能顺利锁表而Cancel，如发生此情况可SM12查看细节并采取措施一一改运行时间等。运行F.28ta匸ustomerSDfta匸ustomerSDfFliRecreationofCreditDataafterOrffanizationafChangesCredt匚ontroJsreaFurthersei.opdons-OnlRecreaceFlData7?OnlyRecreieSDData*RecreateFandsFData|心曰H5DGidn嗣DocumentsI?1TestrunLayout先在测试模式下运行：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册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在考虑未清开票、未清交货等后重新计算了应收。测试无误后实际运行，“CreditlimitforcontrolareaBFDPistobereset”信息不会再出现。FD33各处数据说明及与上述程序关系FD33信贷数据：恿+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斗怕毎验.日？斗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各处数据说明及与信贷检查设置关系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中，选择客户对应的信贷控制范围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如上图高亮处，三项检查前打钩，表明对此类客户的销售订单要进行三项检查