P_RU_MaterialRcptDateMMMvtMatD

DDL: P_RU_MATERIALRCPTDATEMMMVTMATD SQL: PRUMATRCDTMMMVMD Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU_SPL

FI RU get Material Receipt Date: MM Movement MatDoc

P_RU_MaterialRcptDateMMMvtMatD is a Consumption CDS View that provides data about "FI RU get Material Receipt Date: MM Movement MatDoc" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 8 fields. Part of development package GLO_FIN_IS_VAT_RU_SPL.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord MatDocItem from

Annotations (6)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
CompanyCode I_MaterialDocumentRecord CompanyCode
MaterialDocument I_MaterialDocumentRecord MaterialDocument
MaterialDocumentYear I_MaterialDocumentRecord MaterialDocumentYear
MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem
DocumentDate I_MaterialDocumentRecord DocumentDate
PostingDate I_MaterialDocumentRecord PostingDate
PurchaseOrder I_MaterialDocumentRecord PurchaseOrder
PurchaseOrderItem I_MaterialDocumentRecord PurchaseOrderItem 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUMATRCDTMMMVMD'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_MaterialRcptDateMMMvtMatD
  as select from           I_MaterialDocumentRecord as MatDocItem

    left outer to one join I_MaterialDocumentRecord as MatDocItemRvrsl on  MatDocItemRvrsl.ReversedMaterialDocument     =  MatDocItem.MaterialDocument
                                                                       and MatDocItemRvrsl.ReversedMaterialDocumentYear =  MatDocItem.MaterialDocumentYear
                                                                       and MatDocItemRvrsl.ReversedMaterialDocumentItem =  MatDocItem.MaterialDocumentItem
                                                                       and MatDocItemRvrsl.MaterialDocumentRecordType   =  'MDOC'
                                                                       and MatDocItemRvrsl.InventoryTransactionType     =  'WE'
                                                                       and MatDocItemRvrsl.PurchaseOrder                <> ''

{
  MatDocItem.CompanyCode,
  MatDocItem.MaterialDocument,
  MatDocItem.MaterialDocumentYear,
  MatDocItem.MaterialDocumentItem,

  MatDocItem.DocumentDate,
  MatDocItem.PostingDate,
  MatDocItem.PurchaseOrder,
  MatDocItem.PurchaseOrderItem
}
where
      MatDocItem.MaterialDocumentRecordType =  'MDOC'
  and MatDocItem.InventoryTransactionType   =  'WE'
  and MatDocItem.PurchaseOrder              <> ''
  and MatDocItem.ReversedMaterialDocument   =  '' //not reversal document

  and MatDocItemRvrsl.MaterialDocument      is null //not reversed document

Learn More