C_PL_StRpCustTrialBalItmQuery

Customer Trial Balance Query – Poland | view: CPLSRCUSTTRBLITQ | 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
CustomerName Name of Customer TEXT80
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
  • Journal Entry Type
  • Client
  • C_PL_STRPCUSTTRIALBALITMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == T001.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == TCURC.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == KNA1.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.CUSTOMER == KNA1.KUNNR
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == SKB1.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_PL_STRPCUSTTRIALBALITMQUERY.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • C_PL_STRPCUSTTRIALBALITMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPCUSTTRIALBALITMQUERY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == FINSC_LEDGER.MANDT
Posting Key
  • Client
  • Posting Key
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == TBSL.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.POSTINGKEY == TBSL.BSCHL
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • C_PL_STRPCUSTTRIALBALITMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPCUSTTRIALBALITMQUERY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == FINSC_LEDGER.MANDT
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • C_PL_STRPCUSTTRIALBALITMQUERY.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == T074U.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == LFA1.MANDT
  • C_PL_STRPCUSTTRIALBALITMQUERY.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • C_PL_STRPCUSTTRIALBALITMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PL_STRPCUSTTRIALBALITMQUERY.MANDT == TCURC.MANDT