C_StRpJournalEntryItemCube

Jrnl Entry Item Cube for Stat.Reporting | view: CSRGLACJRNLENITC | TRAN | Extraction: Not supported | Component: Financials Poland
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
SourceLedger FK Source Ledger
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
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
FinancialAccountType Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
GLAccountLongName G/L Account Long Text TEXT50
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
ClearingAccountingDocument Clearing Journal Entry BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_STRPJOURNALENTRYITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_STRPJOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == T001.MANDT
  • C_STRPJOURNALENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • C_STRPJOURNALENTRYITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • C_STRPJOURNALENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_STRPJOURNALENTRYITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == SKB1.MANDT
  • C_STRPJOURNALENTRYITEMCUBE.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Posting Key
  • Posting Key
  • Client
  • C_STRPJOURNALENTRYITEMCUBE.POSTINGKEY == TBSL.BSCHL
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == TBSL.MANDT
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Special G/L Indicator
  • Client
  • Account Type
  • Special G/L Indicator
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == T074U.MANDT
  • C_STRPJOURNALENTRYITEMCUBE.FINANCIALACCOUNTTYPE == T074U.KOART
  • C_STRPJOURNALENTRYITEMCUBE.SPECIALGLCODE == T074U.UMSKZ
Reporting Entity
  • Client
  • Reporting Entity
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_STRPJOURNALENTRYITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == LFA1.MANDT
  • C_STRPJOURNALENTRYITEMCUBE.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • C_STRPJOURNALENTRYITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT