Summary of "SAP FICO ENGLISH: GL Master upload using LSMW - Part 1 (BS Accounts)"

Summary of the Video:

"SAP FICO ENGLISH: GL Master upload using LSMW - Part 1 (BS Accounts)"

This video is a detailed tutorial on how to upload General Ledger (GL) Master data into SAP using the LSMW (Legacy System Migration Workbench) tool, specifically focusing on Balance Sheet (BS) accounts. It explains the preparatory steps, the methodology of creating GL accounts manually, recording the transaction for LSMW, preparing the upload template, and initial steps of the LSMW project setup.

Main Ideas and Concepts:

  1. GL Master Data Segregation:
    • GL accounts must be classified into two main categories:
      • Balance Sheet (BS) accounts (Assets and Liabilities)
      • Profit & Loss (P&L) accounts (Income and Expenses)
    • Assets will be uploaded using LSMW.
    • Liabilities will be uploaded using LTMC (a different tool), highlighting practical differences.
  2. Understanding GL Master Data Structure:
    • GL Master data has two main segments:
      • Chart of Accounts segment (stored in table SKA1)
      • Company Code segment (stored in table SKB1)
    • GL accounts must exist at the Chart of Accounts level before they can be created at the Company Code level.
  3. Manual Creation of GL Account (FS00 Transaction):
    • Before automating with LSMW, understand manual GL account creation.
    • Key fields for GL account creation:
      • GL Account Number
      • Company Code
      • Account Type (Balance Sheet or P&L)
      • Account Group (defines characteristics and controls)
      • Short Text and Long Text (descriptions)
      • Currency (default company code currency or foreign currency)
      • Reconciliation Account Indicator (important for reconciliation accounts)
      • Open Item Management (optional)
      • Sort Key (used in reporting and automatic assignment during postings)
      • Field Status Group (controls field behavior during postings)
  4. Differences in GL Account Types in S/4HANA:
    • P&L accounts are further classified into:
      • Non-operating Expense/Income (FI only)
      • Primary Cost or Secondary Cost (FI + CO integration)
    • Balance Sheet accounts are identified by a unique identifier (e.g., "X").
  5. LSMW Recording for GL Master Upload:
    • Use transaction FS01 for recording, NOT FS00.
    • LSMW recording captures all relevant fields for GL account creation.
    • Avoid unnecessary key presses (e.g., avoid pressing Enter on keyboard, use SAP’s Enter button).
    • Save the recording immediately after creation to avoid loss.
    • The recording should include all scenarios and fields relevant to your GL accounts, including reconciliation indicators.
  6. Creating the Upload Template:
    • Extract field names from the LSMW recorded screen (highlighted in orange).
    • Copy field names and sample data into Excel.
    • Use Excel’s Paste Special > Transpose feature to convert vertical field names to horizontal format.
    • Prepare the upload file by filling in actual GL account data:
      • GL Account Number
      • Company Code
      • Short and Long Text (respecting character limits: 20 for short, 50 for long)
      • Balance Sheet indicator (X for BS accounts)
      • Account Group (must be code, not description)
      • Currency (usually company code currency)
      • Reconciliation account indicator (D for customer, A for vendor, blank if not applicable)
      • Line item indicator (checkbox, X or blank)
      • Sort key (used in reporting)
      • Field status group
    • Save the Excel data as a text file (.txt) for LSMW upload.
    • Ensure no extra blank lines or trailing spaces in the text file (remove with a single backspace if needed).
  7. LSMW Project Setup Steps:
    • Create a new LSMW project, subproject, and object (naming convention: start with “Z”).
    • Define object attributes.
    • Create batch input recording using FS01.
    • Define source structure (different from project name).
    • Define source fields and assign appropriate field lengths based on data type.
    • Define structure relations (usually default).
    • Define field mapping and conversion rules (use auto field mapping).
    • (Note: The video ends with auto field mapping step facing some system slowness; continuation planned in next session.)
  8. Important Tips:
    • Always start custom objects and projects with “Z” to differentiate from standard SAP objects.
    • Use the SAP GUI option “Customize Local Layout > Options > Interaction Design” to enable visualization of identification codes (N, P, S, X) for account types.
    • When recording, avoid unnecessary clicks or keystrokes that may

Category ?

Educational

Share this summary

Summarize another video

Video