C_NO_StRpTrialBalanceItemQuery

Norway Trial Balance Query | view: CNOSRTRLBALITEMQ | Extraction: Not supported | Component: Financials Norway
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
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
StartingBalanceAmtInCoCodeCrcy Starting Balance in Company Code Currency
EndingBalanceAmtInCoCodeCrcy Ending Balance in Company Code Currency
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
ReconciliationAccountType Account is Reconciliation Account Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
GLAccountLongName G/L Account Long Text TEXT50
CustomerName Name of Customer TEXT80
SupplierName Name of Supplier TEXT80
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_NO_STRPTRIALBALANCEITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_NO_STRPTRIALBALANCEITEMQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == T001.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == TCURC.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_NO_STRPTRIALBALANCEITEMQUERY.CONTROLLINGAREA == TKA01.KOKRS
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == TKA01.MANDT
Customer Number
  • Client
  • Customer Number
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == KNA1.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.CUSTOMER == KNA1.KUNNR
G/L Account
  • Client
  • Company Code
  • G/L Account
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == SKB1.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.COMPANYCODE == SKB1.BUKRS
  • C_NO_STRPTRIALBALANCEITEMQUERY.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • C_NO_STRPTRIALBALANCEITEMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_NO_STRPTRIALBALANCEITEMQUERY.LEDGER == FINSC_LEDGER.RLDNR
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == FINSC_LEDGER.MANDT
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • C_NO_STRPTRIALBALANCEITEMQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_NO_STRPTRIALBALANCEITEMQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == CEPC.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.PROFITCENTER == CEPC.PRCTR
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == FINSC_LEDGER.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_NO_STRPTRIALBALANCEITEMQUERY.LEDGER == FINSC_LEDGER.RLDNR
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • Account Type
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == T074U.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.SPECIALGLCODE == T074U.UMSKZ
  • C_NO_STRPTRIALBALANCEITEMQUERY.FINANCIALACCOUNTTYPE == T074U.KOART
Reporting Entity
  • Client
  • Reporting Entity
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == LFA1.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Client
  • Tax on Sales/Purchases Code
  • ?
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == T007A.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.TAXCODE == T007A.MWSKZ
  • C_NO_STRPTRIALBALANCEITEMQUERY.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Client
  • Transaction Currency
  • C_NO_STRPTRIALBALANCEITEMQUERY.MANDT == TCURC.MANDT
  • C_NO_STRPTRIALBALANCEITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS