P_MPOpeninvoice

DDL: P_MPOPENINVOICE SQL: PMPOPENINVOICE Type: view COMPOSITE Package: VDM_CPM_WS

Open Invoice

P_MPOpeninvoice is a Composite CDS View that provides data about "Open Invoice" in SAP S/4HANA. It reads from 2 data sources (I_DebitMemoRequestItem, P_Mpsosubdoc) and exposes 8 fields. Part of development package VDM_CPM_WS.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_DebitMemoRequestItem OpenInvoice inner
P_Mpsosubdoc SubDocument from

Annotations (6)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
MasterProject P_Mpsosubdoc MasterProject
MasterProjectUUID P_Mpsosubdoc MasterProjectUUID
MasterProjectIsConfidential P_Mpsosubdoc MasterProjectIsConfidential
MasterProjectOrganization P_Mpsosubdoc MasterProjectOrganization
MasterProjectType P_Mpsosubdoc MasterProjectType
SalesDocument P_Mpsosubdoc SalesDocument
SalesDocumentItem P_Mpsosubdoc SalesDocumentItem
Invoicedate I_DebitMemoRequestItem CreationDate 
@AbapCatalog.sqlViewName: 'PMPOPENINVOICE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Open Invoice'

define view P_MPOpeninvoice
  as select from P_Mpsosubdoc as SubDocument
   // inner join   I_SalesDocumentVB as SalesDocument on  SubDocument.SalesDocument     = SalesDocument.SalesDocument

                  //    and SubDocument.SalesDocumentItem = SalesDocument.SalesDocumentItem

      inner join I_DebitMemoRequestItem as OpenInvoice on SubDocument.SalesDocument = OpenInvoice.DebitMemoRequest
                                  and  SubDocument.SalesDocumentItem = OpenInvoice.DebitMemoRequestItem and OpenInvoice.SDProcessStatus <> 'C'
{
  SubDocument.MasterProject,
  SubDocument.MasterProjectUUID,
  SubDocument.MasterProjectIsConfidential,
  SubDocument.MasterProjectOrganization,
  SubDocument.MasterProjectType,
  SubDocument.SalesDocument,
  SubDocument.SalesDocumentItem,
  //SalesDocument.BillingDate as Invoicedate

  OpenInvoice.CreationDate as Invoicedate
}

Learn More