Transaction Codes Standard - Provided by SAP - will remain same for all the customers Custom - Developed by customer (Normally starts with Z) - is customer specific Enterprise Structure ( ABC Limited is a computer manufacturing company. Group (This will be taken care by Group Reporting module in SAP (Previosly called as SAP BPC) They manufacture Computers - HP Comp, Dell Comp, Laptops - HP Laptops, Dell, Samsung, Tabs -HP, Dell etc There are 2 legal entities (Company Codes in SAP) - ABC Automotives India Limited - Apr- Mar (Fiscal Year Variants) - ABC US Inc - Jan - Dec Trading Partner is required only for intercompany transactions (Company) ABC India has 3 plants - Common, Bengaluru, Mumbai, Kolkata (Logistics - Plants, Finance - Business Areas) ABC US has only 1 plant - New York ABC limited has below Departments in organization (Cost Centers) -ABC Limited ABC India Finance Production HR IT Sales Admin Stores Procurement Quality ABC US Finance HR IT Sales Admin Stores Procurement ABC limited want their Financial Reports (Balance Sheet, Profit & Loss, Cash Flow etc) at below level Group (ABC India + ABC US) Legal Entity (ABC India, ABC US) P/L - Product Level (Computer, laptop, Tabs) - Profit Centers P/L - Plant Level (Bengaluru, Mumbai, Kolkata, New York) - Business Areas Expenses - Department Level (HR, Admin, IT, etc) Cost Centers How many legal entities do a customer has? Out of these legal entities, how many we want to implement in SAP in current phase How many plants they have? What is there Finacial Year? What are their reporting requirements for Financial Statements? Computers (Segment) HP Computer (PC) Dell Computer (PC) Laptops HP Laptops (PC) Dell Laptops(PC) Tabs HP Tabs(PC) Dell Tabs(PC) Enterprise Structure Client Operating Concern (If CO-PA is being implemented) Controlling Areas (If CO module is implemented) Profit Centers Company Codes (Legal Entities - FI) Plants (Only when Logistics modules - MM/SD/PP are getting implemented) Cost Centers (Departments) Business Area Segment Variants 1. Chart of Accounts 2. Fiscal Year Variant 3. Posting Period Variant 4. Field Status Varaints Variant Principle 3 steps 1. Define the Varaint 2. Assign the Variant 3. Determine the Values Chart of Accounts (List of Accounts) - ABC Automotives India Limited - Apr- Mar (Fiscal Year Variants) - ABC US Inc - Jan - Dec In SAP, we have 3 different types of COA 1. Operational (Mandatory) 2. Group (Optional) 3. Country (Optional) 1 Operational GL - 1 Country GL N Operational GL - 1 Country GL Common COA (Operational) Benefits Uniformity Consolidation Maintenance Disadvantages COA Harmonization - This is must Local Reporting (Country COA) 1 Operational GL - 1 Country GL N Operational GL - 1 Country GL Different COA (Operational) Benefits Flexibility to adopt own COA Local Reporting (Country COA) Disadvantages Uniformity Consolidation - Group COA Maintenance IN 400000 Travel Expense 600000 US 131231 Travel Expense 600000 GL Accounts: Account Group Assets 2+++++ Current Assets 201000 - 204999 Fixed Assets 205000 - 209999 Liabilities 1+++++ Current Liabilities 101000 - 101999 Non Current Liabilities 102000 - 102999 Equities 103000 - 103999 Expenses 4+++++ Operational Expense 401000 - 401999 Non Operational Expenses 402000 - 402999 Revenues 3+++++ Operational Expense 301000 - 301999 Non Operational Expenses 302000 - 302999 GL Account Group Controls: 1. Number Range 2. Field Status 2020 (Closing Balance) B/S Assets AR 2000 Stock 5000 Bank 10000 Liabilities Share Capital 2000 Loans 2000 AP 5000 Retained Earning (before 2020) 4000 Retained Earning 8000 P/L Revenues 20000 Expenses 12000 Profit - 8000 2021 (Opening Balance) Assets AR 2000 Stock 5000 Bank 10000 Liabilities Share Capital 2000 Loans 2000 AP 1000 Retained Earning 12000 Fiscal Year Variant Financial Year Total 16 periods 12 normal periods 1 Apr- 12 Mar 1 Jan 12 Dec 4 Special Periods (Year End Adjustments - for closed Financial Years) 13 Management Adjustments 14 Audit related Adjustments 15 Tax related Adjustment 16 IFRS related adjustment 13/06/2021 6 2021 Fiscal can be Calender Year (Jan- Dec) Non Calender Year (Apr- Mar, Jul- Jun) Fiscal Year can be Year Dependent/ Year Specific Year Independent Posting Period Variant - is used to control which period is Open/ Closed. It helps in blocking the postings for closed periods Open Posting Periods are from 5th month 2021 to 6th month 2021 Field Status Varaint: It controls which field is mandatory/ optional for a particular GL H - Hidden/ Suppressed D - Display Only R - Required/ Mandatory O - Optional GL related to Bank GL related to Expense R/3 Presentation -----> Application ------> Database PC/ Laptop -----> SAP S/4 HANA 2020 ------> SAP HANA 2.0 Different -----> Different Screens ------> Different Tables to store the Database Applications Company Codes OX02 business Areas OX03 COA OB13 Field Status Variant OBC4 Configuration Master Data Transactions Reporting Max number of lines in A/C document is 999 Min number of line items in A/c document 2 2023: 100000000 100001000 2024: 100001001 CEO 999999999999 GM 999999999999 Manager 9999999 Sr Accountant 999999 Accountant 99999 Junior Accountant 9999 Unique Combination of Document is Document No Company Code Fiscal Year Transaction Code (FB50) ---> ABAP Code (BAPI/ BADI) ----> Tables (BKPF, ACDCOA) Fiori App --- ABAP Code (BAPI/ BADI) ----> Tables (BKPF, ACDCOA) Park & Post (Document Parking) Junior Accountants - are not allowed to post the transactions but they can park the transactions Reports in GL Accounting GL Balance Reporting FS10N/ FAGLB03 GL Line Items Reporting FBL3N/ FAGLL03 Park ---> Save as completed --->Post Original Document Expense Dr 1000 Bank Cr 1000 Reversal Expense Cr 1000 Bank Dr 1000 Negative Expense Dr -1000 Bank Cr -1000 Recurring Documents On 1st of every month, below accounting transactions should be posted automatically starting from 01/07/2021 to 31/12/2021 2021 10000 7000 2022 8000 Questions: FAGLL03 - Parked Items IND - Jan-Dec US - Jan - Dec Group CO Area: Jan-Dec For IND reporting in Apr-Mar, 1. Download the data of Apr-Mar from system and generate report outside SAP 2. Use Ledger concept to create reports in both - Jan-Dec (0L) as well as Apr-Mar (NL) 2020 - 1 Nov 2019 2 Dec 2019 3 Jan 2020 SAP FI: General Ledger A/c AP AR Asset Accounitng Bank Accounting Accounts Payables (AP) - All the Financial transactions related to Supplier/ Purchasing (Invoice from Supplier, Make the Payments, Supplier Debit Note etc) Accounts Receivables (AR) - All the Accounting transactions related to Customer/ Sales (Creating the Cust Invoice, Receiving Payments, Credit Notes etc) General Ledger Accoutning Configurations Master Data (GL, CC, PC) Transactional Data (FB50) Reporting (FAGLB03/ FS10N, FAGLL03/ FBL3N) Accounts Payables Configurations (Master Data - Vendor Ac Groups, Number Ranges, BP Groupings, Assign BP Grouping to Vendor Ac Group Master Data (Suppliers/ Vendors) Transactional Data (FB60) Reporting (FK10N, FBL1N) Accounts Receivables (Master Data - Customer Ac Groups, Number Ranges, BP Groupings, Assign BP Grouping to Customer Ac Group Configurations Master Data (Customers) Transactional Data (FB70) Reporting (FD10N, FBL5N) Customer/ Vendor Master Data Account Groups: Customer Domestic International Intercompany Account Groups: Vendor Domestic International Intercompany 3 segments in Customer Master 1. General Data - Name, Address (KNA1) 2. Company Code - Financial Data (KNB1) 3. Sales Area - Sales related information (KNVV) 3 segments in Vendor Master 1. General Data - Name, Address (LFA1) 2. Company Code - Financial Data (LFB1) 3. Purchaing Organization - Purchase related information (LFM1) Business Partner Table: BUT000: General Data BUT100: BP Roles Link table for link between BP and Cust/ Vendor CVI_CUST_LINK CVI_VEND_LINK BP No BP Name BP City BP Country Customer Vendor BUT000 BUT000 KNA1 KNA1 CVI_CUST_LINK CVI_VEND_LINK PARTNER NAME_ORG1 ORT01 LAND1 CUSTOMER VENDOR Step1: Pick all the lines from BUT000 Step2: Fetch the values of PARTNER, NAME_ORG1 and store in BP No and BP Name Fields Step3: Fetch the CUSTOMER from CVI_CUST_LINK by referencing BP GUID Step4: Fetch ORT01 and LAND1 from KNA1 by referencing CUSTOMER 10000 Customers 5000 Domestic 4950 Foreign 50 Group Financial Transactions in AP: 1. Supplier Invoice 2. Payments to Vendors 3. Debit/ Credit Notes 4. Advance Payments to Vendors Reports: FK10N, FBL1N Status of AP/ AR line items - Open - Payment not yet completely made/ Cleared - Full payment has been made Invoice Date, Invoice No, Name of Seller, Name of Buyer, Address, Tax No, Payment Term, Payment Method, Bank Details, Expense GL, Cost Center Financial Transactions in AR: 1. Customer Invoice 2. Payments from Customer 3. Debit/ Credit Notes 4. Advance Payments from Customer In ECC, for an accounting document - there were 2 important tables 1. BKPF: Document Header 2. BSEG: Document Line Items In S4, in addition to above 2 tables, there is a new table ACDOCA (Universal Journal table) Cleared Documents have 2 important fields 1. Clearing Document No 2. Clearing Date