P_RU_MaterialReceiptMM

DDL: P_RU_MATERIALRECEIPTMM SQL: PRUMATRCPTMM Type: view COMPOSITE

P_RU_MaterialReceiptMM is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_JournalEntry, I_OperationalAcctgDocItem, I_OperationalAcctgDocItem) and exposes 9 fields.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_JournalEntry GoodsRcptAccDoc inner
I_OperationalAcctgDocItem GoodsRcptAccDocItem inner
I_OperationalAcctgDocItem InvoiceAccDocItem from

Annotations (5)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
CompanyCode I_OperationalAcctgDocItem CompanyCode
InvoiceAccountingDocument I_OperationalAcctgDocItem AccountingDocument
InvoiceFiscalYear I_OperationalAcctgDocItem FiscalYear
GoodsRcptAccountingDocument I_OperationalAcctgDocItem AccountingDocument
GoodsRcptFiscalYear I_OperationalAcctgDocItem FiscalYear
GoodsRcptDocumentDate I_OperationalAcctgDocItem DocumentDate
GoodsRcptPostingDate I_OperationalAcctgDocItem PostingDate
PurchasingDocument I_OperationalAcctgDocItem PurchasingDocument
PurchasingDocumentItem I_OperationalAcctgDocItem PurchasingDocumentItem 
@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                =  ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More