C_PL_StRpGLAcctTrialBalItmQry

GL Account Trial Balance Query – Poland | view: CPLSRGLACTRBLITQ | Extraction: Not supported | Component: Financials Poland
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitCarryFwdBalAmtInCCCrcy Debit Carry Forward Balance Amount in Company Code Currency
CreditCarryFwdBalAmtInCCCrcy Credit Carry Forward Balance 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
DebitStartingBalAmtInCCCrcy Debit Starting Balance Amount in Company Code Currency
CreditStartingBalAmtInCCCrcy Credit Starting Balance Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit 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
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
ItemType Line Item Type Show values
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FiscalPeriod Fiscal Period POPER
GLAccountLongName G/L Account Long Text TEXT50
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == T003.MANDT
  • C_PL_STRPGLACCTTRIALBALITMQRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.COMPANYCODE == T001.BUKRS
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == TCURC.MANDT
  • C_PL_STRPGLACCTTRIALBALITMQRY.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.CUSTOMER == KNA1.KUNNR
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_PL_STRPGLACCTTRIALBALITMQRY.COMPANYCODE == SKB1.BUKRS
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == SKB1.MANDT
  • C_PL_STRPGLACCTTRIALBALITMQRY.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == FINSC_LEDGER.MANDT
  • C_PL_STRPGLACCTTRIALBALITMQRY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPGLACCTTRIALBALITMQRY.SOURCELEDGER == FINSC_LEDGER.RLDNR
Posting Key
  • Posting Key
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.POSTINGKEY == TBSL.BSCHL
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == TBSL.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPGLACCTTRIALBALITMQRY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == FINSC_LEDGER.MANDT
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_PL_STRPGLACCTTRIALBALITMQRY.SPECIALGLCODE == T074U.UMSKZ
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == T074U.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == SRF_RPG_ENT.MANDT
Supplier
  • Client
  • Supplier
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == LFA1.MANDT
  • C_PL_STRPGLACCTTRIALBALITMQRY.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • C_PL_STRPGLACCTTRIALBALITMQRY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PL_STRPGLACCTTRIALBALITMQRY.MANDT == TCURC.MANDT