P_SK_VendRefDocNumVH

DDL: P_SK_VENDREFDOCNUMVH SQL: PSKVENDRDNUMVH Type: view COMPOSITE

P_SK_VendRefDocNumVH is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_OperationalAcctgDocItem) and exposes 10 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry inner
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSKVENDRDNUMVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
FiscalPeriod I_OperationalAcctgDocItem FiscalPeriod
DocumentDate I_OperationalAcctgDocItem DocumentDate
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType
PostingDate I_OperationalAcctgDocItem PostingDate
DocumentReferenceID I_JournalEntry DocumentReferenceID
ReferenceDocumentNumber
Supplier I_OperationalAcctgDocItem Supplier 
@AbapCatalog.sqlViewName: 'PSKVENDRDNUMVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_SK_VendRefDocNumVH
  as select from I_OperationalAcctgDocItem
    inner join   I_JournalEntry on  I_OperationalAcctgDocItem.CompanyCode        = I_JournalEntry.CompanyCode
                                and I_OperationalAcctgDocItem.AccountingDocument = I_JournalEntry.AccountingDocument
                                and I_OperationalAcctgDocItem.FiscalYear         = I_JournalEntry.FiscalYear
{
  key  I_OperationalAcctgDocItem.CompanyCode,
  key  I_OperationalAcctgDocItem.AccountingDocument,
  key  I_OperationalAcctgDocItem.FiscalYear,
       I_OperationalAcctgDocItem.FiscalPeriod,
       I_OperationalAcctgDocItem.DocumentDate,
       I_OperationalAcctgDocItem.AccountingDocumentType,
       I_OperationalAcctgDocItem.PostingDate,
       I_JournalEntry.DocumentReferenceID,
       cast (I_JournalEntry.JrnlEntryCntrySpecificRef4 as fisk_ref_doc_num) as ReferenceDocumentNumber,
       I_OperationalAcctgDocItem.Supplier
}
where
      Supplier                                       is not initial
  and I_OperationalAcctgDocItem.FinancialAccountType = 'K'

Learn More