P_AR_JournalEntry

DDL: P_AR_JOURNALENTRY SQL: PARJOURNALENTRY Type: view CONSUMPTION
31 Fields 1 Data Sources 1 Associations

P_AR_JournalEntry is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 31 fields with key fields CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry JournalEntry from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OneTimeAccountBP _OneTimeAccountBP JournalEntry.CompanyCode = _OneTimeAccountBP.CompanyCode and JournalEntry.FiscalYear = _OneTimeAccountBP.FiscalYear and JournalEntry.AccountingDocument = _OneTimeAccountBP.AccountingDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PARJOURNALENTRY 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 #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntry AccountingDocument Journal Entry
FiscalPeriod I_JournalEntry FiscalPeriod Tax period
PostingDate I_JournalEntry PostingDate Posting Date for GR
DocumentDate I_JournalEntry DocumentDate Journal Entry Date
TaxReportingDate I_JournalEntry TaxReportingDate Tax Reporting Date
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
AccountingDocumentCategory I_JournalEntry AccountingDocumentCategory Journal Entry Category
DocumentReferenceID I_JournalEntry DocumentReferenceID Reference
Branch I_JournalEntry Branch Repository branch
NmbrOfPagesendasj_1anopgasNmbrOfPages
AccountingDocumentHeaderText I_JournalEntry AccountingDocumentHeaderText Doc.Header Text
IsReversal I_JournalEntry IsReversal Reversal doc.
IsReversed I_JournalEntry IsReversed Reversed?
ReverseDocument I_JournalEntry ReverseDocument Reversed With
ReverseDocumentFiscalYear I_JournalEntry ReverseDocumentFiscalYear Year
ReversalReferenceDocument I_JournalEntry ReversalReferenceDocument Reversal Reference Document
OriginalReferenceDocument I_JournalEntry OriginalReferenceDocument Reference Key
ReferenceDocumentType I_JournalEntry ReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem I_JournalEntry ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ExchangeRateDate I_JournalEntry ExchangeRateDate Translatn Date
ExchangeRate
LogicalSystem I_JournalEntry LogicalSystem Logical System
CompanyCodeCurrency I_JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency
AdditionalCurrency1 I_JournalEntry AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_JournalEntry AdditionalCurrency2 Local curr. 3
_CompanyCode _CompanyCode
_OneTimeAccountBP _OneTimeAccountBP
_AccountingDocumentTypeText _AccountingDocumentTypeText

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_JournalEntry.
-- 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: PARJOURNALENTRY

CREATE VIEW P_AR_JournalEntry AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.TaxReportingDate AS TaxReportingDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.Branch AS Branch,
  cast( case when JournalEntry.NmbrOfPages = '000' or JournalEntry.NmbrOfPages = '' then '001' else JournalEntry.NmbrOfPages end as j_1anopg ) as NmbrOfPages AS NmbrOfPagesendasj_1anopgasNmbrOfPages,
  JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  JournalEntry.IsReversal AS IsReversal,
  JournalEntry.IsReversed AS IsReversed,
  JournalEntry.ReverseDocument AS ReverseDocument,
  JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  JournalEntry.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
  JournalEntry.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntry.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  JournalEntry.ExchangeRateDate AS ExchangeRateDate,
  cast( JournalEntry.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  JournalEntry.LogicalSystem AS LogicalSystem,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( JournalEntry.TransactionCurrency as fis_rwcur preserving type ) AS TransactionCurrency,
  JournalEntry.AdditionalCurrency1 AS AdditionalCurrency1,
  JournalEntry.AdditionalCurrency2 AS AdditionalCurrency2
FROM I_JournalEntry AS JournalEntry
LEFT OUTER JOIN I_OneTimeAccountBP AS _OneTimeAccountBP ON JournalEntry.CompanyCode = _OneTimeAccountBP.CompanyCode AND JournalEntry.FiscalYear = _OneTimeAccountBP.FiscalYear AND JournalEntry.AccountingDocument = _OneTimeAccountBP.AccountingDocument  -- association [0..*]
;

Learn More