SA新总账培训教程

NewGeneralLedger–KeyConfiguration/ProcessesandLessonsLearned

10/24/2007AgendaOverviewProjectOverview/ScopeKeyClientRequirements

NewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructures

Conclusions1AgendaOverviewProjectOverview/ScopeKeyClientRequirements

NewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructures

Conclusions2Overview–ProjectOverview/ScopeClientisaFortune500CompanyandperformslimitedmanufacturingVersionbeingimplementedisECC6.0andBI7.0InitialimplementationofSAPinvolvesFI/COforNorthAmericaEntitiesinothercountriesareimplementedbutonlytoloadtrialbalancedataLegacysystemsinterfacesalesandpurchasingdata/PhaseIIwillimplementSD,MM,andotherfunctionalityECCScopeincludesNewG/L,A/P,A/R,AM,CO-CCA,andCO-OPACO-PAinitiallyconsideredbutlaterremovedfromscopeCurrentlyinTestingphase(thoroughunittestingcompleted)3Overview–KeyRequirementsFullybalancedbalancesheetandP/LbylegalentityFullybalancedbalancesheetandP/Lbyoperatingunit(majordivisionofthebusiness)Partialbalancesheet(WorkingCapital)andfullP/LbybranchOperatingexpensesbydepartmentPartialbalancesheet(WorkingCapital)andP/LtogrossmarginbyCommodityCodeandManufacturer(thekeyrequirementforNewG/Lwithcustomfields)FullybalancedbalancesheetandP/Lforlogisticallegalentity(donefortaxpurposes)FI/COtoalwaysreconcile4AgendaOverviewProjectOverview/ScopeKeyClientRequirements

NewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructures

Conclusions5NewGeneralLedgerSet-up/LessonsLearned–CustomFieldsKeyBusinessRequirement:Partialbalancesheet(WorkingCapital)andP/LtogrossmarginneededbyCommodityCodeandManufacturer:BalancesheetdataneedkeydrivertousecustomfieldsTwocustomfieldsdefinedandaddedtoG/LcodeblockTwocustomcheck-tablesdefinedtostorevalidvaluesforeachfieldChecktablesaddedtoCOBLstructuretoprovidestandardlistdisplayofvalidvaluesAdditionalvalidationsdefinedtocheckvalidCommodityCode/Manufacturervaluecombinationsandvalid

CommodityCodes/ProfitCentercombinations6NewGeneralLedgerSet-up/LessonsLearned–CustomFieldsCustomFields:SAPECCallowstheadditionofcustomfieldstothecodeblockoftheGeneralLedger

Onceadded,thesefieldsbehavelikeotheraccountassignmentfields

Fieldscanbewithoutorwithvalidation7NewGeneralLedgerSet-up/LessonsLearned–CustomFieldsConfigurationStep:IncludeCustomFieldstoCodeBlockStepwillregenerateallstructures/programstoincludecustomfields8NewGeneralLedgerSet-up/LessonsLearned–CustomFieldsConfigurationStep:DefineMasterDataCheckForthecustomfields,themasterdatachecktables(customchecktablescreated)mustbedefined(customchecktablesstilladdedtoCOBL)9NewGeneralLedgerSet-up/LessonsLearned––CustomFieldsOtherKeyConfigurationStepsCustomfieldsmustbeaddedtoallEnjoytransactionsCustomfieldsmustbeaddedtocodeblocksubscreenifolderG/LtransactionsaretobeusedPostingkey/accountfieldstatus-customfields,upongenerationbecomepartoffieldstatusconfiguration,butinitialsettingis““hidden”10NewGeneralLedgerSet-up/LessonsLearned––CustomFieldsLessonsLearned:AddchecktablestoCOBLfordrop-downfunctionalityBAPIextensionsonG/LpostingsCustomfieldsworkingwell11AgendaOverviewProjectOverview/ScopeKeyClientRequirementsNewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructuresConclusions12NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaKeyBusinessRequirements:FullybalancedbalancesheetandP/Lbyoperatingunit(majordivisionofthebusiness)Partialbalancesheet(WorkingCapital)andfullP/LbybranchTheSegmentisincludedwithNewG/LSegmentisderivedbyProfitCenter(ProfitCentersdefinedforBranchreporting)BalancedfinancialstatementscanbegeneratedbySegmentusingSplittingfunctionalityAllpostinglineitemsmustidentifyaprofitcenterinordertoensurefullsetoffinancialstatementsbySegment13NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaBusinessAreavs.SegmentBothprovidebalancedfinancialstatements(balancesheetandP/L)byreportingentityotherthanCompanyCodeSegmentoffersSAP-deliveredderivationfromProfitCentermasterrecord(validated““business””definition)BusinessAreanotusedduetoderivation;Segmentviewedas““cleaner”solution14NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaConfigurationStep:AssignSegmentScenariotoLedgerActivatingtheSegmentscenarioallowsforpopulationofSegmentinNewG/L15NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaConfigurationStep:DefineSegmentsDefinethelistofSegmentstobeused16NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaMasterDataStep:SpecifySegmentsonProfitCentermasterrecordsProfitCenterspecifiedonpostinglinewillderiveSegmentfrommasterrecord17NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaConfigurationStep:DefineSplittingCharacteristics(Segmentsettozero-balance)SplittingfunctionalitydrivesbalancedSegmentreporting18NewGeneralLedgerSet-up/LessonsLearned––Segmentvs.BusinessAreaLessonLearnedPartnerSegmentderivationfunctioningmostlycorrectlyexceptforinter-companytransactionsResolutionCustomprogramoruserexitforPartnerSegmentderivationunderinvestigationaspotentialsolutionLessonLearnedSegmentnotavailableonallstandardSAPreportsResolutionCurrentlycontactingSAPaboutthisissue19AgendaOverviewProjectOverview/ScopeKeyClientRequirementsNewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructuresConclusions20NewGeneralLedgerSet-up/LessonsLearned–LedgerDefinition/ScenariosKeyBusinessRequirement:FI/COtoalwaysbeinbalanceClientverysensitivetoanypotentialout-of-balancepointswithreportinginFI/COandProfitCentersProfitCenterabsorptioninNewG/L(andscope)resultinginclientleaningtowardsNewG/LformostreportingCostCenterAccountingsub-module“dangling”––mostcostcenterreportingperformedwithinNewG/LMostscenariosactivatedforLedger21NewGeneralLedgerSet-up/LessonsLearned–LedgerDefinition/ScenariosLedgerDefinition:LeadingLedgerdeliveredbySAPandusedinNewG/LOtherLedgerscanbedefinedifneededScenariosactivatedinledgertocaptureupdatesinNewG/L22NewGeneralLedgerSet-up/LessonsLearned–LedgerDefinition/ScenariosConfigurationStep:AssignScenariostoLedgerAllscenariosapplicableassignedsoastoupdateNewG/Lwithallrelevantpostings23NewGeneralLedgerSet-up/LessonsLearned–LedgerDefinition/ScenariosLessonLearned:GivenscopeandheavyuseofBI,userstrendingtowardsNewG/Lforreporting24AgendaOverviewProjectOverview/ScopeKeyClientRequirementsNewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructuresConclusions25NewGeneralLedgerSet-up/LessonsLearned–ProfitCentersinNewG/LKeyBusinessRequirements:FullybalancedbalancesheetandP/Lbyoperatingunit(majordivisionofthebusiness)Partialbalancesheet(WorkingCapital)andfullP/LbybranchProfitCentersdefinedforBranchreportingSegmentisderivedbyProfitCenterAllpostinglineitemsmustidentifyaprofitcenterinordertoensurefullsetoffinancialstatementsbySegmentProfitcentersusedinNewG/L;ProfitCenterAccountingisnolongerupdated26NewGeneralLedgerSet-up/LessonsLearned–ProfitCentersinNewG/LProfitCentersinNewG/LWithNewG/L,ProfitCenterAccountingnotused–ProfitCentersareafieldwithintheledgerGLPCA,GLPCT,etc.tablesnolongerupdatedCEPCtablestillstoremasterdatainformationandoriginaltransactionsstillusedtocreate,change,etc.27NewGeneralLedgerSet-up/LessonsLearned–ProfitCentersinNewG/LConfigurationStep:ControllingAreaSettings–DoNotActivateProfitCenterAccounting28NewGeneralLedgerSet-up/LessonsLearned–ProfitCentersinNewG/LConfigurationStep:AssignProfitCenterScenariotoLedgerActivatingtheProfitCenterscenarioallowsforpopulationofProfitCentersusingNewG/L29NewGeneralLedgerSet-up/LessonsLearned–ProfitCentersinNewG/LMasterDataStep:DefineProfitCentersProfitCentersmaintainedusingtransactionsusedinProfitCenterAccounting30NewGeneralLedgerSet-up/LessonsLearned–ProfitCentersinNewG/LLessonLearnedLackofavailabilityofsub-ledgerdetailNewG/L(i.e.vendors,customers,assets,etc.)ResolutionTwostandardSAPreportsprovidedforreceivablesandpayablesforSegment/ProfitCenterSolutionbeingaddressedwithinBI31AgendaOverviewProjectOverview/ScopeKeyClientRequirementsNewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructuresConclusions32NewGeneralLedgerSet-up/LessonsLearned–SplittingKeyBusinessRequirements:FullybalancedbalancesheetandP/LbyoperatingunitPartialbalancesheet(WorkingCapital)andfullP/LbybranchPartialbalancesheet(WorkingCapital)andP/LtogrossmarginbyCommodityCodeandManufacturerSplittingusedaspartofNewGeneralLedger33NewGeneralLedgerSet-up/LessonsLearned–SplittingSplitting:SplittingisthemostimportantaspectofconfigurationofNewG/LrelatingtohowfieldsarepopulatedZero-balancingneedsandrequiredfieldsdefinedinSplittingTwokeyaspectsforanytransaction:whatlineitemsare“spoon-fed”andwhatlineitemsaresplitTwokeyviewstoanytransaction:EntryViewandSplittingView34NewGeneralLedgerSet-up/LessonsLearned–SplittingConfigurationStep:IdentifySplittingCharacteristicsFieldstobesplitmustbeidentifiedinthisstepAnyzero-balancingfieldsmustbeidentified(Segment)Anyfieldswhichshouldalwaysbepopulatedaftersplittingoccursmustbeidentified(ProfitCenter)35NewGeneralLedgerSet-up/LessonsLearned––SplittingConfigurationStep:ClassifyDocumentTypesforSplittingAllDocumentTypesbeingusedmustbeassignedEachDocumentTypeismappedtoaBusinessTransactionandaVariantTheTransactionTypeandVarianttellsplittingwhatG/LaccountsshouldsplitandwhatG/Laccountsare““spoon-fed””values36NewGeneralLedgerSet-up/LessonsLearned––SplittingConfigurationStep:ClassifyDocumentTypesforSplittingAllG/LaccountsbeingpostedaremappedtoanItemCategory37NewGeneralLedgerSet-up/LessonsLearned––SplittingConfigurationStep:DefineDocumentSplittingMethodRulesInSplittingMethodconfiguration,eachBusinessTransaction(combinedwiththevariant)istoldwhatitemcategoriesarebeingsplit……38NewGeneralLedgerSet-up/LessonsLearned––SplittingConfigurationStep:DefineDocumentSplittingMethodRulesAndforeachitemcategorybeingsplit,thebasis(baseItemCategoriesonwhichsplittingistooccur)isdefined39NewGeneralLedgerSet-up/LessonsLearned––SplittingOtherKeyConfigurationItems:DefineZero-BalanceClearing––azero-balanceclearingaccountisdefinedforallcharacteristicsrequiringbalancedentries(Segment)DefineDefaultValues––Forcharacteristicsbeingsplit,defaultvaluesaredefinedfortransactionswhereitisnotpossibletodeterminecorrectsplitting40NewGeneralLedgerSet-up/LessonsLearned––SplittingLessonLearnedStandardsplittingmethod(method12)definedbySAPandrecommendedforusedidnotperformasexpectedResolutionCustommethodcreatedbasedonSAP-deliveredmethod2(minorchangesrequired)OtherLessonsLearnedPervasivenessofSplittingVariationsindocumentprocessingcanrequiredifferentDocumentTypesFieldstatusmustbesetto““optional””onaccountsforwhichcharacteristicsarebeingsplit41NewGeneralLedgerSet-up/LessonsLearned––SplittingExampleJournalEntry––VendorInvoice““EntryView””TwoviewsofNewG/Laccountingdocumentswithsplitting:EntryViewandGeneralLedgerViewEntryViewshowsthedocumentasitwasenteredinthesystem42NewGeneralLedgerSet-up/LessonsLearned––SplittingExampleJournalEntry––VendorInvoice““GeneralLedgerView”GeneralLedgerViewshowsthedocumentaftersplittingwasperformed43AgendaOverviewProjectOverview/ScopeKeyClientRequirementsNewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructuresConclusions44NewGeneralLedgerSet-up/LessonsLearned––Allocations/StatisticalKeyFiguresKeyBusinessRequirements:Partialbalancesheet(WorkingCapital)andfullP/LbybranchPartialbalancesheet(WorkingCapital)andP/LtogrossmarginbyCommodityCodeandManufacturer(thekeyrequirementforNewG/Lwithcustomfields)Abilitytoallocatedata(bothBalanceSheetandP/Ldata)betweenProfitCentersandcustomfieldsneededStatisticalinformation(i.e.headcount,squarefootage,etc.)neededtoberecordedbyProfitCentersandcustomfields45NewGeneralLedgerSet-up/LessonsLearned––Allocations/StatisticalKeyFiguresAllocations/StatisticalKeyFiguresDistribution/AssessmentfunctionalityprovidedwithinNewG/LAllocationsmayormaynotuseStatisticalKeyFiguresasabasisforallocationAllocations(assessmentsanddistributions)andpostingStatisticalKeyFiguresfunctionsimilarlyinNewG/LastheydoinCO-CCA46NewGeneralLedgerSet-up/LessonsLearned–Allocations/StatisticalKeyFiguresConfigurationStep:AssignCustomFieldstoNewG/LStatisticalKeyFigureTotalsTableAseparatetotalstableisusedforstoringStatisticalKeyFiguresinNewG/L–thecustomfieldsmustbeaddedtoit47NewGeneralLedgerSet-up/LessonsLearned–Allocations/StatisticalKeyFiguresConfigurationStep:DefineFieldUsageforAllocationsCustomFieldsmustbedefinedforusewithinNewG/Lallocations48NewGeneralLedgerSet-up/LessonsLearned–Allocations/StatisticalKeyFiguresLessonLearnedNewG/LallocationsbetweencostcentersandNewG/LStatisticalKeyFigurepostingstocostcenterswillnotupdateCOResolutionAlltransactionsinvolvingcostcentersshouldbegeneratedfromwithinCostCenterAccounting–withtheCostCenterUpdatescenarioactivated,NewG/LisupdatedLessonLearnedNewG/Lallocationsdonotupdateledgerwithdetailedcycledata49AgendaOverviewProjectOverview/ScopeKeyClientRequirementsNewGeneralLedgerSet-up/LessonsLearnedCustomFieldsSegmentvs.BusinessAreaLedgerDefinition/ScenariosProfitCentersinNewG/LSplittingAllocations/StatisticalKeyFiguresFI/COReal-timeIntegrationTechnicalStructuresConclusions50NewGeneralLedgerSet-up/LessonsLearned–FI/COReal-timeIntegrationKeyBusinessRequirements:FI/COtoalwaysreconcileClientwantedFI/COonreal-timebasistoalwaysbalancetoavoidconfusionCostCenterAccountingsettoupdateinNewG/LinordertoallowupdateinNewG/LusingexistingCoAHigh-levelofFI/COreconciliationneeded51NewGeneralLedgerSet-up/LessonsLearned–FI/COReal-TimeReconciliationFI/COReal-TimeReconciliationReconciliationmovesfromReconciliationLedgerrunmonthlytoreal-timebasisLevelofreconciliationenhancedReconciliationrunsautomatically52NewGeneralLedgerSet-up/LessonsLearned–FI/COReal-timeIntegrationConfigurationStep:ActivateReal-timeIntegrationandDefineReconciliationLedgerAccountDeterminationVariouslevelsofreconciliationarepossible;accountdeterminationcanoccur:AttheoveralllevelByCOtransactionBysecondarycostelement(usessubstitutionrule)53NewGeneralLedgerSet-up/LessonsLearned–FI/COReal-timeIntegrationConfigurationStep:DefineReconciliationAccountSubstitutionOverallFI/COreconciliationaccountdefinedandusedasprerequisiteforsubstitutionCustomer-defineduserexitbranchestocustomtablewhichstoresrelationships54NewGeneralLedgerSet-up/LessonsLearned–FI/COReal-timeIntegrationMasterDataStep:DefineSecondaryCostElementtoPrimaryCostElementMappinginCustomTableIfnocustomtable,substitutionrulewouldhavenumberofstepscorrespondingtonumberofsecondarycostelements55NewGeneralLedgerSet-up/LessonsLearned–FI/COReal-timeIntegrationLessonLearnedInternalordersettlementtoG/Laccounts(whereordersreceivedallocations)requiredmappingofsecondarytoprimarycostelementsResolutionAllocationsstructureofInternalOrderexpandedtoincludemappingExtensiveuseofExternalSettlementcostelements56AgendaOverviewProjectOverview/Sc