C_CL_StRpJournalEntryItemQuery

DDL: C_CL_STRPJOURNALENTRYITEMQUERY SQL: CCLSTRPJEITMQ Type: view CONSUMPTION Package: GLO_FIN_IS_CL
57 Fields 1 Data Sources

Jrnl Entr Items for Chile Reporting Qry

C_CL_StRpJournalEntryItemQuery is a Consumption CDS View that provides data about "Jrnl Entr Items for Chile Reporting Qry" in SAP S/4HANA. It reads from 1 data source (C_CL_StRpJournalEntryItemCube) and exposes 57 fields with key fields Ledger, CompanyCode, FiscalYear, SourceLedger, AccountingDocument. Part of development package GLO_FIN_IS_CL.

Data Sources (1)

SourceAliasJoin Type
C_CL_StRpJournalEntryItemCube C_CL_StRpJournalEntryItemCube from

Parameters (1)

NameTypeDefault
P_ReportingCurrency glo_reporting_currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCLSTRPJEITMQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Jrnl Entr Items for Chile Reporting Qry view
AbapCatalog.compiler.compareFilter true view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SourceLedger SourceLedger Source Ledger
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
NumberOfDocuments
NumberOfDocumentItems
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
DocumentReferenceID DocumentReferenceID Reference
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName AccountingDocumentTypeName
CL_ReportingDocumentType CL_ReportingDocumentType
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
FinancialAccountType FinancialAccountType Fin. Account Type
GLRecordType GLRecordType Record Type
GLAccountType GLAccountType G/L Account Type
GLAccount GLAccount General Ledger
GLAccountLongName GLAccountLongName Long Text
AlternativeGLAccount AlternativeGLAccount Group Account
ChartOfAccounts ChartOfAccounts Node Class
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
FiscalPeriod FiscalPeriod Tax period
FiscalYearVariant FiscalYearVariant FY Variant
FiscalYearPeriod FiscalYearPeriod Period/Year
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
NetDueDate NetDueDate Net Due Date
AccountingDocumentItem AccountingDocumentItem Posting View Item
FinancialTransactionType FinancialTransactionType Transact. Type
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
DocumentItemText DocumentItemText Text
SpecialGLCode SpecialGLCode Special G/L Ind
TaxCode TaxCode Tax Code
ClearingDate ClearingDate Clearing Date
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
Supplier Supplier Supplier
Customer Customer Sold-to Party
TaxNumber1 TaxNumber1 VAT Reg. No.
BusinessPartnerName BusinessPartnerName Extracted Customer Name
DebitCreditCode DebitCreditCode Single-Character Flag
ReportingCurrency ReportingCurrency Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CreditAmountInReportingCrcy CreditAmountInReportingCrcy
DebitAmountInReportingCurrency DebitAmountInReportingCurrency
AmountInReportingCurrency AmountInReportingCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CL_StRpJournalEntryItemQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCLSTRPJEITMQ
-- Parameters: P_ReportingCurrency : glo_reporting_currency

CREATE VIEW C_CL_StRpJournalEntryItemQuery AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  cast( 1 as ficl_number_of_acctg_documents ) AS NumberOfDocuments,
  cast( 1 as ficl_number_of_acctg_doc_items ) AS NumberOfDocumentItems,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  AccountingDocumentType,
  AccountingDocumentTypeName,
  CL_ReportingDocumentType,
  AccountingDocumentCategory,
  FinancialAccountType,
  GLRecordType,
  GLAccountType,
  GLAccount,
  GLAccountLongName,
  AlternativeGLAccount,
  ChartOfAccounts,
  CountryChartOfAccounts,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  DocumentDate,
  PostingDate,
  NetDueDate,
  AccountingDocumentItem,
  FinancialTransactionType,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  DocumentItemText,
  SpecialGLCode,
  TaxCode,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  Supplier,
  Customer,
  TaxNumber1,
  BusinessPartnerName,
  DebitCreditCode,
  ReportingCurrency,
  CompanyCodeCurrency,
  CreditAmountInReportingCrcy,
  DebitAmountInReportingCurrency,
  AmountInReportingCurrency
FROM C_CL_StRpJournalEntryItemCube
;

Learn More