P_RU_MATERIALRECEIPTMM

CDS View

FI RU get Goods Receipt Document by Invoice Document

P_RU_MATERIALRECEIPTMM is a CDS View in S/4HANA. FI RU get Goods Receipt Document by Invoice Document. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_MaterialReceiptDateMM8 view left_outer COMPOSITE FI RU get Material Receipt Date: MM

Fields (4)

KeyField CDS FieldsUsed in Views
GoodsRcptAccountingDocument GoodsRcptAccountingDocument 1
GoodsRcptDocumentDate GoodsRcptDocumentDate 1
GoodsRcptFiscalYear GoodsRcptFiscalYear 1
GoodsRcptPostingDate GoodsRcptPostingDate 1 
@AbapCatalog.sqlViewName: 'PRUMATRCPTMM'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_MaterialReceiptMM
  as select from I_OperationalAcctgDocItem as InvoiceAccDocItem

    inner join   I_OperationalAcctgDocItem as GoodsRcptAccDocItem on  GoodsRcptAccDocItem.CompanyCode            = InvoiceAccDocItem.CompanyCode
                                                                  and GoodsRcptAccDocItem.PurchasingDocument     = InvoiceAccDocItem.PurchasingDocument
                                                                  and GoodsRcptAccDocItem.PurchasingDocumentItem = InvoiceAccDocItem.PurchasingDocumentItem

    inner join   I_JournalEntry            as GoodsRcptAccDoc     on  GoodsRcptAccDoc.CompanyCode        = GoodsRcptAccDocItem.CompanyCode
                                                                  and GoodsRcptAccDoc.AccountingDocument = GoodsRcptAccDocItem.AccountingDocument
                                                                  and GoodsRcptAccDoc.FiscalYear         = GoodsRcptAccDocItem.FiscalYear
{
  InvoiceAccDocItem.CompanyCode,
  InvoiceAccDocItem.AccountingDocument                                    as InvoiceAccountingDocument,
  InvoiceAccDocItem.FiscalYear                                            as InvoiceFiscalYear,
  GoodsRcptAccDocItem.AccountingDocument                                  as GoodsRcptAccountingDocument,
  GoodsRcptAccDocItem.FiscalYear                                          as GoodsRcptFiscalYear,
  GoodsRcptAccDocItem.DocumentDate                                        as GoodsRcptDocumentDate,
  GoodsRcptAccDocItem.PostingDate                                         as GoodsRcptPostingDate,
  GoodsRcptAccDocItem.PurchasingDocument,
  GoodsRcptAccDocItem.PurchasingDocumentItem
}

where
      InvoiceAccDocItem.ReferenceDocumentType        =  'RMRP'
  and GoodsRcptAccDocItem.AccountingDocumentItemType =  'M'
  and GoodsRcptAccDocItem.DebitCreditCode            =  'S'
  and GoodsRcptAccDocItem.PurchasingDocument         <> ''
  and GoodsRcptAccDoc.ReverseDocument                =  ''

Learn More