C_PL_SAFTJournalEntryItemQuery

SAFT PL Journal Entry Item Query | view: CPLSAFTJNLENTITQ | Extraction: Not supported | Component: SAF-T Poland
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
DocumentItemText Item Text TEXT50
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == T004.MANDT
  • C_PL_SAFTJOURNALENTRYITEMQUERY.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_PL_SAFTJOURNALENTRYITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == TCURC.MANDT
  • C_PL_SAFTJOURNALENTRYITEMQUERY.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_PL_SAFTJOURNALENTRYITEMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_PL_SAFTJOURNALENTRYITEMQUERY.COMPANYCODE == SKB1.BUKRS
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_PL_SAFTJOURNALENTRYITEMQUERY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_SAFTJOURNALENTRYITEMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == FINSC_LEDGER.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_PL_SAFTJOURNALENTRYITEMQUERY.LEDGER == FINSC_LEDGER.RLDNR
  • C_PL_SAFTJOURNALENTRYITEMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == FINSC_LEDGER.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_PL_SAFTJOURNALENTRYITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Transaction Currency
  • Client
  • Transaction Currency
  • C_PL_SAFTJOURNALENTRYITEMQUERY.MANDT == TCURC.MANDT
  • C_PL_SAFTJOURNALENTRYITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS