P_AR_JournalEntryLogDetail

DDL: P_AR_JOURNALENTRYLOGDETAIL SQL: PARJRNLELOGDET Type: view CONSUMPTION
14 Fields 1 Data Sources

P_AR_JournalEntryLogDetail is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_AR_JournalEntry) and exposes 14 fields with key fields CompanyCode, FiscalYear, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
P_AR_JournalEntry JournalEntry from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PARJRNLELOGDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_AR_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear P_AR_JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument P_AR_JournalEntry AccountingDocument Journal Entry
PostingDate P_AR_JournalEntry PostingDate Posting Date for GR
ReferenceDocumentType P_AR_JournalEntry ReferenceDocumentType Reference Document Type
ReverseDocument P_AR_JournalEntry ReverseDocument Reversed With
ReverseDocumentFiscalYear P_AR_JournalEntry ReverseDocumentFiscalYear Year
DocumentReferenceID P_AR_JournalEntry DocumentReferenceID Reference
ReportingDate P_AR_JournalEntry ReportingDate
ReportingPeriod
ReversalReferenceDocument P_AR_JournalEntry ReversalReferenceDocument Reversal Reference Document
OriginalReferenceDocument P_AR_JournalEntry OriginalReferenceDocument Reference Key
IsReversal P_AR_JournalEntry IsReversal Reversal doc.
IsReversed P_AR_JournalEntry IsReversed Reversed?

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_AR_JournalEntryLogDetail.
-- 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: PARJRNLELOGDET

CREATE VIEW P_AR_JournalEntryLogDetail AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.ReverseDocument AS ReverseDocument,
  JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.ReportingDate AS ReportingDate,
  cast ( substring( JournalEntry.ReportingDate,1,6 ) as rscalmonth ) AS ReportingPeriod,
  JournalEntry.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  JournalEntry.IsReversal AS IsReversal,
  JournalEntry.IsReversed AS IsReversed
FROM P_AR_JournalEntry AS JournalEntry
;

Learn More