Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
Cross-Application Components (CA)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
  - ACR Activities (FI-LOC-VAT)
  - Audit Reporting (FI-LOC-AUR)
  - Cash Flow Localization (FI-LOC-CF)
  - Cash Management (FI-LOC-CM)
  - Contract Accounts Receivable and Payable (FI-LOC-CA)
  - Corporate Income Tax Framework (FI-LOC-CIT)
  - Globalization Service: Business Place (FI-LOC-BUP)
  - Golden Audit Interface (FI-LOC-GAI)
  - Localization Asset Accounting (FI-LOC-AA)
  - Localization E-Payment Integration (FI-LOC-EPI)
  - Localization Financials (FI-LOC-FI)
    - Financials Arabic Emirates (FI-LOC-FI-AE)
    - Financials Argentina (FI-LOC-FI-AR)
    - Financials Austria (FI-LOC-FI-AT)
    - Financials Belgium (FI-LOC-FI-BE)
    - Financials Brazil (FI-LOC-FI-BR)
    - Financials Chile (FI-LOC-FI-CL)
    - Financials China (FI-LOC-FI-CN)
    - Financials Colombia (FI-LOC-FI-CO)
    - Financials Czech Republic (FI-LOC-FI-CZ)
    - Financials Denmark (FI-LOC-FI-DK)
    - Financials Egypt (FI-LOC-FI-EG)
    - Financials France (FI-LOC-FI-FR)
    - Financials Germany (FI-LOC-FI-DE)
    - Financials Great Britain (FI-LOC-FI-GB)
    - Financials Hungary (FI-LOC-FI-HU)
    - Financials Indonesia (FI-LOC-FI-ID)
    - Financials Ireland (FI-LOC-FI-IE)
    - Financials Israel (FI-LOC-FI-IL)
    - Financials Italy (FI-LOC-FI-IT)
    - Financials Japan (FI-LOC-FI-JP)
    - Financials Kazakhastan (FI-LOC-FI-KZ)
    - Financials Luxembourg (FI-LOC-FI-LU)
    - Financials Malaysia (FI-LOC-FI-MY)
    - Financials Mexico (FI-LOC-FI-MX)
    - Financials Netherlands (FI-LOC-FI-NL)
    - Financials New Zealand (FI-LOC-FI-NZ)
    - Financials Norway (FI-LOC-FI-NO)
    - Financials Peru (FI-LOC-FI-PE)
    - Financials Philippines (FI-LOC-FI-PH)
    - Financials Poland (FI-LOC-FI-PL)
    - Financials Portugal (FI-LOC-FI-PT)
    - Financials Qatar (FI-LOC-FI-QA)
    - Financials Romania (FI-LOC-FI-RO)
    - Financials Russia (FI-LOC-FI-RU)
    - Financials Singapore (FI-LOC-FI-SG)
    - Financials Slovak republic (FI-LOC-FI-SK)
    - Financials Slovenia (FI-LOC-FI-SI)
    - Financials South Korea (FI-LOC-FI-KR)
    - Financials Spain (FI-LOC-FI-ES)
    - Financials Sweden (FI-LOC-FI-SE)
    - Financials Switzerland (FI-LOC-FI-CH)
    - Financials Taiwan (FI-LOC-FI-TW)
    - Financials Thailand (FI-LOC-FI-TH)
    - Financials Turkey (FI-LOC-FI-TR)
    - Financials USA (FI-LOC-FI-US)
    - Financials Ukraine (FI-LOC-FI-UA)
    - Financials Venezuela (FI-LOC-FI-VE)
  - Localization Financials (generic parts) (FI-LOC-GEN)
  - Localization Financials EC Sales List (FI-LOC-ECS)
  - Localization Financials Statements (FI-LOC-FS)
  - Localization Funds Management (FI-LOC-FM)
  - Localization Logistics (FI-LOC-LO)
  - Localization for Utilities Industry (FI-LOC-UT)
  - Payment Receipt (FI-LOC-PR)
  - SAF-T Reporting (Generic Part) (FI-LOC-SAF)
  - Statutory Reporting (FI-LOC-IS)
  - Statutory Reporting Framework (FI-LOC-SRF)
  - Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

C_CL_StRpJournalEntryItemQuery

Jrnl Entr Items for Chile Reporting Qry | view: CCLSTRPJEITMQ | 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

🔑 Keys (9)
💰 Amounts (3)
∑ Quantities
📅 Dates (4)
☰ Categorical (8)
Other (15)
🔗 Relations (20)

Column Name	Description
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
SourceLedger FK	Source Ledger
AccountingDocument	Journal Entry
LedgerGLLineItem	Ledger Journal Entry Item
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
NumberOfDocuments	null
NumberOfDocumentItems	null
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 Client Journal Entry Type	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T003.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Alternative G/L Account Number In Company Code Client Alternative Chart of Accounts for Country/Region Alternative G/L Account Number In Company Code	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == SKA1.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL` `C_CL_STRPJOURNALENTRYITEMQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR`
Business Area Business Area Client	`C_CL_STRPJOURNALENTRYITEMQUERY.BUSINESSAREA == TGSB.GSBER` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == TGSB.MANDT`
Chart of Accounts Client Chart of Accounts	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T004.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.CHARTOFACCOUNTS == T004.KTOPL`
Company Code Company Code Client	`C_CL_STRPJOURNALENTRYITEMQUERY.COMPANYCODE == T001.BUKRS` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_CL_STRPJOURNALENTRYITEMQUERY.COMPANYCODECURRENCY == TCURC.WAERS` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == TCURC.MANDT`
Cost Center ? Client ? Cost Center	`C_CL_STRPJOURNALENTRYITEMQUERY.[column in domain "DATBI"] == CSKS.DATBI` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == CSKS.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.[column in domain "KOKRS"] == CSKS.KOKRS` `C_CL_STRPJOURNALENTRYITEMQUERY.COSTCENTER == CSKS.KOSTL`
Alternative Chart of Accounts for Country/Region Client Alternative Chart of Accounts for Country/Region	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T004.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.COUNTRYCHARTOFACCOUNTS == T004.KTOPL`
Customer Number Customer Number Client	`C_CL_STRPJOURNALENTRYITEMQUERY.CUSTOMER == KNA1.KUNNR` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == KNA1.MANDT`
Financial Transaction Type Client Financial Transaction Type	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T856.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
Fiscal Year Variant Fiscal Year Variant Client	`C_CL_STRPJOURNALENTRYITEMQUERY.FISCALYEARVARIANT == T009.PERIV` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T009.MANDT`
Functional Area Client Functional Area	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == TFKB.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Company Code Client	`C_CL_STRPJOURNALENTRYITEMQUERY.GLACCOUNT == SKB1.SAKNR` `C_CL_STRPJOURNALENTRYITEMQUERY.COMPANYCODE == SKB1.BUKRS` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == SKB1.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting Source Ledger	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == FINSC_LEDGER.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.LEDGER == FINSC_LEDGER.RLDNR` `C_CL_STRPJOURNALENTRYITEMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Profit Center ? Client ? Profit Center	`C_CL_STRPJOURNALENTRYITEMQUERY.[column in domain "DATBI"] == CEPC.DATBI` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == CEPC.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.[column in domain "KOKRS"] == CEPC.KOKRS` `C_CL_STRPJOURNALENTRYITEMQUERY.PROFITCENTER == CEPC.PRCTR`
Source Ledger Client Ledger in General Ledger Accounting Source Ledger	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == FINSC_LEDGER.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.LEDGER == FINSC_LEDGER.RLDNR` `C_CL_STRPJOURNALENTRYITEMQUERY.SOURCELEDGER == FINSC_LEDGER.RLDNR`
Special G/L Indicator Special G/L Indicator Account Type Client	`C_CL_STRPJOURNALENTRYITEMQUERY.SPECIALGLCODE == T074U.UMSKZ` `C_CL_STRPJOURNALENTRYITEMQUERY.FINANCIALACCOUNTTYPE == T074U.KOART` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T074U.MANDT`
Reporting Entity Client Reporting Entity	`C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == SRF_RPG_ENT.MANDT` `C_CL_STRPJOURNALENTRYITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY`
Supplier Supplier Client	`C_CL_STRPJOURNALENTRYITEMQUERY.SUPPLIER == LFA1.LIFNR` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == LFA1.MANDT`
Tax on Sales/Purchases Code Tax on Sales/Purchases Code ? Client	`C_CL_STRPJOURNALENTRYITEMQUERY.TAXCODE == T007A.MWSKZ` `C_CL_STRPJOURNALENTRYITEMQUERY.[column in domain "KALSM_D"] == T007A.KALSM` `C_CL_STRPJOURNALENTRYITEMQUERY.MANDT == T007A.MANDT`