SAP-FI_Document_999_Split_Solution

SAPFIDocument999SplitSolutionHigh-LevelBusinessRequirements•TheBusinessRequirementsintheCRaddressasolutionwhereinmultipleaccountingdocumentsarecreatedforasingleSDbillingdocument,iftheAccountingDocumentwillbeover999lines•Amaximumof950lineitemswillappearonanAccountingDocumentwhenasplitoccurs.•TheaccountingdocumentsrepresentingabillingdocumentmustbepostedinallthreeSAPcurrencies(transactioncurrency,localcurrencyandglobalcurrency)andmustbeautomaticallybalancedineachofthesecurrenciesforeachpostedfinancialdocument.(Stdfunctionality).High-LevelBusinessRequirements•ThedocumentsthatareGLonlywithouttheCustomeraccount(1201)needtohaveadifferentdocumentnumberrange.•Anewsub-accountforthegroupaccount1491mustbeusedtobalancethesplitdocuments.Thisaccounttobalancetheaccountingdocument.•Theinvoicenumberprintedontheinvoicemustberecordedinthereferencefieldintheheaderofeachfinancialdocument.Alltheinvoiceprintoutswillcarrythefirstaccountingdocument(doctypeD4,numberseries64x)intheinvoiceprintout.ThisaccountingdocumentwillhavetheARlineitem–TheSubsequentAccountingDocumentswithouttheARlinewillhaveadifferentnumberrangethantheonewithARline.High-LevelBusinessRequirements•Compassdocumentflow(billingdocument)mustlisteachfinancialaccountingdocument.•Allline-itemsoneachaccountingdocument,includingtheTaxlineitems,mustreflecttheaccuratetaxjurisdictioncode(taxingjurisdiction,whichmayormaynotbetheship-tojurisdiction)assignedinSAPtoeachline-item.Inotherwords,onemustbeabletorefertothetaxjurisdictioncodecapturedoneachline-itemoftheaccountingdocument(excepttheA/Rline-item)inordertodeterminewhichjurisdictionthatitemisassigned.(Notaxcodesummarization-O&C)•AccuratelyrecordandtransmitsaidmultipleFIAccountingDocumentstoSatellitesystems.•AuditTrail(end-to-end)accessibilitybyALLsystemstoALLdocumentsrelatedtothesplit&creationofmultipleFIAccountingDocumentsfromasingleSDBillingInvoice•ThereisneedforbillingdocumentnumbertoflowfromHPSSAPtogERP/LHduringtheIdocpostingtotheARsystemsothatARcanreferenceback,ifneedbe.High-LevelBusinessRequirements•ThereisR/3reportrequestedwithdocumentnumberasselectionparameteralongwithyear&companycode(likefb03).InamultipledocumentscenariothisreportwillhelpfetchallaccountingdocumentsrelatedtoaSDbillingdocument.–OutofScope•SupportthedesignchangethereisaBWreportthatwillbecreatedwithvaluesfromBSEG&BSETtable.–SeparateCaliberentry(CR-273557–BW)Diagram:CurrentProcess•ThelogictothesolutionevolvedaroundsplittingtheaccountingdocumentwhentheAccountingdocumentgoesoverthelimitof999(BSEG-BUZEI).•Aspartofmultipleaccountingdocumentdesign,clearingaccountismaintainedtobalancetheaccountingdocument.•Anexternallymaintainedtablecontrolsthemaximumlinelimitalongwithclearingaccountdebit&creditentries.ItisunderstoodthatSAPrecommendsalimitof950linesperaccountingdocument.•Thereare2externaltablesmaintainedforsalesorg/companycode&billingdocumenttypetolimitthesplitlogic.ThisistoenablethefunctionalitytobeusedforrestoftheworldwithminimumornoadditionalITeffort.SolutionOverview:HighLevel•TheCustomerAR(1201)linewillappearonthefirstAccountingDocument•whenMultipleAccountingDocumentsarecreated,thiswillutilizeaGeneralLedgerclearingaccount(1491XX)tobalanceCredit(CR)&Debit(DB)entries.•ThefirstAccountingDocumentthatcontainstheARlinewillbebasedonInternalnumberrangeassignment.•SubsequentAccountingDocuments,forallcompanycodes,willbebasedonasingleExternalnumberrangeassignmentSolutionOverview:DetailsDiagram:SplitAccountingDocumentsDisplay:SplitAccountingDocuments•ConfigurationofG/LpostingInformationwhenSplitoccurs•Table:ZPS_ZF01AACCTechnicalOverview:IMGConfiguration•ConfigurationforNumberRangeobjectformultipleFIAccountingDocuments.•Transaction:FBN1•CompanyCode:USA7•NumberRangeNumber:R9•FromNumber:0097000000•ToNumber:0097999999TechnicalOverview:IMGConfiguration•ConfigurationofexternaltabletocontrolCompanyCodes•Transaction:GS03•CompanyCode:BUKRS-999•FromValue:gERPcompanycodesTechnicalOverview:IMGConfigurationTechnicalOverview:IMGConfiguration•ConfigurationofexternaltabletocontrolCompanyCodes•Transaction:GS03•CompanyCode:BILLDOC-999•FromValue:PSBillingDocTypesTechnicalOverview:ProcessFlowTechnicalOverview:SharedInterfaces•ChangestoFinancialAccountingDocumentgeneration(split)•Thesolutioninvolvesthefollowing:–Register&modificationof8Include(s)and3FunctionModulecoreSAPobjects•Includes:LF048F00*Form:Long_DocumentLFACIF0K**Form:Check_FI_DocumentLFACIF4B**Form:Document_SplitLFACIF4C**Form:Add_BSEGLFACIF4P**Form:Document_TaxLFACIF5D**Form:FI_Document_PrepareLFACIF70Form:Reverse_ItemsLFACITP5**datadefinitions•FM’s:BREAKDOWN_RELATION_REMEMBER*BREAKDOWN_RELATION_SAVE*G_BEB_SPLIT_DOCUMENTTechnicalOverview:SharedInterfaces•ChangestoIDOCprocessing(FIDDC1/2)forthecompanycodesinscope–Performlogictochangeamount(local&transactioncurrency)on999balanceG/LlinesothatIDocwillpostcorrectlyonLH(eg:gERP)–Modifyuser-exitZX050TOP---SAPLX050•DataDefinitionsfortaxsumsolution–Modifyuser-exitZX050U04---EXIT_SAPLF050_005•DataandSymbolDefinitions•CheckCo.Code,perform999_fix(sumlineitemtaxes)–Modifyuser-exitZX050ZZZ--