P_AR_StRpJournalEntryLogDetail

DDL: P_AR_STRPJOURNALENTRYLOGDETAIL SQL: PARJRNLENTRDET Type: view CONSUMPTION Package: GLO_FIN_IS_AR_JOURNAL_LEDGER
17 Fields 3 Data Sources

Selected Journal Entries for Reporting with Details

P_AR_StRpJournalEntryLogDetail is a Consumption CDS View that provides data about "Selected Journal Entries for Reporting with Details" in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, P_AR_JournalEntry, I_StRpJournalEntryLog) and exposes 17 fields with key fields CompanyCode, FiscalYear, AccountingDocument, StatryRptgEntity, StatryRptCategory. Part of development package GLO_FIN_IS_AR_JOURNAL_LEDGER.

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
P_AR_JournalEntry JournalEntry from
I_StRpJournalEntryLog StRpJournalEntryLog inner

Annotations (10)

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

Fields (17)

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
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
PostingDate P_AR_JournalEntry PostingDate Posting Date for GR
ReportingDate P_AR_JournalEntry ReportingDate
DocumentReferenceID P_AR_JournalEntry DocumentReferenceID Reference
AR_Branch P_AR_JournalEntry AR_Branch
AR_OfficialDocumentNumber P_AR_JournalEntry AR_OfficialDocumentNumber
ReversalReferenceDocument P_AR_JournalEntry ReversalReferenceDocument Reversal Reference Document
AccountingDocumentType P_AR_JournalEntry AccountingDocumentType Journal Entry Type
AR_PrintCharacter P_AR_JournalEntry AR_PrintCharacter
ReferenceDocumentType P_AR_JournalEntry ReferenceDocumentType Reference Document Type
CompanyCodeCurrency P_AR_JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency P_AR_JournalEntry TransactionCurrency Transaction 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_AR_StRpJournalEntryLogDetail.
-- 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: PARJRNLENTRDET

CREATE VIEW P_AR_StRpJournalEntryLogDetail AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.ReportingDate AS ReportingDate,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.AR_Branch AS AR_Branch,
  JournalEntry.AR_OfficialDocumentNumber AS AR_OfficialDocumentNumber,
  JournalEntry.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.AR_PrintCharacter AS AR_PrintCharacter,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency
FROM P_AR_JournalEntry AS JournalEntry
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;

Learn More