P_APProcFlowJournalEntry

DDL: P_APPROCFLOWJOURNALENTRY SQL: PAPFLWJE Type: view CONSUMPTION

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 19 fields with key fields AccountingDocument, CompanyCode, FiscalYear. It has 1 association to related views.

1 data source(s) 19 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
AbapCatalog.sqlViewName PAPFLWJE view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label AP Process Flow Journal Entry view

Fields (19)

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
_OperationalAcctgDocItem _OperationalAcctgDocItem 
@AbapCatalog.sqlViewName: 'PAPFLWJE'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.privilegedAssociations: [ '_UserContactCard' ]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'AP Process Flow Journal Entry'
define view 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,
      _OperationalAcctgDocItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_JOURNALENTRY",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_OPERATIONALACCTGDOCITEM",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_JOURNALENTRY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More