P_HU_MMInvoice

@AbapCatalog.sqlViewName: 'PHUMMINVOICE'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Invoice details for Domestic Sales List'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_HU_MMInvoice
  as select from I_SupplierInvoice
  //    left outer join stxh on

  //      tdname = tdname and

  //      tdobject = 'BELEG' and

  //      tdid = 'HUD'

    join         I_JournalEntry on  //join with ifiaccdoc is done because of xblnr

                                    ReferenceDocumentType     like 'RM%'
                                and OriginalReferenceDocument =    concat(
      SupplierInvoice, I_SupplierInvoice.FiscalYear
    )
{
  key OriginalReferenceDocument          as OriginalReferenceDocument,
  //key I_JournalEntry.DocumentReferenceID  as OriginalReferenceDocument,

  key ReferenceDocumentType              as ReferenceDocumentType,
      I_SupplierInvoice.DocumentDate     as InvoiceDate,
      //SupplierInvoiceIDByInvcgParty      as Invoice,

      I_JournalEntry.DocumentReferenceID as Invoice,
      cast( '' as vbeln )                as ReferenceDocument,
      cast ('' as awkey)                 as PredecessorReferenceDocument,
      cast ('' as awtyp)                 as PredecessorReferenceDocType
}


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_SUPPLIERINVOICE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/