I_MpProcHistoryInvoiceStatus

DDL: I_MPPROCHISTORYINVOICESTATUS SQL: IMPPHIS Type: view BASIC

Procurement History Invoice Status

I_MpProcHistoryInvoiceStatus is a Basic CDS View that provides data about "Procurement History Invoice Status" in SAP S/4HANA. It reads from 2 data sources (I_SupplierInvoice, I_SupplierInvoiceItemPurOrdRef) and exposes 7 fields with key fields MaterialDocument, PurchaseOrder, PurchaseOrderItem, InvoiceReferenceFiscalYear.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_SupplierInvoice SupplierInvoice from
I_SupplierInvoiceItemPurOrdRef SupplierInvoiceItemPurOrdRef inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMPPHIS view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Procurement History Invoice Status view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.successor I_SupplierInvoice view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument I_SupplierInvoice SupplierInvoice
KEY PurchaseOrder I_SupplierInvoiceItemPurOrdRef PurchaseOrder
KEY PurchaseOrderItem I_SupplierInvoiceItemPurOrdRef PurchaseOrderItem
KEY InvoiceReferenceFiscalYear I_SupplierInvoice FiscalYear
PurchaseOrderQuantityUnit I_SupplierInvoiceItemPurOrdRef PurchaseOrderQuantityUnit
CompanyCode I_SupplierInvoice CompanyCode
InvoiceListStatus I_SupplierInvoice SupplierInvoiceStatus 
@AbapCatalog.sqlViewName: 'IMPPHIS'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Procurement History Invoice Status'

@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.lifecycle.successor: 'I_SupplierInvoice'

define view I_MpProcHistoryInvoiceStatus as select from I_SupplierInvoice as SupplierInvoice
inner join I_SupplierInvoiceItemPurOrdRef as SupplierInvoiceItemPurOrdRef on SupplierInvoice.SupplierInvoice = SupplierInvoiceItemPurOrdRef.SupplierInvoice
                       and SupplierInvoice.FiscalYear = SupplierInvoiceItemPurOrdRef.FiscalYear
{
 key SupplierInvoice.SupplierInvoice as MaterialDocument,
 key SupplierInvoiceItemPurOrdRef.PurchaseOrder as PurchaseOrder,
 key SupplierInvoiceItemPurOrdRef.PurchaseOrderItem as PurchaseOrderItem,
 key SupplierInvoice.FiscalYear as InvoiceReferenceFiscalYear,
     SupplierInvoiceItemPurOrdRef.PurchaseOrderQuantityUnit,
     SupplierInvoice.CompanyCode, //Exposed for DCL

     SupplierInvoice.SupplierInvoiceStatus as InvoiceListStatus
}                        
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIERINVOICE",
"I_SUPPLIERINVOICEITEMPURORDREF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More