P_PE_JRNLENTRYWTHOFCLDOCCLASS

CDS View

Journal Entries With Document Class

P_PE_JRNLENTRYWTHOFCLDOCCLASS is a CDS View in S/4HANA. Journal Entries With Document Class. It contains 5 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 5 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_PE_StRpJournalEntryWithTax view inner CONSUMPTION Peru journal entries with tax
C_PE_StRpPurLdgrFrgnSuplrC view inner CONSUMPTION Purchase Ledger Foreign Vendors - Cube
P_PE_PurDmstcSuplrEntryAggrgd view inner CONSUMPTION
P_PE_PurFrgnSuplrEntryAggrgd view inner CONSUMPTION
P_PE_SalesTaxItem view inner CONSUMPTION
P_PE_StRpJournalEntryItem view inner CONSUMPTION Journal Entry Item for Peru in StRp

Fields (5)

KeyField CDS FieldsUsed in Views
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
ODNDocumentClass ODNDocumentClass 4
PostingDate PostingDate 1
ReportingDate ReportingDate 5 
@AbapCatalog.sqlViewName: 'PJRNLWDOCCLN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Journal Entries With Document Class'

define view P_PE_JrnlEntryWthOfclDocClass 
  as select from    I_JournalEntry

    inner join      I_CompanyCode              as CompanyCode             
      on CompanyCode.CompanyCode = I_JournalEntry.CompanyCode

    left outer join I_DocTypeOfclDocClassAssgmt as DocTypeOfclDocClassAssgmt 
      on  DocTypeOfclDocClassAssgmt.Country                = CompanyCode.Country
      and DocTypeOfclDocClassAssgmt.AccountingDocumentType = I_JournalEntry.AccountingDocumentType

{
  key I_JournalEntry.CompanyCode,
  key FiscalYear,
  key AccountingDocument,

  case
    when TaxReportingDate = '00000000' then PostingDate
    else TaxReportingDate
  end as ReportingDate,
  
  ODNDocumentClass,
  I_JournalEntry.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,
  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,
  
  _CompanyCode,
  _FiscalYear,
   _FiscalPeriod,
  _AccountingDocumentType,
  _TransactionCurrency,
  _AccountingDocumentCategory,
  _ReferenceDocumentType,
  _FinancialManagementArea,
  _CompanyCodeCurrency,
  _LogicalSystem,
  _RefDocumentLogicalSystem,
  _Ledger, 
  _BusinessTransactionType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_DOCTYPEOFCLDOCCLASSASSGMT",
"I_JOURNALENTRY"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTCATEGORY",
"I_ACCOUNTINGDOCUMENTTYPE",
"I_BUSINESSTRANSACTIONTYPE",
"I_COMPANYCODE",
"I_CURRENCY",
"I_FINANCIALMANAGEMENTAREA",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_LEDGER",
"I_LOGICALSYSTEM",
"I_REFERENCEDOCUMENTTYPE"
],
"BASE":
[
"I_JOURNALENTRY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More