P_APProcFlowJournalEntry

DDL: P_APPROCFLOWJOURNALENTRY Type: view_entity CONSUMPTION Package: ODATA_PROCESS_FLOW_AP

AP Process Flow Journal Entry

P_APProcFlowJournalEntry is a Consumption CDS View that provides data about "AP Process Flow Journal Entry" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 18 fields with key fields AccountingDocument, CompanyCode, FiscalYear. It has 1 association to related views. Part of development package ODATA_PROCESS_FLOW_AP.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry journalEntry from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard $projection.AccountingDocCreatedByUser = _UserContactCard.ContactCardID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label AP Process Flow Journal Entry view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument I_JournalEntry AccountingDocument
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
ReferenceDocument
ReferenceDocumentFiscalYear
AccountingDocumentCategory I_JournalEntry AccountingDocumentCategory
AccountingDocumentType I_JournalEntry AccountingDocumentType
PostingDate I_JournalEntry PostingDate
ReferenceDocumentType I_JournalEntry ReferenceDocumentType
OriginalReferenceDocument I_JournalEntry OriginalReferenceDocument
DocumentReferenceID I_JournalEntry DocumentReferenceID
AccountingDocCreatedByUser I_JournalEntry AccountingDocCreatedByUser
FullName _UserContactCard FullName
DocumentDate I_JournalEntry DocumentDate
Ledger I_JournalEntry Ledger
_AccountingDocumentType I_JournalEntry _AccountingDocumentType
CompanyCodeName
_UserContactCard _UserContactCard 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl:{
    authorizationCheck: #NOT_REQUIRED,
    privilegedAssociations: [ '_UserContactCard' ]
}
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XXL,
    dataClass: #TRANSACTIONAL
}
@VDM: {
  viewType: #CONSUMPTION,
  private: true
}
@EndUserText.label: 'AP Process Flow Journal Entry'
define view entity P_APProcFlowJournalEntry
  as select from I_JournalEntry as journalEntry

  association [1..1] to I_UserContactCard as _UserContactCard on $projection.AccountingDocCreatedByUser = _UserContactCard.ContactCardID

{


  key journalEntry.AccountingDocument                                                                              as AccountingDocument,
  key journalEntry.CompanyCode                                                                                     as CompanyCode,
  key journalEntry.FiscalYear                                                                                      as FiscalYear,

      // SupplierInvoice Association

      substring(journalEntry.OriginalReferenceDocument, 1, 10)                                                     as ReferenceDocument,
      substring(journalEntry.OriginalReferenceDocument, 11, 4)                                                     as ReferenceDocumentFiscalYear,
      journalEntry.AccountingDocumentCategory                                                                      as AccountingDocumentCategory,

      // Node information

      journalEntry.AccountingDocumentType                                                                          as AccountingDocumentType,
      journalEntry.PostingDate                                                                                     as PostingDate,
      journalEntry.ReferenceDocumentType                                                                           as ReferenceDocumentType,
      journalEntry.OriginalReferenceDocument                                                                       as OriginalReferenceDocument,
      journalEntry.DocumentReferenceID                                                                             as DocumentReferenceID,
      journalEntry.AccountingDocCreatedByUser                                                                      as AccountingDocCreatedByUser,
      _UserContactCard.FullName                                                                                    as FullName,

      //Additional Info

      journalEntry.DocumentDate                                                                                    as DocumentDate,

      //Authorization

      journalEntry.Ledger                                                                                          as Ledger,

      journalEntry._AccountingDocumentType,
      journalEntry._CompanyCode.CompanyCodeName                                                                    as CompanyCodeName,
      _UserContactCard 
}

Learn More