C_PL_StRpGLAcctJrnlEntryItmQry

GL Account Jrnl Entry Item Qry – Poland | view: CPLSRGLACJRENITQ | Extraction: Not supported | Component: Financials Poland
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy null
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FiscalYear Fiscal Year GJAHR
GLAccountLongName G/L Account Long Text TEXT50
AccountingDocument Journal Entry BELNR
AccountingDocumentItem Journal Entry Posting View Item BUZEI
DocumentReferenceID Document Reference ID XBLNR1
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
ClearingAccountingDocument Clearing Journal Entry BELNR
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == T003.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == T001.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == TCURC.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • Company Code
  • G/L Account
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == SKB1.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.COMPANYCODE == SKB1.BUKRS
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == FINSC_LEDGER.MANDT
Posting Key
  • Client
  • Posting Key
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == TBSL.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.POSTINGKEY == TBSL.BSCHL
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == FINSC_LEDGER.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.SOURCELEDGER == FINSC_LEDGER.RLDNR
Special G/L Indicator
  • Account Type
  • Client
  • Special G/L Indicator
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == T074U.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == SRF_RPG_ENT.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == LFA1.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.MANDT == TCURC.MANDT
  • C_PL_STRPGLACCTJRNLENTRYITMQRY.TRANSACTIONCURRENCY == TCURC.WAERS