P_StRpTrialBalanceItem1

Trial Balance Line Item | view: PTRIALBALITEM1 | Extraction: Not supported | Component: Localization Financials
Tables used: SCAL_TT_DATE, ACDOCA, SKB1, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
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):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
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
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_STRPTRIALBALANCEITEM1.MANDT == T003.MANDT
  • P_STRPTRIALBALANCEITEM1.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • P_STRPTRIALBALANCEITEM1.MANDT == SKA1.MANDT
  • P_STRPTRIALBALANCEITEM1.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_STRPTRIALBALANCEITEM1.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Business Area
  • Client
  • P_STRPTRIALBALANCEITEM1.BUSINESSAREA == TGSB.GSBER
  • P_STRPTRIALBALANCEITEM1.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_STRPTRIALBALANCEITEM1.MANDT == T004.MANDT
  • P_STRPTRIALBALANCEITEM1.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_STRPTRIALBALANCEITEM1.MANDT == T001.MANDT
  • P_STRPTRIALBALANCEITEM1.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_STRPTRIALBALANCEITEM1.CONTROLLINGAREA == TKA01.KOKRS
  • P_STRPTRIALBALANCEITEM1.MANDT == TKA01.MANDT
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_STRPTRIALBALANCEITEM1.MANDT == T004.MANDT
  • P_STRPTRIALBALANCEITEM1.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Customer Number
  • Customer Number
  • Client
  • P_STRPTRIALBALANCEITEM1.CUSTOMER == KNA1.KUNNR
  • P_STRPTRIALBALANCEITEM1.MANDT == KNA1.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_STRPTRIALBALANCEITEM1.FISCALYEARVARIANT == T009.PERIV
  • P_STRPTRIALBALANCEITEM1.MANDT == T009.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • P_STRPTRIALBALANCEITEM1.MANDT == TFKB.MANDT
  • P_STRPTRIALBALANCEITEM1.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_STRPTRIALBALANCEITEM1.MANDT == SKB1.MANDT
  • P_STRPTRIALBALANCEITEM1.COMPANYCODE == SKB1.BUKRS
  • P_STRPTRIALBALANCEITEM1.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Posting Key
  • Client
  • Posting Key
  • P_STRPTRIALBALANCEITEM1.MANDT == TBSL.MANDT
  • P_STRPTRIALBALANCEITEM1.POSTINGKEY == TBSL.BSCHL
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • P_STRPTRIALBALANCEITEM1.CONTROLLINGAREA == CEPC.KOKRS
  • P_STRPTRIALBALANCEITEM1.MANDT == CEPC.MANDT
  • P_STRPTRIALBALANCEITEM1.[column in domain "DATBI"] == CEPC.DATBI
  • P_STRPTRIALBALANCEITEM1.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_STRPTRIALBALANCEITEM1.MANDT == FAGL_SEGM.MANDT
  • P_STRPTRIALBALANCEITEM1.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Special G/L Indicator
  • Client
  • Account Type
  • Special G/L Indicator
  • P_STRPTRIALBALANCEITEM1.MANDT == T074U.MANDT
  • P_STRPTRIALBALANCEITEM1.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_STRPTRIALBALANCEITEM1.SPECIALGLCODE == T074U.UMSKZ
Supplier
  • Client
  • Supplier
  • P_STRPTRIALBALANCEITEM1.MANDT == LFA1.MANDT
  • P_STRPTRIALBALANCEITEM1.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • P_STRPTRIALBALANCEITEM1.[column in domain "KALSM_D"] == T007A.KALSM
  • P_STRPTRIALBALANCEITEM1.MANDT == T007A.MANDT
  • P_STRPTRIALBALANCEITEM1.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_STRPTRIALBALANCEITEM1.MANDT == TCURC.MANDT
  • P_STRPTRIALBALANCEITEM1.TRANSACTIONCURRENCY == TCURC.WAERS