P_RU_MaterialRcptDateMM4

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUMATRCDTMM4'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_MaterialRcptDateMM4
  as select from P_RU_AcctgDocReferenceID      as InvoiceAccDocHead

    inner join   I_OperationalAcctgDocItem     as InvoiceAccDocItem    on  InvoiceAccDocItem.CompanyCode        = InvoiceAccDocHead.CompanyCode
                                                                       and InvoiceAccDocItem.AccountingDocument = InvoiceAccDocHead.AccountingDocument
                                                                       and InvoiceAccDocItem.FiscalYear         = InvoiceAccDocHead.FiscalYear

    inner join   P_RU_PurchaseOrderHistoryGRIR as PurchDocItemHistGRIR on  PurchDocItemHistGRIR.PurchasingDocument      = InvoiceAccDocItem.PurchasingDocument
                                                                       and PurchDocItemHistGRIR.PurchasingDocumentItem  = InvoiceAccDocItem.PurchasingDocumentItem
                                                                       and PurchDocItemHistGRIR.IR_MaterialDocument     = InvoiceAccDocHead.OriginalReferenceDocumentNum
                                                                       and PurchDocItemHistGRIR.IR_MaterialDocumentYear = InvoiceAccDocHead.OriginalReferenceDocumentCntxt
                                                                       and (
                                                                          PurchDocItemHistGRIR.GR_CompanyCode           = InvoiceAccDocHead.CompanyCode
                                                                          or PurchDocItemHistGRIR.GR_CompanyCode        is null
                                                                        )

{
  InvoiceAccDocHead.CompanyCode,
  InvoiceAccDocHead.AccountingDocument,
  InvoiceAccDocHead.FiscalYear,
  InvoiceAccDocHead.DocumentDate,
  InvoiceAccDocHead.PostingDate,

  InvoiceAccDocHead.IsReversal,
  InvoiceAccDocHead.IsReversed,

  InvoiceAccDocItem.PurchasingDocument,
  InvoiceAccDocItem.PurchasingDocumentItem,
  PurchDocItemHistGRIR.Plant,
  PurchDocItemHistGRIR.GoodsReceiptIsExpected,

  PurchDocItemHistGRIR.IR_MaterialDocument,
  PurchDocItemHistGRIR.IR_MaterialDocumentYear,
  PurchDocItemHistGRIR.IR_MaterialDocumentItem,

  PurchDocItemHistGRIR.GR_MaterialDocument,
  PurchDocItemHistGRIR.GR_MaterialDocumentYear,
  PurchDocItemHistGRIR.GR_MaterialDocumentItem,
  PurchDocItemHistGRIR.GR_PostingDate,

  PurchDocItemHistGRIR.GRIR_ReferenceDocument,
  PurchDocItemHistGRIR.GRIR_ReferenceDocumentFisYear,
  PurchDocItemHistGRIR.GRIR_ReferenceDocumentItem,

  case when PurchDocItemHistGRIR.GoodsReceiptIsExpected = 'X'
    then 'MIGO'
    else 'MIGO->PMIRO'
  end as SourceType,
  case when PurchDocItemHistGRIR.GoodsReceiptIsExpected = 'X'
    then PurchDocItemHistGRIR.GR_PostingDate
    else InvoiceAccDocHead.PostingDate
  end as MaterialDocumentPostingDate
}
where
      InvoiceAccDocHead.SenderLogicalSystem   =  ''
  and InvoiceAccDocHead.ReferenceDocumentType =  'RMRP'
  and InvoiceAccDocItem.ReferenceDocumentType =  'RMRP'
  and InvoiceAccDocItem.PurchasingDocument    <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"P_RU_ACCTGDOCREFERENCEID",
"P_RU_PURCHASEORDERHISTORYGRIR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/