Fundamentals of MM-FI Account Determination - ERPCorp

When movement type 101 is used to record the goods receipt of raw material (valuation class 3000) for a purchase order, the system looks up the ... BLOG Home/Blog/AshishSampat/FundamentalsofMM-FIAccountDetermination ERPCorpSAPFICOBlog Tags SelectCategoryPaidContentFI-COBlogControlling2012Controlling2013ReportingSAPHANASAPResultsAnalysisCostingSAPCO-PASAPControllingPitfallsSAPControllingCommunityAwardsSAPMaterialsManagementControlling2014SAPMaterialMasterControlling2014WebinarSeriesFICOForumSAPCostingControlling2015Controlling2015WebinarSeriesSAPPlanningBookExcerptControlling2016Controlling2017 Search Subscribetoblog Unsubscribefromblog Fontsize: + – Subscribetothisblogpost Unsubscribe Print FundamentalsofMM-FIAccountDetermination FI-COBlog AshishSampat Monday,21August2017 59027Hits 2Comments ERPCorpLearning ExclusiveSAPControllingConferenceContent StartYourFREETrial SeveralcolleagueshaveaskedmequestionsabouttheintegrationbetweenMaterialsManagement(MM)andFinancialAccounting(FI)modules: -HowdopostingsflowfromMMintoFI? -Howdowefindoutwhatoccursbehind-the-scenes? -HowdoweidentifywhichmovementtypesarepointingtoaspecificGLAccount? -HowdoyouchangethepostingtoadifferentGeneralLedger(GL)Account? -HowdoyoucreateanewmovementtypeandassignittoaspecificGLAccount? ManySAPpractitioners–ITandbusinessalike–areinasimilarsituationanddonotknowwheretostartMM-FIdataflowandreconciliation.ThisblogclarifiesthefundamentalsofMM-FIaccountdetermination. ConfigurationtransactionOBYCformsthecoreofSAP’sintegrationbetweentheMM,FI,andControlling(CO)modulesinatraditionalSAPERPsystem Transactionkeys areusedtodeterminegeneralledgeraccountsusedbythesystem. Accountmodifierisusedtodifferentiateaccountdeterminations,dependingontheprocedure. Transactionandaccountmodifiersarealogicalgroupingsimilartypesoftransactions.Thetransaction-accountmodifier,alongwiththevaluationclass,drivestheaccountingentries.TransactionkeysarepredefinedintheSAPsystemandcannotbechanged.  Figure1:OBYCSetupforBSX–InventoryPosting YoumayhaveseenanaccountingentryatthetimeofthepurchaseofrawmaterialasadebittoinventoryandcreditGR/IR.TheconfigurationsetupoftransactionBSX(inventoryposting)isresponsiblefortheinventoryposting(seeFigure1),andWRX(GR/IRclearingaccount)isresponsibleforGR/IRposting.Whenmovementtype101isusedtorecordthegoodsreceiptofrawmaterial(valuationclass3000)forapurchaseorder,thesystemlooksuptheGLAccountfortransactionBSXandWRXforvaluationclass3000andrecordsitintheaccountingdocument.                                Figure2:OBYCSetupforGBB-VBR–ConsumptiontoOrder Similarly,whenrawmaterialisconsumedusingmovementtype261,thesystemlooksuptransactionGBB(offsettingentryforinventoryposting)foraccountmodifierVBR(consumptionforinternalgoodsissues),andthatreflectstheGLAccountintheaccountingdocument(seeFigure2) Figure3providesasummaryoffewimportantmovementtypesandaccountingentries.Businessprocessislistedinthecolumnfurthesttotheleft,withmovementtypeinthenextcolumn,andthedebitandcreditpostinginthesubsequentcolumns. Thereisacolumnfortransactionandaccountmodifiers;aswenotedearlier,theseareSAP’stermsforlogicallygroupingsimilartypesoftransactions.Thetransactionaccountmodifier,alongwiththevaluationclass,drivestheaccountingentries. TheOBYCMM-FIaccountdeterminationconfigurationissetupatthetimeoforiginalimplementation,andoncesetup,theseaccountsarederivedbehindthescenes.You’llwanttotestthesetupbeforegoinglivetoensurethatthecorrectaccountsarebeinghitfortherespectivetransactions.Youcanchangethisconfigurationaftergo-live,buttherevisedsetupneedstobethoroughlytested.Otherwise,wemayruntheriskofimpactingregularoperations. Figure3:Summaryofselectmovementtypesandaccountingentries Keytake-aways: -Transaction-accountmodifierandvaluationclassdrivetheaccountingentries -Transactionkey:determinesgeneralledgeraccountsforposting -Accountmodifier:differentiatesaccountdeterminationbasedonprocedure -OBYCMM-FIAccountdeterminationsetupisstoredinunderlyingtableT030 -OMJJMovementTypesetupisstoredinunderlyingtableT156X -Combinethesetwotables(viaSQ00query,orsimplyonExcel) -TheaccountmodifierlinkstheMovementTypetotheAccountingentries Ihopethiswrite-upwasusefulandexplainedthefundamentalstoyou. ThetransactionkeyinMM-FIaccountdeterminationisnotthesameastransactioncode.AtransactioncodeisanalphanumericcodethatrepresentsaparticulartaskinSAP.Itallowsuserstoaccesstasksdirectlywithouthavingtousemenupaths. AbouttheAuthorAshishSampatisanSAPFI/COConsultantwhohasprovidedsolutionsinSAPControllingincludingproductcosting,SAPMaterialLedger,andcostcenteraccountingtoglobalclientsinconsumerpackedgoods,lifesciences,andindustrialsectors. AshishisbasedintheChicagoregion,whereheworksasanindependentSAPFI/COconsultant.AshishistheauthorofbestsellingSAPbooksincluding:FirstStepsinSAPControlling(CO)andExperttipstoUnleashtheFullPotentialofSAPControlling.   0 ERPCorpSAPControllingLearning StartYourFREETrial 2021|ControllingConference Registerforonly$999Over50%Off RegisterNow FundamentalsofMM-FIAccountDetermination ActivityTypePostBlogSeriesFinalRecap Abouttheauthor AshishSampat AshishSampatisaqualifiedfinanceandcostingprofessionalwithovertwodecadesof industryexperienceintheSAPFinanceandControllingspace.AshishhasbeenanSAPconsultantformostofhiscareerwithvariousconsultingorganizationsandnowworksasanindependentSAPFI/COconsultant.HehasprovidedsolutionsinseveralareasofSAPControllingincludingproductcosting,MaterialLedger,andcostcenteraccountingtoglobalclientsinconsumerpackedgoods,lifesciences,andindustrialsectors.BornandeducatedinIndia,AshishnowlivesinsuburbanChicagowithhiswifeandtwokids.AshishistheauthorofFirstStepsinSAPControlling(CO) andExpertTipstoUnleashtheFullPotentialofSAPControlling. Author'srecentposts Morepostsfromauthor Tuesday,16July2019 ImprovePerformanceofSAPMaterialLedgerClosingCockpit Wednesday,13June2018 ExploreVariousCostObjectsinSAPControlling Tuesday,10October2017 FundamentalsofMM-FIAccountDetermination   Comments 2 Guest-MikeP onWednesday,23August201702:01 Greatarticle&simpletounderstand. 0 Cancel Reply Greatarticle&simpletounderstand. Greatarticle&simpletounderstand. Cancel UpdateComment Guest-Wolfgang onSunday,10September201712:47 ThanksforthisniceoverviewoftheMMaccountdetermination! Iamsurprisedtoseeinmyprojectwork,howoftentheFICOcolleagueslettheSDorMMguystakecarefortheaccountdetermination.BecauseIMHOevenitcanbefoundintheIMGinSDandMMetc.too,it's100%theresponsibilityofthefinanceteam.Asafinanceconsultant,Ihavethestrong"desire"totakecareforthis,thismustbemybaby:-) 0 Cancel Reply ThanksforthisniceoverviewoftheMMaccountdetermination! Iamsurprisedtoseeinmyprojectwork,howoftentheFICOcolleagueslettheSDorMMguystakecarefortheaccountdetermination.BecauseIMHOevenitcanbefoundintheIMGinSDandMMetc.too,it's100%theresponsibilityofthefinanceteam.Asafinanceconsultant,Ihavethestrong"desire"totakecareforthis,thismustbemybaby:-) ThanksforthisniceoverviewoftheMMaccountdetermination! Iamsurprisedtoseeinmyprojectwork,howoftentheFICOcolleagueslettheSDorMMguystakecarefortheaccountdetermination.BecauseIMHOevenitcanbefoundintheIMGinSDandMMetc.too,it's100%theresponsibilityofthefinanceteam.Asafinanceconsultant,Ihavethestrong"desire"totakecareforthis,thismustbemybaby:-) Cancel UpdateComment AlreadyRegistered? LoginHere Guest Tuesday,26April2022 Ifyou'dliketoregister,pleasefillintheusername,passwordandnamefields. Automaticallyregistermeasauserofthissite Subscribetothisblogpost (Pleasefillinyouremailaddresstosubscribetoupdatesfromthispost.) CaptchaImage SubmitYourComment Byacceptingyouwillbeaccessingaserviceprovidedbyathird-partyexternaltohttps://www.erpcorp.com/ Iunderstandandagree DirectLink GR/IR(GoodsReceipt/InvoiceReceipt)Processing SAPAccountingpoweredbySAPHANA-FrequentlyAskedQuestions IntroductiontoSAPMaterialLedger FundamentalsofMM-FIAccountDetermination Howtomaketradingpartnerarequiredentry(PartI) PIRUsageinCostingVariants Howdosettlementrules,settlementprofilesandallocationstructuresworktogether? TipsonhowtoreconcilecostingbasedCO-PAandGL IntroductiontoSAPResultsAnalysis WhatisanSAPInternalOrder?