P_CL_PurJrnlEntryTaxItemAggrgd

DDL: P_CL_PURJRNLENTRYTAXITEMAGGRGD Type: view_entity CONSUMPTION Package: GLO_FIN_IS_CL
16 Fields 1 Data Sources

Chile Purchase Journal Entry Tax Items Aggregated

P_CL_PurJrnlEntryTaxItemAggrgd is a Consumption CDS View that provides data about "Chile Purchase Journal Entry Tax Items Aggregated" in SAP S/4HANA. It reads from 1 data source (P_CL_PurJournalEntryTaxItem) and exposes 16 fields with key fields CompanyCode, AccountingDocument, FiscalYear, Ledger, StatryRptgEntity. Part of development package GLO_FIN_IS_CL.

Data Sources (1)

SourceAliasJoin Type
P_CL_PurJournalEntryTaxItem P_CL_PurJournalEntryTaxItem from

Parameters (1)

NameTypeDefault
P_ReportingCurrency glo_reporting_currency

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (16)

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
DebitCreditCode JournalEntry DebitCreditCode Single-Character Flag
DocumentDate JournalEntry DocumentDate Journal Entry Date
ReportingDate JournalEntry ReportingDate
DocumentReferenceID JournalEntry DocumentReferenceID Reference
Supplier JournalEntry Supplier Supplier
SourceKey JournalEntry SourceKey
CL_PurchaseType JournalEntry CL_PurchaseType
CL_SIIDocFromPurchaseInvoice JournalEntry CL_SIIDocFromPurchaseInvoice
ReportingCurrency JournalEntry ReportingCurrency Currency

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 P_CL_PurJrnlEntryTaxItemAggrgd.
-- 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 P_CL_PurJrnlEntryTaxItemAggrgd 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.DebitCreditCode AS DebitCreditCode,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.Supplier AS Supplier,
  JournalEntry.SourceKey AS SourceKey,
  JournalEntry.CL_PurchaseType AS CL_PurchaseType,
  JournalEntry.CL_SIIDocFromPurchaseInvoice AS CL_SIIDocFromPurchaseInvoice,
  JournalEntry.ReportingCurrency AS ReportingCurrency
FROM P_CL_PurJournalEntryTaxItem
;

Learn More