P_CL_PurOriginalJournalEntry

DDL: P_CL_PURORIGINALJOURNALENTRY Type: view_entity CONSUMPTION Package: GLO_FIN_IS_CL
15 Fields 1 Data Sources

Original Journal Entry for Chile Purchase Ledger

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

Data Sources (1)

SourceAliasJoin Type
P_CL_PurJrnlEntryItemAggrgd JournalEntry from

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 (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_CL_PurJrnlEntryItemAggrgd CompanyCode Receiver Company Code
KEY AccountingDocument P_CL_PurJrnlEntryItemAggrgd AccountingDocument Journal Entry
KEY FiscalYear P_CL_PurJrnlEntryItemAggrgd FiscalYear G/L Fiscal Year
KEY Ledger P_CL_PurJrnlEntryItemAggrgd Ledger Ledger
KEY StatryRptgEntity P_CL_PurJrnlEntryItemAggrgd StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_CL_PurJrnlEntryItemAggrgd StatryRptCategory Report ID
KEY StatryRptRunID P_CL_PurJrnlEntryItemAggrgd StatryRptRunID Report Run ID
DocumentDate P_CL_PurJrnlEntryItemAggrgd DocumentDate Journal Entry Date
ReportingDate P_CL_PurJrnlEntryItemAggrgd ReportingDate
DocumentReferenceID P_CL_PurJrnlEntryItemAggrgd DocumentReferenceID Reference
OriginalReferenceDocument P_CL_PurJrnlEntryItemAggrgd OriginalReferenceDocument Reference Key
ReferenceDocumentType P_CL_PurJrnlEntryItemAggrgd ReferenceDocumentType Reference Document Type
DebitCreditCode P_CL_PurJrnlEntryItemAggrgd DebitCreditCode Single-Character Flag
Supplier P_CL_PurJrnlEntryItemAggrgd Supplier Supplier
CL_PurchaseType P_CL_PurJrnlEntryItemAggrgd CL_PurchaseType

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_PurOriginalJournalEntry.
-- 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.

CREATE VIEW P_CL_PurOriginalJournalEntry 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.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.DebitCreditCode AS DebitCreditCode,
  JournalEntry.Supplier AS Supplier,
  JournalEntry.CL_PurchaseType AS CL_PurchaseType
FROM P_CL_PurJrnlEntryItemAggrgd AS JournalEntry
;

Learn More