This SAP Trial balance tutorial contains the reference data about its menu path, tcodes, tables, table fields, function modules, SAP components
SAP Trial balance Tcodes
Here is a list of possible transaction codes dealing with trial balance in SAP.
- FACTS 2: Trial Balance – RFACTS2_BL
- FACTS 1: Trial Balance – RFACTS1_BL
- Trial Balance: Guarantees – S_ALR_87101104
- Trial Balance Tie-Points – FMFG_E_TP1
- Trial Balance: Security Deposits – S_ALR_87101090
- Trial Balance: Bills Receivable – S_ALR_87101098
- Trial Balance: Down Payments Made – S_ALR_87101088
- G/L Account Balance – FS10
- Balance Carryforward – SOACARRYFORWARD
- Balance Sheet/P+L – S_ALR_87009837
- MM/FI Balance Comparison – S_P6B_12000136
- Balance Sheet/P+L – S_ALR_87009836
- Balance Sheet/P+L – S_ALR_87009822
- Balance Carryforward – IPMCARRYFORWARD
- Material Balance – /GBT/NW_MB
- Balance Carryforward – ACACCARRYFORWARD
- Balance Sheet/P+L – S_ALR_87009821
- MCA Balance Carryforward – GMCA_BCF
- Empties Balance – /BEV1/EMA
- Set account balance to zero – FMBLEXT0
SAP Trial balance Tables
Here is a list of possible system tables storing trial balance related data in SAP.
- Balance Key: Texts – BROK_SALDKEY
- Balance Key Assignment – Transactions – BROK_SALD_CUST
- AR Balance categories (TBLRD044) – OIUH_AR_BAL
- Customizing for Balance Translation – FAGL_T030TR
- Nomination Material Balance – OIJNOMM
- Balance of Dummy Bank – EPIC_DUM_BAL
- Balance sheet indicator – TW11
- FI documents with FM to BL balance information – FMTOBL
- Line balance items – LDLBP
- Account Balance Roles – TFK021_ROLES
- Taxes Payable Balance – OIUX4_BALANCE
- MMS-2014 – Recoupable Balance – OIUREP_RECOUP
- Run for Balance Sheet Values by Account – MYLAUFHD
- Summarization: Balance Carryforward for P&L Accounts – FAGL_BCF_FIELDS
- FM: Permitted Activities for Balance Carryforward – FMCFB_VRGNG
- TP Balance Categories – Text tabe – OIUX4_BAL_CTGTX
- Ledgers for zero-balance follow-on documents – FAGL_SP_LDGR_OIM
- Account Balance: Current Snapshot – TFK021_SNAP
- Account Balance Role Description – TFK021_ROLEST
- Ledgers for zero-balance follow-on documents – FAGL_LEDGER_OIM
Trial balance Menu path in SAP
Here is the possible menu path to access trial balance menu in SAP.
Accounting – Financial Accounting – Fixed Assets – Information System – Reports on Asset Accounting – Asset Balances – Balance Lists –
Information Systems – Accounting – Financial Accounting – Fixed Assets – Asset Accounting Information System – Asset Balances – Balance Lists –
Accounting – Investment Management – Assets – Information System – Reports on Asset Accounting – Asset Balances – Balance Lists –
Logistics – Production – Master Data – Line Design – Line Balance –
Accounting – Financial Accounting – Banks – Environment – Check balance –
Table Fields with Trial balance data
Here is a list of possible table fields which may be used for storing trial balance related data in SAP.
- SSTYP – Beginning balance type (F=begin balance, M=interim balance)
- ESTYP – Ending balance type (F=ending balance, M=interim balance)
- SHKZG_UMSV – Indicator: Total Balance, Debit Balance or Credit Balance?
- TRIALDATE – Trial Date
- MUSTER_P – IS-M: Number of Samples for Trial Runs (Ad Insert)
- TF_INDICATOR – Trial/Final Indicator
- TF_INDICATOR_YN – Trial/Final Indicator (Yes/No)
- TF_IND – Tax Reporting – Trial/Final Indicator
- TF_CAPABLE – Tax Reporting – Trial/Final Capable
- PEEND – Employment contract: End date of trial period
- .INCLU–AP – Additional Data for Trial Management
- TRIALID – Trial Number
- ANZPROBPLN – Number of Planned Trial Items
- ANZPROBIST – Actual Number of Trial Items
- ANZETPROBE – Number of Publication Days for Trial or Free Item
- BAL_TYPE – GL: Type of New Balance for Balance Sheet Preparation
- BAL_OLD_AMNT – Old Balance for Balance Sheet Preparation
- BALANCE – Balance Shown in the Balance Notification (Account Currency)
- SALDO – Balance Notification – Balance Determined in Transact. Crcy
- SALDO_C – Balance Notification – Balance at Customer in Transact. Crcy
Function Modules for Trial balance in SAP
Here is a list of possible function modules which may be used with trial balance related processes in SAP.
- /CCEE/SIFI_WGL_RFGLBALANCE – G/L Account Balance Display
- /FSCAA/BAPI_AM_GET_BALANCE – Get the account balance
- /ORS/000007_PO_CALC_BALANCE – Calculate the Balance
- /SAPPSSRM/ENABLEBUTTON – Display Synopsis Status after Populating Audit and Trial Tables
- /SAPPSSRM/READ_AUDITTRAIL – Select Different Dataset from Audit Trial Table
- ACCBAL_POSTDATA_CLOSE – Close Account Balance Object
- ACCBAL_S_MAINTAIN – Display Account Balance
- ANLH_UPDATE_LANEP – Update LANEP, for AuC settlement with a balance of zero
- BAPI_ACCSTMT_CREATEFROMBALANCE – Store account balance/check debit information
- BAPI_AP_ACC_GETCURRENTBALANCE – Vendor Account Closing Balance in Current Fiscal Year
- BAPI_AP_ACC_GETKEYDATEBALANCE – Vendor Account Balance at Key Date
- BAPI_AR_ACC_GETCURRENTBALANCE – Closing balance of customer account in current fiscal year
- BAPI_AR_ACC_GETKEYDATEBALANCE – Customer account balance at a key date
- BAPI_BKK_ACCNT_GETLIST_KEYDT – Get Account Master and Balance Details for an Account
- BAPI_BKK_BALNOT_CREATE_SINGLE – Create Balance Notification
- BAPI_BKK_GET_ACCNT_RNG_KEYDT – Get Account Master Data and Key Date Balance Details
- BAPI_BKK_PARTNER_GETLIST_KEYDT – Get Account Master and Balance Details for a Business Partner
- BAPI_CTRACCONTRACTACCOUNT_GBAL – BAPI: FI-CA Read Account Balance
- BAPI_GL_ACC_GETBALANCE – Closing balance of G/L account for chosen year
- BAPI_GL_ACC_GETCURRENTBALANCE – Closing balance of G/L account for current year
Trial balance handling Components in SAP
Here is a list of possible components / sub modules which may be dealing with trial balance related processes in SAP. List contains sub module name, then containing component and description.
- PLM-RM-TRL – ALN0000492 – Trial Management
- FI-GL-CP-COM-BR – HLA0001218 – Balance Reconciliation
- FI-LC-LC-SRV-BCF – HLA0001248 – Balance Carryforward
- FI-SL-SL-BC – HLA0001343 – Balance Carryforward
- IS-EC-PRC-JVA – KA50002489 – Project Balance Sheet
- FI-CA-BF-AD – I210007330 – Account Balance Display
- FS-CML-AC-PO-TR – HLA0100084 – Balance Sheet Transfer
- FI-BL-BM – HLA0100018 – Cash Balance Management
- FI-GL-GL-ADB – XCG0000002 – Average Daily Balance
- FI-CA-BT-IC – I210007316 – Account Balance Interest Calculation
- MM-IM-VP – HLA0009514 – Balance Sheet Valuation Procedures