P_RU_MaterialRcptDateMMMvtAccD

DDL: P_RU_MATERIALRCPTDATEMMMVTACCD SQL: PRUMATRCDTMMMVAD Type: view CONSUMPTION

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

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry AccDoc inner
I_OperationalAcctgDocItem AccDocItem from

Annotations (6)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
CompanyCode I_OperationalAcctgDocItem CompanyCode
AccountingDocument I_OperationalAcctgDocItem AccountingDocument
FiscalYear I_OperationalAcctgDocItem FiscalYear
AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
DocumentDate I_JournalEntry DocumentDate
PostingDate I_JournalEntry PostingDate
PurchasingDocument I_OperationalAcctgDocItem PurchasingDocument
PurchasingDocumentItem I_OperationalAcctgDocItem PurchasingDocumentItem
SenderLogicalSystem I_JournalEntry SenderLogicalSystem 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUMATRCDTMMMVAD'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_MaterialRcptDateMMMvtAccD
  as select from I_OperationalAcctgDocItem as AccDocItem

    inner join   I_JournalEntry            as AccDoc on  AccDoc.CompanyCode                  = AccDocItem.CompanyCode
                                                     and AccDoc.AccountingDocument           = AccDocItem.AccountingDocument
                                                     and AccDoc.FiscalYear                   = AccDocItem.FiscalYear
                                                     and (
                                                        (
                                                          AccDoc.ReferenceDocumentType       = 'MKPF'
                                                          and AccDoc.BusinessTransactionType = 'RMWE'
                                                        )
                                                        or(
                                                          AccDoc.ReferenceDocumentType       = 'CF3PG'
                                                          or AccDoc.BusinessTransactionType  = 'RMWE'
                                                        )
                                                      )
{
  AccDocItem.CompanyCode,
  AccDocItem.AccountingDocument,
  AccDocItem.FiscalYear,
  AccDocItem.AccountingDocumentItem,

  AccDoc.DocumentDate,
  AccDoc.PostingDate,
  AccDocItem.PurchasingDocument,
  AccDocItem.PurchasingDocumentItem,

  AccDoc.SenderLogicalSystem
}
where
       AccDocItem.AccountingDocumentItemType =  'M'
  and  AccDocItem.DebitCreditCode            =  'S'
  and  AccDocItem.PurchasingDocument         <> ''
  and(
       AccDocItem.ReferenceDocumentType      =  'MKPF'
    or AccDocItem.ReferenceDocumentType      =  'CF3PG'
  )
  //  and AccDoc.ReferenceDocumentType          =  'MKPF'

  //  and AccDoc.BusinessTransactionType        =  'RMWE'

  and  AccDoc.IsReversal                     =  ''
  and  AccDoc.IsReversed                     =  ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More