C_CL_StRpJournalEntryItemCube

Jrnl Entr Items for Chile Reporting Cube | view: CCLSTRPJEITM | TRAN | Extraction: Not supported | Component: Financials Chile
Tables used: BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, T003T, BUT000, KNA1, CVI_CUST_LINK, PROJ, LFA1, CVI_VEND_LINK, PRPS, T001, T014, FICLC_VTYP_MAP, FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
CreditAmountInReportingCrcy Credit Amount in Reporting Currency
DebitAmountInReportingCurrency Debit Amount in Reporting Currency
AmountInReportingCurrency Amount in Reporting Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
NetDueDate Net Due Date
ClearingDate Clearing Date
Column Name Description
CL_ReportingDocumentType Voucher Type Show values
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
GLRecordType Record Type Show values
GLAccountType Type of a General Ledger Account Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocumentTypeName Document Type Name TEXT20
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
DocumentItemText Item Text TEXT50
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
TaxNumber1 Tax Number 1 STCD1
BusinessPartnerName Business Partner Name BUSINESSPARTNERNAME
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • C_CL_STRPJOURNALENTRYITEMCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == SKA1.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
Business Area
  • Business Area
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.BUSINESSAREA == TGSB.GSBER
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T004.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.COSTCENTER == CSKS.KOSTL
  • C_CL_STRPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • C_CL_STRPJOURNALENTRYITEMCUBE.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T004.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T856.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.FISCALYEARVARIANT == T009.PERIV
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == TFKB.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_CL_STRPJOURNALENTRYITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == SKB1.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.LEDGER == FINSC_LEDGER.RLDNR
  • C_CL_STRPJOURNALENTRYITEMCUBE.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == FINSC_LEDGER.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • C_CL_STRPJOURNALENTRYITEMCUBE.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_CL_STRPJOURNALENTRYITEMCUBE.PROFITCENTER == CEPC.PRCTR
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • C_CL_STRPJOURNALENTRYITEMCUBE.LEDGER == FINSC_LEDGER.RLDNR
  • C_CL_STRPJOURNALENTRYITEMCUBE.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == FINSC_LEDGER.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • Account Type
  • C_CL_STRPJOURNALENTRYITEMCUBE.SPECIALGLCODE == T074U.UMSKZ
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T074U.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.FINANCIALACCOUNTTYPE == T074U.KOART
Reporting Entity
  • Client
  • Reporting Entity
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == LFA1.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • ?
  • C_CL_STRPJOURNALENTRYITEMCUBE.TAXCODE == T007A.MWSKZ
  • C_CL_STRPJOURNALENTRYITEMCUBE.MANDT == T007A.MANDT
  • C_CL_STRPJOURNALENTRYITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM