C_CL_StRpPurchaseLedgerCube

DDL: C_CL_STRPPURCHASELEDGERCUBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_CL
28 Fields 3 Data Sources

Chile Purchase Ledger - Cube

C_CL_StRpPurchaseLedgerCube is a Consumption CDS View (Cube) that provides data about "Chile Purchase Ledger - Cube" in SAP S/4HANA. It reads from 3 data sources (P_CL_JournalEntryTotalAmount, P_CL_PurJrnlEntryTaxItemAggrgd, I_Supplier) and exposes 28 fields with key fields CompanyCode, AccountingDocument, FiscalYear, Ledger, StatryRptgEntity. Part of development package GLO_FIN_IS_CL.

Data Sources (3)

SourceAliasJoin Type
P_CL_JournalEntryTotalAmount P_CL_JournalEntryTotalAmount inner
P_CL_PurJrnlEntryTaxItemAggrgd P_CL_PurJrnlEntryTaxItemAggrgd from
I_Supplier SupplierData inner

Parameters (1)

NameTypeDefault
P_ReportingCurrency glo_reporting_currency

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label Chile Purchase Ledger - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntry CompanyCode Receiver Company Code
KEY AccountingDocument JournalEntry AccountingDocument Journal Entry
KEY FiscalYear JournalEntry FiscalYear G/L Fiscal Year
KEY Ledger JournalEntry Ledger Ledger
KEY StatryRptgEntity JournalEntry StatryRptgEntity Reporting Entity
KEY StatryRptCategory JournalEntry StatryRptCategory Report ID
KEY StatryRptRunID JournalEntry StatryRptRunID Report Run ID
DocumentDate JournalEntry DocumentDate Journal Entry Date
ReportingDate JournalEntry ReportingDate
CL_PurchaseType JournalEntry CL_PurchaseType
CL_SIIDocFromPurchaseInvoice JournalEntry CL_SIIDocFromPurchaseInvoice
ReportingCurrency JournalEntry ReportingCurrency Currency
Supplier JournalEntry Supplier Supplier
ElectronicDocPostingDate EDocument ElectronicDocPostingDate
CL_SIIEDocReceivedDate EDocument CL_SIIEDocReceivedDate
CL_SIIEDocAcknowledgedDate EDocument CL_SIIEDocAcknowledgedDate
TaxBox01AmtInReportingCurrency JournalEntry TaxBox01AmtInReportingCurrency
TaxBox02AmtInReportingCurrency JournalEntry TaxBox02AmtInReportingCurrency
TaxBox05AmtInReportingCurrency JournalEntry TaxBox05AmtInReportingCurrency
TaxBox06AmtInReportingCurrency JournalEntry TaxBox06AmtInReportingCurrency
TaxBox03AmtInReportingCurrency JournalEntry TaxBox03AmtInReportingCurrency
TaxBox07AmtInReportingCurrency JournalEntry TaxBox07AmtInReportingCurrency
TaxBox08AmtInReportingCurrency JournalEntry TaxBox08AmtInReportingCurrency
TaxBox04AmtInReportingCurrency JournalEntry TaxBox04AmtInReportingCurrency
TaxBox09AmtInReportingCurrency JournalEntry TaxBox09AmtInReportingCurrency
TaxBox10AmtInReportingCurrency JournalEntry TaxBox10AmtInReportingCurrency
TaxBox11AmtInReportingCurrency JournalEntry TaxBox11AmtInReportingCurrency
TaxBox12AmtInReportingCurrency JournalEntry TaxBox12AmtInReportingCurrency

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_StRpPurchaseLedgerCube.
-- 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.
-- Parameters: P_ReportingCurrency : glo_reporting_currency

CREATE VIEW C_CL_StRpPurchaseLedgerCube AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.Ledger AS Ledger,
  JournalEntry.StatryRptgEntity AS StatryRptgEntity,
  JournalEntry.StatryRptCategory AS StatryRptCategory,
  JournalEntry.StatryRptRunID AS StatryRptRunID,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.CL_PurchaseType AS CL_PurchaseType,
  JournalEntry.CL_SIIDocFromPurchaseInvoice AS CL_SIIDocFromPurchaseInvoice,
  JournalEntry.ReportingCurrency AS ReportingCurrency,
  JournalEntry.Supplier AS Supplier,
  EDocument.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  EDocument.CL_SIIEDocReceivedDate AS CL_SIIEDocReceivedDate,
  EDocument.CL_SIIEDocAcknowledgedDate AS CL_SIIEDocAcknowledgedDate,
  JournalEntry.TaxBox01AmtInReportingCurrency AS TaxBox01AmtInReportingCurrency,
  JournalEntry.TaxBox02AmtInReportingCurrency AS TaxBox02AmtInReportingCurrency,
  JournalEntry.TaxBox05AmtInReportingCurrency AS TaxBox05AmtInReportingCurrency,
  JournalEntry.TaxBox06AmtInReportingCurrency AS TaxBox06AmtInReportingCurrency,
  JournalEntry.TaxBox03AmtInReportingCurrency AS TaxBox03AmtInReportingCurrency,
  JournalEntry.TaxBox07AmtInReportingCurrency AS TaxBox07AmtInReportingCurrency,
  JournalEntry.TaxBox08AmtInReportingCurrency AS TaxBox08AmtInReportingCurrency,
  JournalEntry.TaxBox04AmtInReportingCurrency AS TaxBox04AmtInReportingCurrency,
  JournalEntry.TaxBox09AmtInReportingCurrency AS TaxBox09AmtInReportingCurrency,
  JournalEntry.TaxBox10AmtInReportingCurrency AS TaxBox10AmtInReportingCurrency,
  JournalEntry.TaxBox11AmtInReportingCurrency AS TaxBox11AmtInReportingCurrency,
  JournalEntry.TaxBox12AmtInReportingCurrency AS TaxBox12AmtInReportingCurrency
FROM P_CL_PurJrnlEntryTaxItemAggrgd
INNER JOIN P_CL_JournalEntryTotalAmount ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier AS SupplierData ON /* join condition not captured in parsed metadata */
;

Learn More