P_JrnlEntryReferenceDocument

DDL: P_JRNLENTRYREFERENCEDOCUMENT Type: view_entity COMPOSITE

P_JrnlEntryReferenceDocument is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Ledger) and exposes 6 fields with key fields CompanyCode, AccountingDocument, FiscalYear, ReferenceDocumentContext, ReferenceDocument.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_Ledger LeadingLedger inner

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntry CompanyCode
KEY AccountingDocument JournalEntry AccountingDocument
KEY FiscalYear JournalEntry FiscalYear
KEY ReferenceDocumentContext JournalEntry ReferenceDocumentContext
KEY ReferenceDocument JournalEntry ReferenceDocument
KEY ReversalReferenceDocumentType JournalEntry ReversalReferenceDocumentType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true

define view entity P_JrnlEntryReferenceDocument

  as select distinct from I_GLAccountLineItemRawData as JournalEntry

    inner join            I_Ledger                   as LeadingLedger on  JournalEntry.SourceLedger     = LeadingLedger.Ledger
                                                                      and LeadingLedger.IsLeadingLedger = 'X'
{
  key JournalEntry.CompanyCode,
  key JournalEntry.AccountingDocument,
  key JournalEntry.FiscalYear,
  key JournalEntry.ReferenceDocumentContext,
  key JournalEntry.ReferenceDocument,
  key JournalEntry.ReversalReferenceDocumentType
}

Learn More