P_PE_JrnlEntryWthOfclDocClass

DDL: P_PE_JRNLENTRYWTHOFCLDOCCLASS SQL: PJRNLWDOCCLN Type: view CONSUMPTION
73 Fields 3 Data Sources

Journal Entries With Document Class

P_PE_JrnlEntryWthOfclDocClass is a Consumption CDS View that provides data about "Journal Entries With Document Class" in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_DocTypeOfclDocClassAssgmt, I_JournalEntry) and exposes 73 fields with key fields CompanyCode, FiscalYear, AccountingDocument.

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_DocTypeOfclDocClassAssgmt DocTypeOfclDocClassAssgmt left_outer
I_JournalEntry I_JournalEntry from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PJRNLWDOCCLN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Journal Entries With Document Class view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
ODNDocumentClass ODNDocumentClass Document Class
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
FiscalPeriod FiscalPeriod Tax period
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
ExchangeRateDate ExchangeRateDate Translatn Date
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
TransactionCode TransactionCode Transaction Code
IntercompanyTransaction IntercompanyTransaction Intercompany Transaction
DocumentReferenceID DocumentReferenceID Reference
RecurringAccountingDocument RecurringAccountingDocument Recurring Journal Entry
ReverseDocument ReverseDocument Reversed With
ReverseDocumentFiscalYear ReverseDocumentFiscalYear Year
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
TransactionCurrency TransactionCurrency Transaction Currency
ExchangeRate ExchangeRate Exchange rate
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
BusinessTransactionType BusinessTransactionType Bus.transaction
BatchInputSession BatchInputSession Session Name
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
FinancialManagementArea I_JournalEntry FinancialManagementArea FM Area
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
ReversalIsPlanned ReversalIsPlanned Reversal Flag
PlannedReversalDate PlannedReversalDate Reversal Date
TaxIsCalculatedAutomatically TaxIsCalculatedAutomatically Tax Is Automatically Calculated
TaxBaseAmountIsNetAmount TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount
SourceCompanyCode SourceCompanyCode Source CoCode
LogicalSystem LogicalSystem Logical System
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
TaxExchangeRate TaxExchangeRate Rate for Taxes
ReversalReason ReversalReason Reversal Reason
Branch Branch Repository branch
NmbrOfPages NmbrOfPages SDS Number of Pages
IsDiscountDocument IsDiscountDocument discount document
Reference1InDocumentHeader Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader Reference2InDocumentHeader Reference 2
InvoiceReceiptDate InvoiceReceiptDate Invoice Receipt Date
Ledger Ledger Ledger
LedgerGroup LedgerGroup Ledger Group
TaxReportingDate TaxReportingDate Tax Reporting Date
AccountingDocumentClass AccountingDocumentClass Document Cat.
ExchangeRateType ExchangeRateType Exch. Rate Type
SenderLogicalSystem SenderLogicalSystem Sender Logical System
SenderCompanyCode SenderCompanyCode Sender Company Code
SenderAccountingDocument SenderAccountingDocument Sender Journal Entry
SenderFiscalYear SenderFiscalYear Sender FiscalYr
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
SalesDocumentCondition SalesDocumentCondition Doc. Condition
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_FiscalPeriod _FiscalPeriod
_AccountingDocumentType _AccountingDocumentType
_TransactionCurrency _TransactionCurrency
_AccountingDocumentCategory _AccountingDocumentCategory
_ReferenceDocumentType _ReferenceDocumentType
_FinancialManagementArea _FinancialManagementArea
_CompanyCodeCurrency _CompanyCodeCurrency
_LogicalSystem _LogicalSystem
_RefDocumentLogicalSystem _RefDocumentLogicalSystem
_Ledger _Ledger
_BusinessTransactionType _BusinessTransactionType

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_PE_JrnlEntryWthOfclDocClass.
-- 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: PJRNLWDOCCLN

CREATE VIEW P_PE_JrnlEntryWthOfclDocClass AS
SELECT
  I_JournalEntry.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  ODNDocumentClass,
  I_JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  DocumentDate,
  PostingDate,
  FiscalPeriod,
  AccountingDocumentCreationDate,
  CreationTime,
  LastChangeDate,
  ExchangeRateDate,
  AccountingDocCreatedByUser,
  TransactionCode,
  IntercompanyTransaction,
  DocumentReferenceID,
  RecurringAccountingDocument,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  AccountingDocumentHeaderText,
  TransactionCurrency,
  ExchangeRate,
  AccountingDocumentCategory,
  BusinessTransactionType,
  BatchInputSession,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  I_JournalEntry.FinancialManagementArea AS FinancialManagementArea,
  CompanyCodeCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  ReversalIsPlanned,
  PlannedReversalDate,
  TaxIsCalculatedAutomatically,
  TaxBaseAmountIsNetAmount,
  SourceCompanyCode,
  LogicalSystem,
  ReferenceDocumentLogicalSystem,
  TaxExchangeRate,
  ReversalReason,
  Branch,
  NmbrOfPages,
  IsDiscountDocument,
  Reference1InDocumentHeader,
  Reference2InDocumentHeader,
  InvoiceReceiptDate,
  Ledger,
  LedgerGroup,
  TaxReportingDate,
  AccountingDocumentClass,
  ExchangeRateType,
  SenderLogicalSystem,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  SalesDocumentCondition,
  IsReversal,
  IsReversed
FROM I_JournalEntry
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocTypeOfclDocClassAssgmt AS DocTypeOfclDocClassAssgmt ON /* join condition not captured in parsed metadata */
;

Learn More