P_MX_InvoiceReceiptReference

DDL: P_MX_INVOICERECEIPTREFERENCE SQL: PMXINVCRCPTREF Type: view CONSUMPTION Package: GLO_FIN_IS_GL_MX_JE

Business Partner Tax Item (Journal Entry Item Branch 1)

P_MX_InvoiceReceiptReference is a Consumption CDS View that provides data about "Business Partner Tax Item (Journal Entry Item Branch 1)" in SAP S/4HANA. It reads from 2 data sources (I_StRpJournalEntryHeaderLog, I_StRpJournalEntryHeaderLog) and exposes 11 fields. Part of development package GLO_FIN_IS_GL_MX_JE.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_StRpJournalEntryHeaderLog I_StRpJournalEntryHeaderLog inner
I_StRpJournalEntryHeaderLog ReferenceDocumentLog inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMXINVCRCPTREF view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #P view

Fields (11)

KeyFieldSource TableSource FieldDescription
CompanyCode I_JournalEntryItem CompanyCode
FiscalYear
AccountingDocument I_JournalEntryItem AccountingDocument
AccountingDocumentItem I_JournalEntryItem AccountingDocumentItem
InvoiceReference I_JournalEntryItem InvoiceReference
InvoiceReferenceFiscalYear
ReferenceDocument I_JournalEntryItem ReferenceDocument
ReferenceDocumentContext I_JournalEntryItem ReferenceDocumentContext
StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory
StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity
StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID 
@AbapCatalog.sqlViewName: 'PMXINVCRCPTREF'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #P

define view P_MX_InvoiceReceiptReference
  as select distinct from I_JournalEntryItem
  
  inner join I_StRpJournalEntryHeaderLog   on I_StRpJournalEntryHeaderLog.CompanyCode        = I_JournalEntryItem.CompanyCode
                                          and I_StRpJournalEntryHeaderLog.FiscalYear         = I_JournalEntryItem.FiscalYear
                                          and I_StRpJournalEntryHeaderLog.AccountingDocument = I_JournalEntryItem.AccountingDocument
                                    
  inner join I_StRpJournalEntryHeaderLog as ReferenceDocumentLog   
                                     on I_StRpJournalEntryHeaderLog.CompanyCode        = I_JournalEntryItem.CompanyCode
                                    and I_StRpJournalEntryHeaderLog.FiscalYear         = I_JournalEntryItem.FiscalYear
                                    and I_StRpJournalEntryHeaderLog.AccountingDocument = I_JournalEntryItem.ReferenceDocument
                                          and ReferenceDocumentLog.StatryRptCategory   = I_StRpJournalEntryHeaderLog.StatryRptCategory
                                          and ReferenceDocumentLog.StatryRptgEntity    = I_StRpJournalEntryHeaderLog.StatryRptgEntity
                                          and ReferenceDocumentLog.StatryRptRunID      = I_StRpJournalEntryHeaderLog.StatryRptRunID
{
  I_JournalEntryItem.CompanyCode,
  cast( I_JournalEntryItem.FiscalYear as fis_gjahr_no_conv preserving type ) as FiscalYear,
  I_JournalEntryItem.AccountingDocument,
  I_JournalEntryItem.AccountingDocumentItem     as AccountingDocumentItem,  
  I_JournalEntryItem.InvoiceReference           as InvoiceReference,
  cast( I_JournalEntryItem.InvoiceReferenceFiscalYear as fis_gjahr_no_conv preserving type ) as InvoiceReferenceFiscalYear,
  I_JournalEntryItem.ReferenceDocument          as ReferenceDocument,
  I_JournalEntryItem.ReferenceDocumentContext   as ReferenceDocumentContext,
  
  I_StRpJournalEntryHeaderLog.StatryRptCategory,
  I_StRpJournalEntryHeaderLog.StatryRptgEntity,
  I_StRpJournalEntryHeaderLog.StatryRptRunID
  
  }
where
     I_JournalEntryItem.ReferenceDocument <> '' 
 and I_JournalEntryItem.FinancialAccountType =  'K'
 and ReferenceDocumentType = 'RMRP'

Learn More