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)

P_StRpTrialBalanceItem2

Trial Balance Line Item 2 | view: PTRIALBALITEM2 | Extraction: Not supported | Component: Localization Financials

Tables used: SCAL_TT_DATE, ACDOCA, SKB1, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (6)
💰 Amounts (72)
∑ Quantities
📅 Dates (2)
☰ Categorical (7)
Other (7)
🔗 Relations (31)

Column Name	Description
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
SourceLedger FK	Source Ledger
AccountingDocument	Journal Entry
LedgerGLLineItem	Ledger Journal Entry Item

Column Name	Description
💲 Company Code Currency (CompanyCodeCurrency):
CarryFwdBalAmtInCCCrcy	Carry Forward Balance Amount in Company Code Currency
PrevPeriodYTDAmtInCCCrcy	Previous Period YTD Amount in Company Code Currency
StartingBalanceAmtInCoCodeCrcy	Starting Balance in Company Code Currency
EndingBalanceAmtInCoCodeCrcy	Ending Balance in Company Code Currency
AmountInCompanyCodeCurrency	Amount in Company Code Currency
YTDAmtInLoclCrcy	Year to Date Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
CarryFwdBalanceAmtInTransCrcy	Carry Forward Balance Amount in Transaction Currency
PrevPerdYTDAmountInTransCrcy	Previous Period YTD Amount in Transaction Currency
StartingBalanceAmtInTransCrcy	Starting Balance Amount In Transaction Currency
AmountInTransactionCurrency	Amount in Transaction Currency
EndingBalanceAmtInTransCrcy	Ending Balance in Company Code Currency
YrToDteAmtInTransacCrcy	Year to Date Amount in Company Code Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
CarryFwdBalAmtInBalTransCrcy	Carry Forward Balance Amt in Balance Transaction Crcy
PrevPeriodYTDAmtInBalTransCrcy	Previous Period YTD Amount in Company Code Currency
StartingBalAmtInBalTransCrcy	Starting Balance in Company Code Currency
AmountInBalanceTransacCrcy	null
EndingBalanceAmtInBalTransCrcy	Ending Balance in Company Code Currency
YearToDateAmountInBalTransCrcy	Year to Date Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
CarryFwdBalanceAmtInGlobalCrcy	Carry Forward Balance Amount in Global Currency
PrevPerdYTDAmountInGlobalCrcy	Previous Period YTD Amount in Company Code Currency
StartingBalanceAmtInGlobalCrcy	Starting Balance in Company Code Currency
AmountInGlobalCurrency	null
EndingBalanceAmtInGlobalCrcy	Ending Balance in Company Code Currency
YearToDateAmountInGlobalCrcy	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
CarryFwdBalAmountInFDCrcy1	Carry Forward Balance Amount in Freely Defined Crcy 1
PrevPerdYTDAmountInFDCrcy1	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy1	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency1	null
EndingBalAmtInFreeDfndCrcy1	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy1	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
CarryFwdBalAmountInFDCrcy2	Carry Forward Balance Amount in Freely Defined Crcy 2
PrevPerdYTDAmountInFDCrcy2	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy2	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency2	null
EndingBalAmtInFreeDfndCrcy2	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy2	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
CarryFwdBalAmountInFDCrcy3	Carry Forward Balance Amount in Freely Defined Crcy 3
PrevPerdYTDAmountInFDCrcy3	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy3	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency3	null
EndingBalAmtInFreeDfndCrcy3	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy3	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
CarryFwdBalAmountInFDCrcy4	Carry Forward Balance Amount in Freely Defined Crcy 4
PrevPerdYTDAmountInFDCrcy4	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy4	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency4	null
EndingBalAmtInFreeDfndCrcy4	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy4	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
CarryFwdBalAmountInFDCrcy5	Carry Forward Balance Amount in Freely Defined Crcy 5
PrevPerdYTDAmountInFDCrcy5	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy5	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency5	null
EndingBalAmtInFreeDfndCrcy5	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy5	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
CarryFwdBalAmountInFDCrcy6	Carry Forward Balance Amount in Freely Defined Crcy 6
PrevPerdYTDAmountInFDCrcy6	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy6	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency6	null
EndingBalAmtInFreeDfndCrcy6	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy6	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
CarryFwdBalAmountInFDCrcy7	Carry Forward Balance Amount in Freely Defined Crcy 7
PrevPerdYTDAmountInFDCrcy7	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy7	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency7	null
EndingBalAmtInFreeDfndCrcy7	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy7	Year to Date Amount in Company Code Currency
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
CarryFwdBalAmountInFDCrcy8	Carry Forward Balance Amount in Freely Defined Crcy 8
PrevPerdYTDAmountInFDCrcy8	Previous Period YTD Amount in Company Code Currency
StrtgBalAmtInFreeDfndCrcy8	Starting Balance in Company Code Currency
AmountInFreeDefinedCurrency8	null
EndingBalAmtInFreeDfndCrcy8	Ending Balance in Company Code Currency
YearToDateAmountInFDCrcy8	Year to Date Amount in Company Code Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date
DocumentDate	Journal Entry Date

Column Name	Description
IsReversal	Indicator: Item is Reversing Another Item	Show values
IsReversed	Indicator: Item is Reversed	Show values
ReconciliationAccountType	Account is Reconciliation Account	Show values
FinancialAccountType	Account Type	Show values
AccountingDocumentCategory	Journal Entry Category	Show values
DebitCreditCode	Debit/Credit Code	Show values
ItemType	Line Item Type	Show values

Column Name	Description	Domain name
AccountingDocumentItem	Journal Entry Posting View Item	BUZEI
FiscalPeriod	Fiscal Period	POPER
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
CashJournalItemType	null
AssignmentReference	Assignment Reference	ZUONR
DocumentItemText	Item Text	TEXT50
IsSelected	null

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`P_STRPTRIALBALANCEITEM2.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `P_STRPTRIALBALANCEITEM2.MANDT == T003.MANDT`
Alternative G/L Account Number In Company Code Alternative Chart of Accounts for Country/Region Alternative G/L Account Number In Company Code Client	`P_STRPTRIALBALANCEITEM2.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL` `P_STRPTRIALBALANCEITEM2.ALTERNATIVEGLACCOUNT == SKA1.SAKNR` `P_STRPTRIALBALANCEITEM2.MANDT == SKA1.MANDT`
Balance Transaction Currency Balance Transaction Currency Client	`P_STRPTRIALBALANCEITEM2.BALANCETRANSACTIONCURRENCY == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Business Area Business Area Client	`P_STRPTRIALBALANCEITEM2.BUSINESSAREA == TGSB.GSBER` `P_STRPTRIALBALANCEITEM2.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`P_STRPTRIALBALANCEITEM2.CHARTOFACCOUNTS == T004.KTOPL` `P_STRPTRIALBALANCEITEM2.MANDT == T004.MANDT`
Company Code Company Code Client	`P_STRPTRIALBALANCEITEM2.COMPANYCODE == T001.BUKRS` `P_STRPTRIALBALANCEITEM2.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`P_STRPTRIALBALANCEITEM2.COMPANYCODECURRENCY == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`P_STRPTRIALBALANCEITEM2.CONTROLLINGAREA == TKA01.KOKRS` `P_STRPTRIALBALANCEITEM2.MANDT == TKA01.MANDT`
Alternative Chart of Accounts for Country/Region Alternative Chart of Accounts for Country/Region Client	`P_STRPTRIALBALANCEITEM2.COUNTRYCHARTOFACCOUNTS == T004.KTOPL` `P_STRPTRIALBALANCEITEM2.MANDT == T004.MANDT`
Customer Number Customer Number Client	`P_STRPTRIALBALANCEITEM2.CUSTOMER == KNA1.KUNNR` `P_STRPTRIALBALANCEITEM2.MANDT == KNA1.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`P_STRPTRIALBALANCEITEM2.FISCALYEARVARIANT == T009.PERIV` `P_STRPTRIALBALANCEITEM2.MANDT == T009.MANDT`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY1 == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY2 == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Client Freely Defined Currency 5	`P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT` `P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY5 == TCURC.WAERS`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY6 == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Freely Defined Currency 7 Client Freely Defined Currency 7	`P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT` `P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Freely Defined Currency 8 Client	`P_STRPTRIALBALANCEITEM2.FREEDEFINEDCURRENCY8 == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Functional Area Client Functional Area	`P_STRPTRIALBALANCEITEM2.MANDT == TFKB.MANDT` `P_STRPTRIALBALANCEITEM2.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Company Code Client	`P_STRPTRIALBALANCEITEM2.GLACCOUNT == SKB1.SAKNR` `P_STRPTRIALBALANCEITEM2.COMPANYCODE == SKB1.BUKRS` `P_STRPTRIALBALANCEITEM2.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`P_STRPTRIALBALANCEITEM2.GLOBALCURRENCY == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Source Ledger Ledger in General Ledger Accounting	`P_STRPTRIALBALANCEITEM2.MANDT == FINSC_LEDGER.MANDT` `P_STRPTRIALBALANCEITEM2.SOURCELEDGER == FINSC_LEDGER.RLDNR` `P_STRPTRIALBALANCEITEM2.LEDGER == FINSC_LEDGER.RLDNR`
Posting Key Posting Key Client	`P_STRPTRIALBALANCEITEM2.POSTINGKEY == TBSL.BSCHL` `P_STRPTRIALBALANCEITEM2.MANDT == TBSL.MANDT`
Profit Center Profit Center ? Controlling Area Client	`P_STRPTRIALBALANCEITEM2.PROFITCENTER == CEPC.PRCTR` `P_STRPTRIALBALANCEITEM2.[column in domain "DATBI"] == CEPC.DATBI` `P_STRPTRIALBALANCEITEM2.CONTROLLINGAREA == CEPC.KOKRS` `P_STRPTRIALBALANCEITEM2.MANDT == CEPC.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`P_STRPTRIALBALANCEITEM2.SEGMENT == FAGL_SEGM.SEGMENT` `P_STRPTRIALBALANCEITEM2.MANDT == FAGL_SEGM.MANDT`
Source Ledger Client Source Ledger Ledger in General Ledger Accounting	`P_STRPTRIALBALANCEITEM2.MANDT == FINSC_LEDGER.MANDT` `P_STRPTRIALBALANCEITEM2.SOURCELEDGER == FINSC_LEDGER.RLDNR` `P_STRPTRIALBALANCEITEM2.LEDGER == FINSC_LEDGER.RLDNR`
Special G/L Indicator Account Type Client Special G/L Indicator	`P_STRPTRIALBALANCEITEM2.FINANCIALACCOUNTTYPE == T074U.KOART` `P_STRPTRIALBALANCEITEM2.MANDT == T074U.MANDT` `P_STRPTRIALBALANCEITEM2.SPECIALGLCODE == T074U.UMSKZ`
Supplier Supplier Client	`P_STRPTRIALBALANCEITEM2.SUPPLIER == LFA1.LIFNR` `P_STRPTRIALBALANCEITEM2.MANDT == LFA1.MANDT`
Tax on Sales/Purchases Code ? Tax on Sales/Purchases Code Client	`P_STRPTRIALBALANCEITEM2.[column in domain "KALSM_D"] == T007A.KALSM` `P_STRPTRIALBALANCEITEM2.TAXCODE == T007A.MWSKZ` `P_STRPTRIALBALANCEITEM2.MANDT == T007A.MANDT`
Transaction Currency Transaction Currency Client	`P_STRPTRIALBALANCEITEM2.TRANSACTIONCURRENCY == TCURC.WAERS` `P_STRPTRIALBALANCEITEM2.MANDT == TCURC.MANDT`