- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- ACR Activities (FI-LOC-VAT)
- Audit Reporting (FI-LOC-AUR)
- Cash Flow Localization (FI-LOC-CF)
- Cash Management (FI-LOC-CM)
- Contract Accounts Receivable and Payable (FI-LOC-CA)
- Corporate Income Tax Framework (FI-LOC-CIT)
- Globalization Service: Business Place (FI-LOC-BUP)
- Golden Audit Interface (FI-LOC-GAI)
- Localization Asset Accounting (FI-LOC-AA)
- Localization E-Payment Integration (FI-LOC-EPI)
- Localization Financials (FI-LOC-FI)
- Financials Arabic Emirates (FI-LOC-FI-AE)
- Financials Argentina (FI-LOC-FI-AR)
- Financials Austria (FI-LOC-FI-AT)
- Financials Belgium (FI-LOC-FI-BE)
- Financials Brazil (FI-LOC-FI-BR)
- Financials Chile (FI-LOC-FI-CL)
- Financials China (FI-LOC-FI-CN)
- Financials Colombia (FI-LOC-FI-CO)
- Financials Czech Republic (FI-LOC-FI-CZ)
- Financials Denmark (FI-LOC-FI-DK)
- Financials Egypt (FI-LOC-FI-EG)
- Financials France (FI-LOC-FI-FR)
- Financials Germany (FI-LOC-FI-DE)
- Financials Great Britain (FI-LOC-FI-GB)
- Financials Hungary (FI-LOC-FI-HU)
- Financials Indonesia (FI-LOC-FI-ID)
- Financials Ireland (FI-LOC-FI-IE)
- Financials Israel (FI-LOC-FI-IL)
- Financials Italy (FI-LOC-FI-IT)
- Financials Japan (FI-LOC-FI-JP)
- Financials Kazakhastan (FI-LOC-FI-KZ)
- Financials Luxembourg (FI-LOC-FI-LU)
- Financials Malaysia (FI-LOC-FI-MY)
- Financials Mexico (FI-LOC-FI-MX)
- Financials Netherlands (FI-LOC-FI-NL)
- Financials New Zealand (FI-LOC-FI-NZ)
- Financials Norway (FI-LOC-FI-NO)
- Financials Peru (FI-LOC-FI-PE)
- Financials Philippines (FI-LOC-FI-PH)
- Financials Poland (FI-LOC-FI-PL)
- Financials Portugal (FI-LOC-FI-PT)
- Financials Qatar (FI-LOC-FI-QA)
- Financials Romania (FI-LOC-FI-RO)
- Financials Russia (FI-LOC-FI-RU)
- Financials Singapore (FI-LOC-FI-SG)
- Financials Slovak republic (FI-LOC-FI-SK)
- Financials Slovenia (FI-LOC-FI-SI)
- Financials South Korea (FI-LOC-FI-KR)
- Financials Spain (FI-LOC-FI-ES)
- Financials Sweden (FI-LOC-FI-SE)
- Financials Switzerland (FI-LOC-FI-CH)
- Financials Taiwan (FI-LOC-FI-TW)
- Financials Thailand (FI-LOC-FI-TH)
- Financials Turkey (FI-LOC-FI-TR)
- Financials USA (FI-LOC-FI-US)
- Financials Ukraine (FI-LOC-FI-UA)
- Financials Venezuela (FI-LOC-FI-VE)
- Localization Financials (generic parts) (FI-LOC-GEN)
- Localization Financials EC Sales List (FI-LOC-ECS)
- Localization Financials Statements (FI-LOC-FS)
- Localization Funds Management (FI-LOC-FM)
- Localization Logistics (FI-LOC-LO)
- Localization for Utilities Industry (FI-LOC-UT)
- Payment Receipt (FI-LOC-PR)
- SAF-T Reporting (Generic Part) (FI-LOC-SAF)
- Statutory Reporting (FI-LOC-IS)
- Statutory Reporting Framework (FI-LOC-SRF)
- Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_StRpTrialBalanceItemQuery
Trial Balance Query
| view: CSTRPTRIBALITEMQ
| Extraction:
Not supported
| Component: Localization Financials
Tables used:
SCAL_TT_DATE, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, T004, KNA1, SKA1, SKB1, LFA1, SKAT, T004, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
- 🔑 Keys
- 💰 Amounts (36)
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical (3)
- Other (6)
- 🔗 Relations (15)
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Transaction Currency (TransactionCurrency): | ||
| CarryFwdBalAmtInCCCrcy | Carry Forward Balance Amount in Company Code Currency | |
| CarryFwdBalanceAmtInTransCrcy | Carry Forward Balance Amount in Transaction Currency | |
| DebitCarryFwdBalAmtInTransCrcy | Debit Carry Forward Balance Amount in Transaction Currency | |
| CrdtCarryFwdBalAmtInTransCrcy | Credit Carry Forward Balance Amount in Transaction Currency | |
| PrevPerdYTDAmountInTransCrcy | Previous Period YTD Amount in Transaction Currency | |
| DebitPrevPerdYTDAmtInTransCrcy | Debit Previous Period YTD Amount in Transaction Currency | |
| CrdtPrevPerdYTDAmtInTransCrcy | Credit Previous Period YTD Amount in Transaction Currency | |
| StartingBalanceAmtInTransCrcy | Starting Balance Amount In Transaction Currency | |
| DebitStartingBalAmtInTransCrcy | Debit Starting Balance Amount in Transaction Currency | |
| CrdtStartingBalAmtInTransCrcy | Credit Starting Balance Amount in Transaction Currency | |
| AmountInTransactionCurrency | Amount in Transaction Currency | |
| DebitAmountInTransCrcy | Debit Amount in Transaction Currency | |
| CreditAmountInTransCrcy | Credit Amount in Transaction Currency | |
| YrToDteAmtInTransacCrcy | Year to Date Amount in Company Code Currency | |
| YTDDebitAmtInTransCrcy | Debit Year to Date Amount in Transaction Currency | |
| YTDCrdtAmtInTransCrcy | Credit Year to Date Amount in Transaction Currency | |
| EndingBalanceAmtInTransCrcy | Ending Balance in Company Code Currency | |
| DebitEndingBalAmtInTransCrcy | Debit Ending Balance Amount in Transaction Currency | |
| CreditEndingBalAmtInTransCrcy | Credit Ending Balance Amount in Transaction Currency | |
| 💲 Company Code Currency (CompanyCodeCurrency): | ||
| DebitCarryFwdBalAmtInCCCrcy | Debit Carry Forward Balance Amount in Company Code Currency | |
| CreditCarryFwdBalAmtInCCCrcy | Credit Carry Forward Balance Amount in Company Code Currency | |
| PrevPeriodYTDAmtInCCCrcy | Previous Period YTD Amount in Company Code Currency | |
| DebitPrevPeriodYTDAmtInCCCrcy | Debit Previous Period YTD Amount in Company Code Currency | |
| CreditPrevPeriodYTDAmtInCCCrcy | Credit Previous Period YTD Amount in Company Code Currency | |
| StartingBalanceAmtInCoCodeCrcy | Starting Balance in Company Code Currency | |
| DebitStartingBalAmtInCCCrcy | Debit Starting Balance Amount in Company Code Currency | |
| CreditStartingBalAmtInCCCrcy | Credit Starting Balance Amount in Company Code Currency | |
| AmountInCompanyCodeCurrency | Amount in Company Code Currency | |
| DebitAmountInCoCodeCrcy | Debit Amount in Company Code Currency | |
| CreditAmountInCoCodeCrcy | Credit Amount in Company Code Currency | |
| YTDAmtInLoclCrcy | Year to Date Amount in Company Code Currency | |
| YTDDebitAmtInCoCodeCrcy | Debit Year to Date Amount in Company Code Currency | |
| YTDCrdtAmtInCoCodeCrcy | Credit Year to Date Amount in Company Code Currency | |
| EndingBalanceAmtInCoCodeCrcy | Ending Balance in Company Code Currency | |
| DebitEndingBalAmtInCCCrcy | Debit Ending Balance Amount in Company Code Currency | |
| CreditEndingBalAmtInCCCrcy | Credit Ending Balance Amount in Company Code Currency | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PostingDate | Posting Date | |
| DocumentDate | Journal Entry Date |
| Column Name | Description | |
|---|---|---|
| FinancialAccountType | Account Type | Show values |
| AccountingDocumentCategory | Journal Entry Category | Show values |
| DebitCreditCode | Debit/Credit Code | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| StatryRptRunID | Report Run ID | SRF_REPORT_RUN_ID | |
| AccountingDocument | Journal Entry | BELNR | |
| LedgerGLLineItem | Ledger Journal Entry Item | DOCLN6 | |
| SupplierName | Name of Supplier | TEXT80 | |
| CustomerName | Name of Customer | TEXT80 | |
| GLAccountLongName | G/L Account Long Text | TEXT50 |
| Master Data Relations | Join Conditions |
|---|---|
Journal Entry Type
| |
Business Area
| |
Chart of Accounts
| |
Company Code
| |
Company Code Currency
| |
Customer Number
| |
G/L Account
| |
Ledger in General Ledger Accounting
|
|
Posting Key
| |
Source Ledger
|
|
Special G/L Indicator
| |
Reporting Entity
|
|
Supplier
| |
Tax on Sales/Purchases Code
| |
Transaction Currency
|