1、2022-7-26SAP新总账培训教程SAP新总账培训教程新总账培训教程SAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statistical Key Figures FI/CO Real
2、-time Integration Technical Structures ConclusionsSAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statistical Key Figu
3、res FI/CO Real-time Integration Technical Structures ConclusionsSAP新总账培训教程Overview Project Overview/Scope Client is a Fortune 500 Company and performs limited manufacturing Version being implemented is ECC 6.0 and BI 7.0 Initial implementation of SAP involves FI/CO for North America Entities in othe
4、r countries are implemented but only to load trial balance data Legacy systems interface sales and purchasing data/Phase II will implement SD,MM,and other functionality ECC Scope includes New G/L,A/P,A/R,AM,CO-CCA,and CO-OPA CO-PA initially considered but later removed from scope Currently in Testin
5、g phase(thorough unit testing completed)SAP新总账培训教程Overview Key Requirements Fully balanced balance sheet and P/L by legal entity Fully balanced balance sheet and P/L by operating unit(major division of the business)Partial balance sheet(Working Capital)and full P/L by branch Operating expenses by de
6、partment Partial balance sheet(Working Capital)and P/L to gross margin by Commodity Code and Manufacturer(the key requirement for New G/L with custom fields)Fully balanced balance sheet and P/L for logistical legal entity(done for tax purposes)FI/CO to always reconcileSAP新总账培训教程Agenda Overview Proje
7、ct Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statistical Key Figures FI/CO Real-time Integration Technical Structures ConclusionsSAP新总账培训教程New Gen
8、eral Ledger Set-up/Lessons Learned Custom FieldsKey Business Requirement:Partial balance sheet(Working Capital)and P/L to gross margin needed by Commodity Code and Manufacturer:Balance sheet data need key driver to use custom fields Two custom fields defined and added to G/L code block Two custom ch
9、eck-tables defined to store valid values for each field Check tables added to COBL structure to provide standard list display of valid values Additional validations defined to check valid Commodity Code/Manufacturer value combinations and validCommodity Codes/Profit Center combinationsSAP新总账培训教程New
10、General Ledger Set-up/Lessons Learned Custom FieldsCustom Fields:SAP ECC allows the addition of custom fields to the code block of the General Ledger Once added,these fields behave like other account assignment fields Fields can be without or with validationSAP新总账培训教程New General Ledger Set-up/Lesson
11、s Learned Custom Fields Configuration Step:Include Custom Fields to Code Block Step will regenerate all structures/programs to include custom fieldsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Custom Fields Configuration Step:Define Master Data Check For the custom fields,the master data chec
12、k tables(custom check tables created)must be defined(custom check tables still added to COBL)SAP新总账培训教程New General Ledger Set-up/Lessons Learned Custom Fields Other Key Configuration Steps Custom fields must be added to all Enjoy transactions Custom fields must be added to code block subscreen if ol
13、der G/L transactions are to be used Posting key/account field status-custom fields,upon generation become part of field status configuration,but initial setting is“hidden”SAP新总账培训教程New General Ledger Set-up/Lessons Learned Custom Fields Lessons Learned:Add check tables to COBL for drop-down function
14、ality BAPI extensions on G/L postings Custom fields working wellSAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statis
15、tical Key Figures FI/CO Real-time Integration Technical Structures ConclusionsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Key Business Requirements:Fully balanced balance sheet and P/L by operating unit(major division of the business)Partial balance sheet(Working Cap
16、ital)and full P/L by branch The Segment is included with New G/L Segment is derived by Profit Center(Profit Centers defined for Branch reporting)Balanced financial statements can be generated by Segment using Splitting functionality All posting line items must identify a profit center in order to en
17、sure full set of financial statements by SegmentSAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Business Area vs.Segment Both provide balanced financial statements(balance sheet and P/L)by reporting entity other than Company Code Segment offers SAP-delivered derivation f
18、rom Profit Center master record(validated“business”definition)Business Area not used due to derivation;Segment viewed as“cleaner”solutionSAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Configuration Step:Assign Segment Scenario to Ledger Activating the Segment scenario a
19、llows for population of Segment in New G/LSAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Configuration Step:Define Segments Define the list of Segments to be usedSAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Master Data Step:Specify Segmen
20、ts on Profit Center master records Profit Center specified on posting line will derive Segment from master recordSAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Configuration Step:Define Splitting Characteristics(Segment set to zero-balance)Splitting functionality drives
21、 balanced Segment reporting SAP新总账培训教程New General Ledger Set-up/Lessons Learned Segment vs.Business Area Lesson Learned Partner Segment derivation functioning mostly correctly except for inter-company transactions Resolution Custom program or user exit for Partner Segment derivation under investigat
22、ion as potential solution Lesson Learned Segment not available on all standard SAP reports Resolution Currently contacting SAP about this issueSAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Led
23、ger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statistical Key Figures FI/CO Real-time Integration Technical Structures ConclusionsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Ledger Definition/Scenarios Key Business Requirement:FI/CO to always be in balance Client v
24、ery sensitive to any potential out-of-balance points with reporting in FI/CO and Profit Centers Profit Center absorption in New G/L(and scope)resulting in client leaning towards New G/L for most reporting Cost Center Accounting sub-module“dangling”most cost center reporting performed within New G/L
25、Most scenarios activated for LedgerSAP新总账培训教程New General Ledger Set-up/Lessons Learned Ledger Definition/ScenariosLedger Definition:Leading Ledger delivered by SAP and used in New G/L Other Ledgers can be defined if needed Scenarios activated in ledger to capture updates in New G/LSAP新总账培训教程New Gene
26、ral Ledger Set-up/Lessons Learned Ledger Definition/Scenarios Configuration Step:Assign Scenarios to Ledger All scenarios applicable assigned so as to update New G/L with all relevant postingsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Ledger Definition/Scenarios Lesson Learned:Given scope a
27、nd heavy use of BI,users trending towards New G/L for reportingSAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statist
28、ical Key Figures FI/CO Real-time Integration Technical Structures ConclusionsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Profit Centers in New G/L Key Business Requirements:Fully balanced balance sheet and P/L by operating unit(major division of the business)Partial balance sheet(Working Cap
29、ital)and full P/L by branch Profit Centers defined for Branch reporting Segment is derived by Profit Center All posting line items must identify a profit center in order to ensure full set of financial statements by Segment Profit centers used in New G/L;Profit Center Accounting is no longer updated
30、SAP新总账培训教程New General Ledger Set-up/Lessons Learned Profit Centers in New G/LProfit Centers in New G/L With New G/L,Profit Center Accounting not used Profit Centers are a field within the ledger GLPCA,GLPCT,etc.tables no longer updated CEPC table still store master data information and original tran
31、sactions still used to create,change,etc.SAP新总账培训教程New General Ledger Set-up/Lessons Learned Profit Centers in New G/L Configuration Step:Controlling Area Settings Do Not Activate Profit Center AccountingSAP新总账培训教程New General Ledger Set-up/Lessons Learned Profit Centers in New G/L Configuration Step
32、:Assign Profit Center Scenario to Ledger Activating the Profit Center scenario allows for population of Profit Centers using New G/LSAP新总账培训教程New General Ledger Set-up/Lessons Learned Profit Centers in New G/L Master Data Step:Define Profit Centers Profit Centers maintained using transactions used i
33、n Profit Center AccountingSAP新总账培训教程New General Ledger Set-up/Lessons Learned Profit Centers in New G/L Lesson Learned Lack of availability of sub-ledger detail New G/L(i.e.vendors,customers,assets,etc.)Resolution Two standard SAP reports provided for receivables and payables for Segment/Profit Cent
34、er Solution being addressed within BISAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definition/Scenarios Profit Centers in New G/L Splitting Allocations/Statistical Key Figures FI/CO Rea
35、l-time Integration Technical Structures ConclusionsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Key Business Requirements:Fully balanced balance sheet and P/L by operating unit Partial balance sheet(Working Capital)and full P/L by branch Partial balance sheet(Working Capital)and P/L
36、 to gross margin by Commodity Code and Manufacturer Splitting used as part of New General LedgerSAP新总账培训教程New General Ledger Set-up/Lessons Learned SplittingSplitting:Splitting is the most important aspect of configuration of New G/L relating to how fields are populated Zero-balancing needs and requ
37、ired fields defined in Splitting Two key aspects for any transaction:what line items are“spoon-fed”and what line items are split Two key views to any transaction:Entry View and Splitting ViewSAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Configuration Step:Identify Splitting Character
38、istics Fields to be split must be identified in this step Any zero-balancing fields must be identified(Segment)Any fields which should always be populated after splitting occurs must be identified(Profit Center)SAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Configuration Step:Classify
39、 Document Types for Splitting All Document Types being used must be assigned Each Document Type is mapped to a Business Transaction and a Variant The Transaction Type and Variant tell splitting what G/L accounts should split and what G/L accounts are“spoon-fed”valuesSAP新总账培训教程New General Ledger Set-
40、up/Lessons Learned Splitting Configuration Step:Classify Document Types for Splitting All G/L accounts being posted are mapped to an Item CategorySAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Configuration Step:Define Document Splitting Method Rules In Splitting Method configuration,
41、each Business Transaction(combined with the variant)is told what item categories are being splitSAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Configuration Step:Define Document Splitting Method Rules And for each item category being split,the basis(base Item Categories on which split
42、ting is to occur)is definedSAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Other Key Configuration Items:Define Zero-Balance Clearing a zero-balance clearing account is defined for all characteristics requiring balanced entries(Segment)Define Default Values For characteristics being sp
43、lit,default values are defined for transactions where it is not possible to determine correct splittingSAP新总账培训教程New General Ledger Set-up/Lessons Learned Splitting Lesson Learned Standard splitting method(method 12)defined by SAP and recommended for use did not perform as expected Resolution Custom
44、 method created based on SAP-delivered method 2(minor changes required)Other Lessons Learned Pervasiveness of Splitting Variations in document processing can require different Document Types Field status must be set to“optional”on accounts for which characteristics are being splitSAP新总账培训教程New Gener
45、al Ledger Set-up/Lessons Learned Splitting Example Journal Entry Vendor Invoice“Entry View”Two views of New G/L accounting documents with splitting:Entry View and General Ledger View Entry View shows the document as it was entered in the systemSAP新总账培训教程New General Ledger Set-up/Lessons Learned Spli
46、tting Example Journal Entry Vendor Invoice“General Ledger View”General Ledger View shows the document after splitting was performedSAP新总账培训教程Agenda Overview Project Overview/Scope Key Client Requirements New General Ledger Set-up/Lessons Learned Custom Fields Segment vs.Business Area Ledger Definiti
47、on/Scenarios Profit Centers in New G/L Splitting Allocations/Statistical Key Figures FI/CO Real-time Integration Technical Structures ConclusionsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Allocations/Statistical Key Figures Key Business Requirements:Partial balance sheet(Working Capital)and
48、 full P/L by branch Partial balance sheet(Working Capital)and P/L to gross margin by Commodity Code and Manufacturer(the key requirement for New G/L with custom fields)Ability to allocate data(both Balance Sheet and P/L data)between Profit Centers and custom fields needed Statistical information(i.e
49、.headcount,square footage,etc.)needed to be recorded by Profit Centers and custom fieldsSAP新总账培训教程New General Ledger Set-up/Lessons Learned Allocations/Statistical Key Figures Allocations/Statistical Key Figures Distribution/Assessment functionality provided within New G/L Allocations may or may not
50、 use Statistical Key Figures as a basis for allocation Allocations(assessments and distributions)and posting Statistical Key Figures function similarly in New G/L as they do in CO-CCASAP新总账培训教程New General Ledger Set-up/Lessons Learned Allocations/Statistical Key Figures Configuration Step:Assign Cus